DB2 Health checker inputs

Anil Kumar

DB2 Health checker inputs
Hi All,

When I googled "db2 for zos health checker" one of the links displayed is https://www-304.ibm.com/support/docview.wss?uid=swg27005118.This link has the document link which reads"Health Check Your DB2 UDB for z/OS System" . However when I click on this , it says it cannot be accessed because of some reasons.

If anyone has this document downloaded , request you to please send te same.

What I am looking for is some basic inputs on what needs to be included for basic DB2 health check up. As a part of this we have identified a list of all db2 objects whose extents > certain threshold. This will be one of our first health checking criteria.May be in this line I would request to provide some basic DB2 health checking factors that could be developed. If any of these are available , request to please send across the links / pages to get the idea.All inputs would be greatly appreciated.

Thanks,
Anil.

_________________________________________________________________

Register NOW for the IDUG DB2 Tech Conference in Anaheim, May 2-6, 2011!
_________________________________________________________________
If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L
is the home of IDUG's Listserv

Richard Williamson

Re: DB2 Health checker inputs
(in response to Anil Kumar)
Try Googling swg27005118... I was able to get to the link this way...

-----Original Message-----
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Anil Kumar
Sent: Tuesday, May 03, 2011 10:40 AM
To: [login to unmask email]
Subject: [DB2-L] DB2 Health checker inputs

Hi All,

When I googled "db2 for zos health checker" one of the links displayed is https://www-304.ibm.com/support/docview.wss?uid=swg27005118.This link has the document link which reads"Health Check Your DB2 UDB for z/OS System" . However when I click on this , it says it cannot be accessed because of some reasons.

If anyone has this document downloaded , request you to please send te same.

What I am looking for is some basic inputs on what needs to be included for basic DB2 health check up. As a part of this we have identified a list of all db2 objects whose extents > certain threshold. This will be one of our first health checking criteria.May be in this line I would request to provide some basic DB2 health checking factors that could be developed. If any of these are available , request to please send across the links / pages to get the idea.All inputs would be greatly appreciated.

Thanks,
Anil.

_________________________________________________________________

Register NOW for the IDUG DB2 Tech Conference in Anaheim, May 2-6, 2011!
_________________________________________________________________
If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L
is the home of IDUG's Listserv

_________________________________________________________________

Register NOW for the IDUG DB2 Tech Conference in Anaheim, May 2-6, 2011!
_________________________________________________________________
If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L
is the home of IDUG's Listserv


Richard Williamson

Re: DB2 Health checker inputs
(in response to Richard Williamson)
Spoke too soon, I'm getting the same error as you... Looks like the link has been taken down...

-----Original Message-----
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Anil Kumar
Sent: Tuesday, May 03, 2011 10:40 AM
To: [login to unmask email]
Subject: [DB2-L] DB2 Health checker inputs

Hi All,

When I googled "db2 for zos health checker" one of the links displayed is https://www-304.ibm.com/support/docview.wss?uid=swg27005118.This link has the document link which reads"Health Check Your DB2 UDB for z/OS System" . However when I click on this , it says it cannot be accessed because of some reasons.

If anyone has this document downloaded , request you to please send te same.

What I am looking for is some basic inputs on what needs to be included for basic DB2 health check up. As a part of this we have identified a list of all db2 objects whose extents > certain threshold. This will be one of our first health checking criteria.May be in this line I would request to provide some basic DB2 health checking factors that could be developed. If any of these are available , request to please send across the links / pages to get the idea.All inputs would be greatly appreciated.

Thanks,
Anil.

_________________________________________________________________

Register NOW for the IDUG DB2 Tech Conference in Anaheim, May 2-6, 2011!
_________________________________________________________________
If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L
is the home of IDUG's Listserv

_________________________________________________________________

Register NOW for the IDUG DB2 Tech Conference in Anaheim, May 2-6, 2011!
_________________________________________________________________
If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L
is the home of IDUG's Listserv


Chris Hoelscher

Re: DB2 Health checker inputs
(in response to Richard Williamson)
We use RTS to monitor # extents on tablespaces and indexspaces... may be an easier alternative for you

Chris Hoelscher
IDMS & DB2 Database Administrator
502-476-2538

I refuse to repeat gossip - so listen closely the first time


-----Original Message-----
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Anil Kumar
Sent: Tuesday, May 03, 2011 10:40 AM
To: [login to unmask email]
Subject: [DB2-L] DB2 Health checker inputs

Hi All,

When I googled "db2 for zos health checker" one of the links displayed is https://www-304.ibm.com/support/docview.wss?uid=swg27005118.This link has the document link which reads"Health Check Your DB2 UDB for z/OS System" . However when I click on this , it says it cannot be accessed because of some reasons.

If anyone has this document downloaded , request you to please send te same.

What I am looking for is some basic inputs on what needs to be included for basic DB2 health check up. As a part of this we have identified a list of all db2 objects whose extents > certain threshold. This will be one of our first health checking criteria.May be in this line I would request to provide some basic DB2 health checking factors that could be developed. If any of these are available , request to please send across the links / pages to get the idea.All inputs would be greatly appreciated.

Thanks,
Anil.

_________________________________________________________________

Register NOW for the IDUG DB2 Tech Conference in Anaheim, May 2-6, 2011!
_________________________________________________________________
If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L
is the home of IDUG's Listserv


The information transmitted is intended only for the person or entity to which it is addressed and may contain CONFIDENTIAL material. If you receive this material/information in error, please contact the sender and delete or destroy the material/information.


_________________________________________________________________

Register NOW for the IDUG DB2 Tech Conference in Anaheim, May 2-6, 2011!
_________________________________________________________________
If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L
is the home of IDUG's Listserv


[login to unmask email]

Re: DB2 Health checker inputs
(in response to Chris Hoelscher)
Anil,
You may wish to view _www.recoveryknowledge.com_
(http://www.recoveryknowledge.com)
Health Check Interface for DB2 have some features that may be of interest
to you.

Ed.

_________________________________________________________________

Register NOW for the IDUG DB2 Tech Conference in Anaheim, May 2-6, 2011!
_________________________________________________________________
If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L
is the home of IDUG's Listserv

Roger Miller

Re: DB2 Health checker inputs
(in response to DB2information@AOL.COM)
Here are some pointers to health check information:
https://www.ibm.com/developerworks/data/bestpractices/db2zos/
http://www.bwdb2ug.org/PDF/DB2_Health_Check.pdf
http://www.sheltonreese.com/Health%20Check%20Your%20DB2%20UDB%20for%20zOS%20System_files/frame.htm

Roger Miller, DB2 for z/OS




_________________________________________________________________

Register NOW for the IDUG DB2 Tech Conference in Anaheim, May 2-6, 2011!
_________________________________________________________________
If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L
is the home of IDUG's Listserv