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:Steve_Harris AT HEALTH.QLD.GOV DOT AU]
Sent: Monday, September 29, 2003 00:49
To: ADSM-L AT VM.MARIST DOT EDU
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
>>> 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.
****************************************************************************
*******
**********************************************************************
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.
**********************************************************************
|
