Über das DB2 Installation CLIST Input Member DSNTIDXB können spezielle, auf den Betrieb für SAP abgestimmte Konfigurationseinstellungen geladen werden.

SAP hat für bestimmte Einstellungen folgende Empfehlungen ausgesprochen:

DSNTIDXB         Previous   New        Description
entry name       setting    setting    of entry
---------------- ---------  --------   ------------------------
ACCUMACC         5          NO         Rollup accounting for
                                       DDF/RRSAF
BP1_VPSEQT       99         90         VPSEQT size for BP1
BP3              120000     200000     VPSIZE for BP3
BP32K3           15000      25000      VPSIZE for BP32K3
BP32K3_VPSEQT    99         90         VPSEQT size for BP32K3
BP40             4000       5000       VPSIZE for BP40
BP8K1            25000      50000      VPSIZE for BP8K1
BP8K8            1000       20000      VPSIZE for BP8K8
BUFMAX00         2000       5000       VPSIZE for BP0
BUFMAX01         15000      25000      VPSIZE for BP1
BUFMAX02         82000      150000     VPSIZE for BP2
INLISTP          50         101        Max number of elements
                                       in an IN-list for
                                       certain IN predicate
                                       optimizations
                                       to occur
LIKE_BLANK_      NO         YES        LIKE ignores
 INSIGNIFICANT                         trailing blanks
MAX_CONCURRENT_  10         20         Max number of
 PKG_OPS                               package requests
                                       that can be
                                       processed
                                       simultaneously
MAXKEEPD         12000      15000      Max number of
                                       prepared dynamic
                                       statements saved
                                       past commit points
                                       or rollbacks
OVRIDPL          100000     400000     RID pool size
OVSRTPL          64000      96000      Sort pool size
PAGESET_PAGENUM  ABSOLUTE   RELATIVE   For created
                                       range-partitioned
                                       table spaces
PCTFREE_UPD      0          AUTO       Percent of space per
                                       page reserved for
                                       update
RENAMETABLE      DISALLOW_  ALLOW_     Allow or disallow
                 DEP_       DEP_       renaming of tables
                 VIEW_      VIEW_      referenced in a
                 SQLTUDF    SQLTUDF    view or SQL table
                                       function definition
SMFCOMP          OFF        ON         Compress trace records
                                       written to SMF
TSQTY            144        288        Default space
                                       allocation in KB
                                       for table spaces
URLGWTH          100        500        Log writes to
                                       enable UR chec

Anmerkungen:

• VPSEQT = Sequential steal threshold for the buffer pool
• VPSIZE = Number of buffers allocated to the buffer pool

Für mehr Details, siehe SAP Note 2239553.