1. Community Tip: Please Give Thanks to Those Sharing Their Knowledge.
    If you receive helpful answer on this forum, please show thanks to the poster by clicking "LIKE" link for the answer that you found helpful.
  2. Community Tip: Forum Rules (PLEASE CLICK HERE TO READ BEFORE POSTING)
    Click the link above to access ADSM.ORG Acceptable Use Policy and forum rules which should be observed when using this website. Violators may be banned from this website. This notice will disappear after you have made at least 3 posts.

directory container containts

Discussion in 'Backup / Archive Discussion' started by Manos, Apr 21, 2017.

  1. Manos

    Manos Newcomer

    Joined:
    Mar 30, 2017
    Messages:
    4
    Likes Received:
    1
    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
     
  2.  
  3. Manos

    Manos Newcomer

    Joined:
    Mar 30, 2017
    Messages:
    4
    Likes Received:
    1
    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'
     

Share This Page