ADSM-L

[ADSM-L] SV: SV: List of files in filespace

2009-06-01 05:02:53
Subject: [ADSM-L] SV: SV: List of files in filespace
From: Christian Svensson <Christian.Svensson AT CRISTIE DOT SE>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Mon, 1 Jun 2009 11:01:52 +0200
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&#246;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&#246;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

<Prev in Thread] Current Thread [Next in Thread>
  • [ADSM-L] SV: SV: List of files in filespace, Christian Svensson <=