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