create db my_db_name
on D:
using codeset 1252 territory SE
catalog tablespace managed by system using ('D:\SMS\my_db_name\TSCAT') extentsize 32 prefetchsize 64
temporary tablespace managed by system using ('D:\SMS\my_db_name\TSTEMP') extentsize 32 prefetchsize 64
with 'my_db_name';



--
--These are recommended commands, should be run using a DB2 Command Window
--   Be sure to run an offline backup afterwards, and adjust the bufferppols according to your desires
--
db2set DB2_RR_TO_RS=YES -g

db2 update dbm cfg using sheapthres 304128
db2 update dbm cfg using numdb 1
db2 update dbm cfg using keepdari NO
db2 update dbm cfg using mon_heap_sz 4096
db2 update dbm cfg using agent_stack_sz 64
db2 update dbm cfg using dftdbpath D:
db2 update dbm cfg using maxagents 100
db2 update dbm cfg using num_poolagents 32
db2 update dbm cfg using num_initagents 32
--db2 update dbm cfg using intra_parallel YES           --only if using several processors
db2 update dbm cfg using fcm_num_rqb 1024

db2 update db cfg for my_db_name using dft_extent_sz 32
db2 update db cfg for my_db_name using dft_PREFETCH_sz 64
db2 update db cfg for my_db_name using maxfilop 100
db2 update db cfg for my_db_name using dft_degree ANY
db2 update db cfg for my_db_name using dbheap 60000
db2 update db cfg for my_db_name using catalogcache_sz 274
db2 update db cfg for my_db_name using logbufsz 128
db2 update db cfg for my_db_name using util_heap_sz 20000
db2 update db cfg for my_db_name using pckcachesz 1024
db2 update db cfg for my_db_name using locklist 500
db2 update db cfg for my_db_name using locktimeout 30
db2 update db cfg for my_db_name using sortheap 9504
db2 update db cfg for my_db_name using stmtheap 8192
db2 update db cfg for my_db_name using applheapsz 1024
db2 update db cfg for my_db_name using app_ctl_heap_sz 160
db2 update db cfg for my_db_name using num_iocleaners 3
db2 update db cfg for my_db_name using num_ioservers 5
db2 update db cfg for my_db_name using maxappls 30
db2 update db cfg for my_db_name using avg_appls 10
db2 update db cfg for my_db_name using logfilsiz 1024
db2 update db cfg for my_db_name using logprimary 2
db2 update db cfg for my_db_name using logsecond 120
db2 update db cfg for my_db_name using newlogpath D:\DB2Logs\my_db_name\
db2 update db cfg for my_db_name using logretain RECOVERY
db2 update db cfg for my_db_name using userexit ON