Select works in 5.5 but not in 6.x

Hi, Can anyone explain why this select command works fine in TSM 5.5 and not in TSM 6.x? Even if all information are still their. select nodes.domain_name, nodes.node_name, auditocc.backup_mb from nodes,auditocc where nodes.node_name=auditocc.node_name order by nodes.domain_name,nodes.node_name

Re: Select works in 5.5 but not in 6.x

Known bug. You can't do joins in 6.x (usually you don't get errors, you just get no data, which is worse). Occasionally it works, but don't rely on any results you get. Multiple APARS. IC68322, IC63474, IC70346 IC63474 lists the tables it is supposed to affect, but that's incorrect - can affect

Re: Select works in 5.5 but not in 6.x

FWIW, I jumped into dsmadmc on my 6.2.2.0 server and issued the select. This is what I got: tsm: SUN>select nodes.domain_name, nodes.node_name, auditocc.backup_mb from nodes,auditocc where nodes.node_name=auditocc.node_name order by nodes.domain_name,nodes.node_name ANR0162W Supplemental database

Re: Select works in 5.5 but not in 6.x

Christian, I got the same results as Zoltan on my Windows 6.2.2.0 server - also confirmed that the select works fine on my 5.5.4.3 server. Regards, Joerg Pohlmann -Original Message- From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of Zoltan Forray/AC/VCU Sent: Monday