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
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
Robert,
This is a housekeeping type task that is performed, think of it like you
if you ran a defrag disk. This task takes place so that admin task of
reclamation is not needed. All of that is performed by the code without
configuration, that same for your deduplication. Containers are dedup
