IBM solidDB
IBM solidDB Universal Cache
V6.3
IBM solidDB Universal Cache C'8O
S151-1149-00
IBM solidDB
IBM solidDB Universal Cache
V6.3
IBM solidDB Universal Cache C'8O
S151-1149-00
yw
Z 9C>JO0d'VDz 7 .0,k D AZ 69 3 D :yw ;PD E"#
>f >JCZ IBM solidDB(z7 `E 5724-V17) M IBM solidDB Universal Cache(z7 `E 5724-W91)V6R3 0y
P sx"P f M ^)f,1=Z B f>Pm P yw*9#
© Solid Information Technology Ltd. 1993, 2008
?<
< .................v
m .................vii
X Z>Va .............ix
!"<( ...............ix
o(m> (<( .............x
1 IBM solidDB Universal Cache Ev ..1
solidDB Universal Cache De5a9Ev .....2
Universal Cache dC ............3
& \ .................6
^ F .................6
} ]b^F ..............6
CDC ^F ..............7
2 +M O $ ...............8
2 20 solidDB Universal Cache ....9
3 dC solidDB Universal Cache . . . 11
dC solidDB Ms K}]~qw .......11
dC solidDB .............11
dCsK}]~qw ..........12
4( CDC 5} .............12
hC4 F$) ..............12
4 solidDB Universal Cache JOiv 15
@ " solidDB ~qw "zJO ........15
CDC 5}"zJO ............15
&Z HA ==(HotStandby)PD solidDB ~qw "
z JO ................16
w solidDB ~qwM CDC for solidDB 5} .dD
(E47"zJO ............16
sK~qwr sKZc"zJO ........17
sKw~qw "zJO ...........17
5 JOoO .............19
XZ>Z ...............21
XZ InfoSphere CDC for IBM solidDB .....21
20 InfoSphere CDC ...........21
9C;% =204 20 InfoSphere CDC ....21
9C2,204 20 InfoSphere CDC .....22
dC InfoSphere CDC (Windows) ......22
dC InfoSphere CDC 5}( Windows) ....23
dC InfoSphere CDC(UNIX M Linux) ....25
dC InfoSphere CDC 5}( UNIX M Linux)..25
t/M#9 InfoSphere CDC .........28
t/ InfoSphere CDC ..........28
#9 InfoSphere CDC ..........29
Z \mXF(P tC SQL o d .......29
InfoSphere CDC
'VD}]`M ............30
'VD3d .............31
InfoSphere CDC *}]m ..........31
CZ InfoSphere CDC D|n ........32
9 C InfoSphere CDC |n ........32
h C TSINSTANCE 73d? .......33
X F4 F |n .............33
} ]b B qU>|n ..........35
\ m*CZ 4FDm|n .........39
` S4F|n .............43
< vM < kdC|n ..........47
d {|n ..............48
CZ InfoSphere CDC D
CZmMP6 pYwD f"}LC'vZ ....52
(ef"}LC' v Z ..........52
f"}LC' vZ}] b,S .......52
9 Cf"}L C 'vZ4lw } ] ......52
f"}LC' vZD>} .........56
CZ InfoSphere CDC Dy>C'vZ ....57
e;bvsFm ............59
Management Console Administration Guide D=< ..61
d CC'vZ .............61
InfoSphere CDC for IBM solidDB D53N} ..63
'VD}]`M .......30
C 'vZ .......51
6 CDC for solidDB .........21
y w ................69
iii
iv IBM solidDB: Universal Cache C'8O
<
1. solidDB Universal Cache e5a9 .....2
2. solidDB Universal Cache 1!? p .....4
3. _P solidDB _ICTD solidDB Universal
Cache ?p .............5
v
vi IBM solidDB: Universal Cache C'8O
m
1. !"<( ..............ix
2. o(m> (<( ...........x
3. solidDB Universal Cache DD 5 ......9
vii
viii IBM solidDB: Universal Cache C'8O
X Z>Va
!"<(
IBM®solidDB®Universal Cache GCZ a_yZELD + 3 SQL }]~qw+ d YH
Dbv=8,|(};vr` vsolidDB Zf} ]b5}_Y:f&C LrM } ]~q
®
w .dD}]w? #IBM
InfoSphere™Change Data Capture <uICZ 5V solidDB
M}]~qw 5}dD }]4F#
> 8Oa) solidDB Universal Cache EvT0 solidDB Universal Cache D20Md
C8>E"#mb,9|(JO& m<rMJ OoO=8#>8ODns;Z |,P
X gN20 M dC InfoSphere CDC for solidDB Dj8 8 >E"# d C solidDB Uni-
versal Cache 1h*>Z;|
Capture
n UC'D5
C'Va`TUDE "#
a )KkCZsK}]~qwD InfoSphere Change Data
> VaY(A _Q_ 8 ;cT DBMS *6,"R l $ SQL M solidDB #
solidDB D59CBP !"<(:
m1.!"<(
q=JCZ
}]bm KVeCZ yPU(D >#
NOT NULL ICKVeD s4V88> SQL X| V Mj{F#
solid.ini b)Ve8>D~{M76mo =#
SET SYNC MASTER YES;
COMMIT WORK;
run.sh KVeCZ y>|nP#
TRIG_COUNT() KVeCZ /
java.sql.Connection KVeCZ SZ{F#
LockHashSize KVeCZ N}{"/ } T d?M Windows
argument K`?w J 8>C'r&C LrX k a)D E "#
\m8O
D~76m> D~764 UNIX
K VeCZ Lr z kMLrd v #>} SQL od2 9 C K V
e#
}{#
®
"amu?#
bVy=CZ }Cd{D5r _,;D5P D BZ#BuoM
?wD Jb24Ky=i 4#
®
q=a)#1 \(/)V{m>2 0 y?
<#
ix
m1.!"<( (x
q=JCZ
)
o(m> (<(
Y w53 g{D5|,P X Y w53.dD n pDZ], G 4WHa =
DG UNIX q =#Microsoft
.s"(Z (E P #d{Yw53+%@Pv # TZ;,D Y
w539I\P; ,DBZx Phv#
®
Windows q=;Z UNIX q=
solidDB D59CBP o(m >(<(:
m2.o(m> (<(
q=JCZ
INSERT INTO table_name
solid.ini KVe8>D~{M76m o=#
[] =(E8>I!n;g{ GVeD>,G4 Xk+ =(E| ,
| z_,CZ +o(PPD=v%b! nVt*#
{} s(ECZ To(PPD;i%b!nx P (g;g{G Ve
o(hvI CKVe#I f;?V I C
Z o(P#
> ,G4 X k+s(E| (Zo(P#
D
K
Ve#
... !TE8 > IT`NX4 9 CTd?#
.
.
.
I}vciI D;Pm>b GH0zkP DSx#
x IBM solidDB: Universal Cache C'8O
1 IBM solidDB Universal Cache Ev
IBM solidDB Universal Cache GCZ SY+3DyZ ELD }]bDb v=8#|O
"K_Y solidDB 0KZf}]b, K }]bJmz 9 CZsK}]bP&m&C Lr
:Xyhl&1dD; !?V44 PK}L#b+ DFT\"a _YHMuYH}1
d#
} K solidDB 0
ture(;F* InfoSphere CDC r CDC)<uxP }]4F#0K MsK}]b y*T
| ,}]b\m53(DBMS)#
":;\+ solidDB Universal Cache k solidDBD Z ?_Y:f( :eX )l}#Z
?_Y:fCZ 9 solidDB }]b~qwPD I/O Yw|P'
K}]b.b,b v=89{C IBM InfoSphere Change Data Cap-
#
1
solidDB Universal Cache De5a9Ev
B <Y}5wK solidDB Universal Cache Dd MdCDe 5 a9M X |i ~ #
<
1. solidDB Universal Cache
e 5a9
Bfh vKi~DG+M&\#
solidDB - IrdP"S P 4F}]D0K}]b#y] 4 F#M,solidDB ITG4
M/r?j}]b#
} ]~qw - IrdP"S P 4 F }]DsK } ] b #
T G4M/r?j } ]b#
CDC 5} - CZ X( DBMS D CDC }fDKP15 }# * hC CDC 5} ,X
kZvVJbD DBMS }ZdPKPD`,ZcO20`&D CDC zmLrm~( g
2 IBM solidDB: Universal Cache C'8O
y] 4F==,sK }]bI
CDC for DB2®r CDC for solidDB)#solidDB G}biv,z ITZk} ZKP
solidDB DZ c`,S DNNZ cO20M hC CDC for solidDB zmLr#
d C$_ - CZdCM4( CDC 5}DIS(yZ GUI D )$_#ZdC5} 1 ,
&a) CZkd ` CDC 53( EDKZEMCZ ,SA}] b DG< E "
C J ~ qw - Jm\mXF(C'CJ CDC 5 } "Tdx P dCDxL ((#w*
~qrX $LrK P)#;,C'ICJ ;,D5} #ZCJ ~qw20 Zd,53*
s za)\ mXF (+9CDKZEM \m1 G <E"#
#
\mXF
wV~qwOD 4F"8( 4FN}T0SM'z $w>t/"BM5q Yw#
(}Z“CJ \mw” 8S <P4(}] f"w4*<9 C\ mX F(#}]f" w G
M `X CDC 5}D_- 5 e# 9 CQ(e D } ]f" w,IThC$) ,C$
}]b
)|,}]f" wdD } ]4F#
;2P}V`MD}]f" w:4"?j T 0+X#g{}]f" w Q 4(*+X}
]f" w,G4|ITw*4M?jNk$)#
versal Cache dO9C,"RTF 3dTQ (e CZ+r4F#g{ 1>Z0Kr cw
*;A1>,G4 (e%vOX$ )#
ZhCj4 Fs,I ZM'z $w>O XU \m XF(,x;a0l 4~qwk?j
~qw.dn
mzliQzID CDC B ~{" # `Swa)X*D'V T, xX`S4FYwM H
} 1d#zI(}1SY] < NTs49l G )hf4Fd C i ~ D<#\mX
PD`Sw <ZCZ h*, xVv}]F/D 1dt 1D$w73#
Universal Cache dC
solidDB Universal Cache 'V` Vd C#BPwZhv#CD? pXK,i\KZ; ,
zwO4PD;,z 7i~# d{5) 2GI\D#
( - ICZ dCM`S4 F DxP GUI D ;%=&C Lr#|J m z\m
(#,+X}]f" wk solidDB Uni-
/ D}]4Fn / #\mXF(9| (B~U>M ` S w # B~U>J
F(
CDC for solidDB IT(}>Xk6L JDBC ,S4A!}]T0 + }]ek solidDB
}]b,rKz;XZ,;ZcOEC CDC 5}M solidDB }]b
T Zd{ CDC i~,iv"G \ GgK,-r G 3) } ]b;a)(} 6L,S"S
&\DU>A ! API#
Z Nk CDC 4FD? v ZcO4 ( CDC }]f" w 5 }(1 ! ? p)#CDC ?p!
vZQ9 CD} ]bz7#g{9C
PDNNZ cO#XpGZ HA (HotStandby )d CP,*s CDC 5}k solidDB ~
qwZ;,ZcO KP#
CDC for solidDB,G4 CDC 5}I? pZ53
#;x,k"b ,
solidDB Universal Cache 1!? p
n r%DhC|(0KPD%v solidDB }]bM% v s K }]b#b)$F Z d`&
D(C2 ~OKP#k?v}]bX* D CDC 5}+Zk }]b`, DZ cOKP#
Z zz73P,CDC \mX F (+Z%@ D “\m ” ZcOKP,T^FdT
~ qwT\D0l#
1 IBM solidDB Universal Cache Ev 3
N;}]b
<
2. solidDB Universal Cache
1!? p
_P solidDB _I CTD solidDB Universal Cache ?p
g {0K&C Lrh*^POXCJ}],G4 solidDB HotStandby < u ICZ a)_
ICT# y P HotStandby =f(}g ,`vMCT oeM8 COA!)yJ CZ
solidDB Universal Cache _ICThC#ZKi v B,yP CDC 5}+ZsK Z cO
KP,"R+T6L==("k solidDB HotStandby TD ,
Z cOKP#
(}9C solidDB _I CT,I@90Kc P Universal Cache DYw "z%; JO#
4 IBM solidDB: Universal Cache C'8O
S#\FXF(+Z%@D
<3._P
solidDB
_ICTD
solidDB Universal Cache
? p
9C solidDB HA hF? p1,kGCf.ZzD73P&mJOivD=( #PXZ
solidDB Universal Cache 53P&mJOD =(DE",kND Z 15 3D4 B ,
:solidDB Universal Cache JOiv ;;Z #
_PsK_I CTD solidDB Universal Cache ?p
&C LrZsK}]bO2 I \ _ Pd{_I C T rVQ V 4*s#;,}]b~q
w9C;,< u4 5VK`&\#sK }]bT; G%;_- 5e,+ }]M}ZK
P DxLIV<Z`v Z c O#
Zb)ivB,CDC 5}+ZwsK}
] bZcOKP#;x,w*j{DsK}]b
J O*FD;?V,g{sK"zJO,G4+XkZm;zwOXBt/b) CDC 5
} #Kb,9XkT$)x P X B dC ,TXB,x A `X5 } #
1 IBM solidDB Universal Cache Ev 5
&\
BP solidDB &\I )CZ ?p CDC <uDdC:
v 4SbCJ
IT9C4S bCJ(ODBC M JDBC SYw b)9( solidDB &C Lr ,TdV
{ CZf}]bT\Ml&T# P X|`E",kND6IBM solidDB 4SbCJC
'8O7#
v solidDB _ICT'V
'V solidDB ~qw
T C'8O7#
v wY
g {4F^( ] I solidDB ~qwPDVx:X, G 4a+&mYHwM (u Y )#
S&C LrGH45,ba<Bl&1dS $#+4Fw? fk:ex,TcI T
"TsvD: X #9CdCN} MaxLogSize IX F `&Zf:exDs!#
]I;
P X|`E",kND6IBM solidDB \m 1 8O7 P :~qwKdCN};;ZD
“U>DAw?V ”PDU >DAwd CN}#
v QzYwMU>gv
g {4FQ#9rQ'
)Ts+M#9C MaxLogSize dCN }4 hC[}}]D^ F#1[}}]?,
v MaxLogSize N}D5 1,a"zU>g v,<B;YITxP, =4 F#ZC
i vB,h*Z$ )O"B#PX|
:~qwKdCN} ;;ZD“U>DAw?V ”P DU>DAwd CN} #
v U>DAwo O
m `K P 1F } wICZ ` S solidDB 6q(solidDB w*4 )M&C (solidDB w
*?j)xLDYw#mk ND:}]
v }]`M'V
PDJO*F#P X|`E",kND6IBM solidDB _IC
\,G4 solidDB ~qwI \aLx&m:X,"[}}]T
`E",kND6IBM solidDB \m18O7 P
b^F;;Z PD LOBS `X ^F#
y P solidDB }]`MZ4FP y \ 'V# P X|`E",kNDZ 30 3 D :'V
D}]`M;;Z #
^F
} ]b^F
BP ^FJCZ w*4M?j }]~qwD solidDB#
v }Cj{T(solidDB w*4M?j )
4M?jOy Jm9C} Cj{ T <x(b| )#}Cj{TX*X k^(Z$)6
'Z;b|;IT8r$) T b Dm#g{ % 4Kfr,G4 Z 5q
\a"z}Cj{Tms, Kms+ aax4F$)#
mkNDZ 7 3 D:CDC ^F ;;ZPPXT/4 (mM"B D^F#
v }]`M'V
– ^ D m LOB 'V( solidDB w*4)
6 IBM solidDB: Universal Cache C'8O
Zd?jOI
J m Z I C s! ^ FZ R #t Z M m ( Zf m )P D yP LOB ( F *
miniLOB)#s!^F!vZPs !Mis!#ZY(?P;v LOB DivB,s
!^FS| Zis !#g{is !hC* 32KB,G45J miniLOB s !^Fs
< * 30KB#
solidDB D m(yZEL
P ;\ 'V#K^FaICT B =(5):"T+ maxiLOB 4k(w* U >DA
w Vx;? V D)D m'\ ,"r&C Lr 5 Xms#
– P^ LOB 'V( solidDB w*?j)
g {+ LOB 4 k M m",v miniLOB s!^F,G
)OD4F#
v XO(solidDB w*4 )
w*$);?VDmO ; JmvV TRUNCATE TABLE od#g{ %4Kfr,G
4a+ms5 XA&C Lr#
v w|<x (solidDB w*4 )
(i+;?F *s9Cw|#g{4ZmO( ew|,
|B |P'#w| |BZTB=f\ ^F:
– g{Z%PO(ew|,G4; Jmx Pw|D` P| B#
– fZ`Pw|DivB,g{ ;a0l w|D;?V,G4 Jmx P` P| B#
g{%4 NNO
v 2,mMY1 m (solidDB w*4 )
v fr,G4azzms ,"a x $)OD4F(5q )#
Dm) Ds_ g(n s* 2GB)LOB(maxiLOB)Z4
4a5 Xms,"ax$
G 49Cw|H 4 PekM
g{+ solidDB w*4,G42,mMY1 my; \G $)D;?V#
v UNIQUE PPD`v NULL (solidDB w*?j )
Z solidDB P,(e* UNIQUE DPPA `;\P;v NULL
k d{ NULL +<BvV UNIQUE <x%}Ma x $ )OD4F(5q )#
CDC ^F
d{}]~q wD CDC i~PIC DBP&\Z CDC for solidDB O;\'V#
v lY0kM "B
CDC for solidDB ;'VlY0kM "B&\#
v T/4(?jm
g {k*5 q Dmk} C j{T<x ` X *,G4Z(eB $ )1 ,+^(9CT
/4(?jm (4(B
K fr,G4+^( 4 ($)#
^FJCZ yPd C0 `XDd{ DBMS z 7#
v "B
CDC "B&\ZKivB\ ^ F:y]}Cj{T<x,Z$)D?j=NkDmH
;G}Z}C
5 }# T <+Me
?jm )D!n#z&C9 C3d=V Pm !n#g{%4
Dm2;G Q-}C Dm#
1 IBM solidDB Universal Cache Ev 7
2+M O$
g{?j=;h*b|, G4k4PTBYw:
1. g{VP?jm Q-"B, G4SmPF}b|<x#
2. 4(;xb|D?jm #
3. 4P"B#
4. mSb |<x#
v P}K
P }K(.=Vx )v1Z4 mO(ew|1Ej+pwC#
Nk4FD}]b I}# C'{/ \k zF# $#
v zXk* CDC 5}CZ C J}]bDC'{a) kC JM^D}]k* }]`XD
yPX*>$#( iz9 C}]b\m1 C'{#
v C'{M \k I CDC 53f" Z CDC 5}0d ` &DV
O$}]xP`k,4 , 9C uS\=( xP S\#
v ZyPivB,S\ CDC 5}M }]b.dDw?#ZX(Zz7D JDBC }/L
rPa)rx PS\#
v CDC 5}.dDw? 4-} S \#
CTf" bP#+f" D
8 IBM solidDB: Universal Cache C'8O
2 20 solidDB Universal Cache
* ?p solidDB Universal Cache,h * 20 solidDB"sK}]~qw M `XD CDC
i~#>Za)_ 6p2 0Ev,"}C |`j8 D2 08>E"#
1. 20 IBM solidDB#
P X8>E",kND6kE 8 O7 P D:20 solidDB ;;Z #
2. 20sK}]~qw#
PX8>E",
Change Data Capture
k NDCZ sK}]~qwD CDC i~f=a) D InfoSphere
nUC'D5
#
3. 20 InfoSphere CDC for IBM solidDB#
P Xj8 E",kNDZ 21 3 D :20 InfoSphere CDC ;;Z #
":20ax1 ,20Lr9z\ ;t/dC$_,T4(BD CDC 5}#}GQ
4UZ 11 3 D:dC solidDB ; ;ZP D8>E"jI solidDB d C= h,qr
Pp!qt/dC$_#
20JCZ sK }]~qwD InfoSphere CDC#
4.
P X8>E",kND CZ sK}]~qwD CDC i~f=a) D InfoSphere
Change Data Capture
nUC'D5
#
":20ax1 ,20Lr9z\ ;t/dC$_,T4(BD CDC 5}#}GQ
4UCZ sK}]bD InfoSphere Change Data Capture
n UC'D5
PD 8>E
"jI solidDB dC= h ,qrPp! q t/ d C$_#
5. 20 InfoSphere CDC CJ ~qw#
P X8>E",kND z 7f=D InfoSphere Change Data Capture Access Server
and Management Console, Installation Guide#
6. 20 InfoSphere CDC \mXF(
P X8>E",kND z 7f=D InfoSphere Change Data Capture Access Server
and Management Console, Installation Guide#
7. liT7#I TCJBmPP>D D5#
m
3. solidDB Universal Cache
i~ D5 ;C X |D5
CDC for solidDB |(Z IBM solidDB 6.3
CZ sK}]~qwD CDC |(Z InfoSphere Change Data Capture v6.3
CDC \mXF( | (Z InfoSphere Change Data Capture v6.3
CDC CJ ~qw ^@" D5,kND\mXF( D5 ^@" D5,kND\mXF( D5
D D5
D5
D5
Lr|P
Lr|P
D5
Lr|P 6IBM solidDB Universal Cache C' 8
O7,:CDC for solidDB ;Z
InfoSphere Change Data Capture
C'D5
InfoSphere Change Data Capture Management Console, Administration Guide
nU
9
10 IBM solidDB: Universal Cache C'8O
3 dC solidDB Universal Cache
* dC solidDB Universal Cache,zh * HdC0KMs K }]~qw, T ck Uni-
versal Cache dO9C,; s4(k}]~qwT &D CDC 5},nshC|G .d
D4F$)#
dC solidDB MsK}]~qw
dC solidDB
* K\;+ solidDB k CDC <udO 9 C , z h* ^ DdC h C ,T c CDC for
solidDB IT,SA solidDB }]brSP4 F }]#mb,9XkhC CLASSPATH
7 3d?,Tj6 solidDB JDBC }/LrD;C,C } /Lr9 CDC for solidDB \
;CJ solidDB }]b#
1. + solidDB dCD~( solid.ini)PD LogReaderEnabled
“yes”#
[LogReader]
LogReaderEnabled=yes
* K\;Z CDC 4FP + solidDB Cw 4 }]b,h*4 P KYw#v' 5 *
“no”#
2. Z solidDB dCD~( solid.ini)Ph CBqU >#t1dU ds!#
dCN}h C*
9CdCN } MaxLogSize TKxPhC#
[LogReader]
MaxLogSize=<MB>
v' 5* 10 240 (10 GB )#g{QtC U >DAw(kNDOv = h 1 ),G4a
< U j + 9 C y 8( U > D~ #t 1d U d #g {4 4P 8] ,r _N }
CheckpointDeleteLog 4hC * “Yes”,G4U> D ~I\a<C|` U d #
3. gPX*,k^Dd{dCN}
v DurabilityLevel
1 !ivB,solidDB ~qwMCT6phC * m I(DurabilityLevel=1 )#g{
solidDB ~qwbbX "zJO,G4 byI\a<BnBBq* ' Di v#
* @9Kiv, k IC“solid.ini” D ~PDBPh C ,+MCT 6 phC * Oq:
[Logging]
DurabilityLevel=3
":k m IDMCThC`H , O q DMCThCa} p T \ p'#g{T
solidDB HA (HotStandby )dC &C 2-Safe 4F-i(1! 5 ),G4IT9C
mIDMCT,x;afZ} ]*' D#U#
v DefaultStoreIsMemory
#
1 !ivB,solidDB mf" `MhC* M m(DefaultStoreIsMemory=yes)#
11
v IsolationLevel
1 !ivB,solidDB tk6phC*d 5 A(IsolationLevel=1 )#
4. liGqQhC CLASSPATH 73d?, Tc||( solidDB JDBC }/Lr
.jar D~# P X8>E", kND solidDB 20?< P D JDBC T vD~
(jdbcreadme.html r jdbcreadme.txt )#
dCsK}]~qw
*K\;+sK}]~ qwk CDC 4F<udO 9 C,zI \h*|D ddCh C#
4( CDC 5}
y]fz7a)D InfoSphere Change Data Capture
s K}]~qw#
9C CDC dC$_IT4( CDC 5}#
n UC'D5
PD 8>E"4d C
*<.0
v li solidDB Ms K}]b Gq}ZK P#
v zT}]b _Pc;DCJX(#
1. 4( CDC for solidDB DB5}#
P Xj8 D8>E",kND Z 22 3 D :dC InfoSphere CDC (Windows ) ;r
Z 25 3 D:dC InfoSphere CDC(UNIX M Linux) ;BZ #
":g{dCI?p solidDB _ I CT,G4 z h
solidDB ~qwDwz X7MKZ E#
2. 4(CZ sK}]~qw CDC DB 5}#
PXj8 D8>E",kND CZsK}]~qwD InfoSphere Change Data Cap-
n UC'D5 P D d C
ture
InfoSphere CDC ;Z#
*(ew solidDB ~qwM( z
*c:CZ sK}]~qwD CDC D Z(zk G SOLIDDBCACHE#
hC4 F$)
4 F$)I Z \mX F (P 4(#> Z a) _ 6pw}LL E v,"}C InfoSphere
Change Data Capture Management Console, Administration Guide PD|`j8 8>E
"#
*<.0
v li*4FDmGqfZZ solidDB Ms K}]bO#g{m4|,b|,G4 z 2
ITZ4FZd4(m#
v li solidDB Ms K}]b Gq}ZK P#
v liCZ solidDB D CDC 5}Ms K }]~qw Gq}ZK P#
v zT}]b _Pc;DCJX(#
v Qy
12 IBM solidDB: Universal Cache C'8O
]5qfr( eyhD4F-r #
1. G<\mXF(/,S ACJ ~qw#
P Xj8 D8>E",kND InfoSphere Change Data Capture Management Con-
sole, Administration Guide PD Logging into Management Console (Connecting to
Access Server) ;Z#
a>:*K\;Z \mXF(D“C J\mw”8S <P $w,zXkG_P }]
f"wMC'J '\mX(D53 \m1#53 \m1J 'GZ 20\mXF(
Zd4(D#
2. hCCZ
solidDB Ms K}]bD }]f" w#
a. mSB}]f" w# PXj8 D8>E",kND InfoSphere Change Data Cap-
ture Management Console, Administration Guide PD To add a new datastore
;Z#
b. hC,SN}# PX j8D8>E",kND InfoSphere Change Data Cap-
ture Management Console, Administration Guide PD To set connection parameters on a datastore ;Z#
3. +}]f" wVdxC'#
z h**, ;C'Vd solidDB }]f"wMs K } ]
f"w#
a. gPX*,kmSB C '# *K\;mSB C ',zXkG_ PC 'J '\m
X(D53\m1#PXj8 D8>E",kND Management Console Admin-
istration Guide PD Managing user accounts ;Z#
b. +}] f"wVdxC'# P X j8D8>E",kND Management Con-
sole Administration Guide PD Assigning users to datastores ;Z#
c. *9
|Dz',kO*,S ,;sX B,SACJ ~qw#
1) %wD~ > CJ ~qw > O*,S#
2) %wD~ > CJ ~qw > ,S#
4. (I! )*,SA}]f" wh C ,SW!n# z2I TLx9C1 !hC#
PXj8 D8>E",kND
InfoSphere Change Data Capture Management Con-
sole, Administration Guide PD Setting connection preferences ;Z#
5. *4Fh C}]f" w#
a. ,SA solidDB }]f" w#
b. ,SAsK}]f" w#
P Xj8 D8>E",kND InfoSphere Change Data Capture Management Con-
sole, Administration Guide PD Setting up datastores for replication ;Z#
6. (I! )Z solidDB Ms K}]f" wOh C53N }#
P Xj8 D8>E",kND InfoSphere Change Data Capture Management Con-
sole, Administration Guide PD Setting system parameters on source and target
datastores ;Z#
7. hC$)#
a. mS$),dP solidDB G4,sK }]f" w G?j#
b. mS$),dPs K}]f" w G 4, solidDB G?j#
P Xj8 D8>E",kND InfoSphere Change Data Capture Management Con-
sole, Administration Guide PD Setting up subscriptions ;Z#
8. *=v$)PD 4F3dm#
3 dC solidDB Universal Cache 13
P Xj8 D8>E",kND InfoSphere Change Data Capture Management Con-
sole, Administration Guide PD Mapping tables ;Z#
a >:*4P Universal Cache,z&C* 4 F =( !q“5q ” (Change Data Cap-
ture)#
9. TZ?vm 3d,ky]5qfr hCe;lbMbv#
P Xj8 D8>E",kND InfoSphere Change Data Capture Management Con-
sole, Administration Guide PD Setting conflict detection and resolution ;Z#
10. t/=v$ )OD
P Xj8 D8>E",kND InfoSphere Change Data Capture Management Con-
sole, Administration Guide PD Starting and ending replication on subscriptions ;
Z#
4F#
14 IBM solidDB: Universal Cache C'8O