Quick Beginnings EEE for Windows**

Verifying the Installation



Figure 00002674 not displayed.

If you are verifying the installation of a DB2 Enterprise - Extended Edition server, ensure that you perform these steps on the instance-owning database partition server

You can verify that DB2 is installed correctly by creating the DB2 UDB SAMPLE database on your system, and accessing data from the database.

If you have installed First Steps, you can verify the installation by performing the following steps.

Step  1.

Log on to the instance-owning database partition server with the user account that you created to verify the installation.

Step  2.

Start First Steps. For more information, see Starting First Steps.

Step  3.

Select Create SAMPLE databases on the First Steps Launchpad to open the Create SAMPLE databases window.

Step  4.

In the Create SAMPLE databases window, select all of the following databases that you want to create:

  • DB2 UDB Sample database
  • Data Warehousing Sample database
  • OLAP Sample database

You use the DB2 UDB sample database to verify the installation. You need the other two databases if you want to run the Business Intelligence tutorial. For more information about these databases, refer to Data Warehouse Center Administration Guide and OLAP Setup and User's Guide.
Note:The Data Warehousing and OLAP sample databases only apply if you installed the Base Warehouse and OLAP Starter Kit components.

Step  5.

Click OK.

You must ensure that the drive where the SAMPLE database will be created exists on every machine that participates in your partitioned database system. By default, the SAMPLE database is created on the drive where DB2 is installed.

This command may take a few minutes to process. For a detailed description of the contents of the SAMPLE database, refer to the Administration Guide. When the SAMPLE database has been created, you will receive a completion message. Click OK.

Step  6.

Once the database is created, select Work with the SAMPLE databases on the First Steps Launchpad to start the Control Center. The Control Center allows you to perform administration tasks on different instance and database objects.

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. For more information, see Administering Instances and Databases with the DB2 Administration Tools.

To verify that the Data Warehouse component installed correctly, select the Data Warehouse Center icon.

Step  7.

To verify that the OLAP Starter Kit component installed correctly, click Start --> Programs --> IBM DB2 --> OLAP --> OLAP Desktop.

If you did not install the DB2 tools, you can verify the installation by creating the SAMPLE database and connecting to it using the command line processor as follows:

Step  1.

Log on to the instance-owning database partition server with the DB2 user account that you created to verify the installation.

Step  2.

Enter the db2sampl command to create the SAMPLE database.

By default, the SAMPLE database will be created on the drive where DB2 was installed; however, you can specify a drive on which to create this database. For example, to create the SAMPLE database on the F: drive, enter the following command:

   db2sampl F:

This command may take a few minutes to process. For a detailed description of the contents of the SAMPLE database, refer to the Administration Guide. There is no completion message; when the command prompt returns, the process is complete.

You must ensure that the drive where the SAMPLE database will be created exists on every machine that participates in your partitioned database system.

The SAMPLE database is automatically cataloged with the database alias SAMPLE when it is created.

Enter the dwcsmp and olapsmp commands to create data warehousing and OLAP sample databases. When prompted, provide a user ID and password. You need these databases if you want to run the Business Intelligence tutorial. For more information about these databases, see the Data Warehouse Center and OLAP manuals.

Step  3.

Start the database manager by entering the db2start command.

Step  4.

Enter the following DB2 commands from a DB2 Command Window to connect to the SAMPLE database, retrieve a list of all the employees that work in department 20, and reset the database connection:

   db2 connect to sample
   db2 "select * from staff where dept = 20"
   db2 connect reset

For information about entering DB2 commands, see Appendix A, Basic Task Knowledge.



Figure 00002674 not displayed.

After you have verified the installation, you can remove the SAMPLE database to free up disk space. Enter the db2 drop database sample command to drop the SAMPLE database.


[ Top of Page | Previous Page | Next Page ]