DB2 development environment

qq78707

-- unix add user
useradd 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;