Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- #!/bin/sh
- db2 "update command options using v ON"
- db2 -v "CONNECT RESET"
- db2 -v "TERMINATE"
- db2 -v "DEACTIVATE DATABASE COREDB"
- db2 -v "DROP DATABASE COREDB"
- mkdir -p /tmp/opt3/db2log1/COREDB
- mkdir -p /tmp/opt7/backup/COREDB
- mkdir -p /tmp/opt7/backup/faillog/COREDB
- mkdir -p /tmp/opt2/db2data2
- mkdir -p /tmp/opt1/db2data1
- mkdir -p /tmp/dbpath
- mkdir -p /tmp/opt5/db2index1
- mkdir -p /tmp/opt4/archive1
- db2 -v "CREATE DATABASE COREDB AUTOMATIC STORAGE YES ON '/tmp/opt1/db2data1','/tmp/opt2/db2data2' DBPATH ON '/tmp/dbpath' ALIAS COREDB USING CODESET UTF-8 TERRITORY NO WITH 'COREDB'"
- db2 -v "CONNECT TO COREDB"
- db2 -v "CREATE STOGROUP DATASTOGROUP ON '/tmp/opt1/db2data1','/tmp/opt2/db2data2'"
- db2 -v "CREATE STOGROUP INDEXSTOGROUP ON '/tmp/opt5/db2index1'"
- db2 -v "ALTER BUFFERPOOL IBMDEFAULTBP SIZE 15000 AUTOMATIC"
- db2 -v "CREATE BUFFERPOOL BP4KTMP IMMEDIATE ALL DBPARTITIONNUMS SIZE 5000 PAGESIZE 4K"
- db2 -v "CREATE BUFFERPOOL BP32KTMP IMMEDIATE ALL DBPARTITIONNUMS SIZE 1000 PAGESIZE 32K"
- db2 -v "CREATE BUFFERPOOL BP4KTS1 IMMEDIATE ALL DBPARTITIONNUMS SIZE 50000 AUTOMATIC PAGESIZE 4K"
- db2 -v "CREATE BUFFERPOOL BP4KIX1 IMMEDIATE ALL DBPARTITIONNUMS SIZE 50000 AUTOMATIC PAGESIZE 4K"
- db2 -v "CREATE BUFFERPOOL BP4KLOB IMMEDIATE ALL DBPARTITIONNUMS SIZE 2000 AUTOMATIC PAGESIZE 4K"
- db2 -v "CREATE BUFFERPOOL BP32KTS1 IMMEDIATE ALL DBPARTITIONNUMS SIZE 2000 AUTOMATIC PAGESIZE 32K"
- db2 -v "alter bufferpool bp4kts1 numblockpages 2000"
- db2 -v "alter bufferpool bp4kix1 numblockpages 2000"
- db2 -v "alter bufferpool bp32kts1 numblockpages 500"
- db2 -v "CREATE SYSTEM TEMPORARY TABLESPACE TEMPSPACE4K PAGESIZE 4K BUFFERPOOL BP4KTMP USING STOGROUP DATASTOGROUP NO FILE SYSTEM CACHING"
- db2 -v "CREATE SYSTEM TEMPORARY TABLESPACE TEMPSPACE32K PAGESIZE 32K BUFFERPOOL BP32KTMP USING STOGROUP DATASTOGROUP NO FILE SYSTEM CACHING"
- db2 -v "DROP TABLESPACE TEMPSPACE1"
- db2 -v "UPDATE DB CFG USING DBHEAP 20480 AUTOMATIC"
- db2 -v "UPDATE DB CFG USING UTIL_HEAP_SZ 50000 AUTOMATIC"
- db2 -v "UPDATE DB CFG USING SELF_TUNING_MEM ON"
- db2 -v "UPDATE DB CFG USING LOGARCHMETH1 'DISK:/tmp/opt4/archive1' LOGARCHCOMPR1 ON DEFERRED"
- db2 -v "UPDATE DB CFG USING LOGPRIMARY 80 LOGSECOND 140 LOGFILSIZ 4096 LOGINDEXBUILD ON DEFERRED"
- db2 -v "UPDATE DB CFG USING LOGBUFSZ 1024 DEFERRED"
- db2 -v "UPDATE DB CFG USING NEWLOGPATH '/tmp/opt3/db2log1/COREDB' DEFERRED"
- db2 -v "UPDATE DB CFG USING TRACKMOD ON DEFERRED"
- db2 -v "UPDATE DB CFG USING AUTO_DEL_REC_OBJ ON NUM_DB_BACKUPS 14"
- db2 -v "UPDATE DB CFG USING REC_HIS_RETENTN 14 DEFERRED"
- db2 -v "UPDATE DB CFG USING LOCKTIMEOUT 30 DEFERRED"
- db2 -v "UPDATE DB CFG USING DFT_DEGREE ANY DEFERRED"
- db2 -v "CONNECT RESET"
- db2 -v "TERMINATE"
- db2 -v "DEACTIVATE DATABASE COREDB"
- db2 -v "BACKUP DATABASE COREDB TO '/tmp/opt7/backup/COREDB' COMPRESS EXCLUDE LOGS WITHOUT PROMPTING"
- db2 -v "ACTIVATE DATABASE COREDB"
- db2 -v "BACKUP DATABASE COREDB ONLINE TO '/tmp/opt7/backup/COREDB' COMPRESS INCLUDE LOGS WITHOUT PROMPTING"
- db2 -v "CONNECT TO COREDB"
- db2 -tvsf "/tmp/db2move/scripts/core_uat.ddl"
- cd /tmp/db2move
- db2move coredb load -lo replace
- db2 -tvsf "/tmp/db2move/scripts/set_integrity_core_uat.sql"
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement