very interesting - why two equal calls is different?

bughunter

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

Apr 27 '06 #1

Kiran Nair

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.

Apr 27 '06 #2

Serge Rielau

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

Apr 27 '06 #3