I'm trying to join backups with bu_copy_groups to determine current backup and experation based on class. However, when I issue the following command I get the following error:
tsm: TSM_C01>select distinct a.node_name, a.filespace_name, a.class_name, b.domain_name, b.verexists, b.retextra - cont> from - cont> ( select domain_name, verexists, retextra from adsm.bu_copy_groups - cont> group by domain_name, verexists, retextra ) as b, adsm.backups a - cont> where a.node_name='DBADDB01' a.class_name=b.class_name ANR2908E Unexpected SQL punctuation token - '('. | ...............................V............................... , b.verexists, b.retextra from ( select domain_name, verexists, ANS8001I Return code 3. Is there another way to show server/file system on TSM the current backup and retention policy settings Thanks for the help, - Matt