IBM Support

MustGather: Instana DB2 Sensor

Troubleshooting


Problem

This guide provides essential steps for collecting data related to Instana DB2 Sensor. Before contacting IBM® support for assistance, please review the information below to familiarize yourself with the troubleshooting process.

Resolving The Problem

To explore potential solutions, search for issues, access documentation, or visit support forums, head to the IBM® Support page. If you are aware of the affected component, refer to the relevant MustGather details below:
MustGather Data Collection Requirements for Instana DB2 Sensor

Monitored environment details:
  • Kind of deployment (Single host , Primary/Replica, PureScale, Kubernetes, docker, podman, etc.)
  • OS (Linux/ Windows) and version
  • IBM DB2 version (IBM Db2 LUW)/Fix Pack/Patch Level
  • Names of DB2 instance(s) & database(s) being monitored
  • Is the DB2 being monitored locally/remotely?
Agent logs:
  • Collect debug log of Instana agent:
    • See the MustGather page for Instana Agent for more details
Agent configuration:
  • Collect <instana-agent-dir>/etc/instana/configuration.yaml file 
Debug Logs & Error Messages:
  • DB2 diagnostic log: <instance_home>/sqllib/db2dump/db2diag.log
  • Collect any .trap, .dump, or .edf files in diagnostic path.
  • For crash/core dumps, collect:
    • Core dump file
    • Backtrace using db2sym or gdb
    • db2support . -d <dbname> -s -c
Additional output & files to collect:
  • Please run the following SQL and upload the results to the case
    • DB2 authentication & limitations: 
      • db2 get dbm cfg | grep -i auth
    • DB2 user privileges for monitoring: 
      • db2 "SELECT AUTHORITY, D_USER, D_GROUP, D_PUBLIC, ROLE_USER, ROLE_GROUP, ROLE_PUBLIC 
     FROM TABLE (SYSPROC.AUTH_LIST_AUTHORITIES_FOR_AUTHID('<instana_user>', 'U')) AS T"
    • DB2 diagnostics & performance info: 
      • db2set -all
db2 get dbm cfg
db2 get db cfg for <dbname>
db2pd -db <dbname> -hadr        # if HADR enabled
db2cluster -cm -list            # if PureScale
    • ​​​​​​​​​​​​​​System resource snapshots:
      • Linux: 
        top -b -n1, vmstat 5 5, iostat -x 5 5
      • Windows: Windows: PerfMon snapshot

Document Location

Worldwide

[{"Type":"MASTER","Line of Business":{"code":"LOB77","label":"Automation Platform"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSE1JP5","label":"IBM Instana Observability"},"ARM Category":[{"code":"a8m3p000000UoUBAA0","label":"Sensors - Setup \u0026 Discovery"}],"ARM Case Number":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"1.0.281;1.0.282;1.0.283;1.0.284;1.0.285;1.0.286;1.0.287;1.0.288;1.0.289;1.0.290;1.0.291;1.0.292;1.0.293;1.0.294;1.0.295;1.0.296;1.0.297;1.0.298;1.0.299;1.0.300;1.0.301;1.0.302;1.0.303;1.0.304;1.0.305;1.0.307"}]

Document Information

Modified date:
17 October 2025

UID

ibm17245691

Page Feedback