From 32306b5f8ffe4ce594409aa6e89626740b225a39 Mon Sep 17 00:00:00 2001 From: ivan Date: Mon, 15 Nov 2004 10:35:56 +0000 Subject: import sql-ledger 2.4.4 --- sql-ledger/sql/DB2-create.sql | 8 ++++++++ 1 file changed, 8 insertions(+) create mode 100644 sql-ledger/sql/DB2-create.sql (limited to 'sql-ledger/sql/DB2-create.sql') 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@ -- cgit v1.2.1