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 Name Pool Name Files Space Space Occupied Occupied (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.
