Re: [DB2-L] UDB 8.2 ESE (DPF) Monitoring

Per Stricker

Re: [DB2-L] UDB 8.2 ESE (DPF) Monitoring
ITGAIN provides a great monitoring solution for DB2 UBD 8.2 DPF which includes a performance history database incl. db and dbm cfg, . SQL tuning, index tuning, application monitoring, allerting, drilldown and more ...

Trial is avialable at http://www.itgain.de/en/speedgain_trial.html

Per Stricker
itgain Inc.







 


Query Patroller has come along way. It is more appropriate for DPF. Even there it is not a complete monitoring solution. It does not look at dbm or db cfg parameters, does not contain a snapshot repository or performance history database, nor realtime drilldown capability to solve the current production problem. It would be complimented by other point based and exception monitoring tools.  Phil


 



 



 


 


 


www.gunningts.com/db2zone.htm


610.451.5801 Fax 514-509-6886


"We help people succeed with DB2"


See us at IDUG Asia-Pacific Forum 23-24 Mar 2006 and IDUG North America, 7-11 May 2006, Tampa, Fl.


ITgain:http://www.itgain.de


GET READY TO RELEASE THE VIPER AT:http://www-306.ibm.com/software/data/db2/udb/viper/




From: DB2 Data Base Discussion List [mailto:[login to unmask email] On Behalf Of Philip Sevetson
Sent: Wednesday, December 07, 2005 10:21 PM
To: [login to unmask email]
Subject: [DB2-L] UDB 8.2 ESE (DPF) Monitoring


 



UDB ESE/EEE DBAdms and Sysadms:



 



We're looking at possibly acquiring an ESE platform for our data warehouse.  The sales team (IBM, of course) is telling me that Query Patroller is enough monitoring tool for most customers.  I'd love to believe them, but they _are_ an interested party -- they have an axe to grind.



 



Anybody out there using EEE or ESE?  What are you doing for monitoring and managing performance?  Vendors are welcome on this thread, too -- what do you bring to the table that Query Patroller doesn't?  (If this is OT, would some of y'all talk to me privately?) 



 



We need to have a good performance management product/suite on the ground from day one here, priced as part of the whole acquisition, or there's a good chance we won't get it at all.

--
--Phil Sevetson
IBM Certified Solutions Expert -- DB2 V7.1 Database Administration for OS/390
IBM Certified Database Administrator -- DB2 Universal Database V8.1 for zOS
Wakefern Food Corporation
Edison, NJ, USA
ANY OPINIONS OR RECOMMENDATIONS EXPRESSED IN THIS EMAIL
ARE MY OWN, NOT MY EMPLOYER'S OR IBM'S.


--------------------------------------------------------------------------------- Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

--------------------------------------------------------------------------------- Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Per Stricker

AW: Re: [DB2-L] UDB 8.2 ESE (DPF) Monitoring
(in response to Per Stricker)
ITGAIN provides a great monitoring solution for DB2 UBD 8.2 DPF which includes a performance history database incl. db and dbm cfg, . SQL tuning, index tuning, application monitoring, allerting, drilldown and more ..

Trial is avialable at http://www.itgain.de/en/speedgain_trial.html

Per Stricker
itgain Inc.







 


Query Patroller has come along way. It is more appropriate for DPF. Even there it is not a complete monitoring solution. It does not look at dbm or db cfg parameters, does not contain a snapshot repository or performance history database, nor realtime drilldown capability to solve the current production problem. It would be complimented by other point based and exception monitoring tools.  Phil


 



 



 


 


 


www.gunningts.com/db2zone.htm


610.451.5801 Fax 514-509-6886


"We help people succeed with DB2"


See us at IDUG Asia-Pacific Forum 23-24 Mar 2006 and IDUG North America, 7-11 May 2006, Tampa, Fl.


ITgain:http://www.itgain.de


GET READY TO RELEASE THE VIPER AT:http://www-306.ibm.com/software/data/db2/udb/viper/




