Once you have finished Installing the Management Pack (IBM DB2) and Configuring the Management Pack (IBM DB2), check the Collection State and Collection Status for the adapter instance on the Solutions page. If they show as Not Collecting or No Data Receiving, respectively, the following troubleshooting topics can help you diagnose and correct common problems with your adapter instance.

  • Test Connection Errors
  • Adapter and Collector Log Files

Test Connection Errors

When Creating an Adapter Instance (IBM DB2), click Test Connection after entering all of your configuration settings to ensure vROps can connect to the specified host.

The following errors are possible:

Wrong Credentials

Error Message: Unable to establish a valid connection to target system. Connection authorization failure occurred. Reason: User ID or Password invalid.

Action: Ensure the correct IBM DB2 system and vRealize Operations User Name and Password was entered when adding your adapter instance.

Wrong Host

Error Message: Unable to establish a valid connection to target system. Required property is unknown host. Ensure the correct IBM DB2 Management IP or DNS name for you IBM DB2 System was entered.

Action: Ensure the correct hostname or IP address was entered when adding your adapter instance.

Wrong Port

Error Message: Unable to establish a valid connection to target system. Connection authorization failure occurred. Error opening socket server <name> on port with message: Connection refused.

Action: Check your DB2 database system and ensure the connection port number matches the port number entered (if other than default of 50000) when adding your adapter instance.

Wrong Database

Error Message: Connection authorization failure occurred. The application server rejected establishment of the connection. An attempt was made to access a database, <name>, which was either not found or does not support transactions.

Action: Ensure the database name(s) provided match the DB2 system. Multiple databases should be separated by commas in the Manage Solution window.

Adapter and Collector Log Files

You can review adapter errors in the adapter and collector log files, which can be viewed in the vROps UI or in an external log viewer.

  • Adapter log files are located in the $VCOPS_BASE/user/log/adapters/DB2Adapter/ folder.
  • Collector log files are located in the $VCOPS_BASE/user/log/ folder.

To set the base log level for the collector in vROps:

  1. Navigate to Administration > Logs .
  2. Expand the MASTER folder, then select the COLLECTOR folder.
  3. Click the Edit Properties configure_iconicon.
  4. In the Root logger level drop-down menu, select the desired option:

    • The default logging level is warning.
    • To troubleshoot issues, set the logging level to info.
    • To view detailed messages, including micro steps, queries, and returned results, set the logging level to debug.

      Note: If you set the logging level to debug , log files can become large very quickly. Set the logging level to debug only for short periods of time.

For more information about viewing log files and modifying levels, refer to the vROps online help.