Testing the database connectivity

Before you can use IBM® Product Master, you must create the database schema.

About this task

When you are connecting the database, the <install dir>/bin/test_db.sh script tests the native client and the JDBC connections. The script prints any errors.

The schema generation script, create_schema.sh, does not stop if it encounters an error nor does it display errors. Examine the log file, <install dir>/logs/schema.log, to ensure that the schema was successfully created.

You can run the script, create_schema.sh, with the —verbose option. This option prints the logging information to the log file. It also includes the SQL that was sent to the database and the output from the Java™ programs.

Procedure

  1. Verify database user.
    Verify that the database user referenced in the common.properties file exists in the database with the correct privileges.
  2. Verify that you have command-line connectivity and that Product Master can connect to the database by running the following shell script:
    1. Run test_db.sh.
      The command test_db.sh tests command-line connectivity using DB2® or sqlplus. It also tests JDBC connectivity using Java.
  3. After the database user is set up correctly, create the Product Master database schema.