DB2 Federation
- 환경설정
# db2 get dbm cfg | grep -i federated
# db2 update dbm cfg suing federated yes
# db2stop
# db2start
- catalog node, db 생성
# db2 connect to db1svr
# db2 catalog tcpip node KBP_NEW remote xxx.xxx.xxx.xxx server 50000;
# db2 list node directory
# db2 attach to KBP_NEW user db2inst1 using db2inst1
# db2 catalog db KBP_NEW as KBP_NEW at node KBP_NEW;
# db2 list db directory
- wrapper 설정
# db2 create wrapper drda
# db2 select * from syscat.wrappers
- server 정의
# db2 "create server db2svr type db2/udb version '9.1' wrapper "drda" authorization "db2inst1" password "db2inst1" options( add d
bname 'KBP_NEW', add nodename 'KBP_NEW')"
# db2 "select * from syscat.servers"
- user mapping
# db2 "create user mapping for db2singl server db2svr options (remote_authid 'db2inst1`, remote_password 'db2inst1')"
- nickname 생성
# db2 create nickname sapkbp.TAB1_TEST for db2svr.sapkbp.TAP1
- db2 tcp/ip 사용
# db2set db2comm=tcpip
# db2stop
# db2start
# db2 get dbm cfg | grep -i federated
# db2 update dbm cfg suing federated yes
# db2stop
# db2start
- catalog node, db 생성
# db2 connect to db1svr
# db2 catalog tcpip node KBP_NEW remote xxx.xxx.xxx.xxx server 50000;
# db2 list node directory
# db2 attach to KBP_NEW user db2inst1 using db2inst1
# db2 catalog db KBP_NEW as KBP_NEW at node KBP_NEW;
# db2 list db directory
- wrapper 설정
# db2 create wrapper drda
# db2 select * from syscat.wrappers
- server 정의
# db2 "create server db2svr type db2/udb version '9.1' wrapper "drda" authorization "db2inst1" password "db2inst1" options( add d
bname 'KBP_NEW', add nodename 'KBP_NEW')"
# db2 "select * from syscat.servers"
- user mapping
# db2 "create user mapping for db2singl server db2svr options (remote_authid 'db2inst1`, remote_password 'db2inst1')"
- nickname 생성
# db2 create nickname sapkbp.TAB1_TEST for db2svr.sapkbp.TAP1
- db2 tcp/ip 사용
# db2set db2comm=tcpip
# db2stop
# db2start
댓글
댓글 쓰기