Re: Adjusting to DB2

Comments embedded.
Mark A wrote:
> >"Bjarke Wedemeijer" <bjarke_at_wedemeijer.dk> wrote in message
> > >news:1130175944.976195.121260_at_g14g2000cwa.googlegroups.com...
> >Hi Mark and others,
> >
> >normally i do not respond to such fooliness in these kind of threads
> >but Marks remarks about the instrumentation is not incorrect it is also
> >misleading.
>
> The purpose of this thread was not to compare the merits and features of
> Oracle vs. DB2. The decision has already made that the Oracle shop will have
> to support at least one DB2 application. The issue is how much training is
> required for the Oracle DBA's to do this.
>

Agreed.

> Since the application is already completed it is reasonable to assume that
> it was tuned by the vendor who wrote it.

This is your first mistake in assessment. Vendors write applications and make them 'work', whether tuned or not. Many times I've been called upon to tune a vendor's application, something which should have been done by the vendor prior to release, but wasn't done. In one case the *vendor* asked for tuning suggestions, but this is a rare occurrence. At that same site another vendor's application was in dire need of tuning, and very little could be done because the poor code, the poorly designed database objects and a stubborn refusal of the vendor to allow any worthwhile changes prevented any real performance improvements. So, no, it is not reasonable to assume the application has been tuned by the vendor. Most likely quite the opposite is true.

> What you call "instrumentation" is
> therefore not really necessary in this case.

It most certainly is, in this case and any other involving a third-party product using a database.

> Since you claim that DB2 for
> LUW does not have instrumentation, I don't understand why it was even
> mentioned, since the Oracle DBA's clearly don't have to learn about
> something in DB2 that does not exist.

It was mentioned because YOU mentioned in one of your posts in this thread that such instrumentation DOES exist. So, a correction to your misinformation regarding instrumentation in DB2 was in order. And it's interesting that you now claim the DBAs have nothing to learn with regard to DB2 instrumentation, when before you claimed a robust set of tools that somehow vanished between your post quoted by Mr. Wedemeijer and Mr. Wedemeijer's response. As Mr, Wedemeijer stated:

"This typically shows that Mark does not now what he is talking about, ..."

After reading your posts in this newsgroup I would agree with this assessment.

David Fitzjarrell Received on Mon Oct 24 2005 - 15:02:43 CDT