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
|