SAP Note 1474640 - DB2-z/OS:CCMS: Installation Parameter Settings for DB2 V8

Component : DB2 for z/OS - CCM/Database monitors -

Solution : https://service.sap.com/sap/support/notes/1474640 (SAP Service marketplace login required)

Key words :
[highly_recommended]> edmstmtc                = 300000          [recommended]> maxkeepd                <= 8000           [recommended]> srtpool                >= 64000          [recommended]> maxrblk                >= 100000         [recommended]> chkfreq                = 2               [recommended]> dsmax                  = 20000           [recommended]> retlwait                = 1               [recommended]> utimout                = 3               [recommended]> urchkth                = 1               [recommended]> urlgwth                = 100             [recommended]> xlkupdlt                = target          [recommended]> smfacct                = 1, 1             [highly_recommended]> monsize                = 500000          [highly_recommended]> npgthrsh                = 10              [highly_recommended]> lobvala                = 1000000         [highly_recommended]> lobvals                = 50000           [highly_recommended]> starjoin                = 2               [highly_recommended]> sjtables                = 4               [highly_recommended]> tables_joined_threshold = 10              [highly_recommended]> max_opt_cpu            = 2               [highly_recommended]> max_opt_elap            = 4               [highly_recommended]> mxqbce                  = 1023            [highly_recommended]> sjmissky                =, > asccsid                = 819             [required]> decimal                = period          [required]> idback                  >= 20             [required]> maxdbat                >= 100            [required]> idthtoin                = 0               [required]> cmtstat                = inactive        [required]> numlkus                >= 2097152        [highly_recommended]> numlkts                = 1000000         [highly_recommended]> irlmrwt                = 600             [highly_recommended]> evalunc                =, [highly_recommended]> sjmxpool                = 128             [highly_recommended]> mxdtcach                = 256             [highly_recommended]> edmpool                >= 64000          [highly_recommended]> edmdbdc                >= 150000         [highly_recommended]> tbsbplob                = bp40            [highly_recommended]> tsqty                  = 144             [highly_recommended]> ixqty                  = 144             [highly_recommended]> mgextsz                =, [recommended]> pcloset                = 25              [recommended]> pclosen                = 15              [recommended]> mlmt                    = 4               [recommended]> ddf                    = auto            [recommended]> accumacc                = 5               [recommended]> accumuid                = 0               [recommended]> lrdrthld                = 10              [recommended]> statroll                =, /os ccms installation parameters parameter check zparm zparms recommendation recommendations reason, 3           [recommended]> syncval                = 30              [recommended]> seqcach                = sequential      [recommended]> lbackout                =, sap systems require specific db2 system parameter settings, setting npgthrsh=10 ensures good access paths, [recommended]> cachedyn_freelocal      = 1               [recommended]> optccos4                =

Related Notes :

1476146 DB2-z/OS:CCMS: Installation Parameter Settings for DB2 10
1473986DB2-z/OS:CCMS: Installation Parameter Settings for DB2 9
145316DB2-z/OS: Preparations for SAP Support Services