UDB 8.2 ESE (DPF) Monitoring

Philip Sevetson

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

Philip Gunning

Re: UDB 8.2 ESE (DPF) Monitoring
(in response to Philip Sevetson)
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

"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

Mark Horrocks

Re: UDB 8.2 ESE (DPF) Monitoring
(in response to Philip Gunning)
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
>
>"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

Philip Sevetson

Re: UDB 8.2 ESE (DPF) Monitoring
(in response to Mark Horrocks)
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

BALACHANDRAN CHANDRASEKARAN

Re: UDB 8.2 ESE (DPF) Monitoring
(in response to Philip Sevetson)
Hi,

I am out of office starting 9th Dec '05 and will return on 13 Dec '05.
For DRM / DBRS related matters, please write it to Swapan Banerjee or
Rama Venkateshamurthy.

Thanks,
Bala

---------------------------------------------------------------------------------
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

Philip Gunning

Re: UDB 8.2 ESE (DPF) Monitoring
(in response to BALACHANDRAN CHANDRASEKARAN)
Based on my experience you need a tool if new to DB2 UDB for Linux, UNIX and
Windows. In addition to what comes with it. Many clients of mine have
written lots of scripts to take snapshots, etc..but still lack DB2 knowledge
(lack of training and lack of time) and do not know what to look for.hence
little or no monitoring is done. HTH Phil
















< http://www.gunningts.com/db2zone.htm > 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/

_____


---------------------------------------------------------------------------------
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

Philip Sevetson

Re: UDB 8.2 ESE (DPF) Monitoring
(in response to Philip Gunning)
Phil G.,

Thanks. We're pretty clear on the need for monitoring in the (hypothetical)
new environment. This would be a port of an existing datawarehouse from
DB2v7-z/OS, if we do it, and our experience is that monitoring is absolutely
necessary when developing new reports/queries against the couple of dozen
tables in the warehouse which have >100M rows.

--Phil S.


On 12/8/05, Phil Gunning <[login to unmask email]> wrote:
>
> Based on my experience you need a tool if new to DB2 UDB for Linux, UNIX
> and Windows. In addition to what comes with it. Many clients of mine have
> written lots of scripts to take snapshots, etc….but still lack DB2 knowledge
> (lack of training and lack of time) and do not know what to look for…hence
> little or no monitoring is done… HTH Phil
>

--
--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.

Mark Horrocks

Re: UDB 8.2 ESE (DPF) Monitoring
(in response to Philip Sevetson)
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

Philip Sevetson

Re: UDB 8.2 ESE (DPF) Monitoring
(in response to Mark Horrocks)
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

Ravikumar Devireddy

Re: UDB 8.2 ESE (DPF) Monitoring
(in response to Philip Sevetson)
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

Mark Horrocks

Re: UDB 8.2 ESE (DPF) Monitoring
(in response to Ravikumar Devireddy)
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