Re: Select list of files backed up/archived on tsm?!?
2004-05-21 11:40:32
You can also concatenate with the '||' operator, like this:
select filespace_name || hl_name || ll_name from backups ...
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.
Richard Sims <rbs AT BU DOT EDU>
Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
05/21/2004 04:57
Please respond to
"ADSM: Dist Stor Manager"
To
ADSM-L AT VM.MARIST DOT EDU
cc
Subject
Re: Select list of files backed up/archived on tsm?!?
...
>select * from backups where node_name='CHSU050', but that doesn't give me
>the actual name of the file, it just gives high level and low level. ...
FILESPACE_NAME + HL_NAME + LL_NAME constitute the full path spec of the
file.
The Select is not withholding anything.
You can do like select concat(HL_NAME, LL_NAME) from backups
to stick those two components together.
Richard Sims
|
|
|