Solution : https://service.sap.com/sap/support/notes/82953 (SAP Service marketplace login required)
Key words :
indexes 6000 40 30 5 12000 40 yesbp4 c8 tables & indexes 1000 10 70 50 0bp5 c7 tables & indexes 1000 30 10 5 0bp6 c6 tables & indexes 7000 30 40 10 0bp7 c5 tables & indexes 8000 30 40 10 0bp8 c4 tables & indexes 7000 30 20 5 14000 30 yesbp9 c3 tables & indexes 8000 30 20 5 16000 30 nobp10 c2 tables & indexes 5000 60 50 10 0bp11 c1 tables & indexes 4000 60 20 5 8000 60 yesbp32k, bp category vpsize vpseqt dwqt vdwqt hpsize hpseqt cast------- ------------------ --------------------------------------------bp0 catalog 2000 50 50 10 0bp1 4k-page work files 5000 100 70 50 0bp2, engines data manager critical threshold sort merge passes degraded work file prefetch disabled, 32k tables 400 40 30 50 800 40 yesbp32k1 32k-page work files 100 100 70 50 0bp32k2 c2, -categorized 32k-page tablesbp32k1 32k-page work filesbp32k2 category c2, symptom low buffer pools hit ratio additional key words buffer pools, bp objects------- ---------------------------------------------------------------bp0 catalogbp1 4k-page work filesbp2, -categorized 4k-page tablesbp3 indexes, c5-c8 32k tables 900 40 40 10 0bp32k3 c1, /total getpageswhere total pages read = total synchronous reads + pages read
Related Notes :
| 1312704 | DB2-z/OS: Handling of VBDATA (with DB2 v9.1) |
| 141925 | DB2/390: buffer pool optim.+access to syst.catalog |
| 122599 | DB2/390: Performance of the update |
| 121245 | System settings for local currency changeover to euro |
| 116698 | DB2/390: Optimizing Access to Tables VBHDR, VBMOD, VBDATA |