IBM Support

Collecting data: Read first for DB2 for Linux, UNIX, and Windows products

Question & Answer


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:
  1. Symptoms match known problems (rediscovery).
  2. There is a non-defect problem that can be identified and resolved.
  3. There is a defect that identifies a workaround to reduce severity.
  4. 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)
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