Teradata Extension for Tivoli Storage Manager generates Teradata-specific messages in the TSM server activity log every time it opens and closes a backup file. These messages are strings that include TDB0nnn, where nnn is the message ID.
The next example includes a command, plus the report it generates, of Teradata Extension for Tivoli Storage Manager messages that are associated with opening a Teradata backup file in WRITE mode:
Query actlog search=TDB0002| Date/Time | Message |
|---|---|
| 06/23/2003 11:41:54 | ANE4991I (Session: 4901, Node: MERLOT) Teradata TDB0002 System merlot Opening Teradata backup NS=Teradata,DSN-DATA0001 Generation=3 in write mode |
| 06/23/2003 11:56:17 | ANE4991I (Session: 4903, Node: MERLOT) Teradata TDB0002 System merlot Opening Teradata backup NS=Teradata, DSN-DATA0002 Generation=4 in write mode |
| 06/23/2003 11:56:44 | ANE 4991I (Session: 4905, Node: MERLOT) Teradata TDB0002 System merlot Opening Teradata backup NS=Teradata, DSN=DATA0001\Long_Path$#.DATA Generation=1 in write mode |
| 06/23/2003 11:57:12 | ANE4991I (Session: 4906, Node: MERLOT) Teradata TDB0002 System merlot Opening Teradata backup NS=Teradata, DSN=DATA0001.DSN Generation=1 in write mode |
Query for all messages associated with a particular session or time period to see the server context of the operation, such as, device errors from mounting tapes.
The default retention period for a TSM server activity log is only one day, so regular checks are recommended. Viewing older logs requires special procedures.
For more information about the syntax of the QUERY ACTLOG command, refer to IBM’s Tivoli Storage Manager for Windows: Administrator’s Reference.