[DB2] 원격데이터베이스 설정하여 원격 DB 접속

노드 생성(TNS)
등록
db2 catalog tcpip node <Node Name> remote <IP Address> server <Port>
해제
db2 uncatalog node <Node Name>

 

노드를 토대로 원격 DB 생성(DB link)
db2 catalog database <DB Name> as <Alias Name> at node <Node Name>

 

작업명령어

IP 대신 /etc/hosts에 저장된 host명을 입력해도 됩니다.

$ db2 catalog tcpip node DB2POR remote ptdwdb1 server 50020
DB20000I  The CATALOG TCPIP NODE command completed successfully.
DB21056W  Directory changes may not be effective until the directory cache is
refreshed.



$ db2 catalog db PORTAL as PORTAL at node DB2POR
DB20000I  The CATALOG DATABASE command completed successfully.
DB21056W  Directory changes may not be effective until the directory cache is
refreshed.

 

접속 시도

$ db2 connect to PORTAL user db2por
Enter current password for db2por: [비밀번호 입력]

   Database Connection Information

 Database server        = DB2/LINUXX8664 11.1.4.7
 SQL authorization ID   = DB2POR
 Local database alias   = PORTAL
 
 접속 잘되고 완료.