Re: testing memory parameters

From: Serge Rielau <srielau_at_ca.ibm.com>
Date: Wed, 19 Mar 2008 20:13:55 -0400
Message-ID: <64doiaF2bkgevU1@mid.individual.net>

DA Morgan wrote:

> Serge Rielau wrote:
>> DA Morgan wrote:
>>> hpuxrac wrote:

>>>> On Mar 18, 4:24 pm, DA Morgan <damor..._at_psoug.org> 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.
>> One of the first things you learn in law-school is that the one making 
>> the allegation is the one having to prove they are correct.
>> "Because, in DB2, you don't have sufficient instrumentation to look
>> inside and see what is happening."
>> The onus is not on me. Aside this is an Oracle group. I asked a 
>> question. I got a reasonanble answer from anyone but you.
>>
>>> But while we're at it I will clarify the request ... DB2 on LUX not
>>> DB2 on the mainframe.
>> What does Luxemburg have to do with this?
>>
>> Cheers
>> Serge
> 
> Two times you could have provided the name of that equivalent technology
> built into your product so that people could look it up and see. Twice
> you have dodged. Here's a third opportunity to set the record straight
> if you think I am misrepresenting the capabilities of DB2 on Linux UNix.

If you ask NICELY in c.d.ibm-db2 AND you EXPLAIN these acronyms you're throwing around mean (I'm the SQL guy, remember - that's why I ask the stupid questions about hit ratios) then I'm sure someone will point you to DB2 technologies.
Oh and it will help if you state whether they are free or add-on's so the net is cast appropriately.

Cheers
Serge

-- 
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

Received on Wed Mar 19 2008 - 19:13:55 CDT