directory container containts

Manos

Active Newcomer
Joined
Mar 30, 2017
Messages
7
Reaction score
1
Points
0
PREDATAR Control23

Hi,
I have a directory container that I need to dicomission. Most data have expired but still very few (200G) remain. I need to find out the contents in order to either delete or move them. How can that be done ? Database query ? data restore ?

Any suggestions
 
PREDATAR Control23

the following select statement will provide info on the stored data

select FILESPACE_ID,FILESPACE_NAME,LOGICAL_MB,NODE_NAME,NUM_FILES,PHYSICAL_MB,REPORTING_MB,STGPOOL_NAME,TYPE,FILESPACE_ID,FILESPACE_NAME,LOGICAL_MB,NODE_NAME,NUM_FILES,PHYSICAL_MB,REPORTING_MB,STGPOOL_NAME,TYPE from OCCUPANCY where stgpool_name='DIRECTORY_POOL'
 
Top