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, December 20, 2010 08:36 To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] 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 diagnostic information: -1:42S22:-206 ([IBM][CLI Driver][DB2/LINUXX8664] SQL0206N "NODES.NODE_NAME" is not valid in the context where it is used. SQLSTATE=42703 ). ANR2940E The command 'select nodes.domain_name , nodes.node_name , auditocc.backup_mb from NODESVIEW , auditocc where nodes.node_name = auditocc.node_name order by nodes.domain_name , nodes.node_name ' contains an unknown SQL column name. ANS8001I Return code 3. tsm: SUN> Zoltan Forray TSM Software & Hardware Administrator Virginia Commonwealth University UCC/Office of Technology Services zfor...@vcu.edu - 804-828-4807 Don't be a phishing victim - VCU and other reputable organizations will never use email to request that you reply with your password, social security number or confidential personal information. For more details visit http://infosecurity.vcu.edu/phishing.html From: "Prather, Wanda" <wprat...@icfi.com> To: ADSM-L@VM.MARIST.EDU Date: 12/20/2010 10:16 AM Subject: Re: [ADSM-L] Select works in 5.5 but not in 6.x Sent by: "ADSM: Dist Stor Manager" <ADSM-L@VM.MARIST.EDU> 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