SAP Note 1476146 - DB2-z/OS:CCMS: Installation Parameter Settings for DB2 10

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

Solution : https://service.sap.com/sap/support/notes/1476146 (Connexion à SAP Service Marketplace requise)

Mots Clés :
[highly_recommended]> lob_inline_length        = 2000            [highly_recommended]> edmpool                  >= 64000          [recommended]> edmstmtc                >= 300000         [recommended]> maxkeepd                >= 12000          [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, > asccsid                  = 819             [required]> cthread                  >= 200            [required]> decimal                  = period          [required]> idback                  >= 50             [required]> maxdbat                  >= 1000           [required]> idthtoin                = 0               [required]> cmtstat                  = inactive        [required]> dsnseq_implicitdb        = 10000           [highly_recommended]> numlkus                  >= 2097152        [highly_recommended]> numlkts                  = 1000000         [highly_recommended]> irlmrwt                  = 600             [highly_recommended]> evalunc                  =, [highly_recommended]> tbsbpool                = bp2             [highly_recommended]> idxbpool                = bp3             [highly_recommended]> tbsbp8k                  = bp8k1           [highly_recommended]> tbsbp16k                = bp16k1          [highly_recommended]> tbsbp32k                = bp32k1          [highly_recommended]> tbsbplob                = bp40            [highly_recommended]> tsqty                    = 144             [highly_recommended]> ixqty                    = 144             [highly_recommended]> mgextsz                  =, 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]> max_opt_cpu              = 2               [highly_recommended]> mxqbce                  = 1023            [highly_recommended]> mxdtcach                = 256             [highly_recommended]> edmdbdc                  >= 150000         [highly_recommended]> impdsdef                =, [recommended]> pcloset                  = 25              [recommended]> pclosen                  = 15              [recommended]> mlmt                    >= 4              [recommended]> ddf                      = auto            [recommended]> accumacc                = 5               [recommended]> accumuid                = 11              [recommended]> lrdrthld                = 10              [recommended]> system_level_backups    =, [recommended]> paramdeg                = 4               [recommended]> check_fastreplication    = required        [recommended]> rec_fastreplication      = preferred       [recommended]> flashcopy_pprc          = required        [recommended]> en_pjsj                  =, /os ccms installation parameters parameter check zparm zparms recommendation recommendations reason, [highly_recommended]> rrf                      = disable         [highly_recommended]> impdssize                = 64              [highly_recommended]> imptkmod                =, 3           [recommended]> syncval                  = 30              [recommended]> seqcach                  = seq             [recommended]> lbackout                =, setting npgthrsh=10 ensures good access paths

Notes associées :

1492381DB2-z/OS:v10: Inline lob length
1474640DB2-z/OS:CCMS: Installation Parameter Settings for DB2 V8
1473986DB2-z/OS:CCMS: Installation Parameter Settings for DB2 9
1452370DB2-z/OS:v10: Release of DB2 10 for SAP Components
145316DB2-z/OS: Preparations for SAP Support Services