Verifying database connections

After WebSphere Portal is configured to work with your preferred database, test the database connection to ensure that it operates correctly. You can verify the database connection using the WebSphere Application Server Administrative Console or from a command prompt.

• Verifying the connection with WebSphere Application Server
• Verifying the connection from a command prompt

Verifying the connection with WebSphere Application Server

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

1. If you installed the WebSphere Portal V5.0 Test Environment on WebSphere Application Server (WAS) V5.0.2:
   • Change directory to WS_Installdir\runtimes\portal_base_v5\bin (WS_Installdir is the directory where you have installed WebSphere Studio).
2. Execute the following commands:
   Linux:
   1. ./startServer.sh server1
   2. Access the WebSphere Application Server administrative console by entering http://localhost:9090/admin in a browser.
   Windows:
   1. "firststeps.bat" to open the WebSphere Application Server First Steps.
   2. Select Start the Server and Administrative Console.
3. Log in to the administrative console.
4. Click Resources JDBC Providers .
5. Select wps50JDBC.
6. Select Data Sources from Additional Properties.
7. Check the data source that you want to test.
8. Click Test Connection to verify the database connection. Note: You might have to restart WebSphere Application Server for the test to complete.

Verifying the connection from a command line

You can also verify the database connection from a command prompt by performing the following steps:

1. In the command prompt, change to the directory WS_Installdir/runtimes/portal_v50/config.
2. To verify connections for the WebSphere Portal, Member Manager, and content publishing databases, enter the following commands:
   • Linux:
     • ./WPSconfig.sh validate-database-connection-wps -DDbPassword=password
     • ./WPSconfig.sh validate-database-connection-wmm -DWmmDbPassword=password
     • ./WPSconfig.sh validate-database-connection-wpcp -DWpcpDbPassword=password -DFeedbackDbPassword=password
   • Windows:
     • WPSconfig.bat validate-database-connection-wps -DDbPassword=password
     • WPSconfig.bat validate-database-connection-wmm -DWmmDbPassword=password
     • WPSconfig.bat validate-database-connection-wpcp -DWpcpDbPassword=password -DFeedbackDbPassword=password

Next steps

You have completed this step.