Dear Paul,

Thanks for you help. I've got the information base on the SQL you provided.
How can I analyze my information so that I can know where my tapesss gone...
I got around 1400 tapes from the result of the second SQL. Does it mean that
I have great problem on that? If yes, how can I solve it? Thank you very
much.

> Regards,
> Kathy Lai


-----Original Message-----
From: Seay, Paul [mailto:seay_pd AT NAPTHEON DOT COM]
Sent: Thursday, August 29, 2002 1:16 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: Consumption of new scratch tape increase abnormally


"I know the name of this tune."

Is expiration running?
What is the reclaim percent for your pools?

Issue this command to see how your volumes fair on utilization on average:

Select cast(avg(pct_utilized) as decimal(5,2)), stgpool_name,
count(stgpool_name) from volumes group by stgpool_name order by 1

Issue this one to figure out what the bad ones are:

Select cast(volume_name as char(7)) as "Volume",
cast(substr(stgpool_name,1,25) as char(25)) as "Storage Pool             ",
cast(pct_utilized as decimal(5,2)) as "% Util", cast(status as char(10)) as
"Status   ", cast(access as char(10)) as "Access    " from volumes where
pct_utilized < 40 order by 3

And "my all time favorite", find out the tapes that were checked in private
that should be scratch:

select volume_name from libvolumes where status='Private' and
libvolumes.volume_name not in (select volume_name from volumes) and
libvolumes.volume_name not in (select volume_name from volhistory where type
in ('BACKUPFULL', 'BACKUPINCR', 'DBSNAPSHOT', 'EXPORT'))

Hope this helps.  The quotes are from the Fifth Element, which character?




Paul D. Seay, Jr.
Technical Specialist
Naptheon Inc.
757-688-8180


-----Original Message-----
From: Lai, Kathy KL [mailto:Kathy.KL.Lai AT PCCW DOT COM]
Sent: Wednesday, August 28, 2002 9:46 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Consumption of new scratch tape increase abnormally


Dear all,

I am using ADSM v3.1 with HSM and DRM option. Recently ( this half year ) I
found that the consumption of new scratch tape increase abnormally. I have
to initial 180 tapes in only 23 days!!! However, I have check that the
backup volume doesn't have great change. What is the cause of the scenerio?
Will there be any problem in my daily operation so that tapes that have been
initilize cannot be reuse so the consumption of new tapes increase so
significantly? Please help as it is a quite urgent issue as my management
will not invest anymore to buy new tapes if the root cause of this scenerio
cannot be found!!! Thank you very much.

> Regards,
> Kathy Lai
> Outsourcing & Managed Services
> Pacific Century CyberWorks
> * 852-8101 2790
> kathy.kl.lai AT pccw DOT com
>