From: DB2 Data Base Discussion List [mailto:[login to unmask email] On Behalf Of Philip Sevetson
Sent: Wednesday, December 07, 2005 10:21 PM
To: [login to unmask email]
Subject: [DB2-L] UDB 8.2 ESE (DPF) Monitoring


 



UDB ESE/EEE DBAdms and Sysadms:



 



We're looking at possibly acquiring an ESE platform for our data warehouse.  The sales team (IBM, of course) is telling me that Query Patroller is enough monitoring tool for most customers.  I'd love to believe them, but they _are_ an interested party -- they have an axe to grind.



 



Anybody out there using EEE or ESE?  What are you doing for monitoring and managing performance?  Vendors are welcome on this thread, too -- what do you bring to the table that Query Patroller doesn't?  (If this is OT, would some of y'all talk to me privately?) 



 



We need to have a good performance management product/suite on the ground from day one here, priced as part of the whole acquisition, or there's a good chance we won't get it at all.

--
--Phil Sevetson
IBM Certified Solutions Expert -- DB2 V7.1 Database Administration for OS/390
IBM Certified Database Administrator -- DB2 Universal Database V8.1 for zOS
Wakefern Food Corporation
Edison, NJ, USA
ANY OPINIONS OR RECOMMENDATIONS EXPRESSED IN THIS EMAIL
ARE MY OWN, NOT MY EMPLOYER'S OR IBM'S.


--------------------------------------------------------------------------------- Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

--------------------------------------------------------------------------------- Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

James Harrington

Re: UDB 8.2 ESE (DPF) Monitoring
(in response to Per Stricker)
db2top is available via AlphaWorks on the IBM website:
http://www.alphaworks.ibm.com/tech/db2top

-James


