Re: testing memory parameters

From: DA Morgan <>
Date: Wed, 19 Mar 2008 13:44:25 -0700
Message-ID: <>

hpuxrac wrote:
> On Mar 18, 4:24 pm, DA Morgan <> wrote:
> snip

>>>> Because, in DB2, you don't have sufficient instrumentation to look
>>>> inside and see what is happening.
>>> Ah, Daniel, you never fail to live up to my expectation of taking a
>>> cheap shot wherever you can. What would you know about DB2's state of
>>> perf tuning tools...
>>> But I digress. I got the answers I needed.
>>> Thanks Ana
>>> Serge
>> Perhaps I was wrong ... please provide me the link to the DB2 equivalent
>> to ASH, AWR, and the wait interface.

> Why don't you take some time and read the DB2 documentation?
> Probably you can start with some searches on google ... let's see
> there is the DB2 Technical Library, IBM Redbooks, stuff like the DB2
> Tuning Database Performance manual ... etc. Doing a little legwork
> might be good for you.
> Of course Oracle offers free access to all the stuff like ASH, AWR,
> and the wait interface thru OEM or Grid Control ... well at least if
> you pay extra licensing fee's for the options packs and enterprise
> edition.
> Wonder if many oracle customer's skip paying for these options and use
> 3rd party tools like Quest or BMC etc? Wonder if any other 3rd
> parties do the same thing for DB2 ... why surprise I guess they do!
> Looks like you have a bunch of homework to do!

One of the first thing you learn in law school is to not ask a question, in court, to which you don't already know the answer. Let Serge respond if he wishes.

But while we're at it I will clarify the request ... DB2 on LUX not DB2 on the mainframe.

Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington (replace x with u to respond)
Puget Sound Oracle Users Group
Received on Wed Mar 19 2008 - 15:44:25 CDT

Original text of this message