Question & Answer
Question
Collecting DB2 environment information for Tivoli Storage Manager Server troubleshooting using the db2support utility.
Answer
Collecting DB2 environment information via the "db2support" utility can be required to aide in V6/V7 Tivoli Storage Manager Server troubleshooting activities. The "db2support" utility automatically collects DB2 and system diagnostic information to help in problem determination.
While the db2support utility provides many options, flags, and switches, the following syntax is the most common:
db2support <output directory path> -d <database name> -c -s
This command will generate a compressed file labeled "db2support.zip" that includes the DB2 environment data.
Collecting a db2support.zip on UNIX platforms:
1. Login to the system as the TSM instance owner (ie tsminst1).
2. Issue the db2support command at the system shell. For example:
$ db2support . -d TSMDB1 -c -s
3. Once the command completes, a db2support.zip file will be located in the directory specified.
Collecting a db2support.zip on Windows platforms:
1. Login to the system as the Administrator.
2. Open an MS-DOS command prompt and issue "db2cmd" to start the DB2 command-line processor.
3. Within the DB2 CLP, issue the db2support command. For example:
C:\Users\Administrator>db2support . -d TSMDB1 -c -s
4. Once the command completes, a db2support.zip will be located in the directory specified.
Related Information
Product Synonym
ITSM ADSM TSM
Was this topic helpful?
Document Information
Modified date:
17 June 2018
UID
swg21621733