Re: [ADSM-L] 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 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