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
Related Information
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21335118