For every problem, collecting data can aid in problem determination and save time resolving Problem Management Records (PMRs).
Gathering this data before calling IBM support will help you understand the problem and save time analyzing the data. This document will help answer the question which information should I collect?
Collecting data early, even before opening the PMR, helps IBM® Support quickly determine if:
- Symptoms match known problems (rediscovery).
- There is a non-defect problem that can be identified and resolved.
- There is a defect that identifies a workaround to reduce severity.
- Locating root cause can speed development of a code fix.
Gathering general information
For IBM® DB2 for Linux, UNIX, and Windows products, gather the following information for any problem:
Collecting environment information using db2support
Gathering specific information
|Client / Server Connectivity|
|Compiler (Query Explain, Query Rewrite, Query Optimizer)|
|Backup / Restore|
|High Availability Disaster Recovery (HADR)|
|Deadlocks and Locking Issues|
|More topics to come as they become available.|
Submitting information to IBM Support
Once you have collected your information, you can begin Problem Determination through the product Support web page, or simply submit the diagnostic information to IBM support. Use the document below for instructions on submitting your files to IBM DB2 Support.
Submitting diagnostic information to IBM Technical Support for problem determination