Db2 9 * = required/recommended value for sap – IBM DB2 V8 User Manual

Page 34

Advertising
background image

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
Planning and Preparation Guide for SAP NetWeaver Version 6.40: z/OS Implementation

Advertising
This manual is related to the following products: