Verify database connections

 

Overview

After WebSphere Portal is configured to work with the preferred database, the connection should be verified to ensure that it operates correctly. You can verify the database connection with the WAS administrative console or from a command line.

 

Verify the connection with WAS

This topic includes information on verifying the database connection after installation and configuration. Verify that the database server is installed and working properly.

  1. Access the WAS administrative console by entering...

    http://<hostname.yourco.com>:<port_number>/admin

    ...in a browser. Type the following information in a 5250 session command line to determine the port number:

    qsh cmd('/QIBM/ProdData/WebAS5/PME/bin/dspwasinst -instance <instance>')

  2. Log in to the administrative console and go to...

    Resources JDBC Providers Then click wps50JDBC Then click Data Sources Then click Additional Properties

  3. Check the data source that you want to test.

  4. Click Test Connection to verify the database connection.

    You might have to restart the WAS for the test to complete.

 

Verify the connection from a command line

You can also verify the database connection from a command line starting a 5250 session on the local machine where WebSphere Portal is installed, and then running...

> strqsh
> cd /qibm/userdata/webas5/base/<instance>/portalserver5/config
> wpsconfig.sh validate-database-connection-<schema_name> -DDbPassword=<password>

...where <schema_name> is wmm, wps, or wpcp

Note on passwords: For security reasons, not leave passwords in the wpconfig.properties file. It is recommended that you edit the wpconfig.properties file prior to running a configuration task, inserting the passwords that are needed for that task. Then, after the task has run, delete all passwords from the wpconfig.properties file. For more information, see Deleting passwords.

Alternatively, you can specify the password on the command line rather than update the wpconfig.properties file. For example:

WPSconfig.sh -DPortalAdminPwd=<password> validate-wps-admin-login

If you select the Install and Configure option when installing WebSphere Portal, or use the IBM Web Administration for iSeries tool, the passwords in the wpconfig.properties file are automatically removed after configuration.

 

Related information