哇靠 想不到这么多人关注,好吧 我把我的整个建库流程都贴出来:root用户登录:#groupadd ecity #useradd -g ecity -s /bin/bash -d /home/ecity -m test然后用test用户登录,修改密码。切换到db2inst1用户#db2 create databa...
显示全部哇靠 想不到这么多人关注,好吧 我把我的整个建库流程都贴出来:
root用户登录:
#groupadd ecity
#useradd -g ecity -s /bin/bash -d /home/ecity -m test
然后用test用户登录,修改密码。
切换到db2inst1用户
#db2 create database test
#db2 CONNECT TO test
#db2 GRANT CREATETAB, BINDADD, CONNECT, IMPLICIT_SCHEMA, LOAD, QUIESCE_CONNECT ON DATABASE TO USER test
#db2 create bufferpool test_BP size 2000 pagesize 32k
#db2 “CREATE REGULAR TABLESPACE test_TBS PAGESIZE 32 K MANAGED BY DATABASE USING ( FILE '/home/db2inst1/ecity/test.dbf' 25600 ) EXTENTSIZE 16 OVERHEAD 10.5 PREFETCHSIZE 16 TRANSFERRATE 0.14 BUFFERPOOL test_bp DROPPED TABLE RECOVERY OFF”
#db2 GRANT USE OF TABLESPACE test_TBS TO user test WITH GRANT OPTION
#db2 CONNECT RESET
切换到test用户
#db2 CREATE SCHEMA test AUTHORIZATION test
然后创建表,建表语句如下:
create table XZSP_SPSX_SXXX (
SPSXID DECIMAL(10,0) primary key not null,
SPSXBM VARCHAR(20),
SPSXQC VARCHAR(200) default 'N',
SPSXJC VARCHAR(100),
ZXBM CHAR(2),
ZXQC VARCHAR(200),
ZXJC VARCHAR(100),
SFWJDSX CHAR(1),
JDID Integer,
XKLS CHAR(1),
MXDX VARCHAR(20),
SXLX CHAR(1),
SSDWID DECIMAL(10,0),
BLNR VARCHAR(1000),
BLSL VARCHAR(200),
SFJDZJC CHAR(1),
DZJCSXBM VARCHAR(50),
SQTJ LONG VARCHAR,
BLCX LONG VARCHAR,
SDYJ LONG VARCHAR,
SQCL LONG VARCHAR,
CYCL LONG VARCHAR,
SFBJ VARCHAR(2000),
SLJG VARCHAR(800),
JDJG VARCHAR(800),
YJZDT CHAR(1),
SLDZ VARCHAR(1000),
SLCK VARCHAR(100),
XSXX DECIMAL(2,0),
SBSJXZ CHAR(1),
SBKSSJ DATE,
SBJSRQ DATE,
SLSJXZ CHAR(1),
SLKSSJ DATE,
SLJSSJ DATE,
BLSXLX CHAR(1),
BLSX DECIMAL(3,0),
BLSXMS VARCHAR(1000),
ZZLX VARCHAR(100),
ZZMC VARCHAR(1000),
FLXL VARCHAR(2000),
SFNS CHAR(1),
SFYXFC CHAR(1),
SFSF CHAR(1),
SFJE DECIMAL(16,2),
SYYJTS DECIMAL(3,0),
BJZBTS DECIMAL(3,0),
SSDWMC VARCHAR(100),
BSZNZT CHAR(1),
MEMO LONG VARCHAR,
creator VARCHAR(30),
createtime date,
modifier VARCHAR(30),
modifytime timestamp,
esbmodifytime timestamp,
esbdqbz CHAR(1),
extend1 VARCHAR(255),
extend2 VARCHAR(255),
extend3 VARCHAR(255) not null default '1'
);
收起