SV: SV: List of files in filespace
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ö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: 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
Re: SV: List of files in filespace
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: 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 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
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: 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 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
Doselect * from syscat.tables to see actual table names.
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: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
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
List of files in filespace
Is there any way to list out all the file names from the filespace using the TSM console? AP