I would start with setting the environment for the Activity Monitor in your
Control Center. Go to the action bar, select tools, select wizards, select
Activity Monitor.
Identify what is of concern to you there and generate thereports you need
that it suggests.
Also, got to dbm cfg, verify and set the HEALTH_MON parm is set to ON
Restart your instance.
Now go to Health Monitor Center and set to evaluate the indicators that DB2
should monitor. Set the Warning and Alarm thresholds to your needs and let
it run.
Remeber to set the snapshot frequency for each of these so you have current
data when you look at them.
The combination of both should then give you information about which
applications are trouble some to you and which parameters you need to tune.
I'd also suggest some serious reading of your DB2 Admin. Guide Performance
handbook on that subject. This way you get a much faster answer to your
requests.
Hope this helps, Pierre.
--
Pierre Saint-Jacques
SES Consultants Inc.
514-737-4515
"Maddy" <ar********@gmail.coma écrit dans le message de news:
11**********************@e3g2000cwe.googlegroups.c om...
>
Lennart wrote:
>Maddy wrote:
Hi all,
I am new to DB2 database.I just have the basic knowledge abt this
database.I in a serious situation of handling 5 large databases.Can
some one help me how to prepare the health check report for the
databases.
I dont think there is something like "the health check report".
Different things will have different importance dependending of your
buissness/system. If your databases are critical, my best advise is to
hire an experienced DB2 dba and work side by side with him/her to get
you started.
Kind regards
/Lennart
Hi,
Can u suggest me which monitoring tool help me the most for my
database.
I working on db2 v8.1 database on unix server.
Its a critical database and often suffers from performance issues.
Kindly help me.
Maddy
>[...]