Try BACKUPS instead of BACKUP.
That will do it.
Best Regards
Christian Svensson
Cell: +46-70-325 1577
E-mail: Christian.Svensson AT cristie DOT se
Skype: cristie.christian.svensson
________________________________________
Från: ADSM: Dist Stor Manager [ADSM-L AT VM.MARIST DOT EDU] för Arthur
Poon [apoon AT MODESTOGOV DOT COM]
Skickat: den 29 maj 2009 17:43
Till: ADSM-L AT VM.MARIST DOT EDU
Ämne: Re: SV: List of files in filespace
When I execute the SQL statement I got the following errors
tsm: ADSMSERV>select filespace_name as filespace, hl_name as directory, ll_names
as file_name from backup where node_name='COMAPPS'
ANR2906E Unexpected SQL literal token - 'BACKUP'.
|
...............................V...............................
ry, ll_names as file_name from backup where node_name='COMAPPS'
ANS8001I Return code 3.
I am using TSM version 5.5 for both server and client on window platform.
Thanks.
AP
-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Christian Svensson
Sent: Thursday, May 28, 2009 11:00 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: [ADSM-L] SV: List of files in filespace
Hi,
Yes you can, my way to do it is probably not the best one but it works.
Select filespace_name as Filespace, hl_name as Directory, ll_name as Filename
from backup where node_name='NODENAME'
But be careful to select from tablespace BACKUP because it's a lot of
information in their and it takes a wild to do a query from it.
Best Regards
Christian Svensson
Cell: +46-70-325 1577
E-mail: Christian.Svensson AT cristie DOT se
Skype: cristie.christian.svensson
________________________________________
Från: ADSM: Dist Stor Manager [ADSM-L AT VM.MARIST DOT EDU] för Arthur
Poon [apoon AT MODESTOGOV DOT COM]
Skickat: den 29 maj 2009 00:37
Till: ADSM-L AT VM.MARIST DOT EDU
Ämne: List of files in filespace
Is there any way to list out all the file names from the filespace using the
TSM console?
AP
|