Problem: A stored procedure takes about 1 to 2 minutes for the first invocation (No difference in this timing for green screen or i-series navigator or Java call through QZDASOINIT jobs). Subsequent invocations are wicked fast with subsecond response times
Other info: Procedure takes 1 input parameter and results a return set by opening a cursor.
Please let me know if this is because of plan or access paths being built every time for a new job? If yes, how can this be moved to the DB2 side so that the access path is shared across the jobs?
September 10, 2005 10:42 AM
September 12, 2005 8:14 AM