469,602 Members | 1,769 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,602 developers. It's quick & easy.

DB2 health checkup - help needed

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.

Also suggest me gud books for learning DB2.

Thanks in advance,
Maddy

Oct 23 '06 #1
4 3266

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

[...]

Oct 23 '06 #2


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
[...]
Oct 24 '06 #3
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
>[...]
Oct 24 '06 #4
You may want to check out the IBM Toronto Lab Services team. They have
some really sharp guys/gals, and I believe a healthcheck offering.
Pierre Saint-Jacques wrote:
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
[...]
Oct 25 '06 #5

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

7 posts views Thread by Bruce MacDonald | last post: by
2 posts views Thread by Debbie E | last post: by
reply views Thread by Maddy | last post: by
4 posts views Thread by Klauer | last post: by
reply views Thread by hahaqu321 | last post: by
reply views Thread by suresh191 | last post: by
4 posts views Thread by guiromero | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.