Re: SV: List of files in filespace

2009-05-29 Thread Mark Mooney
: 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

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

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 Arthur Poon
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'.