Symantec logo

Confirming the setup of DB2 MPP installation

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

 To check if each 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