Solution : https://service.sap.com/sap/support/notes/1473986 (SAP Service marketplace login required)
Key words :
[highly_recommended]> rrf = disable [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, > asccsid = 819 [required]> decimal = period [required]> idback >= 20 [required]> maxdbat >= 100 [required]> idthtoin = 0 [required]> prgstrin = disable [required]> dsnseq_implicitdb = 10000 [required]> cmtstat = inactive [required]> numlkus >= 2097152 [highly_recommended]> numlkts = 1000000 [highly_recommended]> irlmrwt = 600 [highly_recommended]> evalunc =, 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]> edmpool >= 64000 [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 =, [highly_recommended]> tbsbpool = bp2 [highly_recommended]> idxbpool = bp3 [highly_recommended]> tbsbplob = bp40 [highly_recommended]> tsqty = 144 [highly_recommended]> ixqty = 144 [highly_recommended]> mgextsz =, /os ccms installation parameters parameter check zparm zparms recommendation recommendations reason, [recommended]> cachedyn_freelocal = 1 [recommended]> check_fastreplication = required [recommended]> optixopref =, 3 [recommended]> syncval = 30 [recommended]> seqcach = sequential [recommended]> lbackout =, [recommended]> statclus = enhanced [recommended]> opthybcst =, setting npgthrsh=10 ensures good access paths
Related Notes :
| 1476146 | DB2-z/OS:CCMS: Installation Parameter Settings for DB2 10 |
| 1474640 | DB2-z/OS:CCMS: Installation Parameter Settings for DB2 V8 |
| 145316 | DB2-z/OS: Preparations for SAP Support Services |