I look into snapshot (dynsnap) and see 2 different sql (diff in space
between name and bracket)
CALL schema.spname(?,?,?,?,?,?,?,?) ( NUM_EXECUTIONS 7759 )
CALL schema.spname (?,?,?,?,?,?,?,?) ( NUM_EXECUTIONS 12424 )
We have only one procedure with schema.spname (with only one kind of
parameters).
Andy 2 1089
The diffrence may not be because of the space between the parameter
markers ..May be the data in the database would have changed which
resulted in some code paths executed more times ..hence diffent number
of executions.
bughunter@ru wrote: I look into snapshot (dynsnap) and see 2 different sql (diff in space between name and bracket)
CALL schema.spname(?,?,?,?,?,?,?,?) ( NUM_EXECUTIONS 7759 )
CALL schema.spname (?,?,?,?,?,?,?,?) ( NUM_EXECUTIONS 12424 )
Hashing in the cache is done on the string. So number of paces is relevant.
I assume you call the procedure from at least two different places. One
of which is formatted different.
Cheers
Serge
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Steven O. |
last post by:
I am seeking some kind of tool that I can use for GUI prototyping. I
know how to use Visual Basic, but since a lot of software is being
coded in Java or C++, I'd like to learn a Java or C++ -based...
|
by: Frag |
last post by:
Hi guys,
I searched around without any clear answer. Tons of stuff, but nothing concrete.
I am trying to call this Javascript function:
function ButtonClicked()
{
alert("The button has...
|
by: Janross |
last post by:
I'm having trouble with a query that's prohibitively slow. On my free-standing
office computer it's fine (well, 2-4 seconds), but on the client's network, it
takes at least 5 minutes to run. ...
|
by: Piper707 |
last post by:
Hi,
I need to know how I can check to see if a particular node is NOT equal
to a SET of values.
i.e. a valid form of : <xsl:template match!="H" && match!="Y"&&
match!="Z">
I have an XML...
|
by: Claude Yih |
last post by:
Hi, everyone. I noticed an interesting thing about fread() this
afternoon. Well, I can't see why so I post this message in the hope of
getting some explanation. Please help me.
I wrote the...
| |
by: Frederick Gotham |
last post by:
I thought it might be interesting to share experiences of tracking down a
subtle or mysterious bug. I myself haven't much experience with tracking
down bugs, but there's one in particular which...
|
by: nufuhsus |
last post by:
Hello all,
First let me appologise if this has been answered but I could not find
an acurate answer to this interesting problem.
If the following is true:
C:\Python25\rg.py>python
Python...
|
by: robert |
last post by:
I'm very pleased to announce that Foundations of F#, the first book to
be published on the F# programming, will finish its first printing
run, tomorrow, Friday 25th May. It should reach any...
|
by: jacob navia |
last post by:
Buffer overflows are a fact of life, and, more specifically, a fact of
C.
All is not lost however. In the book
"Value Range Analysis of C programs" Axel Simon tries to establish a...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
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...
| |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
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...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
|
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: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| |
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...
| |