On 12/9/05, Ravi Reddy <[login to unmask email]> wrote:
>
> We are very large warehouse shop ( upwds of 80+TB )
> running ESE DPF.
>
> Some of them use query patroller, and we are now
> looking at smartDBA to see if it can help us in
> anyway.
>
> We also have some cutom built monitoring tools based
> on specific requirements.
>
> Along those lines, db2top from IBM is a very good tool
> to capture snapshots, cfgs, sqls etc...particularly
> for DPF instances. I don't know if db2top is available
> out there for all, or if it is still in BETA/EVAL
> stage..you might want to check it with your IBM rep.
>
> Thanks,
> Ravi.
>
> --- Philip Sevetson <[login to unmask email]> wrote:
>
> > Yes -- AIX flavor. Don't know release numbers.
> > (UDB ESE is only valid on
> > UNIX flavors as far as I know.)
> >
> > --Phil
> >
> >
> > On 12/9/05, Mark Horrocks <[login to unmask email]>
> > wrote:
> > >
> > > Is this going to be on UNIX?
> > >
> > > >From: Philip Sevetson <[login to unmask email]>
> > > >Reply-To: DB2 Database Discussion list at IDUG
> > <[login to unmask email]>
> > > >To: [login to unmask email]
> > > >Subject: Re: [DB2-L] UDB 8.2 ESE (DPF) Monitoring
> > > >Date: Thu, 8 Dec 2005 09:23:58 -0500
> > > >
> > > >Mark,
> > > >
> > > >We're brand-new to UDB non-z/OS in this shop --
> > it actually hasn't yet
> > > been
> > > >determined that we're actually going there; I'm
> > just trying to be ready.
> > > >In-house script development would be nice (we're
> > familiar with Perl and
> > > >Ksh), but we assume we're going to need some
> > serious UDB training first.
> > > >
> > > >--Phil
> > > >
> > > >On 12/8/05, Mark Horrocks
> > <[login to unmask email]> wrote:
> > > >
> > > > > If you have ESE/EEE DBAs then you should have
> > no problems setting up
> > > >your
> > > > > own in-house monitoring scripts. Starting with
> > a performance
> > > monitoring
> > > > > priority list and working through.
> > > > >
> > > > > Plus if in-house devloped no expensive license
> > costs and your in-house
> > > > > scripts can re-used.
> > > > >
> > > > > Big benefit you gain more knowledge of your
> > WH.
> > > > >
> > > > >
> > > > > >From: Phil Gunning <[login to unmask email]>
> > > > > >Reply-To: DB2 Database Discussion list at
> > IDUG
> > > ><[login to unmask email]>
> > > > > >To: [login to unmask email]
> > > > > >Subject: Re: [DB2-L] UDB 8.2 ESE (DPF)
> > Monitoring
> > > > > >Date: Wed, 7 Dec 2005 22:25:43 -0500
> > > > > >
> > > > > >Query Patroller has come along way. It is
> > more appropriate for DPF.
> > > Even
> > > > > >there it is not a complete monitoring
> > solution. It does not look at
> > > dbm or
> > > > > >db cfg parameters, does not contain a
> > snapshot repository or
> > > performance
> > > > > >history database, nor realtime drilldown
> > capability to solve the
> > > current
> > > > > >production problem. It would be complimented
> > by other point based and
> > > > > >exception monitoring tools. Phil
> > > > > > < http://www.gunningts.com/db2zone.htm >
> > > www.gunningts.com/db2zone.htm
> > > > > >610.451.5801 Fax 514-509-6886
> > > > > >
> > > > > >ITgain:http://www.itgain.de
> > > > > >
> > > > > >
> > > > > >From: DB2 Data Base Discussion List
> > [mailto:[login to unmask email]
> > > On Behalf
> > > > > >Of Philip Sevetson
> > > > > >Sent: Wednesday, December 07, 2005 10:21 PM
> > > > > >To: [login to unmask email]
> > > > > >Subject: [DB2-L] UDB 8.2 ESE (DPF) Monitoring
> > > > > >
> > > > > >UDB ESE/EEE DBAdms and Sysadms:
> > > > > >
> > > > > >We're looking at possibly acquiring an ESE
> > platform for our
> > > data warehouse.
> > > > > >The sales team (IBM, of course) is telling me
> > that Query Patroller
> > > is enough
> > > > > >monitoring tool for most customers. I'd love
> > to believe them, but
> > > they
> > > > > >_are_ an interested party -- they have an axe
> > to grind.
> > > > > >
> > > > > >Anybody out there using EEE or ESE? What are
> > you doing for
> > > monitoring and
> > > > > >managing performance? Vendors are welcome on
> > this thread, too --
> > > what do
> > > > > >you bring to the table that Query Patroller
> > doesn't? (If this is
> > > OT, would
> > > > > >some of y'all talk to me privately?)
> > > > > >
> > > > > >We need to have a good performance management
> > product/suite on the
> > > ground
> > > > > >from day one here, priced as part of the
> > whole acquisition, or
> > > there's a
> > > > > >good chance we won't get it at all.
> > > > > >
> > > > > >--
> > > > > >--Phil Sevetson
> > > > > >
> > >
> > --
> > --Phil Sevetson
> > IBM Certified Solutions Expert -- DB2 V7.1 Database
> > Administration for
> > OS/390
> > IBM Certified Database Administrator -- DB2
> > Universal Database V8.1 for zOS
> > Wakefern Food Corporation
> > Edison, NJ, USA
> > ANY OPINIONS OR RECOMMENDATIONS EXPRESSED IN THIS
> > EMAIL
> > ARE MY OWN, NOT MY EMPLOYER'S OR IBM'S.
> >
> >
>
> ---------------------------------------------------------------------------------
> > Welcome to the IDUG DB2-L list. To unsubscribe, go
> > to the archives and home page at
> > http://www.idugdb2-l.org/archives/db2-l.html. From
> > that page select "Join or Leave the list". The IDUG
> > DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG
> > List Admins can be reached at
> > [login to unmask email] Find out the latest
> > on IDUG conferences at
> > http://conferences.idug.org/index.cfm
> >
>
>
> __________________________________________________
> Do You Yahoo!?
> Tired of spam? Yahoo! Mail has the best spam protection around
> http://mail.yahoo.com
>
>
> ---------------------------------------------------------------------------------
> Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and
> home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page
> select "Join or Leave the list". The IDUG DB2-L FAQ is at
> http://www.idugdb2-l.org. The IDUG List Admins can be reached at
> [login to unmask email] Find out the latest on IDUG conferences
> at http://conferences.idug.org/index.cfm
>

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

James Harrington

Re: UDB 8.2 ESE (DPF) Monitoring
(in response to Kumar Vaddadi/EIG)
db2top is available via AlphaWorks on the IBM website:
http://www.alphaworks.ibm.com/tech/db2top

-James


On 12/9/05, Ravi Reddy <[login to unmask email]> wrote:
>
> We are very large warehouse shop ( upwds of 80+TB )
> running ESE DPF.
>
> Some of them use query patroller, and we are now
> looking at smartDBA to see if it can help us in
> anyway.
>
> We also have some cutom built monitoring tools based
> on specific requirements.
>
> Along those lines, db2top from IBM is a very good tool
> to capture snapshots, cfgs, sqls etc...particularly
> for DPF instances. I don't know if db2top is available
> out there for all, or if it is still in BETA/EVAL
> stage..you might want to check it with your IBM rep.
>
> Thanks,
> Ravi.
>
> --- Philip Sevetson <[login to unmask email]> wrote:
>
> > Yes -- AIX flavor. Don't know release numbers.
> > (UDB ESE is only valid on
> > UNIX flavors as far as I know.)
> >
> > --Phil
> >
> >
> > On 12/9/05, Mark Horrocks <[login to unmask email]>
> > wrote:
> > >
> > > Is this going to be on UNIX?
> > >
> > > >From: Philip Sevetson <[login to unmask email]>
> > > >Reply-To: DB2 Database Discussion list at IDUG
> > <[login to unmask email]>
> > > >To: [login to unmask email]
> > > >Subject: Re: [DB2-L] UDB 8.2 ESE (DPF) Monitoring
> > > >Date: Thu, 8 Dec 2005 09:23:58 -0500
> > > >
> > > >Mark,
> > > >
> > > >We're brand-new to UDB non-z/OS in this shop --
> > it actually hasn't yet
> > > been
> > > >determined that we're actually going there; I'm
> > just trying to be ready.
> > > >In-house script development would be nice (we're
> > familiar with Perl and
> > > >Ksh), but we assume we're going to need some
> > serious UDB training first.
> > > >
> > > >--Phil
> > > >
> > > >On 12/8/05, Mark Horrocks
> > <[login to unmask email]> wrote:
> > > >
> > > > > If you have ESE/EEE DBAs then you should have
> > no problems setting up
> > > >your
> > > > > own in-house monitoring scripts. Starting with
> > a performance
> > > monitoring
> > > > > priority list and working through.
> > > > >
> > > > > Plus if in-house devloped no expensive license
> > costs and your in-house
> > > > > scripts can re-used.
> > > > >
> > > > > Big benefit you gain more knowledge of your
> > WH.
> > > > >
> > > > >
> > > > > >From: Phil Gunning <[login to unmask email]>
> > > > > >Reply-To: DB2 Database Discussion list at
> > IDUG
> > > ><[login to unmask email]>
> > > > > >To: [login to unmask email]
> > > > > >Subject: Re: [DB2-L] UDB 8.2 ESE (DPF)
> > Monitoring
> > > > > >Date: Wed, 7 Dec 2005 22:25:43 -0500
> > > > > >
> > > > > >Query Patroller has come along way. It is
> > more appropriate for DPF.
> > > Even
> > > > > >there it is not a complete monitoring
> > solution. It does not look at
> > > dbm or
> > > > > >db cfg parameters, does not contain a
> > snapshot repository or
> > > performance
> > > > > >history database, nor realtime drilldown
> > capability to solve the
> > > current
> > > > > >production problem. It would be complimented
> > by other point based and
> > > > > >exception monitoring tools. Phil
> > > > > > < http://www.gunningts.com/db2zone.htm >
> > > www.gunningts.com/db2zone.htm
> > > > > >610.451.5801 Fax 514-509-6886
> > > > > >
> > > > > >ITgain:http://www.itgain.de
> > > > > >
> > > > > >
> > > > > >From: DB2 Data Base Discussion List
> > [mailto:[login to unmask email]
> > > On Behalf
> > > > > >Of Philip Sevetson
> > > > > >Sent: Wednesday, December 07, 2005 10:21 PM
> > > > > >To: [login to unmask email]
> > > > > >Subject: [DB2-L] UDB 8.2 ESE (DPF) Monitoring
> > > > > >
> > > > > >UDB ESE/EEE DBAdms and Sysadms:
> > > > > >
> > > > > >We're looking at possibly acquiring an ESE
> > platform for our
> > > data warehouse.
> > > > > >The sales team (IBM, of course) is telling me
> > that Query Patroller
> > > is enough
> > > > > >monitoring tool for most customers. I'd love
> > to believe them, but
> > > they
> > > > > >_are_ an interested party -- they have an axe
> > to grind.
> > > > > >
> > > > > >Anybody out there using EEE or ESE? What are
> > you doing for
> > > monitoring and
> > > > > >managing performance? Vendors are welcome on
> > this thread, too --
> > > what do
> > > > > >you bring to the table that Query Patroller
> > doesn't? (If this is
> > > OT, would
> > > > > >some of y'all talk to me privately?)
> > > > > >
> > > > > >We need to have a good performance management
> > product/suite on the
> > > ground
> > > > > >from day one here, priced as part of the
> > whole acquisition, or
> > > there's a
> > > > > >good chance we won't get it at all.
> > > > > >
> > > > > >--
> > > > > >--Phil Sevetson
> > > > > >
> > >
> > --
> > --Phil Sevetson
> > IBM Certified Solutions Expert -- DB2 V7.1 Database
> > Administration for
> > OS/390
> > IBM Certified Database Administrator -- DB2
> > Universal Database V8.1 for zOS
> > Wakefern Food Corporation
> > Edison, NJ, USA
> > ANY OPINIONS OR RECOMMENDATIONS EXPRESSED IN THIS
> > EMAIL
> > ARE MY OWN, NOT MY EMPLOYER'S OR IBM'S.
> >
> >
>
> ---------------------------------------------------------------------------------
> > Welcome to the IDUG DB2-L list. To unsubscribe, go
> > to the archives and home page at
> > http://www.idugdb2-l.org/archives/db2-l.html. From
> > that page select "Join or Leave the list". The IDUG
> > DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG
> > List Admins can be reached at
> > [login to unmask email] Find out the latest
> > on IDUG conferences at
> > http://conferences.idug.org/index.cfm
> >
>
>
> __________________________________________________
> Do You Yahoo!?
> Tired of spam? Yahoo! Mail has the best spam protection around
> http://mail.yahoo.com
>
>
> ---------------------------------------------------------------------------------
> Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and
> home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page
> select "Join or Leave the list". The IDUG DB2-L FAQ is at
> http://www.idugdb2-l.org. The IDUG List Admins can be reached at
> [login to unmask email] Find out the latest on IDUG conferences
> at http://conferences.idug.org/index.cfm
>

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Kumar Vaddadi/EIG

Re: UDB 8.2 ESE (DPF) Monitoring
(in response to James Harrington)
Is there anything similar to Db2top for Non-DPF environment.... Other than
writing in scripts if any tool pls let us know..

************* Thanks & Regards *******************
Vaddadi Shyam Kumar
IBM Db2 Certified Database Administrator
Data Management Group
The Economical Insurance Group, Waterloo.
Reach me @ 519-570-8500 ext 2242
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------

Happiness is when what you think, what you say, and what you do are in
harmony. ----- Mahatma Gandhi
******************************************************************************************************************************


|---------+---------------------------->
| | Mark Horrocks |
| | <[login to unmask email]|
| | IL.COM> |
| | Sent by: DB2 Data|
| | Base Discussion |
| | List |
| | <[login to unmask email]|
| | ORG> |
| | |
| | |
| | 12/09/2005 02:36 |
| | PM |
| | Please respond to|
| | DB2 Database |
| | Discussion list |
| | at IDUG |
| | |
|---------+---------------------------->
>------------------------------------------------------------------------------------------------------------------------------|
| |
| To: [login to unmask email] |
| cc: |
| Subject: Re: [DB2-L] UDB 8.2 ESE (DPF) Monitoring |
>------------------------------------------------------------------------------------------------------------------------------|




Philip,

Getting the deisgn right for EEE on the AIX is key in terms of data skew
and
dbm/db cfg parameters.

You need to pay close attention to your partitioning keys as this will
effect data skew.

Many Thanks,

Mark Horrocks.


>From: Philip Sevetson <[login to unmask email]>
>Reply-To: DB2 Database Discussion list at IDUG <[login to unmask email]>
>To: [login to unmask email]
>Subject: Re: [DB2-L] UDB 8.2 ESE (DPF) Monitoring
>Date: Fri, 9 Dec 2005 13:58:54 -0500
>
>Yes -- AIX flavor. Don't know release numbers. (UDB ESE is only valid on
>UNIX flavors as far as I know.)
>
>--Phil
>
>
>On 12/9/05, Mark Horrocks <[login to unmask email]> wrote:
> >
> > Is this going to be on UNIX?
> >
> > >From: Philip Sevetson <[login to unmask email]>
> > >Reply-To: DB2 Database Discussion list at IDUG
><[login to unmask email]>
> > >To: [login to unmask email]
> > >Subject: Re: [DB2-L] UDB 8.2 ESE (DPF) Monitoring
> > >Date: Thu, 8 Dec 2005 09:23:58 -0500
> > >
> > >Mark,
> > >
> > >We're brand-new to UDB non-z/OS in this shop -- it actually hasn't yet
> > been
> > >determined that we're actually going there; I'm just trying to be
>ready.
> > >In-house script development would be nice (we're familiar with Perl
and
> > >Ksh), but we assume we're going to need some serious UDB training
>first.
> > >
> > >--Phil
> > >
> > >On 12/8/05, Mark Horrocks <[login to unmask email]> wrote:
> > >
> > > > If you have ESE/EEE DBAs then you should have no problems setting
up
> > >your
> > > > own in-house monitoring scripts. Starting with a performance
> > monitoring
> > > > priority list and working through.
> > > >
> > > > Plus if in-house devloped no expensive license costs and your
>in-house
> > > > scripts can re-used.
> > > >
> > > > Big benefit you gain more knowledge of your WH.
> > > >
> > > >
> > > > >From: Phil Gunning <[login to unmask email]>
> > > > >Reply-To: DB2 Database Discussion list at IDUG
> > ><[login to unmask email]>
> > > > >To: [login to unmask email]
> > > > >Subject: Re: [DB2-L] UDB 8.2 ESE (DPF) Monitoring
> > > > >Date: Wed, 7 Dec 2005 22:25:43 -0500
> > > > >
> > > > >Query Patroller has come along way. It is more appropriate for
DPF.
> > Even
> > > > >there it is not a complete monitoring solution. It does not look
at
> > dbm or
> > > > >db cfg parameters, does not contain a snapshot repository or
> > performance
> > > > >history database, nor realtime drilldown capability to solve the
> > current
> > > > >production problem. It would be complimented by other point based
>and
> > > > >exception monitoring tools. Phil
> > > > > < http://www.gunningts.com/db2zone.htm >
> > www.gunningts.com/db2zone.htm
> > > > >610.451.5801 Fax 514-509-6886
> > > > >
> > > > >ITgain:http://www.itgain.de
> > > > >
> > > > >
> > > > >From: DB2 Data Base Discussion List [mailto:[login to unmask email]
> > On Behalf
> > > > >Of Philip Sevetson
> > > > >Sent: Wednesday, December 07, 2005 10:21 PM
> > > > >To: [login to unmask email]
> > > > >Subject: [DB2-L] UDB 8.2 ESE (DPF) Monitoring
> > > > >
> > > > >UDB ESE/EEE DBAdms and Sysadms:
> > > > >
> > > > >We're looking at possibly acquiring an ESE platform for our
> > data warehouse.
> > > > >The sales team (IBM, of course) is telling me that Query Patroller
> > is enough
> > > > >monitoring tool for most customers. I'd love to believe them, but
> > they
> > > > >_are_ an interested party -- they have an axe to grind.
> > > > >
> > > > >Anybody out there using EEE or ESE? What are you doing for
> > monitoring and
> > > > >managing performance? Vendors are welcome on this thread, too --
> > what do
> > > > >you bring to the table that Query Patroller doesn't? (If this is
> > OT, would
> > > > >some of y'all talk to me privately?)
> > > > >
> > > > >We need to have a good performance management product/suite on the
> > ground
> > > > >from day one here, priced as part of the whole acquisition, or
> > there's a
> > > > >good chance we won't get it at all.
> > > > >
> > > > >--
> > > > >--Phil Sevetson
> > > > >
> >
>--
>--Phil Sevetson
>IBM Certified Solutions Expert -- DB2 V7.1 Database Administration for
>OS/390
>IBM Certified Database Administrator -- DB2 Universal Database V8.1 for
zOS
>Wakefern Food Corporation
>Edison, NJ, USA
>ANY OPINIONS OR RECOMMENDATIONS EXPRESSED IN THIS EMAIL
>ARE MY OWN, NOT MY EMPLOYER'S OR IBM'S.
>
>---------------------------------------------------------------------------------

>Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and
home
>page at http://www.idugdb2-l.org/archives/db2-l.html. From that page
select
>"Join or Leave the list". The IDUG DB2-L FAQ is at
>http://www.idugdb2-l.org. The IDUG List Admins can be reached at
>[login to unmask email] Find out the latest on IDUG conferences
at
>http://conferences.idug.org/index.cfm

---------------------------------------------------------------------------------

Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home
page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select
"Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org
. The IDUG List Admins can be reached at [login to unmask email]
Find out the latest on IDUG conferences at
http://conferences.idug.org/index.cfm

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Kumar Vaddadi/EIG

Re: UDB 8.2 ESE (DPF) Monitoring
(in response to James Harrington)
Is there anything similar to Db2top for Non-DPF environment.... Other than
writing in scripts if any tool pls let us know..

************* Thanks & Regards *******************
Vaddadi Shyam Kumar
IBM Db2 Certified Database Administrator
Data Management Group
The Economical Insurance Group, Waterloo.
Reach me @ 519-570-8500 ext 2242
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------

Happiness is when what you think, what you say, and what you do are in
harmony. ----- Mahatma Gandhi
******************************************************************************************************************************


|---------+---------------------------->
| | Mark Horrocks |
| | <[login to unmask email]|
| | IL.COM> |
| | Sent by: DB2 Data|
| | Base Discussion |
| | List |
| | <[login to unmask email]|
| | ORG> |
| | |
| | |
| | 12/09/2005 02:36 |
| | PM |
| | Please respond to|
| | DB2 Database |
| | Discussion list |
| | at IDUG |
| | |
|---------+---------------------------->
>------------------------------------------------------------------------------------------------------------------------------|
| |
| To: [login to unmask email] |
| cc: |
| Subject: Re: [DB2-L] UDB 8.2 ESE (DPF) Monitoring |
>------------------------------------------------------------------------------------------------------------------------------|




Philip,

Getting the deisgn right for EEE on the AIX is key in terms of data skew
and
dbm/db cfg parameters.

You need to pay close attention to your partitioning keys as this will
effect data skew.

Many Thanks,

Mark Horrocks.


>From: Philip Sevetson <[login to unmask email]>
>Reply-To: DB2 Database Discussion list at IDUG <[login to unmask email]>
>To: [login to unmask email]
>Subject: Re: [DB2-L] UDB 8.2 ESE (DPF) Monitoring
>Date: Fri, 9 Dec 2005 13:58:54 -0500
>
>Yes -- AIX flavor. Don't know release numbers. (UDB ESE is only valid on
>UNIX flavors as far as I know.)
>
>--Phil
>
>
>On 12/9/05, Mark Horrocks <[login to unmask email]> wrote:
> >
> > Is this going to be on UNIX?
> >
> > >From: Philip Sevetson <[login to unmask email]>
> > >Reply-To: DB2 Database Discussion list at IDUG
><[login to unmask email]>
> > >To: [login to unmask email]
> > >Subject: Re: [DB2-L] UDB 8.2 ESE (DPF) Monitoring
> > >Date: Thu, 8 Dec 2005 09:23:58 -0500
> > >
> > >Mark,
> > >
> > >We're brand-new to UDB non-z/OS in this shop -- it actually hasn't yet
> > been
> > >determined that we're actually going there; I'm just trying to be
>ready.
> > >In-house script development would be nice (we're familiar with Perl
and
> > >Ksh), but we assume we're going to need some serious UDB training
>first.
> > >
> > >--Phil
> > >
> > >On 12/8/05, Mark Horrocks <[login to unmask email]> wrote:
> > >
> > > > If you have ESE/EEE DBAs then you should have no problems setting
up
> > >your
> > > > own in-house monitoring scripts. Starting with a performance
> > monitoring
> > > > priority list and working through.
> > > >
> > > > Plus if in-house devloped no expensive license costs and your
>in-house
> > > > scripts can re-used.
> > > >
> > > > Big benefit you gain more knowledge of your WH.
> > > >
> > > >
> > > > >From: Phil Gunning <[login to unmask email]>
> > > > >Reply-To: DB2 Database Discussion list at IDUG
> > ><[login to unmask email]>
> > > > >To: [login to unmask email]
> > > > >Subject: Re: [DB2-L] UDB 8.2 ESE (DPF) Monitoring
> > > > >Date: Wed, 7 Dec 2005 22:25:43 -0500
> > > > >
> > > > >Query Patroller has come along way. It is more appropriate for
DPF.
> > Even
> > > > >there it is not a complete monitoring solution. It does not look
at
> > dbm or
> > > > >db cfg parameters, does not contain a snapshot repository or
> > performance
> > > > >history database, nor realtime drilldown capability to solve the
> > current
> > > > >production problem. It would be complimented by other point based
>and
> > > > >exception monitoring tools. Phil
> > > > > < http://www.gunningts.com/db2zone.htm >
> > www.gunningts.com/db2zone.htm
> > > > >610.451.5801 Fax 514-509-6886
> > > > >
> > > > >ITgain:http://www.itgain.de
> > > > >
> > > > >
> > > > >From: DB2 Data Base Discussion List [mailto:[login to unmask email]
> > On Behalf
> > > > >Of Philip Sevetson
> > > > >Sent: Wednesday, December 07, 2005 10:21 PM
> > > > >To: [login to unmask email]
> > > > >Subject: [DB2-L] UDB 8.2 ESE (DPF) Monitoring
> > > > >
> > > > >UDB ESE/EEE DBAdms and Sysadms:
> > > > >
> > > > >We're looking at possibly acquiring an ESE platform for our
> > data warehouse.
> > > > >The sales team (IBM, of course) is telling me that Query Patroller
> > is enough
> > > > >monitoring tool for most customers. I'd love to believe them, but
> > they
> > > > >_are_ an interested party -- they have an axe to grind.
> > > > >
> > > > >Anybody out there using EEE or ESE? What are you doing for
> > monitoring and
> > > > >managing performance? Vendors are welcome on this thread, too --
> > what do
> > > > >you bring to the table that Query Patroller doesn't? (If this is
> > OT, would
> > > > >some of y'all talk to me privately?)
> > > > >
> > > > >We need to have a good performance management product/suite on the
> > ground
> > > > >from day one here, priced as part of the whole acquisition, or
> > there's a
> > > > >good chance we won't get it at all.
> > > > >
> > > > >--
> > > > >--Phil Sevetson
> > > > >
> >
>--
>--Phil Sevetson
>IBM Certified Solutions Expert -- DB2 V7.1 Database Administration for
>OS/390
>IBM Certified Database Administrator -- DB2 Universal Database V8.1 for
zOS
>Wakefern Food Corporation
>Edison, NJ, USA
>ANY OPINIONS OR RECOMMENDATIONS EXPRESSED IN THIS EMAIL
>ARE MY OWN, NOT MY EMPLOYER'S OR IBM'S.
>
>---------------------------------------------------------------------------------

>Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and
home
>page at http://www.idugdb2-l.org/archives/db2-l.html. From that page
select
>"Join or Leave the list". The IDUG DB2-L FAQ is at
>http://www.idugdb2-l.org. The IDUG List Admins can be reached at
>[login to unmask email] Find out the latest on IDUG conferences
at
>http://conferences.idug.org/index.cfm

---------------------------------------------------------------------------------

Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home
page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select
"Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org
The IDUG List Admins can be reached at [login to unmask email]
Find out the latest on IDUG conferences at
http://conferences.idug.org/index.cfm

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm