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

Composant : DB2 for z/OS -

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

Mots Clés :
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

Notes associées :

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