Question & Answer
Question
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?
Answer
Collecting data early, even before opening the PMR, helps IBM® Support quickly determine if:
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
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
- 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
| Topic |
| Installation |
| Client / Server Connectivity |
| Compiler (Query Explain, Query Rewrite, Query Optimizer) |
| Backup / Restore |
| High Availability Disaster Recovery (HADR) |
| Migration Issues |
| Deadlocks and Locking Issues |
| Server Hang |
| Infosphere Federation Server |
| Other Topics |
| 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
[{"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"OTHER - Uncategorised","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"9.7;9.5;10.1;10.5;11.1","Edition":"Enterprise Server;Express;Personal;Workgroup Server","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
31 July 2019
UID
swg21282870