DB2 10.5 for Linux, UNIX, and Windows

Verifying your DB2 pureScale installation and setup

Use the steps in this task to verify your installation and setup of the IBM® DB2® pureScale® Feature.

About this task

The following steps outline a procedure for you to verify your DB2 pureScale installation and setup. Perform these steps after you have created your DB2 pureScale instance and added all of the members and CFs you want in your DB2 pureScale environment.

Procedure

Check the installation logs for any errors.
As the instance user, run the db2instance -list command. This command returns a list of the members and cluster caching facilities (CFs) in your DB2 pureScale environment. If you manually installed the DB2 pureScale Feature, the status of the members and CFs in your DB2 pureScale environment will be in the STOPPED state. You can, run the db2start command to start the DB2 pureScale instance and rerun the db2instance -list command.
Verify that all the members and CFs have been started (STATE = STARTED). One CF should be PRIMARY. The other CF should be in either PEER state or CATCHUP state.
Note: When you view the status of the non-primary CF using the command db2instance -list, it will be in CATCHUP state until a connection is made to the database. Once the first connection is made, the process of copying data from the primary CF begins.
Run the db2sampl command to create a sample database.
Issue the following command to connect to the SAMPLE database:
```
   db2start 
   db2 connect to SAMPLE
```
Issue the following statement:
```
   db2 "select *from EMP"
```
If this command returns records, then everything is working as it should.