Verify status for objects managed by a Tivoli Storage Manager server

Resolving The Problem

You can use the FLAGS field from the BACKUP_OBJECTS, ARCHIVE_OBJECTS or SPACEMAN_OBJECTS DB2 tables to verify the object status. Valid flag settings are:
COMPRESSED   0x0001
ENCR_DES56   0x0002
ENCR_AES128  0x0004
DEDUP_CLIENT 0x0008
ENCR_AES256  0x0040

For example, you can use the following SQL command to verify objects exist with DES56 encryption:

db2 connect to tsmdb1
db2 "select 'AES', count(*) from tsmdb1.backup_Objects where bitand(flags,4) = 4"
.
1   2                  
--- -----------        
AES        2028        
  1 record(s) selected.


or use the following command to get overall statistics for all your client nodes:
db2 connect to tsmdb1
db2 "select n.nodename, bo.flags, count(*) as count from Backup_objects bo left join nodes n on(n.NODEID=bo.NODEID) group by n.nodename, bo.flags"

NODENAME           FLAGS       COUNT
------------------ ----------- -----------
HSMBACLIENT                  8           6
PEPERONI                     0          91
..
TEST_SQL                     4           2

Note: If your server manages objects that have been backed up to a pre 6.2 Tivoli Storage Manager server, objects might be compressed or encrypted without the flag field reflecting this.

Note: If your server manages objects that have no data associated with them, the objects will not be reported as compressed/encrypted/dedupped. The following is SHOW INVO information for a sample object:

tsm: SERVERXXX>sh invo 1747334593
Inventory object 1747334593 of copy type Backup has attributes:
NodeName: NODE001, Filespace(2): ASR,
ObjName: \NODE001\ASR.
hlID: 97F6C26C0BEAB953F9D4E6E214634DFDA83CD365
llID: 0501B432BBE8312458D55E18854211303EB47158
Type: 2 (File) MC: 1 (DEFAULT) CG: 1 Size: 0 HeaderSize: 0
Active, Inserted 03/07/2014 04:15:14 AM (UTC 03/07/2014 03:15:14 AM)
GroupMap 0x00020000, bypassRecogToken NULL
Peer Group Leader, GroupId: 1747334593

Bitfile Object: 1747334593
Active
Bitfile Object NOT found.