Thursday, March 21, 2019

Read dynamic statement cache full sql text IFCID 316 IFCID 317

This Rexx reads "dynamically" the dynamic statement cache with basic statistics on the  each SQL execution. It uses IFCID 316 and IFCID 317 (to get the full sql text )
With IFCID316 and IFCID 401 you have all executed statements at hand

Get the code here
https://github.com/ndt98/Db2z/blob/master/ifc316.rex


No comments:

Post a Comment