시스템
db2 콘솔 접속~
레곤플라이
2008. 12. 9. 11:27
\\\\\ 사용자 계정생성
>adduser db2inst1 <<<< instance owner
>passwd db2inst1
>비번등록
>adduser db2fenc1 <<<< fence user 생성
>passwd db2fenc1
>비번등록
>adduser dasusr1 <<<< das server user 생성
>passwd dasusr1
>비번등록
\\\\\ instance 생성
>cd /opt/ibm/db2/V9.5/instance
>./db2icrt -w 비트수 -u db2fenc1 db2inst1
\\\\\ das server 생성
>./dascrt dasusr1
\\\\\설치확인
==================== db2isnt1 접속
\\\\ sample database 생성/확인
>db2sampl
>db2start
>db2 activate db sample
>db2 connect to sample
>db2 "select * from employee"
\\\\ sample database 삭제
>db2 force applications all
>db2 terminate
>db2 deactivate db sample
>db2 drop db sample
>adduser db2inst1 <<<< instance owner
>passwd db2inst1
>비번등록
>adduser db2fenc1 <<<< fence user 생성
>passwd db2fenc1
>비번등록
>adduser dasusr1 <<<< das server user 생성
>passwd dasusr1
>비번등록
\\\\\ instance 생성
>cd /opt/ibm/db2/V9.5/instance
>./db2icrt -w 비트수 -u db2fenc1 db2inst1
\\\\\ das server 생성
>./dascrt dasusr1
\\\\\설치확인
==================== db2isnt1 접속
\\\\ sample database 생성/확인
>db2sampl
>db2start
>db2 activate db sample
>db2 connect to sample
>db2 "select * from employee"
\\\\ sample database 삭제
>db2 force applications all
>db2 terminate
>db2 deactivate db sample
>db2 drop db sample
[출처] 리눅스_db2기본설치|작성자 뷰