summaryrefslogtreecommitdiff
path: root/sql-ledger/sql/DB2-create.sql
diff options
context:
space:
mode:
authorivan <ivan>2004-11-15 10:35:56 +0000
committerivan <ivan>2004-11-15 10:35:56 +0000
commit5fc8c5edf574ab024d4646914b6432d458e2ffbd (patch)
treec8031ae966b35c47f6aea9929e10911412ff6c59 /sql-ledger/sql/DB2-create.sql
parenta4fc489e860b7bc51b5282a87ea21750b30b905e (diff)
parent32306b5f8ffe4ce594409aa6e89626740b225a39 (diff)
This commit was generated by cvs2svn to compensate for changes in r3883,
which included commits to RCS files with non-trunk default branches.
Diffstat (limited to 'sql-ledger/sql/DB2-create.sql')
-rw-r--r--sql-ledger/sql/DB2-create.sql8
1 files changed, 8 insertions, 0 deletions
diff --git a/sql-ledger/sql/DB2-create.sql b/sql-ledger/sql/DB2-create.sql
new file mode 100644
index 000000000..4187f6c82
--- /dev/null
+++ b/sql-ledger/sql/DB2-create.sql
@@ -0,0 +1,8 @@
+CONNECT RESET@
+ATTACH TO db2inst1@
+CREATE DATABASE LEDGER USING CODESET UTF-8 TERRITORY US DFT_EXTENT_SZ 16@
+CONNECT TO LEDGER@
+CREATE BUFFERPOOL LEDGERBP_8K IMMEDIATE SIZE 1000 PAGESIZE 8192@
+CREATE TABLESPACE LEDGER_TS PAGESIZE 8K MANAGED BY SYSTEM USING ('LEDGER_TS') PREFETCHSIZE 8 BUFFERPOOL LEDGERBP_8K@
+CREATE TEMPORARY TABLESPACE LEDGER_TMP_8K PAGESIZE 8K MANAGED BY SYSTEM USING ('LEDGER_TMP_8K') BUFFERPOOL LEDGERBP_8K@
+CONNECT RESET@