`
zgqynx
  • 浏览: 1385223 次
  • 性别: Icon_minigender_1
  • 来自: 北京
社区版块
存档分类
最新评论

db2 express-c 安装后检查及安装例子数据库

阅读更多
摘自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
分享到:
评论

相关推荐

    CentOS下DB2数据库安装过程详解

    在本教程中,我们将深入探讨如何在CentOS操作系统上安装IBM的DB2数据库。DB2是一款功能强大的关系型数据库管理系统,广泛应用于企业级应用。在Linux环境下,特别是CentOS这样的服务器操作系统,DB2提供了稳定且高效...

    学习笔记:DB2+9+基础.pdf

    - **DB2 Express-C**:免费版本,支持Linux和Windows操作系统,提供DB2 Express的大部分功能。 - **DB2 Express Edition (DB2 Express)**:一款功能全面的客户机/服务器RDBMS,支持Web应用。 - **DB2 WorkGroup ...

    oracle学习文档 笔记 全面 深刻 详细 通俗易懂 doc word格式 清晰 连接字符串

    预定义角色是在数据库安装后,系统自动创建的一些常用的角色。下面我们就简单介绍些系统角色:  CONNECT, RESOURCE, DBA这些预定义角色主要是为了向后兼容。其主要是用于数据库管理。oracle建议用户自己设计数据库...

    SQL简单分页教程~~~详细

    此时,你需要在`JOIN`后的查询语句中使用`ROW_NUMBER()`,并确保所有的数据都能正确排序。例如: ```sql WITH CTE AS ( SELECT ROW_NUMBER() OVER (ORDER BY t1.column1 DESC) AS Row, t1.*, t2.* FROM table1 t1...

Global site tag (gtag.js) - Google Analytics