automated-access-plan comparisons on LUW (db2 v8.2.2)

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

mike - 19 Apr 2006 10:36 GMT

Hi all,

What do you people do (if anything) to help with
automated access-plan checking of static-SQL
on DB2 LUW v8.2.2 ?

Sometimes after we rebind, DB2 will choose a
"bad" plan in certain circumstances. We have
thousands of stored procedures with static-sql
and it would be nice to have some automatic
way to comparing plans. Usually we find and fix the
"bad" plan after manual comparison of db2exfmt output - but clearly
we want to avoid the manual step.

I know that tools exist for this purpose on the
DB2 Z/OS platform, but are there any tools for LUW ?
If so, have you used them and what are your opinions?

Reply to this Message

Serge Rielau - 19 Apr 2006 16:12 GMT

> Hi all,
>
> What do you people do (if anything) to help with
> automated access-plan checking of static-SQL
> on DB2 LUW v8.2.2 ?

...
Good timing. We are in process of uploading some good stuff.
Stay tuned.

Cheers
Serge

Signature

Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

Reply to this Message

Serge Rielau - 19 Apr 2006 22:34 GMT

Enjoy!
ftp://ftp.software.ibm.com/ps/products/db2/tools/db2perf-1.0.zip

Signature

Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

Reply to this Message

Gert van der Kooij - 19 Apr 2006 23:20 GMT

> Enjoy!
> ftp://ftp.software.ibm.com/ps/products/db2/tools/db2perf-1.0.zip

I really like to use these tools, but I don't have a C compiler on my
system. Wich compiler needs to be used to compile those program?
(I hope it's a free one)

Reply to this Message

Gert van der Kooij - 19 Apr 2006 23:51 GMT

> > Enjoy!
> > ftp://ftp.software.ibm.com/ps/products/db2/tools/db2perf-1.0.zip
>
> I really like to use these tools, but I don't have a C compiler on my
> system. Wich compiler needs to be used to compile those program?
> (I hope it's a free one)

I forgot to say I'm running DB2 Express-C on Windows 2000.

Reply to this Message

Serge Rielau - 20 Apr 2006 01:24 GMT

>>> Enjoy!
>>> ftp://ftp.software.ibm.com/ps/products/db2/tools/db2perf-1.0.zip
[quoted text clipped - 4 lines]
>
> I forgot to say I'm running DB2 Express-C on Windows 2000.

gcc will work fine (even though its' officially not supported).
If you send Steve a nice note maybe he'll upload the binaries for some
common platforms.
Isn't the base MS C compiler on Windows free as well?

Cheers
Serge

Signature

Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

Reply to this Message

Gert van der Kooij - 20 Apr 2006 01:31 GMT

> >>> Enjoy!
> >>> ftp://ftp.software.ibm.com/ps/products/db2/tools/db2perf-1.0.zip
[quoted text clipped - 8 lines]
> common platforms.
> Isn't the base MS C compiler on Windows free as well?

Yes, I've downloaded the free C++ Toolkit and the Platform SDK is being
downloaded/installed right know. I will try to get it compiled.

Reply to this Message

Gert van der Kooij - 21 Apr 2006 21:01 GMT

> > gcc will work fine (even though its' officially not supported).
> > If you send Steve a nice note maybe he'll upload the binaries for some
[quoted text clipped - 3 lines]
> Yes, I've downloaded the free C++ Toolkit and the Platform SDK is being
> downloaded/installed right know. I will try to get it compiled.

I downloaded a lot yesterday but the bldrtn needs msvcrt.lib which still
isn't in the packages I downloaded even though it should be there
according to the search results. The only thing left to try is the
Visual Studio Express but it doesn't fit on disk, it needs to much
space.
How about gcc, does it also need msvcrt.lib ?

Reply to this Message

Dave Hughes - 22 Apr 2006 02:38 GMT

> > > gcc will work fine (even though its' officially not supported).
> > > If you send Steve a nice note maybe he'll upload the binaries for
[quoted text clipped - 11 lines]
> much space.
> How about gcc, does it also need msvcrt.lib ?

I thought msvcrt.lib would be included in the Platform SDK, but
apparently not (checked my installation and it ain't there). Found this
after a little googling (http://wiki.tcl.tk/11431):

"Missing msvcrt.lib - this is the link library for the C runtime used
by Tcl and most extensions. You can in theory create a link library
from a .dll using link -dump -exports dllname and some processing, but
I have been unable to make this work. Instead you can install the .NET
Framework SDK (free download) and get a copy of msvcrt.lib from this
[http://tinyurl.com/5flob]. (It ends up in "Microsoft Visual Studio
.NET 2003\Vc7\lib")"

As for gcc, I seem to recall that depends on which gcc for Windows
you're using. IIRC, the MinGW gcc, or the Cygwin gcc running in
-mno-cygwin mode can (must?) link against msvcrt.lib, while the Cygwin
gcc running in normal mode (i.e. without -mno-cygwin) must *not* link
against msvcrt.lib (as it'll interfere with Cygwin's libc). However, in
the latter case, any binary produced will depend on cygwin1.dll (i.e.
will depend on the Cygwin environment).

HTH,

Dave.

Reply to this Message

Gert van der Kooij - 22 Apr 2006 09:56 GMT

> I thought msvcrt.lib would be included in the Platform SDK, but
> apparently not (checked my installation and it ain't there). Found this
[quoted text clipped - 7 lines]
> [http://tinyurl.com/5flob]. (It ends up in "Microsoft Visual Studio
> .NET 2003\Vc7\lib")"

I must have been trying for too long, apparently it was too late in the
night when I was searching and trying (3.00 AM).
After installing the .NET framework the msvcrt.lib was in the mentioned
directory, I just didn't find it.

Reply to this Message