By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,610 Members | 2,332 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,610 IT Pros & Developers. It's quick & easy.

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

P: n/a
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?

Apr 19 '06 #1
Share this Question
Share on Google+
9 Replies


P: n/a
mike wrote:
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
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab
Apr 19 '06 #2

P: n/a
Enjoy!
ftp://ftp.software.ibm.com/ps/produc...b2perf-1.0.zip

--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab
Apr 19 '06 #3

P: n/a
In article <4a************@individual.net>, sr*****@ca.ibm.com says...
Enjoy!
ftp://ftp.software.ibm.com/ps/produc...b2perf-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)
Apr 19 '06 #4

P: n/a
In article <MP************************@news.xs4all.nl>,
no****@nl.invalid says...
In article <4a************@individual.net>, sr*****@ca.ibm.com says...
Enjoy!
ftp://ftp.software.ibm.com/ps/produc...b2perf-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.
Apr 19 '06 #5

P: n/a
Gert van der Kooij wrote:
In article <MP************************@news.xs4all.nl>,
no****@nl.invalid says...
In article <4a************@individual.net>, sr*****@ca.ibm.com says...
Enjoy!
ftp://ftp.software.ibm.com/ps/produc...b2perf-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.

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
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab
Apr 20 '06 #6

P: n/a
In article <4a************@individual.net>, sr*****@ca.ibm.com says...
Gert van der Kooij wrote:
In article <MP************************@news.xs4all.nl>,
no****@nl.invalid says...
In article <4a************@individual.net>, sr*****@ca.ibm.com says...
Enjoy!
ftp://ftp.software.ibm.com/ps/produc...b2perf-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.

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?


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.
Apr 20 '06 #7

P: n/a
In article <MP************************@news.xs4all.nl>,
no****@nl.invalid says...
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?


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 ?
Apr 21 '06 #8

P: n/a
Gert van der Kooij wrote:
In article <MP************************@news.xs4all.nl>,
no****@nl.invalid says...
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?


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 ?


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.

--

Apr 22 '06 #9

P: n/a
In article <44***********************@ptn-nntp-reader03.plus.net>,
da**@waveform.plus.com says...

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


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.
Apr 22 '06 #10

This discussion thread is closed

Replies have been disabled for this discussion.