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 AT VM.MARIST DOT EDU] On Behalf Of 
Ullrich Mänz
Sent: Thursday, 4 August 2016 6:29 PM
To: ADSM-L AT VM.MARIST DOT 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 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.
--
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.