Solution : https://service.sap.com/sap/support/notes/83819 (SAP Service marketplace login required)
Summary :
SAP Note outlines procedures for using the db2support tool from IBM DB2 for Linux, UNIX, and Windows to gather data crucial for troubleshooting database issues. When database problems arise, specific data collection helps SAP support analyze issues effectively. This tool compiles necessary information into a db2support.zip file. Users must execute this under specific user accounts with appropriate commands detailed in the note. The tool supports various options to fine-tune data collection per scenario needs and supports multiple database partitions. For optimization-related data, direct SQL input and configuration parameters are also supported.
Key words :
sql stmt> -ol <optlevel> -cs <connect user>, txt -ol 5 -cs sapcxx additional information, set current schema <connect user>, db2<sid>>/sqllib/misc/explain, sap support ream requires data, collecting general support data enter, sap connect user sapcxx, option '-cs <connect user>', <sid>db2 -tvf <home, sql # sql text exfmt_badquery
Related Notes :
| 1486120 | DB6: Data Collection in a CLI driver environment |
| 932918 | DB6: Collect Stack Traces of DB2 Processes |
| 851151 | DB6: New functions in DB2 V8 FixPak 9 (V8.2.2) |
| 721359 | DB2support tool error causes database to crash |
| 538315 | Central SAP Note for DB6 Admin Tools |
| 132290 | DB2/CS: SQL0912 maximum number of lock requests |
| 65761 | Configuration test tool for Windows, sapntchk download |