Verifying database creation and deployment

To verify that the database was created and deployed successfully:

1. On the server where you installed the resource manager database, enter the following command at a Db2® command prompt:

   list db directory 

   Verify that the resource manager database name appears in the list of databases.

   • If the resource manager is listed, continue with step 2.
   • If it is not listed, see Troubleshooting resource manager database creation errors using the icmcrrmdb.log.
2. At the same command prompt, enter:

   connect to resourcemanager_dbname user userID using password 

   • If the connection succeeds, continue with step 3.
   • If the connection fails, see Troubleshooting resource manager database creation errors using the icmcrrmdb.log.
3. At the same command prompt, enter:

   list tables 

   Verify that the program returns a list of approximately 25 tables.

   • If the system displays the expected number of tables, continue with step 4.
   • If the system displays fewer tables, see Troubleshooting resource manager database creation errors using the icmcrrmdb.log.
4. Verify that the resource manager was deployed and is started. Enter:

   list applications 

   When the resource manager starts, it attempts three connections to the resource manager database. Verify that the program displays three java.exe applications, and that the resource manager name is listed in the DB Name column. If you receive results that are different from those results, see Verifying resource manager deployment and Verifying database connections.