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:ads...@vm.marist.edu] On Behalf Of
Christian Svensson
Sent: Thursday, May 28, 2009 11:00 PM
To: ADSM-L@VM.MARIST.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.svens...@cristie.se
Skype: cristie.christian.svensson
________________________________________
Från: ADSM: Dist Stor Manager [ads...@vm.marist.edu] för Arthur Poon
[ap...@modestogov.com]
Skickat: den 29 maj 2009 00:37
Till: ADSM-L@VM.MARIST.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
