Solution : https://service.sap.com/sap/support/notes/113008 (SAP Service marketplace login required)
Key words :
high CPU utilization, deadlocks, RUNSTATS, access path, Optimizer, catalog statistics, hints
Related Notes :
| 765983 | DB2/zOS: Reducing number of DSNACCOR REORG recommendations |
| 711245 | DB2/390: Catalog modifications |
| 507824 | DB2/390 V7: Real Time Statistics and DSNACCOR |
| 496167 | IS-H: Poor performance during free time slot search in DB2 |
| 489690 | CC INFO: Copying large production clients |
| 208919 | CC-INFO: Performance as of Release 4.6 |
| 194761 | DB2/390: REORG,REBUILD Inline Statistics Collection |
| 192320 | DB2/390: Ensuring index access for volatile tables |
| 181286 | DB2/390: Excluding tablespaces from RUNSTATS |
| 162034 | DB2/390: Database hints in Open SQL |
| 159102 | DB2/390: upd after RNSTS upload case incrt |
| 132424 | DB2-z/OS: Optimizing access to the TRFC Tables |
| 129385 | Database hints in Open SQL |
| 127320 | DB2/390: RUNSTATS can invalidate cached statements |
| 126684 | DB2/390: Quicker version of the catalog update |
| 121245 | System settings for local currency changeover to euro |
| 119915 | DB2/390: Improved catalog update after Runstats |
| 117867 | DB2/390: DO NOT USE CATALOG UPDATES IN DB13!!!!! |
| 116698 | DB2/390: Optimizing Access to Tables VBHDR, VBMOD, VBDATA |
| 97461 | DB2/390: CCMS enhancements |
| 83335 | DB2/390: Deadlocks, bad performance on cluster tables |
| 82072 | DB2/390: Invalidating Cached Statements |
| 81737 | DB2-z/OS: APAR List |
| 67205 | CC-INFO: Copying large and productive clients |