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 any tables. Was supposed to be fixed in 6.2.1, but wasn't. Now it's supposed to be fixed in 6.2.2, but I don't have a 6.2.2 server to test, so I don't know if it's really fixed or not.
W -----Original Message----- From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of Christian Svensson Sent: Monday, December 20, 2010 9:58 AM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] 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 Happy Holiday Christian Svensson Best Regards Christian Svensson Cell: +46-70-325 1577 E-mail: christian.svens...@cristie.se Skype: cristie.christian.svensson Supported Platform for CPU2TSM:: http://www.cristie.se/cpu2tsm-supported-platforms