By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,559 Members | 1,154 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,559 IT Pros & Developers. It's quick & easy.

DB2 health checkup - help needed

P: n/a
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
Share this Question
Share on Google+
4 Replies


P: n/a

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

P: n/a


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

P: n/a
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

P: n/a
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.