DB2

1. 데이터베이스 생성(db2inst1)

create database safecert

 

2. 버퍼 풀 생성(db2inst1)

create bufferpool bp32 size 2000 pagesize 32K

 

3. 테이블스페이스 생성(db2inst1)

create tablespace safecerts_d pagesize 32K

   managed by database using(file '/home/db2inst1/tbs/safecerts_d1' 2000)

   extentsize 16 bufferpool bp32

create tablespace safecerts_i pagesize 32K

   managed by database using(file '/home/db2inst1/tbs/safecerts_i1' 2000)

   extentsize 16 bufferpool bp32

 

4. 권한 부여(db2inst1)

--GRANT

GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE CCMS_ALLOWED_APP_INFO TO USER LCMS_APP WITH GRANT OPTION;

 

5. 별칭 부여(user)

CREATE ALIAS CCMS_ALLOWED_APP_INFO FOR LCMS_MGR.LCMS_APP;

 

 

5. db2에서  rownum, connect by 사용 설정 

 # db2stop

 # db2set DB2_COMPATIBILITY_VECTOR=09

 # db2start

DB2  테이블 정보

select * from tab; //테이블 리스트 확인

 

describe table 테이블이름; //테이블 정보 확인