Oracle GoldenGate _ DB2 to Oracle _ Rick Miners' Oracle Blog.pdf
5墨值下载
2
0
1
7
/
7
/
7
O
r
a
cl
e
G
o
l
d
e
n
G
a
t
e
:
D
B
2
t
o
O
r
a
cl
e
|
R
i
ck
M
i
n
e
r
s'
O
r
a
cl
e
B
l
o
g
h
t
t
p
s:
/
/
m
i
n
e
r
so
r
a
cl
e
b
l
o
g
.
w
o
r
d
p
r
e
ss.
co
m
/
2
0
1
4
/
0
8
/
2
5
/
o
r
a
cl
e
-
g
o
l
d
e
n
g
a
t
e
-
d
b
2
-
t
o
-
o
r
a
cl
e
/
1
/
6
Rick Miners' Oracle Blog
An Oracle Blog
Oracle GoldenGate : DB2 to Oracle
This entry was posted on A
ugust 25, 2014, in
GoldenGate, Oracle
. Bookmark the
permalink. Leave a comment
This article will demonstrate heterogeneous replication using OGG from DB2 to Oracle.
1.
Pre-requisites
OGG is installed on source and target systems.
2.
Environment
DB2 on Mainfram Z/OS
Oracle Database : 11.2.0.3
3. Configuration on Source
Server ( DB2 )
2
0
1
7
/
7
/
7
O
r
a
cl
e
G
o
l
d
e
n
G
a
t
e
:
D
B
2
t
o
O
r
a
cl
e
|
R
i
ck
M
i
n
e
r
s'
O
r
a
cl
e
B
l
o
g
h
t
t
p
s:
/
/
m
i
n
e
r
so
r
a
cl
e
b
l
o
g
.
w
o
r
d
p
r
e
ss.
co
m
/
2
0
1
4
/
0
8
/
2
5
/
o
r
a
cl
e
-
g
o
l
d
e
n
g
a
t
e
-
d
b
2
-
t
o
-
o
r
a
cl
e
/
2
/
6
A. Parameter Files
Place all parameter files in the $GG_HOME/dirprm directory.
Extract Capture
E
xtract Data Pump
E
xtract for Initial Load
B. Add Trandata
1
2
3
4
5
6
7
8
> cat cdb2.prm
extract cdb2
--trailcharsetascii
s
ourcedb db2t, userid ggcap, password ggcap
e
xttrail ./dirdat/lt
transmemory directory(./dirtmp, 450m, 450m),transallsources 450m
table user.table1;
1
2
3
4
5
6
7
> cat pdb2.prm
extract pdb2
rmthost target_server, mgrport 7809
r
mttrail ./dirdat/rt
passthru
table user.table1;
1
2
3
4
5
6
7
8
> cat ildb2.prm
e
xtract ildb2
sourceistable
s
ourcedb db2t, userid ggcap, password ggcap
rmthost target_server, mgrport 7809, tcpbufsize 1048576, tcpflushbytes 1048576
rmtfile ./dirdat/la, megabytes 2048, maxfiles 999
TABLE user.table1;
1
c
d $GG_HOME
of 6
5墨值下载
【版权声明】本文为墨天轮用户原创内容，转载时必须标注文档的来源（墨天轮），文档链接，文档作者等基本信息，否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容，欢迎发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。
下载排行榜
评论