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 |
| 1473986 | DB2-z/OS:CCMS: Installation Parameter Settings for DB2 9 |
| 145316 | DB2-z/OS: Preparations for SAP Support Services |