467,202 Members | 1,018 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,202 developers. It's quick & easy.

very interesting - why two equal calls is different?

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
  • viewed: 1005
Share:
2 Replies
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
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

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

7 posts views Thread by Piper707@hotmail.com | last post: by
6 posts views Thread by Claude Yih | last post: by
27 posts views Thread by Frederick Gotham | last post: by
40 posts views Thread by nufuhsus@gmail.com | last post: by
52 posts views Thread by robert@strangelights.com | last post: by
126 posts views Thread by jacob navia | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.