import sql-ledger 2.4.4

[freeside.git] / sql-ledger / sql-ledger / sql / DB2-create.sql

diff --git a/sql-ledger/sql-ledger/sql/DB2-create.sql b/sql-ledger/sql-ledger/sql/DB2-create.sql
new file mode 100644 (file)
index 0000000..4187f6c
--- /dev/null
+++ b/sql-ledger/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@