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

very interesting - why two equal calls is different?

P: n/a
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
Share this Question
Share on Google+
2 Replies


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

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