IBM Support

Collecting data for DB2 Restore failure from TSM 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 TSM. 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).

TSM API Version:

* For Linux/UNIX, do a what command on the TSM API library file libApiDS.x file (libApiDS64.x for 64-bit) (where x=a for AIX, x=so for Solaris, x=sl for HPUX).
* For Windows look at the Version tab from the Properties of the tsmapi.dll file.
* Also running the dsmc command on the client to start the TSM backup client will output the level of the client during startup. Once in the TSM backup client, you can run Q SESS command to get the level of the TSM server that the client is connected to.

Files to collect

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

* The output of the previous commands (db2support.zip, dsmc output, etc).
* The exact restore command used.

TSM options files:

* dsm.opt (pointed to by DSMI_CONFIG environment variable)
* dsm.sys (UNIX only) (in the directory pointed to by DSMI_DIR environment variable)

TSM error log:

* dsierror.log in the directory pointed to by DSMI_LOG environment variable (or ERRORLOGNAME in the options file - dsm.opt)
* Also, please gather the TSM Server activity log for time of restore.


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

swg21335118

Page Feedback