[LUW] Question about Oracle Enterprise Manager Grid Control and DB2

DB2 DBA Jeffrey Benner

[LUW] Question about Oracle Enterprise Manager Grid Control and DB2
I am working with some other DBA's on a project which formerly had been 100%
Oracle. They have been successfully managing hundreds of Oracle databases
using Oracle Enterprise Manager Grid Control. Now, they contemplate adding
DB2 to the mix (Grid Control has a DB2 Plug-in, as well as MYSQL, and other
platforms). I was wondering if anyone on DB2-L has used Grid Control to
manage DB2 resources, and what your experience with it has been.

Thank you in advance.

Jeffrey

______________________________________________________________________

* IDUG 2009 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/Events *
______________________________________________________________________




IDUG.org was recently updated requiring members to use a new password. You should have gotten an e-mail with the temporary password assigned to your account. Please log in and update your member profile. If you are not already an IDUG.org member, please register at http://www.idug.org/component/juser/register.html

Peter Suhner

Re: [LUW] Question about Oracle Enterprise Manager Grid Control and DB2
(in response to DB2 DBA Jeffrey Benner)

Jeffrey,

yes, we do - just for convenience (many Oracle DBs, only around 60 DB2 LUW instances). The DB2 Plug-in is ok, it basically grabs the values from the DB2 databases through JDBC by calling the respective admin functions (e.g. "get_dbsize_info(?,?,?,-1)" and the like - NOT the SYSIBMADM views). It provides you with about all relevant standard monitoring values. I think you could also extend these standard checks with some of your own, but I haven't found the time to delve into this.

However, my experience is as follows:
- I'm not aware of a way to acutally manage the DB2 instances, we just monitor them through OEM. Maybe I missed something there?
- DB2 health monitoring must be turned on (not all shops like to do this for performance reasons)
- You can use the DB2 plug-in out of the box, but might want to adapt
some of the standard threshold and scheduling
values

