Are Native Nested Stored Procedure Statistics Rolled Up?

Document ID : KB000096794
Last Modified Date : 04/06/2018
Show Technical Document Details
Introduction:
This article states whether or not statistics for Native Nested Stored Procedure Statistics are rolled up.
Question:
Are Native Nested Stored Procedure Statistics Rolled Up?
Environment:
z/OS 1.11 and above.
 
Answer:
The native stored procedure getpage counts do not appear to be rolled up because they’re calculated as the getpage count change in a DB2 control block that is not shared between the DB2 thread executing the native stored procedure and the DB2 thread calling the native stored procedure. Metrics that are calculated from DB2 control blocks that are shared between the DB2 thread executing the native stored procedure and the DB2 thread calling the native stored procedure will appear to be rolled up.

Native stored procedure INDB2_CPU, ZIIP_CPU, and INDB2_TIME will always appear to be rolled up but native stored procedure GETPAGE will never appear to be rolled up.