One way would be to use a monitoring application like TSM Manager,
ServerGraph or TSM Operational Reporting to be able to store historical
data about your database.
This way the monitoring application would be able to predict how much your
database will grow and when it will become full. Im not sure wether or not
TSM OR can do this. I know both TSM Manager (www.tsmmanager.com) and
Servergraph(www.servergraph.com) can do this.
Best Regards
Daniel Sparrman
-----------------------------------
Daniel Sparrman
Exist i Stockholm AB
Propellervägen 6B
183 62 TÄBY
Växel: 08 - 754 98 00
Mobil: 070 - 399 27 51
Henrik Wahlstedt <shwl AT STATOIL DOT COM>
Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
2005-05-09 09:42
Please respond to
"ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
To
ADSM-L AT VM.MARIST DOT EDU
cc
Subject
Re: Inquiry About TSM Database
Hi,
I´m not sure you can do that without taking the output from 'q db' and put
into a spreedsheet on a daily basis..etc.. Consider using VB or Perl to
automate it a little.
A prediction might be good, but to me it is better to be warned when DB
utilization is 90% or so, and then schedule a extention of the database?
Operation reporting helps you with that and sends you e-mail.
When log or db gets full TSM will stop.
//Henrik
Norita binti
Hassan To: ADSM-L AT VM.MARIST DOT EDU
<ita AT POS DOT COM. cc: (bcc: Henrik Wahlstedt)
MY> Subject: Inquiry About TSM
Database
Sent by:
"ADSM: Dist
Stor Manager"
<ADSM-L AT VM DOT MA
RIST.EDU>
2005-05-09
05:34
Please
respond to
"ADSM: Dist
Stor Manager"
How to estimete % of incremental in my database so that I can do a
prediction when to add new dbvol.
What happen if the database is full?
Thanks
NORITA BINTI HASAN
Senior Programmer
Enterprise Systems Services
Information Communication Tech.Div
6th Floor, Pos Malaysia Berhad
50670 Kuala Lumpur
Tel : 03 - 22756638
Pos Malaysia Berhad is Malaysia's national postal company
Visit us online at www.pos.com.my
NOTICE
This message may contain privileged and/or confidential
information. If you are not the addressee or authorised
to receive this email, you must not use, copy, disclose
or take any action based on this email. If you have
received this email in error, please advise the sender
immediately by reply e-mail and delete this message.
Pos Malaysia Berhad takes no responsibility for the
contents of this email.
-------------------------------------------------------------------
The information contained in this message may be CONFIDENTIAL and is
intended for the addressee only. Any unauthorised use, dissemination of
the
information or copying of this message is prohibited. If you are not the
addressee, please notify the sender immediately by return e-mail and
delete
this message.
Thank you.
|