Merry Christmas

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

[출처] 리눅스_db2기본설치|작성자


: