DB2数据库安装与配置

最新推荐文章于 2024-03-04 17:41:32 发布

chuinger01112223

最新推荐文章于 2024-03-04 17:41:32 发布

阅读量624

点赞数

文章标签：数据库

原文链接：https://my.oschina.net/u/3173910/blog/811279

版权

一、DB2数据库安装

1、数据库安装

略。

2、创建DB2运行所属的用户和组

#groupadd db2iadm
#groupadd db2fadm
#groupadd dasadm
#useradd –g db2iadm –m –d /home/db2inst db2inst
#useradd –g db2fadm –m –d /home/db2fenc db2fenc
#useradd –g dasadm –m –d /home/dasusr dasusr

3、创建DAS并启动

#cd /opt/ibm/db2/V9.7/instance
#./dascrt –u dasusr
#su – dasusr
$db2admin start

4、创建数据库实例并启动

#cd /opt/ibm/db2/V9.7/instance
#./db2icrt -p 60004 -s wse -u db2fenc db2inst
#su db2inst
$. /home/db2inst/sqllib/db2profile
$db2set DB2COMM=TCPIP
$db2stop
$db2start

5、创建样例数据库

#su - db2inst
$db2sampl
$db2 connect to SAMPLE

二、DB2应用数据库创建

1、创建管理用户、应用用户、查询用户

#useradd -m -s /bin/bash op_mgmad
#useradd -m -s /bin/bash op_mgmap
#useradd -m -s /bin/bash op_mgmmn

2、创建管理实例、应用实例、查询实例

#./db2icrt -p 60004 -s wse -u db2fenc op_mgmad
#./db2icrt -s client -u db2fenc op_mgmap
#./db2icrt -s client -u db2fenc op_mgmmn

3、启动管理实例

#su op_mgmad
$. /home/op_mgmad/sqllib/db2profile
$db2set DB2COMM=TCPIP
$db2stop
$db2start

4、创建数据库

create db OPSTADB using codeset GBK territory CN collate using identity
;

connect to opstadb
;

drop tablespace userspace1
;

create bufferpool BP32K all nodes size -1 pagesize 32K
;

create large tablespace opsta_32k_1 pagesize 32k managed by automatic storage bufferpool BP32K
;

create system temporary tablespace opsta_32k_tmp pagesize 32k managed by automatic storage bufferpool BP32K
;

update db cfg using LOGFILSIZ 102400
;

5、创建表

SET CURRENT SCHEMA DICDAT;

CREATE TABLE
    DICDAT.TBL_DICDAT_INS_CATA
    (   
        INS_ID_CD VARCHAR(16) NOT NULL WITH DEFAULT,
        INS_CN_NM VARCHAR(100) NOT NULL WITH DEFAULT,
        ROOT_INS_CD VARCHAR(16) NOT NULL WITH DEFAULT,
        ROOT_INS_NM VARCHAR(100) NOT NULL WITH DEFAULT,
        CUP_BRANCH_CD VARCHAR(16) NOT NULL WITH DEFAULT,
        CUP_BRANCH_NM VARCHAR(100) NOT NULL WITH DEFAULT,
        INS_CATA_1ST_ID INTEGER NOT NULL WITH DEFAULT,
        INS_CATA_1ST_NM VARCHAR(100) NOT NULL WITH DEFAULT,
        INS_CATA_2ND_ID INTEGER NOT NULL WITH DEFAULT,
        INS_CATA_2ND_NM VARCHAR(100) NOT NULL WITH DEFAULT,
        INS_CATA_3RD_ID INTEGER NOT NULL WITH DEFAULT,
        INS_CATA_3RD_NM VARCHAR(100) NOT NULL WITH DEFAULT,
        INS_CATA_4TH_ID INTEGER NOT NULL WITH DEFAULT,
        INS_CATA_4TH_NM VARCHAR(100) NOT NULL WITH DEFAULT,
        CONSTRAINT IND_DICDAT_AT_PK PRIMARY KEY (INS_ID_CD)
    );

--CREATE INDEX DICDAT.IND_DICDAT_AT_I1
--ON DICDAT.TBL_DICDAT_INS_CATA (
--        MCHNT_CD
--        ,AUDIT_ST
--    )
--;


GRANT ALL ON DICDAT.TBL_DICDAT_INS_CATA TO USER OP_MGMAP;
GRANT SELECT ON DICDAT.TBL_DICDAT_INS_CATA TO USER OP_MGMMN;

转载于:https://my.oschina.net/u/3173910/blog/811279