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 >>> [EMAIL PROTECTED] 27/09/2003 4:57:00 >>> From: Loon, E.J. van - SPLXM [mailto:[EMAIL PROTECTED] 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 ([EMAIL PROTECTED]) *********************************************************************************** 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. ***********************************************************************************
