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
------------------------------
Original Message:
Sent: 01-31-2019 02:19 AM
From: Håkon Phillip Tønder-Keul
Subject: Size is not updating on Directory container pool on Operation center
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
Original Message:
Sent: 01-30-2019 07:40 AM
From: Prem Singh
Subject: Size is not updating on Directory container pool on Operation center
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
Original Message:
Sent: 01-10-2019 02:52 AM
From: Håkon Phillip Tønder-Keul
Subject: Size is not updating on Directory container pool on Operation center
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
Original Message:
Sent: 01-09-2019 07:25 AM
From: Prem Singh
Subject: Size is not updating on Directory container pool on Operation center
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
Original Message:
Sent: 01-06-2019 11:03 PM
From: Prem Singh
Subject: Size is not updating on Directory container pool on Operation center
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
------------------------------