- Not all the values shown in OEM are 100% reliable (e.g. Bufferpool Hit Ratio sometimes varies heavily from what native DB2 values show - looks like this is caused by OEM doing some strange maths of it's own to various values - thus the term "Oracle"?). For our shop, these differences were found to be negligible.
- OEM database tends to become incredibly slow with growing amounts of monitoring data
- As a result, reports of one single DB usually work fine, but reports over groups (which would be a nice feature) just fail with timeouts (maybe there's a way to tune our OEM database? But I've seen better data models in my life)

From my experience, I would not recommend OEM for sites with many and/or performance critical DB2 databases. However, to integrate monitoring of a few DB2 instances into an Oracle shop, this is an acceptable solution providing low overhead and one single, identical interface. Definitely a pro!


Best regards,
Peter




Date: Thu, 22 Jan 2009 16:58:47 -0600
From: [login to unmask email]
Subject: [DB2-L] [LUW] Question about Oracle Enterprise Manager Grid Control and DB2
To: [login to unmask email]

I am working with some other DBA's on a project which formerly had been 100% Oracle. They have been successfully managing hundreds of Oracle databases using Oracle Enterprise Manager Grid Control. Now, they contemplate adding DB2 to the mix (Grid Control has a DB2 Plug-in, as well as MYSQL, and other platforms). I was wondering if anyone on DB2-L has used Grid Control to manage DB2 resources, and what your experience with it has been.


Thank you in advance.

Jeffrey





IDUG 2009 - Australasia * 18-20 March * Melbourne, Australia


IDUG.org was recently updated requiring members to use a new password. You should have gotten an e-mail with the temporary password assigned to your account. Please log in and update your member profile. If you are not already an IDUG.org member, please register here.

_________________________________________________________________
Invite your mail contacts to join your friends list with Windows Live Spaces. It's easy!
http://spaces.live.com/spacesapi.aspx?wx_action=create&wx_url=/friends.aspx&mkt=en-us
______________________________________________________________________

* IDUG 2009 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/Events *
______________________________________________________________________




IDUG.org was recently updated requiring members to use a new password. You should have gotten an e-mail with the temporary password assigned to your account. Please log in and update your member profile. If you are not already an IDUG.org member, please register at http://www.idug.org/component/juser/register.html

DB2 DBA Jeffrey Benner

Re: [LUW] Question about Oracle Enterprise Manager Grid Control and DB2
(in response to Peter Suhner)
Thank you Peter for your brilliant response. Your detail will prove very
helpful in our own planning. I appreciate that you took the time to post
such a detailed overview of OEM/GC.

Jeffrey

On Sun, Jan 25, 2009 at 16:44, Peter Suhner <[login to unmask email]>wrote:

> Jeffrey,
>
> yes, we do - just for convenience (many Oracle DBs, only around 60 DB2 LUW
> instances). The DB2 Plug-in is ok, it basically grabs the values from the
> DB2 databases through JDBC by calling the respective admin functions (e.g.
> "get_dbsize_info(?,?,?,-1)" and the like - NOT the SYSIBMADM views). It
> provides you with about all relevant standard monitoring values. I think you
> could also extend these standard checks with some of your own, but I haven't
> found the time to delve into this.
>
> However, my experience is as follows:
> - I'm not aware of a way to acutally manage the DB2 instances, we just
> monitor them through OEM. Maybe I missed something there?
> - DB2 health monitoring must be turned on (not all shops like to do this
> for performance reasons)
> - You can use the DB2 plug-in out of the box, but might want to adapt some
> of the standard threshold and scheduling values
> - Not all the values shown in OEM are 100% reliable (e.g. Bufferpool Hit
> Ratio sometimes varies heavily from what native DB2 values show - looks like
> this is caused by OEM doing some strange maths of it's own to various values
> - thus the term "Oracle"?). For our shop, these differences were found to be
> negligible.
> - OEM database tends to become incredibly slow with growing amounts of
> monitoring data
> - As a result, reports of one single DB usually work fine, but reports over
> groups (which would be a nice feature) just fail with timeouts (maybe
> there's a way to tune our OEM database? But I've seen better data models in
> my life)
>
> From my experience, I would not recommend OEM for sites with many and/or
> performance critical DB2 databases. However, to integrate monitoring of a
> few DB2 instances into an Oracle shop, this is an acceptable solution
> providing low overhead and one single, identical interface. Definitely a
> pro!
>
>
> Best regards,
> Peter
>
>
>
>
> ------------------------------
> Date: Thu, 22 Jan 2009 16:58:47 -0600
> From: [login to unmask email]
> Subject: [DB2-L] [LUW] Question about Oracle Enterprise Manager Grid
> Control and DB2
> To: [login to unmask email]
>
> I am working with some other DBA's on a project which formerly had been
> 100% Oracle. They have been successfully managing hundreds of Oracle
> databases using Oracle Enterprise Manager Grid Control. Now, they
> contemplate adding DB2 to the mix (Grid Control has a DB2 Plug-in, as well
> as MYSQL, and other platforms). I was wondering if anyone on DB2-L has used
> Grid Control to manage DB2 resources, and what your experience with it has
> been.
>
> Thank you in advance.
>
> Jeffrey
>
>
> ------------------------------
>
> *IDUG 2009 - Australasia * 18-20 March * Melbourne, Australia* < http://idug.org/lsAU >
> *** *
> *IDUG.org* < http://www.idug.org > was recently updated requiring members to
> use a new password. You should have gotten an e-mail with the temporary
> password assigned to your account. Please log in and update your member
> profile. If you are not already an IDUG.org member, please register here. < http://www.idug.org/component/juser/register.html >
>
> ------------------------------
> Invite your mail contacts to join your friends list with Windows Live
> Spaces. It's easy! Try it! < http://spaces.live.com/spacesapi.aspx?wx_action=create&wx_url=/friends.aspx&mkt=en-us >
>
> ------------------------------
>
> *IDUG 2009 - Europe * 5-9 October * Rome, Italy* < http://idug.org/lseu >
>
> *IDUG.org* < http://www.idug.org > was recently updated requiring members to
> use a new password. You should have gotten an e-mail with the temporary
> password assigned to your account. Please log in and update your member
> profile. If you are not already an IDUG.org member, please register here. < http://www.idug.org/component/juser/register.html >
>

______________________________________________________________________

* IDUG 2009 Melbourne, Australia * 18-20 March * http://IDUG.ORG/Events *
______________________________________________________________________




IDUG.org was recently updated requiring members to use a new password. You should have gotten an e-mail with the temporary password assigned to your account. Please log in and update your member profile. If you are not already an IDUG.org member, please register at http://www.idug.org/component/juser/register.html