Question & Answer
Question
Can the activity log messages be seen when the server is not running?
Answer
If DB2 is running, it is possible to create a SELECT statement and query DB2 to get the Tivoli Storage Manager activity log messages while the server is not running. To do this, first connect to the Tivoli Storage Manager database using the instance owners ID (example, tsminst1):
db2 connect to TSMDB1
db2 set schema TSMDB1
In the following example, all messages from 9/22/2009 at 13:44:25 to the current time will be retrieved and put in order by the date/time:
db2 "select * from TSMDB1.ACTIVITY_LOG where DATETIME >= '2009-09-22-13.44.25' order by DATETIME" > /tmp/actlog.txt
It is recommended that you redirect the output to a file. To list all the table names within the database, use the following command:
db2 "select * from syscat.tables" > /tmp/syscat.txt
The important part to remember when creating a select statement is to have the entire select statement in double quotes.
[{"Product":{"code":"SSGSG7","label":"Tivoli Storage Manager"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Component":"Server","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"6.3;7.1","Edition":"","Line of Business":{"code":"LOB26","label":"Storage"}}]
Historical Number
1405463
Product Synonym
TSM
Was this topic helpful?
Document Information
Modified date:
17 June 2018
UID
swg21579501