SV: SV: List of files in filespace

2009-06-01 Thread Christian Svensson
Try BACKUPS instead of BACKUP.
That will do 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#246;r Arthur Poon 
[ap...@modestogov.com]
Skickat: den 29 maj 2009 17:43
Till: ADSM-L@VM.MARIST.EDU
Ämne: Re: SV: List of files in filespace

When I execute the SQL statement I got the following errors

tsm: ADSMSERVselect 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#246;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


SV: List of files in filespace

2009-05-29 Thread Christian Svensson
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#246;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


Re: SV: List of files in filespace

2009-05-29 Thread Arthur Poon
When I execute the SQL statement I got the following errors

tsm: ADSMSERVselect 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#246;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


Re: SV: List of files in filespace

2009-05-29 Thread Richard Sims

Doselect * from syscat.tables
to see actual table names.


Re: SV: List of files in filespace

2009-05-29 Thread David McClelland
Try 'BACKUPS', rather than 'BACKUP' as your table name and that should see
you right.

/David Mc
London, UK

http://www.linkedin.com/in/dmcclelland


-Original Message-
From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of
Arthur Poon
Sent: 29 May 2009 16:43
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] SV: List of files in filespace

When I execute the SQL statement I got the following errors

tsm: ADSMSERVselect 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#246;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

No virus found in this incoming message.
Checked by AVG - www.avg.com 
Version: 8.5.339 / Virus Database: 270.12.39/2134 - Release Date: 05/28/09
18:09:00


Re: SV: List of files in filespace

2009-05-29 Thread Mark Mooney
I also find it helpful to use the ODBC driver to check out the table names in 
excel.

Thanks,
Mooney

-Original Message-
From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of David 
McClelland
Sent: Friday, May 29, 2009 12:16 PM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: SV: List of files in filespace

Try 'BACKUPS', rather than 'BACKUP' as your table name and that should see
you right.

/David Mc
London, UK

http://www.linkedin.com/in/dmcclelland


-Original Message-
From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of
Arthur Poon
Sent: 29 May 2009 16:43
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] SV: List of files in filespace

When I execute the SQL statement I got the following errors

tsm: ADSMSERVselect 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#246;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

No virus found in this incoming message.
Checked by AVG - www.avg.com
Version: 8.5.339 / Virus Database: 270.12.39/2134 - Release Date: 05/28/09
18:09:00