IBM DB2 9 DB2 = required/recommended value for SAP, DSN6ENV MVS=XA DSN6SPRM RESTART ALL ABEXP=YES

Models: DB2 V8 DB2 9

1 51
Download 51 pages 32.56 Kb
Page 34
Image 34

DB2 9

* = required/recommended value for SAP

DSN6ENV MVS=XA

DSN6SPRM RESTART,

ALL,

ABEXP=YES,

ABIND=YES,

AUTH=YES,

AUTHCACH=4096,

BINDNV=BINDADD,

BMPTOUT=0,

*CACHEDYN=YES,

*CACHEDYN_FREELOCAL=1, CACHEPAC=1048576,

CATALOG=DNX1SYS, * CDSSREF=1,

CHGDC=NO,

* CONTSTOR=YES, DECDIV3=NO,

DEFLTID=IBMUSER,

DESCSTAT=YES,

DLITOUT=0,

* DSMAX=20000,

* EDMDBDC=value presented by DB2 install CLIST, min 150MB

*EDMSTMTC=300000,

*EDMPOOL = value presented by DB2 install CLIST, min 64MB EDPROP=NO,

EXTSEC=NO,

* EVALUNC=YES, HOPAUTH=YES, IRLMAUT=YES, IRLMPRC=<SID>IRLM, IRLMSID=INX1,

* IRLMRWT=600,

*IRLMSWT=300, * LRDRTHLD=10,

* MAXRBLK=100000,

*MAXKEEPD=8000, * MINSTOR=YES,

*MXDTCACH=128, * NPGTHRSH=10,

* NUMLKTS=1000000,

*NUMLKUS=500000(nonproduction),2097152(production) * PADIX=NO, (OSS Note 793204)

* PARAMDEG=number of CPUs,

Copyright 2006 IBM Solutions Technical Sales (STS)

12/18/2007Page 34 of 51

12/18/2007

 

Page 34
Image 34
IBM DB2 9, DB2 V8 manual DB2 = required/recommended value for SAP, DSN6ENV MVS=XA DSN6SPRM RESTART ALL ABEXP=YES