SAP Note 82953 - DB2/390: Tables Isolation and Buffer Pools Tuning

Component : DB2 for z/OS -

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 :

1312704DB2-z/OS: Handling of VBDATA (with DB2 v9.1)
141925DB2/390: buffer pool optim.+access to syst.catalog
122599DB2/390: Performance of the update
121245System settings for local currency changeover to euro
116698DB2/390: Optimizing Access to Tables VBHDR, VBMOD, VBDATA