473,406 Members | 2,377 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,406 software developers and data experts.

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

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
9 1608
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
Enjoy!
ftp://ftp.software.ibm.com/ps/produc...b2perf-1.0.zip

--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab
Apr 19 '06 #3
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
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
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
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
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
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
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

19
by: Blair Adamache | last post by:
IBM is hosting a user focus session to get feedback on a new design concept for installing software products and maintenance. The information below gives a brief summary of the information about...
2
by: naufal | last post by:
Hi guys, I had many troubles of finding a company who provides Remote Database Administration. I reviewed quite a lot of services and finally got to know about a company who has done some work...
4
by: Civilian_Target | last post by:
Is there any way in DB2 to automate the taking of a snapshot, for example, a function that will cause a db2 snapshot to be taken every 5 minutes and written to a uniquely named file? Am I better...
8
by: Mark Rowland | last post by:
Please bear with me, as I am a newbie in the world of databases and DB2. We are trying to migrate an application that binds to a DB2 database (Workgroup Edition, V6.1) from a server running Windows...
7
by: scottgamble | last post by:
My company is making the switch to DB2 from Oracle. I have been working with Oracle for the last 10 years or so and still very very new to DB2. One question that has come up recently within our...
3
by: aj | last post by:
DB2 LUW 8.2 FP14 Red Hat AS 2.1 I am using a response file w/ db2setup to install DB2. I then want to install the latest fixpak in the same automated way. Is there any way to use a response...
0
by: nttest | last post by:
I am new to DB2 coming from SQL server background. Trying to setup maintenace plan for the DB2 database for a IBM datawarehouse. What is the best way to implement REORG? How frequently should...
1
by: Siebbel | last post by:
Hello, I posted this problem already in the linux section but without positive result. Perhaps someone here has experienced the smae problem. I am pretty new with writing shell scripts and...
0
by: bhd282 | last post by:
am unable to find out how to locate and update some of the configuration parameters for automated backup, ie, outside of the Control Center's Automation Maintenance Wizard. I am able to...
0
by: Mikelowe | last post by:
Would like to know is there an automated way to copy the maxvalue of sequence number from db2 production to db2 test. When we copy data from our production that uses a sequence number value as its...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.