IBM Support

Collecting data for DB2 Restore failure from Disk for DB2 on all platforms.

Question & Answer


Question

What information should be collected when I experience a problem with my software? Collecting data for a DB2 Restore failure from disk. Collecting this information before calling IBM support will help you understand the problem and save time analyzing the data.

Answer

Processes to run:
This section lists processes to run in this situation to gather required data.

* On Linux/UNIX, run ps -ef to a file (to collect a list of the currently running processes).
* On all platforms run db2support -d DBNAME -c -s (to collect basic troubleshooting information).
* On Linux/UNIX, ls -lr of the backup directory (to get complete directory tree for the backup directory).
* On Windows, use the tree command on the backup directory (to get a complete directory tree for the backup directory).

Files to collect
This section lists files to collect which are normally (or optimally) generated for this problem.

* The output of the commands (db2support.zip, output of ps -ef and directory listing commands).
* The exact restore command used.


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 submitting information to IBM Support.
Submitting diagnostic information to IBM Technical Support for problem determination

[{"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Component":"Recovery - Restore","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"9.8;9.7;9.5;9.1;10.1;10.5","Edition":"Enterprise Server;Express;Personal;Workgroup Server","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
16 June 2018

UID

swg21326472