Solution : https://service.sap.com/sap/support/notes/113008 (SAP Service marketplace login required)
Key words :
sap business warehouse additional catalog statistics, db2 optimizer access path selection process, symptom long running transactions due, cluster tables access path considerations, qrfc tables access path considerations, access path selection process, terms high cpu utilization, alert monitor identifies tables, influence access path selection, db2 system parameter npgthrsh
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 |