Contents

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Conventions
• What's Changed

1 Troubleshooting Common Issues

• 1.1 Installation Guides
• 1.2 Debugging the Agent
  • 1.2.1 Setting the Log Level
  • 1.2.2 Turning on the Metric Browser
  • 1.2.3 Checking Connectivity from the Agent Host
  • 1.2.4 Using the Test Connection Button
• 1.3 JDBC Driver Issues
  • 1.3.1 Failure in loading Classpath: Could not create instance: <JDBC DRIVER>
  • 1.3.2 Cannot resolve non-optional query descriptor property [PLUGIN_DEPENDENCIES] (PLUGIN_DEPENDENCIES)

2 Troubleshooting Microsoft SQL Server Plug-in

• 2.1 Diagnostic Tools
  • 2.1.1 WBEMTEST
  • 2.1.2 CIM Studio
  • 2.1.3 SQL Server Enterprise Manager
• 2.2 Diagnostic Steps
  • 2.2.1 Phase 1 Checklist
  • 2.2.2 Phase 2 Checklist
  • 2.2.3 Phase 3 Checklist
• 2.3 Finding TCP/IP Port
• 2.4 Microsoft URL for WMI Errors
• 2.5 How To Fix Microsoft SQL Server Plug-in Issues
  • 2.5.1 Downloading the Latest Version of the Plug-in
  • 2.5.2 Enabling TCP/IP Port (Microsoft SQL Server 2005 Only)
  • 2.5.3 Modifying Permissions
    • 2.5.3.1 Modifying Windows Management Instrumentation Control Permissions
    • 2.5.3.2 Modifying Registry Permissions
    • 2.5.3.3 Modifying Permissions for Database Authentication
    • 2.5.3.4 Assigning User Rights
    • 2.5.3.5 Modifying DCOM Remote Access Permissions
    • 2.5.3.6 Modifying Access Privileges of SQL Server Services
• 2.6 General Issues
  • 2.6.1 The ”Add Microsoft SQL Server” Page Explained
    • 2.6.1.1 Monitoring Database Host Credentials
    • 2.6.1.2 Monitoring Database Credentials
    • 2.6.1.3 Using Windows Integrated Authentication
  • 2.6.2 Monitoring Error Messages
  • 2.6.3 General Connection Issues
    • 2.6.3.1 General Connection Errors
    • 2.6.3.2 JDBC Connection Errors
    • 2.6.3.3 WMI Connection Errors
  • 2.6.4 Windows Authentication Issues
• 2.7 Report Elements and Dependent Metrics
  • 2.7.1 Report Error Messages
• 2.8 Support References for Microsoft SQL Server Plug-in

3 Troubleshooting IBM DB2 Database Plug-in

• 3.1 Finding a TCP/IP Port
  • 3.1.1 Finding a TCP/IP Port for UNIX Platforms
  • 3.1.2 Finding a TCP/IP Port for Microsoft Windows Platforms
  • 3.1.3 Finding a TCP/IP Port for z/OS Platforms
• 3.2 IBM DB2 Problem Resolution
  • 3.2.1 Using a Suitable OS User and Assigning Authorities and Privileges
  • 3.2.2 Incorrect Credentials Used
  • 3.2.3 Failure in Loading Classpath: Could Not Create Instance
  • 3.2.4 No Data for Health Indicator Metrics
  • 3.2.5 Lock Waits Metric Not Collecting
• 3.3 Database Monitoring Metric Collection Error Messages
• 3.4 Report Elements and Dependent Metrics
• 3.5 Support References for IBM DB2 Plug-in

4 Troubleshooting Sybase ASE Plug-in

• 4.1 General Error Messages
• 4.2 Configuration Parameter Errors
• 4.3 Report Element Errors
• 4.4 Support References for Sybase ASE Plug-in

Index