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.
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:
- Locate the db2cli.ini file in the DB2 installation directory: {db2_install}/sqllib/cfg
- Append this stanza to the db2cli.ini file:
[COMMON]
TRACE=1
TRACEFILENAME=C:\DB2TRC.TXT
TRACEFLUSH=1 - Recreate the behavior.
- 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"}}]
Was this topic helpful?
Document Information
Modified date:
24 July 2020
UID
swg21177047