SAP Note 192320 - DB2/390: Ensuring index access for volatile tables

Component : DB2 for z/OS -

Solution : https://service.sap.com/sap/support/notes/192320 (SAP Service marketplace login required)

Key words :
db2 v6 apar pq33429 introduced, symptom long running statements, long running tablespace scans, perform corrective catalog updates, prerequisites db2 optimizer, manual catalog updates, catalog updates step, real table size, special purpose tables, terms access path

Related Notes :

132424DB2-z/OS: Optimizing access to the TRFC Tables
116698DB2/390: Optimizing Access to Tables VBHDR, VBMOD, VBDATA
113008DB2/390: Maintaining Catalog Statistics