IBM Support

Can you get Tivoli Storage Manager actlog messages when server is down?

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

Document Information

Modified date:
17 June 2018

UID

swg21579501