Hi Steve, Christian and Mark! Thank you very much for your replies! Looks like my diskpool is way too small. I'll have to take some actions here, thanks! Kindest regards, Eric van Loon KLM Royal Dutch Airlines
-----Original Message----- From: Steve Harris [mailto:[EMAIL PROTECTED] Sent: Monday, September 29, 2003 00:49 To: [EMAIL PROTECTED] Subject: Re: SQL query 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. **************************************************************************** ******* ********************************************************************** For information, services and offers, please visit our web site: http://www.klm.com. This e-mail and any attachment may contain confidential and privileged material intended for the addressee only. If you are not the addressee, you are notified that no part of the e-mail or any attachment may be disclosed, copied or distributed, and that any other action related to this e-mail or attachment is strictly prohibited, and may be unlawful. If you have received this e-mail by error, please notify the sender immediately by return e-mail, and delete this message. Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its employees shall not be liable for the incorrect or incomplete transmission of this e-mail or any attachments, nor responsible for any delay in receipt. **********************************************************************
