?????. 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