Primary Storage

 View Only
Expand all | Collapse all

Size is not updating on Directory container pool on Operation center

  • 1.  Size is not updating on Directory container pool on Operation center

    Posted Sun January 06, 2019 11:03 PM
    Hi All,

    I have 12 directory on one of the stgpool we have added one more and define into that stgpool although we can see that space is showing added  while running q stg but at the same time it is not updating on operation center still showing old size and displaying a error message of threshold on operation center. Please let me know what to do.

    I have 2-3 query please advise.

    1. how expiration is working on this directory container pool.
    2. how space will reclaim after expiration.
    3. how these threshold message will go from operation center.

    ------------------------------
    Prem Singh

    ------------------------------


  • 2.  RE: Size is not updating on Directory container pool on Operation center

    Posted Mon January 07, 2019 12:39 AM
    Hi,

    below is the snapshot for your reference.


    Storage pool snapshot from admin console.



    ------------------------------
    Prem Singh

    ------------------------------



  • 3.  RE: Size is not updating on Directory container pool on Operation center

    Posted Mon January 07, 2019 09:55 AM
    Guys,

    Any thoughts any suggestions.

    Thanks & regards
    Prem Singh Bathyal
    Mobile - 8527337214





  • 4.  RE: Size is not updating on Directory container pool on Operation center

    Posted Tue January 08, 2019 01:54 AM
    Hi,
    What does 'q stgpooldire f=d' show?

    And, if you look for entries in the new directory

    q container /path/to/new/dire/* f=d

    Håkon

    ------------------------------
    Håkon Phillip Tønder-Keul
    ------------------------------



  • 5.  RE: Size is not updating on Directory container pool on Operation center

    Posted Wed January 09, 2019 04:34 AM
    Hi Hakon,

    Thanks for the help I can see the results from both the query.

    q stgpooldire f=d  (result pasted only for new added directory) 

    Storage Pool Name: REPDBSTGPOOL_KARA
            Directory: /DBREPSTGPOOL12
               Access: Read/Write
       Free Space(MB): 3,803,044
      Total Space(MB): 5,240,838
          File System: /DBREPSTGPOOL12

    q container /path/to/new/dire/* f=d (showing result but not pasted because it is huge)

    still not able to understand why space is not updating on operation center. 

    --
    Regards
    Prem Singh Bathyal
    Contact- 8527337214





  • 6.  RE: Size is not updating on Directory container pool on Operation center

    Posted Wed January 09, 2019 07:25 AM
    How expiration and reclamation is working in directory container pool.

    1. Because I am keep on adding space from storage and mximum I have 30 days retention for any backup still I always needed space on every week to extend the file system space of storage pools.
     I read in the document reclaim command is not supported then how space is reclaiming after expiration.

    ------------------------------
    Prem Singh
    ------------------------------



  • 7.  RE: Size is not updating on Directory container pool on Operation center

    Posted Thu January 10, 2019 02:53 AM
    Hi,
    Reclaim of containers is very much dependant upon your version.

    Later version, 8.1.5 +, has a builtin reclaim feature for containers.

    Earlier version did not reclaim very well.  The policy was to fill up all space before reusing space.  You could use some special settings when moving containers to only move real data, not whitespace.  This was a very crude system.

    You can write a script that will find the 100 containers that will release the most space when moved with defrag=yes

    Play around with this:

    select 'move container '||cast(container_name as char(40))||' defrag=yes' from containers where TOTAL_SPACE_MB-FREE_SPACE_MB<100 and STATE<>'PENDING'



    ------------------------------
    Håkon Phillip Tønder-Keul
    ------------------------------



  • 8.  RE: Size is not updating on Directory container pool on Operation center

    Posted Wed January 30, 2019 07:40 AM
    Hi Hakon,

    Thanks and apologies for late reply but I needed your more help here.

    select 'move container '||cast(container_name as char(40))||' defrag=yes' from containers where TOTAL_SPACE_MB-FREE_SPACE_MB<100 and STATE<>'PENDING'

    TOTAL_SPACE_MB-FREE_SPACE_MB<100 
     Which i highlighted that value i can check 


    which i highlighted in yellow that value i can adjust according to my requirement and another thing which is showing pending i can use that by just simply deleting that. Please advise.

    ------------------------------
    Prem Singh

    ------------------------------



  • 9.  RE: Size is not updating on Directory container pool on Operation center

    Posted Thu January 31, 2019 02:19 AM
    Hi,

    The containers in pending state will be deleted automatically when the reusedelay has passed.  You do not need to move them around.

    For the TOTAL_SPACE_MB-FREE_SPACE_MB<100 , just replace 100 with your own value.  It is in MB, so start with a low number, and increase for each run.


    ------------------------------
    Håkon Phillip Tønder-Keul
    ------------------------------



  • 10.  RE: Size is not updating on Directory container pool on Operation center

    Posted Wed February 06, 2019 05:17 PM
    ​Hi All,

    What I am suspecting is copy group is the issue that's why it is just utilizing the space on and on and on.

    Please see if you understand specifically for oracle database backup policy from both the server we have

    7.1.7 container pool, and it is replicating the data from one TSM Server to another. For me these settings

    are incorrect.

    tsm: ESVIOTSM50_TSMINST1>q copy oracle_domain_mdc

    Policy        Policy        Mgmt          Copy          Version-     Version-      Retain      Retain
    Domain        Set Name      Class         Group          s Data       s Data        Extra        Only
    Name                        Name          Name            Exists      Deleted     Versions     Version
    ---------     ---------     ---------     ---------     --------     --------     --------     -------
    ORACLE_D-     ACTIVE        ORACLE_M-     STANDARD      No Limit     No Limit           14          30
     OMAIN_M-                    GMT_MDC
     DC
    ORACLE_D-     ORACLE_P-     ORACLE_M-     STANDARD      No Limit     No Limit           14          30
     OMAIN_M-      OLSET_M-      GMT_MDC
     DC            DC

    tsm: ESVIOTSM50_TSMINST1>q copy oracle_domain_tsminst1

    Policy        Policy        Mgmt          Copy          Version-     Version-      Retain      Retain
    Domain        Set Name      Class         Group          s Data       s Data        Extra        Only
    Name                        Name          Name            Exists      Deleted     Versions     Version
    ---------     ---------     ---------     ---------     --------     --------     --------     -------
    ORACLE_D-     ACTIVE        ORACLE_M-     STANDARD      No Limit     No Limit            7          30
     OMAIN_T-                    GMTCLS_-
     SMINST1                     TSMINST1
    ORACLE_D-     ORACLE_P-     ORACLE_M-     STANDARD      No Limit     No Limit            7          30
     OMAIN_T-      OLSET_T-      GMTCLS_-
     SMINST1       SMINST1       TSMINST1

    tsm: ESVIOTSM50_TSMINST1>q copy oracle_domain_tsminst2

    Policy        Policy        Mgmt          Copy          Version-     Version-      Retain      Retain
    Domain        Set Name      Class         Group          s Data       s Data        Extra        Only
    Name                        Name          Name            Exists      Deleted     Versions     Version
    ---------     ---------     ---------     ---------     --------     --------     --------     -------
    ORACLE_D-     ACTIVE        ORACLE_M-     STANDARD      No Limit     No Limit           30          30
     OMAIN_T-                    GMTCLS_-
     SMINST2                     TSMINST2
    ORACLE_D-     ORACLE_P-     ORACLE_M-     STANDARD      No Limit     No Limit           30          30
     OMAIN_T-      OLSET_T-      GMTCLS_-
     SMINST2       SMINST2       TSMINST2

    tsm: ESVIOTSM050_TSMINST2>q copy oracle_domain_mdc

    Policy        Policy        Mgmt          Copy          Version-     Version-      Retain      Retain
    Domain        Set Name      Class         Group          s Data       s Data        Extra        Only
    Name                        Name          Name            Exists      Deleted     Versions     Version
    ---------     ---------     ---------     ---------     --------     --------     --------     -------
    ORACLE_D-     ACTIVE        ORACLE_M-     STANDARD      No Limit     No Limit           30          30
     OMAIN_M-                    GMT_MDC
     DC
    ORACLE_D-     ORACLE_P-     ORACLE_M-     STANDARD      No Limit     No Limit           30          30
     OMAIN_M-      OLSET_M-      GMT_MDC
     DC            DC

    tsm: ESVIOTSM050_TSMINST2>q copy oracle_domain_tsminst1

    Policy        Policy        Mgmt          Copy          Version-     Version-      Retain      Retain
    Domain        Set Name      Class         Group          s Data       s Data        Extra        Only
    Name                        Name          Name            Exists      Deleted     Versions     Version
    ---------     ---------     ---------     ---------     --------     --------     --------     -------
    ORACLE_D-     ACTIVE        ORACLE_M-     STANDARD      No Limit     No Limit           30          30
     OMAIN_T-                    GMTCLS_-
     SMINST1                     TSMINST1
    ORACLE_D-     ORACLE_P-     ORACLE_M-     STANDARD      No Limit     No Limit           30          30
     OMAIN_T-      OLSET_T-      GMTCLS_-
     SMINST1       SMINST1       TSMINST1

    tsm: ESVIOTSM050_TSMINST2>q copy oracle_domain_tsminst2

    Policy        Policy        Mgmt          Copy          Version-     Version-      Retain      Retain
    Domain        Set Name      Class         Group          s Data       s Data        Extra        Only
    Name                        Name          Name            Exists      Deleted     Versions     Version
    ---------     ---------     ---------     ---------     --------     --------     --------     -------
    ORACLE_D-     ACTIVE        ORACLE_M-     STANDARD      No Limit     No Limit           30          14
     OMAIN_T-                    GMTCLS_-
     SMINST2                     TSMINST2
    ORACLE_D-     ORACLE_P-     ORACLE_M-     STANDARD      No Limit     No Limit           30          14
     OMAIN_T-      OLSET_T-      GMTCLS_-
     SMINST2       SMINST2       TSMINST2

    that is why it's creating issue and occupying the issue.


    ------------------------------
    Prem Singh

    ------------------------------



  • 11.  RE: Size is not updating on Directory container pool on Operation center

    Posted Fri February 08, 2019 01:58 PM
    in addition to that I have found more than 400 container state is unavailable I have ran Audit container but unfortunately it is not moved into available state.

    --
    Regards
    Prem