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.