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