IBM Support

Procedure for capturing a DB2 CLI trace for IBM Integration Bus

Troubleshooting


Problem

IBM Integration Bus (IIB) supports connectivity to DB2 databases.
Use this process to capture a trace of the DB2 Command Line Interface (CLI) for the purpose of providing to IBM Support for analysis.

Resolving The Problem

Use this procedure to capture a DB2 CLI trace:
  1. Locate the db2cli.ini file in the DB2 installation directory: {db2_install}/sqllib/cfg
  2. Append this stanza to the db2cli.ini file:
    [COMMON] 
    TRACE=1 
    TRACEFILENAME=C:\DB2TRC.TXT 
    TRACEFLUSH=1
  3. Recreate the behavior.
  4. Disable the trace by updating the db2cli.ini file: TRACE=0

[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSNQK6","label":"IBM Integration Bus"},"ARM Category":[{"code":"a8m50000000CiJ2AAK","label":"IIB2->Databases->DB2"}],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"10.0.0;9.0.0","Line of Business":{"code":"LOB45","label":"Automation"}}]

Document Information

Modified date:
24 July 2020

UID

swg21177047