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
zforray AT vcu DOT 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" <wPrather AT ICFI DOT COM>
To:
ADSM-L AT VM.MARIST DOT 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 AT VM.MARIST DOT 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:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Christian Svensson
Sent: Monday, December 20, 2010 9:58 AM
To: ADSM-L AT VM.MARIST DOT 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.Svensson AT cristie DOT se
Skype: cristie.christian.svensson
Supported Platform for CPU2TSM::
http://www.cristie.se/cpu2tsm-supported-platforms
|
