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 AT VM.MARIST DOT EDU] Im Auftrag 
von Paul_Dudley
Gesendet: Donnerstag, 4. August 2016 02:11
An: ADSM-L AT VM.MARIST DOT 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

pdudley AT anl.com DOT 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.