Verifying a partitioned database server installation (Linux® and UNIX)

Use the db2val tool to verify the core functions of a Db2® copy by validating installation files, instances, database creation, connections to that database, and the state of partitioned database environments. For details, see Validating your Db2 copy. The state of a partitioned database environment is only verified if there are at least 2 nodes. In addition, to verify that your Db2 database server installation was successful, you will create a sample database and run SQL commands to retrieve sample data and to verify that the data has been distributed to all participating database partition servers.

Before you begin

Before following these steps, make sure you have completed all of the installation steps.


To create the SAMPLE database:

  1. Log on to the primary computer (ServerA) as the instance-owning user.
    For this example, db2inst1 is the instance-owning user.
  2. Enter the db2sampl command to create the SAMPLE database.
    By default, the sample database will be created in the instance-owner's home directory. In our example /db2home/db2inst1/ is the instance owner's home directory. The instance owner's home directory is the default database path.

    This command can take a few minutes to process. There is no completion message; when the command prompt returns, the process is complete.

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

  3. Start the database manager by entering the db2start command.
  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:
       db2 connect to sample
       db2 "select * from staff where dept = 20"
  5. To verify that data has been distributed across database partition servers, enter the following commands from a Db2 command window:
    db2 "select distinct dbpartitionnum(empno) from employee"
    The output will list the database partitions used by the employee table. The specific output will depend on:
    • The number of database partitions in the database
    • The number of database partitions in the database partition group that is used by the table space where the employee table was created

What to do next

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.