Solution : https://service.sap.com/sap/support/notes/1476146 (SAP Service marketplace login required)
Key words :
[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
Related Notes :
| 1492381 | DB2-z/OS:v10: Inline lob length |
| 1474640 | DB2-z/OS:CCMS: Installation Parameter Settings for DB2 V8 |
| 1473986 | DB2-z/OS:CCMS: Installation Parameter Settings for DB2 9 |
| 1452370 | DB2-z/OS:v10: Release of DB2 10 for SAP Components |
| 145316 | DB2-z/OS: Preparations for SAP Support Services |