- 浏览: 1365978 次
- 性别:
- 来自: 北京
文章分类
- 全部博客 (551)
- 计划 (4)
- java (115)
- oracle (60)
- ajax (3)
- javascript (64)
- 计算机操作技巧集 (11)
- 近期关注话题 (10)
- 随想 (13)
- html (6)
- struts (15)
- hibernate (16)
- spring (2)
- game (0)
- Eglish (10)
- DisplayTag (6)
- jsp (18)
- css (3)
- eclipse (3)
- 其他知识 (8)
- 备用1 (12)
- 备用2 (1)
- 笑话-放松心情 (9)
- 设计 (1)
- 设计模式 (1)
- 数据结构 (0)
- office办公软件 (5)
- webwork (0)
- tomcat (2)
- MySql (1)
- 我的链接资源 (5)
- xml (2)
- servlet (0)
- PHP (13)
- DOM (0)
- 网页画图vml,canvas (1)
- 协议 (2)
- 健康 (3)
- 书籍下载 (1)
- jbpm (1)
- EXT (1)
- 自考 (2)
- 报表 (4)
- 生活 (64)
- 操作系统基础知识 (2)
- 测试 (2)
- guice (1)
- google学习 (2)
- Erlang (1)
- LOG4J (2)
- wicket (1)
- 考研 (1)
- 法律 (1)
- 地震 (1)
- 易学-等等相关 (1)
- 音乐 (1)
- 建站 (4)
- 分享说 (3)
- 购物省钱 (0)
- linux (1)
最新评论
-
zenmshuo:
如果使用SpreadJS这一类的表格工具,应该能更好的实现这些 ...
js中excel的用法 -
hjhj2991708:
第一个已经使用不了
jar包查询网站 非常好用! -
jiangmeiwei:
...
中文乱码 我的总结 不断更新 -
gary_bu:
...
response.sendRedirect 中文乱码问题解决 -
hnez:
多谢指点,怎么调试也不通,原来我在<body>&l ...
ExtJs IE ownerDocument.createRange() 错误解决方案
摘自http://publib.boulder.ibm.com/infocenter/db2luw/v9/index.jsp?topic=/com.ibm.db2.udb.admin.doc/doc/t0004676.htm
Verifying the installation of DB2 servers using First Steps (Linux and Windows)
You should verify that the DB2(R) server installation has completed successfully by accessing data from the SAMPLE database.
Prerequisites
* You must have the Control Center and the First Steps component installed to perform this task.
First Steps is listed as a getting started component in the feature selection window in the DB2 Setup wizard. It is installed as part of a Typical installation or may be selected when performing a Custom installation.
The Control Center component is only available on Linux(TM) (x86 and AMD64/EM64T only) and Windows(R).
Procedure
1. On Linux, log on to the system as the instance owner.
2. On Windows, click Start and, select Programs -> IBM DB2 -> [DB2 Copy Name] -> Set-up Tools > First Steps. On Linux and Windows, you can start First Steps by typing the db2fs command.
(注意:要以拥有实例的用户[例如:db2inst1]登录,再执行db2fs)
注意:如果是执行了db2fs 后,也不报错,但是什么反应也没有,
则执行此命令:xhost + db2inst1
3. Select Database Creation in the First Steps launchpad. On the Database Creation page, you will see links to the DB2 Information Center for creating the SAMPLE database and the Create SAMPLE Database button. Click Create SAMPLE Database to launch the Create SAMPLE Databases window.
4. You have the options to choose the type of database objects to create and the database location. You can choose the drive on which to create the SAMPLE database on Windows, and the directory on which to create the SAMPLE database on Linux.
5. This command may take a few minutes to process. When the SAMPLE database has been created, you will receive a completion message. Click OK.
6. Launch the Control Center. On Windows, click Start and, select Programs -> IBM DB2 -> [DB2 Copy Name] -> General Administration Tools --> Control Center.. On Linux systems, type the db2cc command
7. In the left pane of the Control Center screen, expand the object tree to view the SAMPLE database and SAMPLE database objects. Select the Tables object to view the SAMPLE database tables in the right pane of the Control Center screen. Right-click on the table name staff and select Query. In the command editor window, click the run button to execute the query and see the result set.
After you have verified the installation, you can remove the SAMPLE database to free up disk space. However, you will need to keep the sample database if you plan to make use of the sample applications.
Enter the db2 drop database sample command to drop the SAMPLE database.
Related tasks
* Verifying the installation using the command line processor (CLP)
Related reference
* db2fs - First steps command
Verifying the installation of DB2 servers using First Steps (Linux and Windows)
You should verify that the DB2(R) server installation has completed successfully by accessing data from the SAMPLE database.
Prerequisites
* You must have the Control Center and the First Steps component installed to perform this task.
First Steps is listed as a getting started component in the feature selection window in the DB2 Setup wizard. It is installed as part of a Typical installation or may be selected when performing a Custom installation.
The Control Center component is only available on Linux(TM) (x86 and AMD64/EM64T only) and Windows(R).
Procedure
1. On Linux, log on to the system as the instance owner.
2. On Windows, click Start and, select Programs -> IBM DB2 -> [DB2 Copy Name] -> Set-up Tools > First Steps. On Linux and Windows, you can start First Steps by typing the db2fs command.
(注意:要以拥有实例的用户[例如:db2inst1]登录,再执行db2fs)
注意:如果是执行了db2fs 后,也不报错,但是什么反应也没有,
则执行此命令:xhost + db2inst1
3. Select Database Creation in the First Steps launchpad. On the Database Creation page, you will see links to the DB2 Information Center for creating the SAMPLE database and the Create SAMPLE Database button. Click Create SAMPLE Database to launch the Create SAMPLE Databases window.
4. You have the options to choose the type of database objects to create and the database location. You can choose the drive on which to create the SAMPLE database on Windows, and the directory on which to create the SAMPLE database on Linux.
5. This command may take a few minutes to process. When the SAMPLE database has been created, you will receive a completion message. Click OK.
6. Launch the Control Center. On Windows, click Start and, select Programs -> IBM DB2 -> [DB2 Copy Name] -> General Administration Tools --> Control Center.. On Linux systems, type the db2cc command
7. In the left pane of the Control Center screen, expand the object tree to view the SAMPLE database and SAMPLE database objects. Select the Tables object to view the SAMPLE database tables in the right pane of the Control Center screen. Right-click on the table name staff and select Query. In the command editor window, click the run button to execute the query and see the result set.
After you have verified the installation, you can remove the SAMPLE database to free up disk space. However, you will need to keep the sample database if you plan to make use of the sample applications.
Enter the db2 drop database sample command to drop the SAMPLE database.
Related tasks
* Verifying the installation using the command line processor (CLP)
Related reference
* db2fs - First steps command
发表评论
-
oracle删除重复记录
2009-07-16 11:16 1216有困难,找猪八戒 Q:要删除一张表中的重复记录,但是要保留一条 ... -
问:如何得到与WEB-INF同级目录下的配置文件
2008-09-23 08:35 2136Q: 有如下需求:需要从WEB-INF同级的目录下读取配 ... -
讨论如何优化这条sql
2008-09-11 16:33 1600SELECT * FROM ( ... -
N Vs Exist in SQL
2008-07-02 16:39 1394N Vs Exist in SQL 原文如下: http:// ... -
SQL 指南
2008-05-27 11:45 1047http://www.sql-tutorial.com/ -
orace 分析函数
2008-05-26 09:08 1214select x.num, sum(x.num) over ( ... -
oralce tutoial 指南
2008-03-22 14:21 1033http://www.exforsys.com/tutoria ... -
查找部分字段重复的记录 ORACLE Identifying duplicate rows
2008-03-13 08:49 1968http://www.jlcomp.demon.co.uk/f ... -
oracle 资源网站
2008-01-12 11:42 1880oracle alter table table_ ... -
Top 5 Oracle Reference Books 前5本 oracle 参考书
2008-01-12 11:24 1721http://databases.about.com/od/o ... -
Oracle与DB2、MySQL取前10条记录的对比<转>
2008-01-11 16:46 2223原文:http://tech.ccidnet.com/art/ ... -
expert on e on one oracle - Thomas Kyte 读书笔记
2008-01-11 10:17 2111=============================== ... -
oracle 资源 整体理解oralce 比较好 英文网
2008-01-09 16:59 1200http://www.adp-gmbh.ch/ora/admi ... -
oracle java 插入 clob insert clob hibernate
2007-12-21 15:48 7232用jdbc 或者 hibernate http://www.w ... -
pl/sql 应用之一
2007-12-12 17:21 1142declare begin insert into x ... -
init.ora文件所在目录
2007-12-12 15:58 2167Oracle安装盘:\oracle\admin\DB名称\pf ... -
[Oracle] 如何解决ORA-04031 错误
2007-12-12 15:53 3254[Oracle] 如何解决ORA-04031 ... -
oracle faq 常见问题解答 http://www.orafaq.com/
2007-12-12 13:34 1499The Oracle FAQ http://www.oraf ... -
oracle 快速参考
2007-12-12 09:58 1095http://www.psoug.org/library.ht ... -
oracle like
2007-12-12 09:18 3417http://www.adp-gmbh.ch/ora/sql/ ...
相关推荐
DB2 Express-C是IBM公司推出的一款免费、高性能的数据库管理系统,适用于Linux、UNIX和Windows操作系统,它旨在满足开发人员和小型企业对于数据库产品的需求。DB2 Express-C具有易于使用、功能强大、灵活性高等特点...
DB2 Express-C是一款免费的数据库管理系统,由IBM公司提供,适用于小型企业和个人开发者。它集成了企业级数据库功能,提供了一种经济高效的方式来处理数据存储和管理任务。本压缩包包含了一份“DB2 Express-C 快速...
DB2 Express-C是一款免费的IBM数据库管理系统,专为开发者和小型企业设计,提供了一种经济高效的方式来处理数据存储和管理。本快速入门指南将帮助读者迅速掌握DB2 Express-C的基本概念、安装步骤以及如何进行基本...
描述:本文深入解析了IBM官方的DB2 Express-C使用教程,旨在为初学者提供一个全面而深入的学习路径,涵盖DB2 Express-C的基本概念、特点、安装过程以及相关的工具和环境设置。 ### 一、DB2 Express-C概述 #### 1.1...
1. **安装与配置**:如何在不同的操作系统(如Windows、Linux或Unix)上安装DB2 Express C,以及配置数据库实例和数据库。 2. **数据库概念**:理解数据库的结构,如表、索引、视图、存储过程和触发器等,以及如何...
DB2 Express-C 9 DBA 和开发人员基础实验教程系列是IBM提供的一套全面的教育资源,旨在帮助初学者和有经验的IT专业人士掌握DB2 Express-C数据库管理系统的使用。DB2 Express-C是一款功能强大的免费版数据库,适用于...
用于 Docker 的 IBM DB2 Express-C 映像 这是 Dockerfiles 和 IBM DB2 Express-C 脚本的 Git 存储库,由 IBM Analytics Emerging Technology 团队维护。 此目录中的 Dockerfile 用于在上构建DB2 Express-C映像 用法...
在开始实验前,你需要下载并安装DB2 UDB Express-C V9.7。安装过程包括接受许可协议、选择安装类型(默认推荐“典型”)、设置安装路径以及配置数据库实例。安装后,需要创建一个数据库管理员(DBA)用户,用于后续...
资源名称:DB2 Express-C快速入门资源截图: 资源太大,传百度网盘了,链接在附件中,有需要的同学自取。
根据提供的文件信息,本书《DB2 Express-C:开发人员手册》涵盖了XML、PHP、C/C++、Java 和 .NET 在 DB2 数据库环境中的应用开发技术。以下是对该书籍涉及的关键知识点进行的详细阐述。 ### DB2 应用程序开发概述 ...
5. **创建数据库**:安装完成后,你可以使用DB2控制中心或命令行工具创建新的数据库。定义数据库的大小、存储特性以及安全性设置。 6. **驱动配置**:DB2链接服务器驱动使得在非DB2环境中可以访问DB2数据,例如在...
DB2 Express-C V9.5是一款适用于Linux、UNIX和Windows平台上的关系型数据库管理系统,由IBM公司开发。DB2 Express-C为社区版,意味着它在一定范围内提供免费的开发、部署和分发,不收取任何授权费用,但同时提供了...
很详细 一步步教你 一点都没有问题哦 下载瞎开看看
当然如果开发的话做好还是去IBM网站去下一个免费DB2数据库DB2 Express-C和开发包便于开发,开发包在数据库下载页面下载,DB2 Express-C VSAI 。下载前需要有一个IBM的账号,可以在网站上免费申请。 安装过程就不说了...
在本篇文章中,我们将详细介绍如何在 Ubuntu 操作系统上安装 IBM DB2 数据库系统。DB2 是一款功能强大的数据库管理系统,支持多种高级特性如存储过程、触发器以及数据分区等,并且提供了丰富的图形化管理工具。尽管...