DB2 development environment
-- unix add useruseradd etsbiz
passwd etsbiz
-- db2 add user
GRANT DBADM, CONNECT, CREATETAB, IMPLICIT_SCHEMA, BINDADD,
CREATE_NOT_FENCED_ROUTINE, LOAD, CREATE_EXTERNAL_ROUTINE, QUIESCE_CONNECT, SECADM ON DATABASE TO USER "ETSBIZ";
commit;
-- new schema "etsbiz"
CREATE SCHEMA etsbiz
AUTHORIZATION ETSBIZ;
COMMENT ON SCHEMA etsbiz IS '业务数据库';
COMMIT;
GRANT CREATEIN, DROPIN, ALTERIN ON SCHEMA "ETSBIZ" TO USER "ETSBIZ";
COMMIT;
-- bufferpool
CREATE BUFFERPOOL "DAT01"
IMMEDIATE
ALL DBPARTITIONNUMS
SIZE 12800
NUMBLOCKPAGES 384
BLOCKSIZE 32
PAGESIZE 8K;
CREATE BUFFERPOOL "DAT02"
IMMEDIATE
ALL DBPARTITIONNUMS
SIZE 32000
NUMBLOCKPAGES 960
BLOCKSIZE 32
PAGESIZE 8K;
CREATE BUFFERPOOL "IDX01"
IMMEDIATE
ALL DBPARTITIONNUMS
SIZE 25600
NUMBLOCKPAGES 768
BLOCKSIZE 32
PAGESIZE 8K;
CREATE BUFFERPOOL "TMP01"
IMMEDIATE
ALL DBPARTITIONNUMS
SIZE 2560
NUMBLOCKPAGES 77
BLOCKSIZE 32
PAGESIZE 8K;
-- tablespace
CREATE LARGE TABLESPACE "DATSPACE01"
IN DATABASE PARTITION GROUP "IBMDEFAULTGROUP"
PAGESIZE 8K
MANAGED BY DATABASE
USING ( File '/home/etsdbonl/data/retsuslv01' 523000 )
EXTENTSIZE 32
PREFETCHSIZE AUTOMATIC
BUFFERPOOL "DAT01"
OVERHEAD 7.5
TRANSFERRATE 0.06
AUTORESIZE NO;
GRANT USE OF TABLESPACE "DATSPACE01" TO USER "ETSDBONL" WITH GRANT OPTION;
CREATE LARGE TABLESPACE "DATSPACE02"
IN DATABASE PARTITION GROUP "IBMDEFAULTGROUP"
PAGESIZE 8K
MANAGED BY DATABASE
USING ( File '/home/etsdbonl/data/retsuslv02' 523000 )
EXTENTSIZE 32
PREFETCHSIZE AUTOMATIC
BUFFERPOOL "DAT02"
OVERHEAD 7.5
TRANSFERRATE 0.06
AUTORESIZE NO;
GRANT USE OF TABLESPACE "DATSPACE02" TO USER "ETSDBONL" WITH GRANT OPTION;
CREATE LARGE TABLESPACE "IDXSPACE01"
IN DATABASE PARTITION GROUP "IBMDEFAULTGROUP"
PAGESIZE 8K
MANAGED BY DATABASE
USING ( File '/home/etsdbonl/data/retsuslv03' 261000 )
EXTENTSIZE 32
PREFETCHSIZE AUTOMATIC
BUFFERPOOL "IDX01"
OVERHEAD 7.5
TRANSFERRATE 0.06
AUTORESIZE NO;
GRANT USE OF TABLESPACE "IDXSPACE01" TO USER "ETSDBONL" WITH GRANT OPTION;
CREATE SYSTEM TEMPORARY TABLESPACE "TMPSPACE01"
IN DATABASE PARTITION GROUP "IBMTEMPGROUP"
PAGESIZE 8K
MANAGED BY DATABASE
USING ( File '/home/etsdbonl/data/retstmlv01' 523000 )
EXTENTSIZE 32
PREFETCHSIZE AUTOMATIC
BUFFERPOOL "TMP01"
OVERHEAD 7.5
TRANSFERRATE 0.06
AUTORESIZE NO
NO FILE SYSTEM CACHING;
页:
[1]