IBM DB2 9, DB2 V8 manual Sample DB2 DSNZPARMS, DB2 = required/recommended value for SAP

Models: DB2 V8 DB2 9

1 51
Download 51 pages 32.56 Kb
Page 30
Image 30

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

 

Page 30
Image 30
IBM DB2 9, DB2 V8 manual Sample DB2 DSNZPARMS, DB2 = required/recommended value for SAP