This sounds like APAR IC34776. You can view this APAR at
http://www.ibm.com. Just enter the APAR number in the search box at the
top of the web page. It is fixed in 5.1.7.
Regards,
Andy
Andy Raibeck
IBM Software Group
Tivoli Storage Manager Client Development
Internal Notes e-mail: Andrew Raibeck/Tucson/IBM@IBMUS
Internet e-mail: storman AT us.ibm DOT com
The only dumb question is the one that goes unasked.
The command line is your friend.
"Good enough" is the enemy of excellence.
Mark Ferraretto <mark.ferraretto AT DB DOT COM>
Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
08/12/2003 21:21
Please respond to "ADSM: Dist Stor Manager"
To: ADSM-L AT VM.MARIST DOT EDU
cc:
Subject: Funny query business
All,
Seems that the order you specify tables in an SQL query is important. I'm
running TSM 5.1.6.1 on AIX 5.1. I wanted to query volhistory and
backupset tables:
tsm: SM040>select VOLUME_NAME, location, backupset_name from BACKUPSETS,
VOLHISTORY where BACKUPSETS.DATE_TIME = VOLHISTORY.DATE_TIME
VOLUME_NAME LOCATION BACKUPSET_NAME
------------------ ------------------ ------------------
A00249 HKGIICOREP1.20030-
805.77813798
tsm: SM040>select VOLUME_NAME, location, backupset_name from volhistory,
backupsets where BACKUPSETS.DATE_TIME = VOLHISTORY.DATE_TIME
ANR2034E SELECT: No match found using this criteria.
ANS8001I Return code 11.
tsm: SM040>
The first result is the result I wanted.
Why is the order of tables important? Is this documented somewhere? I'm
concerned that I may not be getting correct data in other queries I run.
Mark
--
Mark Ferraretto
Unix Systems Administrator
Deutsche Bank Hong Kong
w: +852 2203 6362 m: +852 9558 8032 f: +852 2203 6971
mark.ferraretto AT db DOT com
--
This e-mail may contain confidential and/or privileged information. If you
are not the intended recipient (or have received this e-mail in error)
please notify the sender immediately and destroy this e-mail. Any
unauthorized copying, disclosure or distribution of the material in this
e-mail is strictly forbidden.
|