?????. DB2 ? XpertMon ??? ???!
? ????????? DB ??????.
?? ?? XpertMon ????? ????? ???? ???? ? ? ????
????? ??? ?? ??? ?? ???, ? ? ??? ?? ?????
? ? ?? ??? ???? history ??? ???? ????.
??? ???? ???? ???? ????? ??? ???? ??????
?????.
?? ???? IBM WebSphere Information Integrator? Q Replication? ???? DB2?
???? ????? Sybase? ???? ??? ?? ???????.
???? ?? ????? ???, ?? ?????? ?? ????
(
www.iteg.co.kr)
???? ????? ?? ? ????.
???? ?? ?? ???? ??? ??? ??? ??????. ???? ?????
?????.
Quick Start for Q Replication to
Oracle and Sybase
??
IBM WebSphere Infromation Integrator Q replication? DB2? commit? ????
???? ????? Sybase? ??? ? ?? ? ???.
? ??? Q ??? WSII? federation ??? ???? DB2 ???????? ???
?? ????? ?? ???? ??? ???.
[??1] Federated target server? ?? ??? ???????? Q??
[??1]?? ??? ? ??? ??? ??? ?? DB2 ??? ??? ?????.
Websphere MQ? ? DB2 ?????? ??? ?? ??? ?????.
????? Q capture ????? Q apply ????? ?? DB2 ????????
????? Sybase ??????? ?????. Q capture ????? Db2 ?????
?????? ????? ??, Websphere MQ? ?? ??? ????.
DB2?? Q??? ?? ? ???? ??? ??? Q apply ????. ????? Sybase
?? ??????? ??, Q apply ????? WSII ?? ????, ????? federation
??? nickname?? ??? ????? Sybase ??? ?????. (Nickname? ? DB2
??????? ?? ???? ?? ???? ?? ?????.)
Q??? federation ??? ???? ???? ???? Nickname? ?? ?? ???
????? ????? ????? ????? ????? Q apply ??? ?????.
Federated Q??? ???? ??? ??? ???? ???? GUI ??? CLP, ???
????? ???? ??? ?????. ?? ???? ??? ????? ?????
??? health ??? ???? ? ???.
??? federated Q ????? WSII V8.2.2 (Version 8.1 ? FixPack 9 ??) ??
?????.
- ??? ?? : ??? ??? z/OS ? LUW? DB2?? ?? wrapper? ???? federation
?? ??? ???(NET8 ?? SQLNET wrapper) ?? Sybase(CTLIB wrapper)? ?????.
???? Nickname? ??? ???? ???? ????? ?? ??? ?????.
Q apply ????? ?? ???? EXPORT ? IMPORT? ???? ??? ?? ???
? DB2 ?????? ???? ??? ? ????.
- ?? ?? : ? DB2 ??????? ??? Q ??? ??? ?, ?? ???? ??
?? Q apply control ???? ????, ?? ??? ?? Nickname? ?? ???
? ????. ?? ?? ???? ???? ?? UOW ??? Q apply ? control table?
???? ?????. Fedrated? ??? ???????? ? ??? control table?
?????.
- ???? ??? ?? : ????? ??? ??? ??? ??? ???. (?? ??,
?? ???? INTEGER NOT NULL ??? nickname? INTEGER NOT NULL ??) Q ???
?? ???? ?? ??? ???? ??? nickname ???? ??? ?????.
?? ??, ??? ??? ?? ?? ???? ??? ? nickname ???? ??? ? ????.
- ???? : Replication Alert Monitor ? table differencing, reconciliation ??
?? (asntdiff ? asntrep)? ? DB2 ?? ???? ?????. asntdiff ?????
?? ???? nickname?? ?????. asntrep ????? ??? ??? ????
?? nickname? update ???.
WSII? WS MQ? ?? ? DB2 ??????? ??? ?????. [?1]??? SQL ???
Q ??? ??? ??? ???? ???? ?? ???.
?? ?? |
?? ??? |
?? ??? |
SQL ?? |
DB2 for LUW
DB2 for z/OS
DB2 for iSeries™
Informix®
Microsoft® SQL Server
Oracle
Sybase
|
DB2 for LUW
DB2 for z/OS
DB2 for iSeries
Informix
Microsoft SQL Server
Oracle
Sybase
Teradata
|
Q ?? |
DB2 for LUW
DB2 for z/OS
|
DB2 for LUW
DB2 for z/OS
Oracle
Sybase
|
[?1] SQL ?? ? Q ??? ?? ???
????? ????
Q capture ????? ???? ??? ????? ????? DB2 V8.2 ?? ????
??? ????. Q apply ????? ???? ???? WSII V8.2.2(V8.1 + FP 9)?
?????.
Q apply ????? ???? ???? ????? Sybase ????? ????? ???
??? ?????? ?????.
- Websphere Information Integrator V8.2 (Relational Wrapper ??) ? FP9
- DB2 Universal Database Version 8.2
- Websphere MQ Version 5.3 (WSII ???? ??? ??)
Fedrated Q ?? ?? ??
??? ? Sybase? ??? ?? Q ?? ?? ??? ??? ????.
1. Websphere MQ ?? ??
2. Q apply??? ? DB2 ?? ?? ?? ? federated object ??
3. Q ?? object ??
4. ?? ??
[?? 2]?? ?? ??? ????? ?????.
[?? 2] ? DB2 ???? Q ?? ?? ??
??? ???
'??-source'? '??-target'?? ??? federated ????? ??? ?? ???
?? ? ????. ? ????? WSII federated ??? Q apply ????? ?????
nickname? ???? ??, ??? ?? ???? ??? ?? ? DB2 ??????
??? '??-target'??? ???????.
[?? 3] Federated Q ??? ??? ??? ??
WebSphere MQ ? ??? ??
?? ??????? Q capture ????? federated Q apply ???? ?? ????
?? ? ??? ?? ???? ?, ?? ? ???? ???? WebSphere MQ ? ????
?????.
? ??? Q capture ? Q apply ????? ???? ???? ? ???? ?????.
Q ??? Q capture ? Q apply ????? MQ ?????? ??? ????? ??
? ???? ????? ???? WS MQ ??-????? ??? ?????.
???? : ??? ??? ???? ? ???? Q capture ? Q apply ?????
??? ??? ??????.
??
WS MQ ? ???? ????? :
1. Q capture ????? ???? ???? OS ???? ??? ?? ??? ??????.
crtmqm
quere-manager-name
2. ?? ??? Q apply????? ???? ????? ??????.
?? ? ?? ? ??
Q capture ? Q apply ????? ???? ?? WS MQ script(MQSC)? ?? ??? ?
????.
???? ?? Q capture ? Q apply ? ??? ? ???? ???? ??? ???.
Q ??? DB2 ???? ??? ? Sybase ???? ? ?? ??? ?????, ???
? ?? ? ?? ??? ?? ????.
??
?? ? ? ?? ?? ???? ??? ??? ????.
1. ?? ??? ?? ?? ????? ? ???? ?????.
strmqm
queue-manager-name
2. ?? ??? ?? ?? ? ???? ???? ?? MQSC ??? ?????.
runmqsc
queue-manager-name
3. [?2]? ?? ??? ?? ?? ?? ?????.
? |
?? |
MQSC ?? |
Send Queue |
Q capture ?? Q apply? ????? Control ???? ?? |
DEFINE QREMOTE('send-queue-name')
RNAME('receive-queue-name')
RQMNAME('remote-queue-manager-name')
XMITQ('transmit-queue-name')
|
Administration Queue |
Q apply?? Q capture?? control ???? ?? |
DEFINE QLOCAL('Q-capture-admin-queue-name')
|
Restart Queue |
??? ? Q capture? ?? ??? DB2 log? ??? ?? |
DEFINE QLOCAL('restart-queue-name')
|
Transmission Queue |
Q apply? ???? Q capture??? ???? ? ?? ???? ?? |
DEFINE QLOCAL('transmit-queue-name')
USAGE(XMITQ)
|
[?2] ?? ? ?? ??
4. end ??? ???? ?? ? ???? ?? MQSC ??? ?????.
5. ?? ??? ?? ?? ???? ? ???? ?????.
strmqm
queue-manager-name
6. ?? ??? ?? ?? ? ???? ?? MQSC ??? ?????.
runmqsc
queue-manager-name
7. [?3]? ?? ??? ?? ?? ?? ?????.
? |
?? |
MQSC ?? |
Receive Queue |
Q capture ?? Q apply?? ????? Control ???? ?? |
DEFINE QLOCAL('receive-queue-name')
|
Administration Queue |
Q apply?? Q capture? control ???? ?? |
DEFINE QREMOTE('Q-apply-admin-queue-name')
RNAME('Q-capture-admin-queue-name')
RQMNAME('remote-queue-manager-name')
XMITQ('transmit-queue-name')
|
Transmission Queue |
Q capture? ???? Q apply??? control ???? ?? |
DEFINE QLOCAL('transmit-queue-name')
USAGE(XMITQ)
|
[?3] ?? ? ?? ??
??? ??? WebSphere MQ ?? ??
?? ??????? Q capture ????? federated Q apply ??? Q apply ????
???? ???? ???? ?? ?? ? ?? ? ??? ??? WS MQ??? ?????.
???? ??, Q capture ? Q apply ????? ?? ? ???? ?? ? ?? ??
??? ???.
??? ?? ?? ?? ????. [?? 4]? ?? ?? ??? ?? ? ??? ???
????, ?? ??? ?? ? ??? ??? ?????.
[?? 4] ??? ??? ??? ??
??
??? ??? ??? ???? ??? ??? ????.
1. ?????? ? ???? ?? ??? ?? ?? ??? ?????.
strmqm
queue-manager-name
2. ?? ??? ?? ?? ? ????? ?? MQSC ??? ?????.
runmqsc
queue-manager-name
3. ?? ??? ?? ?? ? ????? ?? ? ????? (TCP/IP ????? ???)
?? ??? ?????.
DEFINECHL(
'source-sender-channel-name)CHLTYPE(SDR) TRPTYPE(TCP)
CONNAME(
'target-IP-address(port)')
XMIT(
'source-transmit-queue-name')
?? ??? port ?? ?? ???, WSMQ? ???? 1414? ?????. ???????
UNIX/LINUX??? /etc/services ???, Windwos??? etcservices ??? ????
???? ??? ?? ???? ?? ????? ??? ? ????.
4. ?? ??? ?? ?? ? ????? ?? ? ????? ?? ??? ?????.
DEFINE CHL(
'source-receiver-channel-name')CHLTYPE(RCVR) TRPTYPE(TCP)
5. end ??? ???? ?? ? ????? ?? MQSC ??? ?????.
6. ?? ??? ?? ?? ???? ? ???? ?????.
strmqm
queue-manager-name
7. ?? ??? ?? ?? ? ????? ?? MQSC ??? ?????.
runmqsc
queue-manager-name
8. ?? ??? ?? ?? ? ????? ?? ? ????? (TCP/IP ????? ???)
????? ?????.
DEFINE CHL(
'target-sender-channel-name') CHLTYPE(SDR) TRPTYPE(TCP)
CONNAME(
'source-IP-address(port)')
XMIT(
'target-transmit-queue-name')
9. ?? ??? ?? ?? ? ????? ?? ? ????? ?? ??? ?????.
DEFINE CHL(
'target-receiver-channel-name') CHLTYPE(RCVR) TRPTYPE(TCP)
Federated Q ??? ?? ??? ?? ??? ??
? DB2 ??? ??? ?? ?? Q capture ????? ??? ?? DB2 ?? ???
???? ????, Q apply ????? ??? ?? DB2 ????? ???????
????? ???.
??
Federated Q ??? ?? ??? ?? ???? ???? ??? ??? ????.
1. LUW : ?? ? ??? ???? ?? ??????? ?? ??? archival logging
?? ?????.
A. ???? : Q Capture ?? ???? ??? ???????? ??? ?? ?
"Enable Database for Q Replication"? ?????.
[?? 5] ????? ?? Archival logging ??
B. CFG ?? : ?? ??? ?????.
UPDATEDB CFG FOR
database-anme USING LOGRETAIN RECOVERY
???
database-name? ?? ?????? ?? ????.
? ??? ???? ??????? BACKUP PENDING ??? ????.
BACKUP PENDING ????? OFF LINE ??? ??? ???, ?? ??? ?? ???
??? ??? ??? ???.
BACKUP DATABASE
database-name TO
path
???
path? ?? ???? ??? ??? ????.
2. ?? ? ??? ???? Q apply ??? federated ??? ??? ???.
A. ???? : DBM CFG ??? Q apply ??????? ?? ?????? ??? ?? ?
???? ?? ???? Configuration Parameters? ?????. Environment ???
Federated? ???? '...'? ???? federated ??? ??????.
[?? 6] ????? DBM CFG ?
B. CFG ?? : Q apply ???? ????? attach ? ?, ?? ??? ?????.
UPDATE DBM CFG using FEDERATED YES
** ?? ??? ???? ???? ????? ????? ???.
3. Federated Q apply ???? db2dj.ini ??? ??? ? Sybase ????? ?????.
WSII? ???? ?? ????? Sybase ?????? ???? ???, ??? ?????
db2dj.ini? ???? ?? ????. ??? ???, ??? ??? ?????.
A.?? ?? : 'Typical' ??? ???? WAII??????? ?? ???? ????
??? ?????.
** WSII ??? ?? ????? ?????. ??? ????? ???? ??? ??? ???.
B. db2dj.ini ??? ?????. ? ??? ???
?UNIX/Linux ????? sqllib/cfg ???? ???.
?Windows ????? sqllibcfg ?? %DB2PATHcfg
???? ???.
db2dj.ini ??? federated ??? ??? ??? ? Sybase ????? ??????
????? ?? ????. ??? ???, ???? ???? db2dj.ini ??? ??
???? ???. db2dj.ini ???? ???? ??? ???? ?? ???? ???.
??? ??? ??? ?????.
4. Linux/UNIX : ?? ?????? DB2 ????? .profile ??? ????? ?????.
???? : ??? ??????? ???? ?? ??? ?????.
???
oracle_home_directory? ??? ????? ?????? ??? ????? ?????.
export ORACLE_HOME=
oracle_home_directory
export PATH=$ORACLE_HOME/bin:$PATH
?Sybase : Sybase ??????? ???? ?? ??? ?????.
??? sybase_home_directory? Sybase ????? ?????? ??? ?????
?? ???. OCS-version_release? ??? Sysbase Open ????? ??? ???
??? ?????.
export SYBASE=
sybase_home_directory
export SYBASE_OCS=OCS-version_release
export PATH=$SYBASE/bin:$PATH
5. Linux/UNIX : DB2 ???? .profile? ?? ?????.
.$HOME/.profile
????? db2dj.ini ??? ??? ??? ????, Q apply ??? ??? ???
?? ? ??? db2 ????? ??????.
6. Q apply? ???? ?? ??????? ????? ??? ?????.
A. ??? : ?? ??? tnsnames.ora ??? ??? ??????? ???? ??
TCP/IP ??, ?? ??, ??? ? ? ?? ??? ?????.
?Linux/UNIX : $ORACLE_HOME/network/admin
?Windows : %ORACLE_HOMENETWORKADMIN
??? ????? ?????? ???? ORACLE NET Configuration Assistant
????? ???? tnsnames.ora ??? ??? ? ????. ? ????? ??
??? ??? ?? ??? ????? ????.
tnsnames.ora ??? SID(SERVICE_NAME)? ??? ???? ???, HOST? ???
??? ??? ??? ??? ????.
B. Sybase : $SYBASE ????? interfaces ??? Sybase SQL Server? ?? ??
Adaptive Server Enterprise ????? ?????? ???? ????(????)?
?????. interfaces ??? Q apply ??? ??? DB2 ????? $HOME/sqllib
????? ?????. interfaces ???? ??? ?????, CREATE SERVER ???
IFILE ??? ?? ?? ??? ????? ??? ?? ????.
7. ????? ??? ??????.
A. ??? : ?? ???? ?? sqlplus ????? ?????.
B. Sybase : ?? ???? ?? isql ? ??? Sybase ?? ????? ?????.
Oracle ? Sybase Wrapper ??
Federated Q apply ??? ? DB2 ?? ??? ?? ? ??? ??? ?? wrapper?
?????.
Wrapper? ???? ?? ??? ???? ??? ??? ?? ?? ??? wrapper?
???? ????.
???? ??, Q apply ??? ????? federated? ???? ?? wrapper? ?
DB2 ???? write access? ????? ??????.
???? : Q ??? ? DB2 ???? ??? ??? ODBC wrapper? ?? ????
wrapper? ?? ??? ???? ????.
??
??? ? Sybase wrapper? ???? ??? ?? ? ??? ??? ??????.
A. ???? : Create Wrapper?? ?????. ?? ?? ???? ???? ????
federated Q apply database? ????, Federated Database Object ??? ???
??? ?, ???? Create Wrapper? ?????.
[?? 7] Create Wrapper ?
B. CREATE WRAPPER ? ?? : ?? SQL?? ???? wrapper? ?????.
CREATE WRAPPER
wrapper-name
Q ??? ???? ??? NET8 ? SQLNET wrapper?, Sybase? ??? CTLB wrapper?
?????. Wrapper? ?? ???? ???? federated ??? ???? Q apply ???
???? ???? ??? ?????? ?????.
Wrapper ??? ???? ?? ?? ??? ?????, LIBRARY ????? ????
OS? ??? ?????? ??? ??? ???.
??? ? Sybase ??? ?? Server ?? ??
federated Q apply ??? ?? ??? ? ??? ? Sybase? ?? ?? ??? ? ???.
????? ??, Q apply??? ??? DB2 ????? federated ? ????? ??
?? ??? ??, ? DB2 ??? ?? wrapper? ???? ??? ???.
??
??? ? Sybase ? ?? ????? ???? ??? ??? ????.
1. ?? ?? ?????. (federated ????, ??? ?? ???????)
A. ??? : ?? ?? tnsnames.ora ??? ?? ? ?? ?????.
B. Sybase : ???? sqllib ????? interfaces ??? ?????.
2. ?? ??? ???? ?? ?? ? ??? ??? ??????.
A. ?? ?? : ?? ?? ?? ?? ?????. ?? ?? ???? ???? ??
?? federated Q apply ??????? ???? ???? wrapper ???? ?????.
Server Definition ??? ??? ???? ???? ?? ? create? ?????.
???? ??(Setting) ??? ???? ???? NODE ???, Sybase? ????
??? DBNAME ??? ?????.
[?? 8] ?? ?? ?? ?
B. CREATE SERVER ? ?? : ?? SQL ?? ???? ????.
CREATE SERVER
server-definition-name TYPE
target-type
VERSION
version_number WRAPPER
wrapper
OPTIONS (NODE
'node-name', DBNAME
'database-name');
target-type : ????? Sybase ??? ?????.
version_number : ? DB2 ?? ??????? ??? ?????. ???? ????
8i, 9i, 10, ??? 10g? ?????. Sybase ? ???? 11.0,11.5, 11.9, 12.0,
??? 12.5? ?????.
wrapper : ???? NET8 ?? SQLNET, Sybase? ???? CTLIB? ?????.
node-name : ???? tnsnames.ora ??, Sybase ? ???? interfaces ????
?? ?? ?? ? ????. NODE? ??? ? Sybase ???? ??? ?????.
database-name : Sybase ????? ??? ?????.
??? ? Sybase ??? ?? User mapping ??
Q apply ????? ????? Sybase? ???? ???? federated Q apply ??
?? ???? ??? ID? ????? ? DB2 ?? ???????? ???? ???
ID? ?????? ??? ??? ??? ???.
??
??? ? Sybase ??? ?? user mapping? ????? ?? ? ??? ??? ??
????.
1. ?? ?? : User Mapping ?? ?? ?????. ? ?? ???, ? DB2 ??
??????? ?? ?? ?? ??? ????, user mapping ??? ??? ????
??? ???? CREATE ? ?????. Federated Q apply ??? ??? ID? ???
?, Setting ??? ? DB2 ??? ???? ???? ID? ????? ?????.
[?? 9] User mapping ?? ?
2. CREATE USER MAPPING ? ?? : ?? SQL?? ???? ?????.
CREATE USER MAPPING FOR
QApply_userID
SERVER
server-definition-name
OPTIONS (REMOTE_AUTHID
'remote_userID',
REMOTE_PASSWORD
'remote_password');
?????? OPTION ???? ???? ??? ? Sybase ??? ??? ????
???? REMOTE_AUTHID? REMOTE_PASSWORD? ??? ??? ??? ???.
Federated Q ??? ?? ?? ??? ??
? DB2 ??? ???? ???? ??, Q subscription, ??? ?, operational
parameter ? ??? ?? ?? ??? ??? ?? ???? ???? ???.
???? ??, ?? ???? ????? ???.
- ????? ?? ??? federated ??? ??? ? ??? ???.
?? ??? ? DB2 ?? ??? pass-through ? nickname ??? ?? ??? ??
?? ???.
- ? DB2 ??? ?? wrapper, server??, ??? mapping ?? ???? ??? ???.
- ?????, remote authorization ID ? ? DB2 ?? ??????? ????
Q apply ?? ???? ???? ??? ??? ????? ???.
- Q capture ?? ???? ???, Q capture ????? ???? Websphere MQ ?
???? ???, ?? ?? ???? local ?? ??? ?? ???? local ??
??? ?????.
- Q apply ?? ???? ???, Q apply ????? ???? Websphere MQ ? ????
??? ?????.
??? ?? ????? ? ???? ? ??? ?? ??? ??? ???? ????.
?? ???? ??? ? MQ ???? ?? ?? ??? ??????. ??? ???
Q capture ? Q apply? ????? ???? ?? ? ????. MQ ???? ??
????? ?????.
? DB2 ????, ?? Q apply ?? ???? ?? ???? ???? ?? ?????
nickname? ?? ?????. ??? ?? ????? Q apply ??? ?????.
[?4]? ?? ???? ??? ?????.
Federated Server? ???? ??? |
? DB2 ?? ??? ???? ??? |
IBMQREP_APPLYENQ
IBMQREP_APPLYTRACE
IBMQREP_APPLYMON
IBMQREP_APPLYPARMS
|
IBMQREP_DONEMSG
IBMQREP_EXCEPTIONS
IBMQREP_RECVQUEUES
IBMQERP_SAVERI
IBMQERP_SPILLEDROW
IBMQERP_SPILLQS
IBMQERP_TRG_COLS
IBMQERP_TARGETS
|
??
?? ??? ?? ?????? Q capture ???? ? Q apply ????? ?? ??
???? ?????.
1. Q capture ?? ??? ???? ?????. ???? ?? ???? Q capture
servers ???? ??? ?? ?, Create Q Capture Control Tables? ?????.
2. Q apply ?? ??? ???? ?????. ???? ?? ???? Q apply servers
???? ??? ?? ?, Create Q Apply Control Tables? ?????.
A. ???? : ?? ?????, Q apply ??? ? DB2 ????? ????? ???
????? Custom? ??????.
?. Q apply ???? ?? ???? ? ??? ????? ?????. ??? ???
????? ?????, ??? ?? ??? ????? ??? ? ????.
?. ? DB2 ???? ?? ???? ?? ??? ???? (???) ?? ?? ????
(Sybase)? ?????, ??? ?? ??? ???? ?? ????? ??? ? ????.
B. ?? ?????, federation ??? ?????.
[?? 10] Q apply ?? ??? ?? ???? ?? ???
C. ?? ??? ?????, ?? ???? ? DB2 ??????? ?? Q apply ???
mapping ????? ????, ??? ??????.
?. ?? ? (? DB2 ??????? ?? ??? ????.)
?. ????? Sybase? ???? Q apply ?? ???? ?? ??? (? DB2 ???
???? ?? ??? ??? remote authorization ID? ?? ??? ????. ???
?? ??? ? ????.)
[?? 11] Q apply ?? ??? ?? ???? ?? ??? ???
D. ? ??? ?????, Q apply ????? ???? ? ???? ??????.
E. ?? ????? ?? ??? ??? ?, ?? ???? ???? ????? ??
??? ?? ??? ??????. ????? ????? ?????? ???? ???,
??? ??? ? ????.
ASNCLP? ???? ?? ??? ??
ASNCLP? ???? Q capture ? Q apply ?? ???? ??? ?? ????.
CREATE CONTROL TABLES FOR ??? ?????. Q apply ?? ???? ????
FEDERATED ???? ??????. ? DB2 ??????? ??? RMT SCHEMA ????
???? ?? ??? ???? ??? ? ????. ???? remote authorization
ID ???. ?? ?? ??? ??? ??? ????(???)? ????(Sybase)?
??? ?? ????.
?? ??, ??, federated Q apply ?? FED_DB? ??, ORACLE_ID? remote authorization ID?
???? ORACLE_TARGET??? ??? ???? ?? Q apply ?? ???? ????
??? ??? ????.
ASNCLP SESSION SET TO Q REPLICATION;
SET SERVER TARGET TO DB FED_DB NONIBM SERVER ORACLE_TARGET;
SET QMANAGER QM2 FOR APPLY SCHEMA;
SET APPLY SCHEMA ASN;
CREATE CONTROL TABLES FOR APPLY SERVER IN FEDERATED RMT SCHEMA ORACLE_ID;
? ??? ????? ???? ???? ????, ??? ??? ????? ?????.
?? ? ? ??
?? ? ?? ?? ?? send ?? ?? ?? receive ?? ???? ?? ????
?? ??? ?? ???. Administration ?? ???? Q apply ????? Q capture
?????? ?? ???? ????? ? ?? ????.
???? ??, Q capture ? Q apply ?? ???? ???? ??? ??, send ?,
receive ?, ??? Q apply administration ?? ??? ??? ???.
??
?? ???? ?? ? ?? ???? ???? ??? ??? ?????.
1. ?? ? ? ?? ?? ???.
2. ? ?? ??? Q capture ????? ???? Q capture ???? ?????.
3. ?? ? ? ??? ??? ???? ???? ???? CREATE ? ?????.
[?? 12] ?? ? ? ?? ?
4. ?? ?????, ?? ??? ?????.
A. Maximum message length : Q capture ????? send ?? ?? ? ?? ????
?? ??( KB ??)
B. Queue error action : ??? ??? ???? ? ?? ????? ? ?
C. Number of Q Apply agents : Q apply ????? receive ???? ????? ???
???? ?? ???? agent thread ?
D. Maximum Q Apply memory usage : Q apply????? receive ???? ?? ????
buffer? ??? ???? ?? ??(MB ??)
E. Heartbeat interval : ??? ????? ?? ? Q capture ????? ? ??
?? ??? ??? ?? ??? ??? ??(? ??)
ASNCLP? ?? ? ? ??
ASNCLP?? CREATE REPLQMAP ??? ?? ?? ? ?? ?? ? ? ????.
?? ??, send ? ? receive ?? ??? ?? ASN.QM1_TO_QM2.DATAQ ??,
administration ?? ??? ASN.ADMINQ ?? ???? ????? ?? ? ?
SAMPLE_ASN_TO_FED_DB_ASN? ???? ??? ??? ????.
ASNCLP SESSION SET TO Q REPLICATION;
SET SERVER TARGET TO DB FED_DB NONIBM SERVER ORACLE_TARGET;
SET QMANAGER QM2 FOR APPLY SCHEMA;
SET APPLY SCHEMA ASN;
CREATE REPLQMAP SAMPLE_ASN_TO_FED_DB_ASN
USING ADMINQ ASN.QM1.ADMINQ RECVQ ASN.QM1_TO_QM2.DATAQ
SENDQ ASN. ASN.QM1_TO_QM2.DATAQ
Federated Q ??? ?? Q subscription ??
Q subscription? DB2???? ?? ???? ? DB2 ?? ??????? ????
???? ????? ?? ????. Q subscription?? ? ?, ?? ??? ??,
??? ?? ????? ?????.
??? ??? ??? ?? Q subscription? ?????.
???? ??, Q capture ? Q apply ?? ??? ? ?? ? ?? ??? ???.
????
? DB2 ??? ?? ??? ??? ???? ????.
? DB2 ??????? ?? ???? ????? ??? ???? ????.
?????? EXPORT / IMPORT ??? ???? ???? nickname?? ???? ??
???? ????? ???.
? DB2 ?? ???? ?? ?? ??? ????? ?? ?? ???? ?? nickname?
?? ????? ???? ??? ??? ???. ?? ????? ??? ?????
???? ???? ????.
??? Q apply ????? nickname? ?? ?? ??? ????? ?????? ??
? ? ???? ??? ????. ???? : ?? ??? ????? ?? nickname?
???? "no load" ??? ????, ?? ?? ? ??? ?? ???? ????
??????.
?? ???? ?? ?? nickname? ???, IPMQREP_SUBS ???? ?? Q subscription?
BEFORE_VALUES ??? Y , CHANGED_COLS_ONLY ??? 'N' ??? ???.
??
Federated Q ?? ???? Q subscription? ???? ???? ??? ??? ??????.
1. ?????? Q subscription ?? ???? ???. ???? ?? ???? ??
?? ???? ??? Q capture ??? ?? Q apply ???? ??? ?, Q subscriptions
???? ??? ??? ?? ??? ??? Create? ?????.
[?? 13] Q subscription ?? ??? ??
2. ?? ????? ???? Unidirectional? ?????.
3. Servers ????? :
A. ?? ??? ?????.
B. ?? ??? Q apply ??? ?????. Q apply ????? ? DB2 ??? ???
???? ??? nickname ? ?????.
C. ?? ? ?? ?????.
4. ?? ??? ?????, ????? ?? ???? ?????.
5. ?? ?????, ????? ?? ??? ??? ?????.
A. Nickname? ?? ??? ? DB2 ??????? ???? ??? ? ????.
?? ??? ?? ??? ???? ??? ? ? ???, ??? ???? ????
??? ? ????.
B. Nickname? ???? ? ?? ???? ??? ?? ???? ????? ???
? ????. ? ????? Q apply ??? ?? ????? ??, nickname?? ?
? ??? ???.
** ??????? ? DB2 ?? ???? ?? ??? nickname? ??? ????,
??? ?? nickname? ?????. ??? nickname? ????? nickname ???
?? control ??? ?? ???, ?? nickname? ?? ?? DB2 ???????
? DB2 ??? ?? ?? ??? ??? ? ????.
[?? 14] Q subscription ?? ???? Target ???
6. ?? Q subscription ? ?? : ?? ????? ?? ???? ?????, Q apply
??? ?? ? DB2 ?? ???, ???, ??????? ?? ???? , ???
?? nickname? ?? profile? ???? ???. Change ??? ???? ?? ????
profile ?? ?? ??? ??????.
7. Rows and column ?????? ?? ??? ?????.
A. ?? ???? ?? ?? ?? ?? ?? ????? ???, Source changes ?
??????.
B. ?? ??? ? DB2 ?? ??? ?? ??? ?? ??? ????? ??? Column
mapping ? ??????. ?? ?? ??? Q apply ??? nickname? ? DB2 ??
??? ??? ?? ??? ?? ?? ?? ? ?? ??? ?? ???? ??? ??
???? ??? ??????.
C. Q apply ????? ??? ?? ????, ????? ??? ????? ????
? ??? ?????, Index or primary key? ??????.
8. ????(Unexpected condition) ?????, Q apply ????? ??? ???
???? ??????.
9. ? ??? ?? ????? :
A. ?? ??? ??????.
** Q apply ????? ?? ???? ?? ?? ??? ???, federated Q ?????
EXPORT / IMPORT ?? ?????.
B. Q subscription? ?? ? ?? ??? ? ??? ??? ??????. ? ???
????, Q capture ? Q apply ????? ???? Q subscription? ?? ???
?????.
10. ?? ??????, ????? ??? ?????. ?? ??? ??? ???
??? ???, Q subscription? ??? ? Properties? ?????.
11. ?? ????? Finish ? ????, Q subscription? ???? ?????
?????. ? ????? ?? ?????, ?????? ???????, ???
??? ? ????.
ASNCLP ?? Q subscription ??
ASNCLP??, CREATE QSUB ?? ???? Q subscription? ?????. TARGET NAME??
? DB2 ?? ???? ?????. FEDERATED ???? ???? nickname ?? owner?
???? ???? ??? ? ????.
?? ??, ??? ?? ???? Q subscription? ????? ??? ?????
?????.
- ?? ??? SAMPLE ???.
- Federated Q apply ??? (TARGET ???) FED_DB ???.
- ? DB2 ?? ??? (NONIBM SERVER ???) ORACLE_TARGET ???.
- ?? ? ??(REPLQMAP ???) SAMPLE_ASN_TO_FED_DB_ASN ???.
- Q subscription ?? (SUBNAME ???) FEDSUB ???.
- ??? ??????? ?? ???? EMPLOYEE ???.
- Federated Q apply ???? EMPLOYEE ???? ???? nickname? EMPNICKNAME ???.
- Q subscription ? ?? (E) ??? ??? ?????.(HAS LOAD PHASE ???)
ASNCLP SESSION SET TO Q REPLICATION;
SET SERVER CAPTURE TO DB SAMPLE;
SET SERVER TARGET TO DB FED_DB NONIBM SERVER ORACLE_TARGET;
SET CAPTURE SCHEMA ASN;
SET QMANAGER QM1 FOR CAPTURE SCHEMA;
SET QMANAGER QM2 FOR APPLY SCHEMA;
CREATE QSUB USING REPLQMAP SAMPLE_ASN_TO_FED_DB_ASN (SUBNAME FEDSUB
TARGET NAME EMPLOYEE FEDERATED EMPNICKNAME OPTIONS
HAS LOAD PHASE E);
? DB2 ??? ?? Q ?? ??
? DB2 ??? ?? Q ??? ???? ??? DB2 ???? ??? ?????.
???? WS MQ ??? ???? ???? ??? ???????.
???? ??, ??? ??? ?????.
?? ??? WS QM ???, ?, ?? ?? ???? ??? ???.
Q capture ??, ? DB2 ??, federated Q apply ??? ???? ??? ???.
wrapper, server ??, user mapping? ???? ??? ???.
?? ???, ?? ? ? ? Q subscription? ???? ??? ???.
??
? DB2 ???? Q ??? ????? ??? ??? ??????.
1. Q capture?? Q apply? Q apply?? Q capture ?? WS MQ ??? ??????.
A. ?? ??? ?? ??? ??? ?? ? ???? ????? ??????.
strmqm
source_queue_manager_name
strmqm
target_queue_manager_name
B. ?? ??? ???? ????? ?? ???? ???? ?? ? ???? ????
??????.
runmqlsr -t tcp -m
source_queue_manager_name -p
source_port_numer
** ??? ????? runmqlsr ??? ???? ??? ???? ??? ??, ??
???? ??? ??? ? ????. UNIX ? Linux??? ??? ?? '%'? ??????.
C. ?? ??? ???? ?? ? ???? ?? ??? ??????.
runmqsc
source_queue_manager_name
D. ?? ??? ???? ???? sender ??? ??????.
start channel (
source_sender_channel_name)
E. end ??? ???? ?? ? ????? ?? ??? ??????
F. ?? ??? ???? ?????? ?? ???? ???? ?? ? ????
???? ??????.
runmqlsr -t tcp -m
target_queue_manager_name -p
target_port_numer
G. ?? ??? ???? ?? ? ???? ?? ??? ??????.
runmqsc
target_queue_manager_name
H. ?? ??? ???? ???? sender ??? ??????.
start channel (
target_sender_channel_name)
2. Q capture ????? ??????.
3. Q apply ????? ??????.
Federated Q ??? ????
?? ??? WSII V8.1 FP9? ?? ? ??? ?? ???????.
?? ????
- asntdiff ? anstrep ????? DB2 ?? ???? federated Q apply ???
nickname?? ??? ??? ???? ???.
- ??? ???? Q subscription ? ADDCOL ???? ???? ??? ?????
? ??, ?? ??? ? nickname? ?? ??? ???? ???.
(nickname?? ??? ??? ? ????.)
??? ?? ????
- LOB ??? ??? ??? ???? ???? NET8 wrapper? ??? ???.
- GRAPHIC, VARGRAPHIC, DBCLOB ??? ??? ???? ????, ??? ??? 9
????? ???. ?? ?? ?? ?? 9????? ???.
- ??? ? Sybase?? LONG VARGRAPHIC ??? ??? FP 9??? ???? ????.
- Sybase : ?? ???? ??? LONG VARCHAR? ??? ??, nickname? VARCHAR(32672)
??? ?????. LONG VARCHAR? ?? ??? 32672 ?????, ???? ???
? ????.
XpertMon for DB2 UDB V2
DB ???
Tel : 02-2108-1458
Fax : 02-2108-1459
Mobile : 011-896-6545
E-mail :
hjlee@iteg.co.kr
URL :
http://iteg.co.kr