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