ADSM-L

Re: [ADSM-L] Strange difference between Primary and Copypool

2007-12-11 08:26:55
Subject: Re: [ADSM-L] Strange difference between Primary and Copypool
From: Jim Young <jimyoung AT CATTLES.CO DOT UK>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Tue, 11 Dec 2007 13:26:17 -0000
Hi

My theory works if the following is true. 

1) the copy pool is offsite. 
2) your statement that the copy pool is larger than the primary pool was 
incorrect. Its the other way round looing at the numbers given.

Original sizings
Storagepool MB
------------------ ---------------------------------
DL_LBU3_CPY_1 26489427.98
DL_LBU3_PRI_1 27658559.10

As the tapes onsite (in the library) can be mounted over and over again putting 
new data at the end of the volume until full, you have a non-tape wasting 
process, 

BUT 

The offsite tapes are created and then shipped offsite. The offsite tapes can 
only be recreated from onsite data and as such, unless they trigger the 60% 
free reclamation they will sit there until 40% utilized, never defraging, just 
taking up lots of your lovely tapes.  Additional waste can be caused by 
collocation as well. Not knowing if that is used for nodes in this pool i 
cannot comment.  Plus we don't know the size of files you are backing up 
against the size of the tapes. ie. a 36Gb database file on a 40Gb DLT holds 90% 
of the tape.

I find this SQL useful for identifying tapes that get stuck and not reclaimed.

    select volume_name, stgpool_name,pct_utilized, status from volumes -
    where pct_utilized < 40 and stgpool_name <>'DISKPOOL' -
    order by pct_utilized, stgpool_name, volume_name

Cheers

Jim 


Cattles plc Registered in England No: 543610
Kingston House, Centre 27 Business Park,
Woodhead Road, Birstall, Batley, WF179TD.

The views and opinions expressed herein are those of the author and not of 
Cattles plc or any of its subsidiaries.The content of this e-mail is 
confidential, may contain privileged material and is intended solely for the 
recipient(s) named above. 

If you receive this in error, please notify the sender immediately and delete 
this e-mail.

Please note that neither Cattles plc nor the sender accepts any responsibility 
for viruses and it is your responsibility to scan the email and attachments(if 
any). No contracts or agreements may be concluded on behalf of Cattles plc or 
its subsidiaries by means of email communications.

This message has been scanned for Viruses  
by Cattles and Sophos Puremessage scanning service.