summaryrefslogtreecommitdiff
path: root/sql/DB2-create.sql
blob: 4187f6c82e572c65a94455877965f6412361e867 (plain) 
    

  1. CONNECT RESET@
    2. 

  2. ATTACH TO db2inst1@
    3. 

  3. CREATE DATABASE LEDGER USING CODESET UTF-8 TERRITORY US DFT_EXTENT_SZ 16@
    4. 

  4. CONNECT TO LEDGER@
    5. 

  5. CREATE BUFFERPOOL LEDGERBP_8K IMMEDIATE SIZE 1000 PAGESIZE 8192@
    6. 

  6. CREATE TABLESPACE LEDGER_TS PAGESIZE 8K MANAGED BY SYSTEM USING ('LEDGER_TS') PREFETCHSIZE 8 BUFFERPOOL LEDGERBP_8K@
    7. 

  7. CREATE TEMPORARY TABLESPACE LEDGER_TMP_8K PAGESIZE 8K MANAGED BY SYSTEM USING ('LEDGER_TMP_8K') BUFFERPOOL LEDGERBP_8K@
    8. 

  8. CONNECT RESET@
    9.
generated by cgit v1.2.3 (git 2.39.1) at 2024-07-04 23:50:56 +0000