IBM DB2 V8 User Manual

Page 30

Advertising
background image

XI Sample DB2 DSNZPARMS

DB2 V8
* = 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, (APAR PK21861)

CACHEPAC=1048576,
CATALOG=DNX1SYS,

*

CDSSREF=1,
CHGDC=NO,

* CONTSTOR=YES,

DECDIV3=NO,

DEFLTID=IBMUSER,
DESCSTAT=YES,
DLITOUT=0,

*

DSMAX=6000,

* EDMSTMTC=300000,

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,
* NPGTHRSH=10,

*

NUMLKTS=1000000,

*

NUMLKUS=500000(nonproduction),2097152(production)

* PADIX=NO, (OSS Note 793204)
* PARTKEYU=YES,

Copyright 2006

IBM Solutions Technical Sales (STS) 12/18/2007Page 30 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: