Symantec logo

Confirming the setup of DB2 MPP and non-MPP installations

On the host where the shared file system is mounted, check whether you can start and stop each instance, to verify that DB2 is properly installed.

 To check if a DB2 instance can start and stop

  1. Log in as the instance owner:

    # su - db2inst1

  2. Attempt to start the instance:

    $ db2start

    The application should start on the nodes specified in the db2nodes.cfg file.

  3. Assuming the previous command is successful, stop the instance:

    $ db2stop

  4. If the application does not start successfully or stop correctly on each node, check for configuration errors. Review your DB2 UDB documentation, such as the DB2 Universal Database Quick Beginnings Guide.
  5. Create a database.

    $ db2 create database dbname

  6. List the database directory

    $ db2 list database directory

 To check the rest of the DB2 configuration in the cluster

  1. For each node in the VCS cluster, import the disk group and start all the volumes in the disk group.
  2. Mount the file system for the volume containing the DB2 instance and database.
  3. Perform the steps in the procedure above.

    See To check if a DB2 instance can start and stop.

  4. Unmount and deport the disk group.
  5. Repeat this procedure for each node in the cluster.