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
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
