Skip to main content

Software  >  Information Management  >  DB2 Product Family  >  

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

 
 
 

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
Please take a moment to complete this form to help us better serve you.
This material provides me with the information I need.




This material is clear and easy to understand.




Did the information help you to achieve your goal?
What updates, improvements, or related information would you like to see in this document?
Your response will be used to improve our document content. Requests for assistance, if applicable, should be submitted through your normal support channel as we cannot respond from this site.
Input the verification number to submit feedback:
Document information
 Product categories:
 Software
 Data Management
 Data Servers (Database Management Systems)
 DB2 for Linux, UNIX and Windows
 Operating system(s):
  AIX, HP-UX, Linux, Linux iSeries, Linux pSeries, Linux xSeries, Linux zSeries, Solaris, Windows
 Software version:
  8, 9.1, 9.5, 9.7
 Software edition:
  Enterprise Server, Express, Personal, Personal Developer's, Workgroup Server
 Reference #:
  1282870
 IBM Group:
 Software Group
 Modified date:
 2009-07-08

Translate My Page
 
 

Rate this page

Help us improve this page. Your response will be used to improve our document content. Requests for assistance, if applicable, should be submitted through your normal support channel as we cannot respond from this site.