@echo off

set DB1=CORPDB
set DB2=MFGDB
set DB3=SUPPDB
set DB4=ORDSDB
set DB5=UTILDB

db2 update dbm cfg using SHEAPTHRES         33761
db2 update dbm cfg using INTRA_PARALLEL     OFF
db2 update dbm cfg using MAX_QUERYDEGREE    1
db2 update dbm cfg using MAXAGENTS          2000
db2 update dbm cfg using DFT_MON_LOCK       OFF
db2 update dbm cfg using DFT_MON_STMT       OFF
db2 update dbm cfg using DFT_MON_TABLE      OFF
db2 update dbm cfg using DFT_MON_UOW        OFF
db2 update dbm cfg using DFT_MON_TIMESTAMP OFF
db2 update dbm cfg using notifylevel 0
db2 update dbm cfg using query_heap_sz 52428
db2 update dbm cfg using rqrioblk 65535
db2 update dbm cfg using aslheapsz 2000
db2 update dbm cfg using svcename 50002

REM ------------- DB CFGS -----------------------------

db2 connect to %DB1% user spec using spec
db2 update db cfg for %DB1% using dft_queryopt 0
db2 update db cfg for %DB1% using seqdetect NO
db2 update db cfg for %DB1% using CHNGPGS_THRESH  80
db2 update db cfg for %DB1% using DBHEAP          12800
db2 update db cfg for %DB1% using LOCKLIST        4006
db2 update db cfg for %DB1% using LOGBUFSZ        4096
db2 update db cfg for %DB1% using LOGFILSIZ       65535
db2 update db cfg for %DB1% using LOGPRIMARY      12
db2 update db cfg for %DB1% using LOGSECOND       0
db2 update db cfg for %DB1% using NEWLOGPATH      H:\SpecDB_XA_Logs\%DB1%
db2 update db cfg for %DB1% using MAXAPPLS        4000
db2 update db cfg for %DB1% using MAXLOCKS        100
db2 update db cfg for %DB1% using MINCOMMIT       1
db2 update db cfg for %DB1% using NUM_IOCLEANERS  1
db2 update db cfg for %DB1% using NUM_IOSERVERS   1
db2 update db cfg for %DB1% using SOFTMAX         1000
db2 update db cfg for %DB1% using DFT_DEGREE      1
db2 alter bufferpool ibmdefaultbp size 65535
db2 connect reset

 
db2 connect to %DB2% user spec using spec
db2 update db cfg for %DB2% using dft_queryopt 0
db2 update db cfg for %DB2% using seqdetect NO
db2 update db cfg for %DB2% using CHNGPGS_THRESH  80
db2 update db cfg for %DB2% using DBHEAP          12800
db2 update db cfg for %DB2% using LOCKLIST        4006
db2 update db cfg for %DB2% using LOGBUFSZ        4096
db2 update db cfg for %DB2% using LOGFILSIZ       65535
db2 update db cfg for %DB2% using LOGPRIMARY      12
db2 update db cfg for %DB2% using LOGSECOND       0
db2 update db cfg for %DB2% using NEWLOGPATH      H:\SpecDB_XA_Logs\%DB2%
db2 update db cfg for %DB2% using MAXAPPLS        4000
db2 update db cfg for %DB2% using MAXLOCKS        100
db2 update db cfg for %DB2% using MINCOMMIT       1
db2 update db cfg for %DB2% using NUM_IOCLEANERS  1
db2 update db cfg for %DB2% using NUM_IOSERVERS   1
db2 update db cfg for %DB2% using SOFTMAX         1000
db2 update db cfg for %DB2% using DFT_DEGREE      1
db2 alter bufferpool ibmdefaultbp size 131070
db2 alter table m_largeorder volatile
db2 connect reset


db2 connect to %DB3% user spec using spec
db2 update db cfg for %DB3% using dft_queryopt 0
db2 update db cfg for %DB3% using seqdetect NO
db2 update db cfg for %DB3% using CHNGPGS_THRESH  80
db2 update db cfg for %DB3% using DBHEAP          12800
db2 update db cfg for %DB3% using LOCKLIST        4006
db2 update db cfg for %DB3% using LOGBUFSZ        4096
db2 update db cfg for %DB3% using LOGFILSIZ       65535
db2 update db cfg for %DB3% using LOGPRIMARY      12
db2 update db cfg for %DB3% using LOGSECOND       0
db2 update db cfg for %DB3% using NEWLOGPATH      h:\SpecDB_XA_Logs\%DB3%
db2 update db cfg for %DB3% using MAXAPPLS        4000
db2 update db cfg for %DB3% using MAXLOCKS        100
db2 update db cfg for %DB3% using MINCOMMIT       1
db2 update db cfg for %DB3% using NUM_IOCLEANERS  1
db2 update db cfg for %DB3% using NUM_IOSERVERS   1
db2 update db cfg for %DB3% using SOFTMAX         1000
db2 update db cfg for %DB3% using DFT_DEGREE      1
db2 alter bufferpool ibmdefaultbp size 65535
db2 connect reset


db2 connect to %DB4% user spec using spec
db2 update db cfg for %DB4% using dft_queryopt 0
db2 update db cfg for %DB4% using seqdetect NO
db2 update db cfg for %DB4% using CHNGPGS_THRESH  80
db2 update db cfg for %DB4% using DBHEAP          12800
db2 update db cfg for %DB4% using LOCKLIST        4006
db2 update db cfg for %DB4% using LOGBUFSZ        4096
db2 update db cfg for %DB4% using LOGFILSIZ       65535
db2 update db cfg for %DB4% using LOGPRIMARY      12
db2 update db cfg for %DB4% using LOGSECOND       0
db2 update db cfg for %DB4% using NEWLOGPATH      h:\SpecDB_XA_Logs\%DB4%
db2 update db cfg for %DB4% using MAXAPPLS        4000
db2 update db cfg for %DB4% using MAXLOCKS        100
db2 update db cfg for %DB4% using MINCOMMIT       1
db2 update db cfg for %DB4% using NUM_IOCLEANERS  1
db2 update db cfg for %DB4% using NUM_IOSERVERS   1
db2 update db cfg for %DB4% using SOFTMAX         1000
db2 update db cfg for %DB4% using DFT_DEGREE      1
db2 alter bufferpool ibmdefaultbp size 65535
db2 connect reset


db2 connect to %DB5% user spec using spec
db2 update db cfg for %DB5% using dft_queryopt 0
db2 update db cfg for %DB5% using seqdetect NO
db2 update db cfg for %DB5% using CHNGPGS_THRESH  80
db2 update db cfg for %DB5% using DBHEAP          12800
db2 update db cfg for %DB5% using LOCKLIST        4006
db2 update db cfg for %DB5% using LOGBUFSZ        4096
db2 update db cfg for %DB5% using LOGFILSIZ       65535
db2 update db cfg for %DB5% using LOGPRIMARY      12
db2 update db cfg for %DB5% using LOGSECOND       0
db2 update db cfg for %DB5% using NEWLOGPATH      h:\SpecDB_XA_Logs\%DB5%
db2 update db cfg for %DB5% using MAXAPPLS        4000
db2 update db cfg for %DB5% using MAXLOCKS        100
db2 update db cfg for %DB5% using MINCOMMIT       1
db2 update db cfg for %DB5% using NUM_IOCLEANERS  1
db2 update db cfg for %DB5% using NUM_IOSERVERS   1
db2 update db cfg for %DB5% using SOFTMAX         1000
db2 update db cfg for %DB5% using DFT_DEGREE      1
db2 alter bufferpool ibmdefaultbp size 65535
db2 connect reset

