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 AT VM.MARIST DOT EDU] On Behalf Of
Paul_Dudley
Sent: Sunday, August 07, 2016 7:40 PM
To: ADSM-L AT VM.MARIST DOT 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 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.
This email has been scanned by BullGuard antivirus protection.
For more info visit www.bullguard.com
|