Re: query occupancy command - file names
Paul, First, get a list of volumes that have data from that filespace in that stgpool. (use the table volumeusage) Then for each volume (say, volid), issue the SELECT with volume_name=volid. This will break the select into manageable chunks. The output can still be very large. One goal of proper storage pool design is to keep the number of volumes with data from a given node/filespace to a reasonable number (for recovery efficiency.) Richard -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Paul_Dudley Sent: Sunday, August 07, 2016 7:40 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] query occupancy command - file names Hi, Tried that but it failed after 18 hours with the following memory failure: ANS8000I Server command: 'select file_name from contents where volume_name in (select volume_name from volumes where stgpool_name='B KPLTO6POOL' )' ANR0163E tbnsql.c(789): Database insufficient memory detected on 47:1. ANR0162W Supplemental database diagnostic information: -1:57011:-1218 ([IBM][CLI Driver][DB2/NT64] SQL1218N There are no pages currently available in bufferpool "1". SQLSTATE=57011 ). ANR0516E SQL processing for statement select file_name from contents where volume_name in ( select volume_name from volumes where st gpool_name = 'BKPLTO6POOL' ) failed. Thanks & Regards Paul -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Ullrich Mänz Sent: Thursday, 4 August 2016 6:29 PM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] AW: query occupancy command - file names Hi Paul, try out that: select file_name from contents where volume_name in (select volume_name from volumes where stgpool_name='BKPLTO6POOL') Because data is taken out of contents table, this query may run very long. Regards Ulli Maenz -Ursprüngliche Nachricht- Von: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] Im Auftrag von Paul_Dudley Gesendet: Donnerstag, 4. August 2016 02:11 An: ADSM-L@VM.MARIST.EDU Betreff: [ADSM-L] query occupancy command - file names The query occupancy command below shows 283 files in the bkplto6pool storage pool for this filespace. Is it possible to get a list of the file names? tsm: TSMANL>query occ ANLDBPROD_SQL stgp=bkplto6pool type=backup Node Name Type Filespace FSID Storage Number of Physical Logical NamePool NameFiles Space Space OccupiedOccupied (MB)(MB) -- -- -- --- --- --- DBPROD-Bkup DBPROD- 17 BKPLTO6PO- 283 9,771,429.0 9,771,429.0 _SQL\data\00- OL 0 0 01 Thanks & Regards Paul Paul Dudley IT Operations ANL Container Line pdud...@anl.com.au 61-3-8842-5603 ANL DISCLAIMER This e-mail and any file attached is confidential, and intended solely to the named add ressees. Any unauthorised dissemination or use is strictly prohibited. If you received this e-mail in error, please immediately notify the sender by return e-mail from your s ystem. Please do not copy, use or make reference to it for any purpose, or disclose its contents to any person. -- Message protected by MailGuard: e-mail anti-virus, anti-spam and content filtering. http://www.mailguard.com.au Click here to report this message as spam: https://console.mailguard.com.au/ras/1OYBJ9Ghcx/5mAucmMa3OSDp5zeRiFgkA/1.222 ANL DISCLAIMER This e-mail and any file attached is confidential, and intended solely to the named add ressees. Any unauthorised dissemination or use is strictly prohibited. If you received this e-mail in error, please immediately notify the sender by return e-mail from your s ystem. Please do not copy, use or make reference to it for any purpose, or disclose its contents to any person. This email has been scanned by BullGuard antivirus protection. For more info visit www.bullguard.com
Re: query occupancy command - file names
Hi, Tried that but it failed after 18 hours with the following memory failure: ANS8000I Server command: 'select file_name from contents where volume_name in (select volume_name from volumes where stgpool_name='B KPLTO6POOL' )' ANR0163E tbnsql.c(789): Database insufficient memory detected on 47:1. ANR0162W Supplemental database diagnostic information: -1:57011:-1218 ([IBM][CLI Driver][DB2/NT64] SQL1218N There are no pages currently available in bufferpool "1". SQLSTATE=57011 ). ANR0516E SQL processing for statement select file_name from contents where volume_name in ( select volume_name from volumes where st gpool_name = 'BKPLTO6POOL' ) failed. Thanks & Regards Paul -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Ullrich Mänz Sent: Thursday, 4 August 2016 6:29 PM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] AW: query occupancy command - file names Hi Paul, try out that: select file_name from contents where volume_name in (select volume_name from volumes where stgpool_name='BKPLTO6POOL') Because data is taken out of contents table, this query may run very long. Regards Ulli Maenz -Ursprüngliche Nachricht- Von: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] Im Auftrag von Paul_Dudley Gesendet: Donnerstag, 4. August 2016 02:11 An: ADSM-L@VM.MARIST.EDU Betreff: [ADSM-L] query occupancy command - file names The query occupancy command below shows 283 files in the bkplto6pool storage pool for this filespace. Is it possible to get a list of the file names? tsm: TSMANL>query occ ANLDBPROD_SQL stgp=bkplto6pool type=backup Node Name Type Filespace FSID Storage Number of Physical Logical NamePool NameFiles Space Space OccupiedOccupied (MB)(MB) -- -- -- --- --- --- DBPROD-Bkup DBPROD- 17 BKPLTO6PO- 283 9,771,429.0 9,771,429.0 _SQL\data\00- OL 0 0 01 Thanks & Regards Paul Paul Dudley IT Operations ANL Container Line pdud...@anl.com.au 61-3-8842-5603 ANL DISCLAIMER This e-mail and any file attached is confidential, and intended solely to the named add ressees. Any unauthorised dissemination or use is strictly prohibited. If you received this e-mail in error, please immediately notify the sender by return e-mail from your s ystem. Please do not copy, use or make reference to it for any purpose, or disclose its contents to any person. -- Message protected by MailGuard: e-mail anti-virus, anti-spam and content filtering. http://www.mailguard.com.au Click here to report this message as spam: https://console.mailguard.com.au/ras/1OYBJ9Ghcx/5mAucmMa3OSDp5zeRiFgkA/1.222 ANL DISCLAIMER This e-mail and any file attached is confidential, and intended solely to the named add ressees. Any unauthorised dissemination or use is strictly prohibited. If you received this e-mail in error, please immediately notify the sender by return e-mail from your s ystem. Please do not copy, use or make reference to it for any purpose, or disclose its contents to any person.
AW: query occupancy command - file names
Hi Paul, try out that: select file_name from contents where volume_name in (select volume_name from volumes where stgpool_name='BKPLTO6POOL') Because data is taken out of contents table, this query may run very long. Regards Ulli Maenz -Ursprüngliche Nachricht- Von: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] Im Auftrag von Paul_Dudley Gesendet: Donnerstag, 4. August 2016 02:11 An: ADSM-L@VM.MARIST.EDU Betreff: [ADSM-L] query occupancy command - file names The query occupancy command below shows 283 files in the bkplto6pool storage pool for this filespace. Is it possible to get a list of the file names? tsm: TSMANL>query occ ANLDBPROD_SQL stgp=bkplto6pool type=backup Node Name Type Filespace FSID Storage Number of Physical Logical NamePool NameFiles Space Space OccupiedOccupied (MB)(MB) -- -- -- --- --- --- DBPROD-Bkup DBPROD- 17 BKPLTO6PO- 283 9,771,429.0 9,771,429.0 _SQL\data\00- OL 0 0 01 Thanks & Regards Paul Paul Dudley IT Operations ANL Container Line pdud...@anl.com.au 61-3-8842-5603 ANL DISCLAIMER This e-mail and any file attached is confidential, and intended solely to the named add ressees. Any unauthorised dissemination or use is strictly prohibited. If you received this e-mail in error, please immediately notify the sender by return e-mail from your s ystem. Please do not copy, use or make reference to it for any purpose, or disclose its contents to any person.
query occupancy command - file names
The query occupancy command below shows 283 files in the bkplto6pool storage pool for this filespace. Is it possible to get a list of the file names? tsm: TSMANL>query occ ANLDBPROD_SQL stgp=bkplto6pool type=backup Node Name Type Filespace FSID Storage Number of Physical Logical NamePool NameFiles Space Space OccupiedOccupied (MB)(MB) -- -- -- --- --- --- DBPROD-Bkup DBPROD- 17 BKPLTO6PO- 283 9,771,429.0 9,771,429.0 _SQL\data\00- OL 0 0 01 Thanks & Regards Paul Paul Dudley IT Operations ANL Container Line pdud...@anl.com.au 61-3-8842-5603 ANL DISCLAIMER This e-mail and any file attached is confidential, and intended solely to the named add ressees. Any unauthorised dissemination or use is strictly prohibited. If you received this e-mail in error, please immediately notify the sender by return e-mail from your s ystem. Please do not copy, use or make reference to it for any purpose, or disclose its contents to any person.