Try BACKUPS instead of BACKUP. That will do it. Best Regards Christian Svensson
Cell: +46-70-325 1577 E-mail: [email protected] Skype: cristie.christian.svensson ________________________________________ Från: ADSM: Dist Stor Manager [[email protected]] för Arthur Poon [[email protected]] Skickat: den 29 maj 2009 17:43 Till: [email protected] Ä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:[email protected]] On Behalf Of Christian Svensson Sent: Thursday, May 28, 2009 11:00 PM To: [email protected] 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: [email protected] Skype: cristie.christian.svensson ________________________________________ Från: ADSM: Dist Stor Manager [[email protected]] för Arthur Poon [[email protected]] Skickat: den 29 maj 2009 00:37 Till: [email protected] Ä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
