SAP Note 132424 - DB2-z/OS: Optimizing access to the TRFC Tables

Composant : DB2 for z/OS -

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

Mots Clés :
multi-table tablespaces isolate, dedicated single-table tablespaces, db2 v7 reason, db2 optimizer chooses, optimal access path, older db2 releases, avoid regularly repeating, systables      set cardf=-1, systabstats      set card=-1, sysindexes       set clusterratio=100

Notes associées :

765983DB2/zOS: Reducing number of DSNACCOR REORG recommendations
712019
711245DB2/390: Catalog modifications
507824DB2/390 V7: Real Time Statistics and DSNACCOR
330059
192320DB2/390: Ensuring index access for volatile tables
181286DB2/390: Excluding tablespaces from RUNSTATS
116698DB2/390: Optimizing Access to Tables VBHDR, VBMOD, VBDATA
113008DB2/390: Maintaining Catalog Statistics
82072DB2/390: Invalidating Cached Statements