Eric,

Assuming you have a steady state, and no expoiration of data whilsty it is on 
disk, on average the amount migrated each day will equal the amount backed up.

Select sum(bytes) from summary where activity='MIGRATION' and 
entity='DISKPOOLNAME' and divide by the number of days in your activity table.

If you migrate only daily, the max(bytes) might be a better figure.

Alternatively, bytes moved by backup stg is another measure you could use.

Regards

Steve Harris
AIX and TSM Admin
Queensland Health, Brisbane Australia


>>> stapleto AT BERBEE DOT COM 27/09/2003 4:57:00 >>>
From: Loon, E.J. van - SPLXM [mailto:Eric-van.Loon AT KLM DOT COM] 
I'm currently investigating my diskpool sizing. I would like my diskpool
to be large enough to contain a complete backup window (one day). I'm
looking for a query to see how much data was written to the diskpool
during the last 24 hours. Does anybody has one for me? Thank you VERY
much in advance!

Easy. Turn on accounting, open the resultant dsmaccnt.log file with
Excel, and add up everything in column Q.

--
Mark Stapleton (stapleton AT berbee DOT com)



***********************************************************************************
This email, including any attachments sent with it, is confidential and for the 
sole use of the intended recipients(s).  This confidentiality is not waived or 
lost, if you receive it and you are not the intended recipient(s), or if it is 
transmitted/received in error.

Any unauthorised use, alteration, disclosure, distribution or review of this 
email is prohibited.  It may be subject to a statutory duty of confidentiality 
if it relates to health service matters.

If you are not the intended recipients(s), or if you have received this e-mail 
in error, you are asked to immediately notify the sender by telephone or by 
return e-mail.  You should also delete this e-mail message and destroy any hard 
copies produced.
***********************************************************************************