Search a file for a specific node on the TSM server:
tsm: TSM1>select * from backups where node_name='AVALOQPROD_ITSM' and ll_name='AVALIV_sbmdqfo1_1' NODE_NAME: AVALOQPROD_ITSM FILESPACE_NAME: /tsmorc FILESPACE_ID: 1 STATE: ACTIVE_VERSION TYPE: FILE HL_NAME: // LL_NAME: AVALIV_sbmdqfo1_1 OBJECT_ID: 801171339 BACKUP_DATE: 2011-06-01 18:31:30.000000 DEACTIVATE_DATE: OWNER: oracle CLASS_NAME: MC_ORACLE_ITSM tsm: TSM1>select * from backups where node_name='BENJAMIN' and filespace_name='\\benjamin\c$' NODE_NAME: BENJAMIN FILESPACE_NAME: \\benjamin\c$ STATE: ACTIVE_VERSION TYPE: DIR HL_NAME: \ LL_NAME: OBJECT_ID: 6145 BACKUP_DATE: 2002-12-30 08:29:29.000000 DEACTIVATE_DATE: OWNER: CLASS_NAME: STANDARD NODE_NAME: BENJAMIN FILESPACE_NAME: \\benjamin\c$ STATE: ACTIVE_VERSION TYPE: FILE HL_NAME: \ LL_NAME: 1-3200201.PRT OBJECT_ID: 6176 BACKUP_DATE: 2002-12-30 08:29:29.000000 DEACTIVATE_DATE: OWNER: CLASS_NAME: DEFAULT
List the content of a TSM volume:
tsm: TSM1>select * from contents where volume_name='501245' VOLUME_NAME: 501245 NODE_NAME: AVALOQPROD_ITSM TYPE: Bkup FILESPACE_NAME: /tsmorc FILE_NAME: //AVALIV_g6m0ufb2_1 AGGREGATED: No FILE_SIZE: 2957235626 SEGMENT: 1/1 CACHED: NO FILESPACE_ID: 1 FILESPACE_HEXNAME: 2F74736D6F7263 FILE_HEXNAME: 2F2F4156414C49565F67366D30756662325F31 BITFILE_ID: 677419256 OBJECT_ID: 677419256 COPIED: No DAMAGED: Yes VOLUME_NAME: 501245 NODE_NAME: AVALOQPROD_ITSM TYPE: Bkup FILESPACE_NAME: /tsmorc FILE_NAME: //AVALIV_g7m0ufb2_1 AGGREGATED: No FILE_SIZE: 2793244785 SEGMENT: 1/1 CACHED: NO FILESPACE_ID: 1 FILESPACE_HEXNAME: 2F74736D6F7263 FILE_HEXNAME: 2F2F4156414C49565F67376D30756662325F31 BITFILE_ID: 677419257 OBJECT_ID: 677419257 COPIED: No DAMAGED: Yes VOLUME_NAME: 501245 NODE_NAME: AVALOQPROD_ITSM TYPE: Bkup FILESPACE_NAME: /tsmorc FILE_NAME: //AVALIV_g9m0ufb2_1 AGGREGATED: No FILE_SIZE: 2006986989 SEGMENT: 1/1 CACHED: NO FILESPACE_ID: 1 FILESPACE_HEXNAME: 2F74736D6F7263 FILE_HEXNAME: 2F2F4156414C49565F67396D30756662325F31 BITFILE_ID: 677419258 OBJECT_ID: 677419258 COPIED: No DAMAGED: Yes