Skip to main content

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


Technote (FAQ)


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:

  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

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
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

Rate this page:

(0 users)Average rating

Copyright and trademark information

IBM, the IBM logo and ibm.com are trademarks of International Business Machines Corp., registered in many jurisdictions worldwide. Other product and service names might be trademarks of IBM or other companies. A current list of IBM trademarks is available on the Web at "Copyright and trademark information" at www.ibm.com/legal/copytrade.shtml.

Rate this page:


(0 users)Average rating

Add comments

Document information

DB2 for Linux, UNIX and Windows


Software version:
8, 9.1, 9.5, 9.7


Operating system(s):
AIX, HP-UX, Linux, Linux iSeries, Linux pSeries, Linux xSeries, Linux zSeries, Solaris, Windows


Software edition:
Enterprise Server, Express, Personal, Personal Developer's, Workgroup Server


Reference #:
1282870


Modified date:
2013-04-16

Translate my page

Content navigation