SAP Note 82072 - DB2/390: Invalidating Cached Statements

Composant : DB2 for z/OS -

Solution : https://service.sap.com/sap/support/notes/82072 (Connexion à SAP Service Marketplace requise)

Mots Clés :
db2 ptf uq23145 installed, runstats utility automatically invalidates, additional key words runstats, manual catalog statistics update, sql statement continues, optimal access path, db2 runstats utility, relevant catalog tables, newly created index, affected cached statements

Notes associées :

132424DB2-z/OS: Optimizing access to the TRFC Tables
127320DB2/390: RUNSTATS can invalidate cached statements
116698DB2/390: Optimizing Access to Tables VBHDR, VBMOD, VBDATA
113008DB2/390: Maintaining Catalog Statistics
83335DB2/390: Deadlocks, bad performance on cluster tables