CREATE DATABASE TXDB AUTOMATIC STORAGE YES ON /db2inst1 DBPATH ON /db2inst1 USING CODESET UTF-8 TERRITORY US COLLATE USING SYSTEM
CREATE BUFFERPOOL BP_16K IMMEDIATE ALL DBPARTITIONNUMS SIZE 50000 NUMBLOCKPAGES 0 PAGESIZE 16 K
CREATE LARGE TABLESPACE DATATS_16K IN DATABASE PARTITION GROUP IBMDEFAULTGROUP PAGESIZE 16 K BUFFERPOOL BP_16K NO FILE SYSTEM CACHING
db2 update db cfg for TXDB using LOGBUFSZ 2048
db2 update db cfg for TXDB using CHNGPGS_THRESH 60
db2 update dbm cfg using DIAGSIZE 1024
db2 update db cfg for TXDB using LOGARCHMETH1 DISK:/db2archlog
db2 backup db TXDB to . compress