IBM solidDB User Manual

Download

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

Z9C>JO0d'VDz7.0,kDAZ 69 3D:yw;PDE"#

>f>JCZ IBM solidDB(z7`E 5724-V17)M IBM solidDB Universal Cache(z7`E 5724-W91)V6R3 0y Psx"PfM^)f,1=ZBf>PmPyw*9#

< .................v

m .................vii

XZ>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+MO$ ...............8

2 20 solidDB Universal Cache ....9

3 dC solidDB Universal Cache . . . 11

dC solidDB MsK}]~qw .......11

dC solidDB .............11

dCsK}]~qw ..........12

4( CDC 5} .............12

hC4F$) ..............12

4 solidDB Universal Cache JOiv 15

@" solidDB ~qw"zJO ........15

CDC 5}"zJO ............15

&Z HA ==(HotStandby)PD solidDB ~qw"

zJO ................16

w solidDB ~qwM CDC for solidDB 5}.dD

(E47"zJO ............16

sK~qwrsKZc"zJO ........17

sKw~qw"zJO ...........17

5 JOoO .............19

XZ>Z ...............21

XZ InfoSphere CDC for IBM solidDB .....21

20 InfoSphere CDC ...........21

9C;%=20420 InfoSphere CDC ....21

9C2,20420 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(PtC SQL od .......29

InfoSphere CDC

'VD}]`M ............30

'VD3d .............31

InfoSphere CDC *}]m..........31

CZ InfoSphere CDC D|n ........32

9C InfoSphere CDC |n ........32

hC TSINSTANCE 73d? .......33

XF4F|n .............33

}]bBqU>|n ..........35

\m*CZ4FDm|n .........39

`S4F|n .............43

<vM<kdC|n ..........47

d{|n ..............48

CZ InfoSphere CDC D

CZmMP6pYwDf"}LC'vZ ....52

(ef"}LC'vZ ..........52

f"}LC'vZ}]b,S .......52

9Cf"}LC'vZ4lw}] ......52

f"}LC'vZD>} .........56

CZ InfoSphere CDC Dy>C'vZ ....57

e;bvsFm ............59

Management Console Administration Guide D=< ..61

dCC'vZ .............61

InfoSphere CDC for IBM solidDB D53N} ..63

'VD}]`M .......30

C'vZ .......51

6 CDC for solidDB .........21

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

vi IBM solidDB: Universal Cache C'8O

1. !"<(..............ix

2. o(m>(<( ...........x

3. solidDB Universal Cache DD5 ......9

vii

viii IBM solidDB: Universal Cache C'8O

XZ>Va

!"<(

IBM®solidDB®Universal Cache GCZa_yZELD+3 SQL }]~qw+dYH Dbv=8,|(};vr`vsolidDB Zf}]b5}_Y:f&CLrM}]~q

w.dD}]w?#IBM

InfoSphere™Change Data Capture <uICZ5V solidDB

M}]~qw5}dD}]4F#

>8Oa) solidDB Universal Cache EvT0 solidDB Universal Cache D20Md C8>E"#mb,9|(JO&m<rMJOoO=8#>8ODns;Z|,P

XgN20MdC InfoSphere CDC for solidDB Dj88>E"#dC solidDB Uni- versal Cache 1h*>Z;|

Capture

nUC'D5

C'Va`TUDE"#

a)KkCZsK}]~qwD InfoSphere Change Data

>VaY(A_Q_8;cT DBMS *6,"Rl$ SQL M solidDB#

solidDB D59CBP!"<(:

m1.!"<(

q=JCZ

}]bm KVeCZyPU(D>#

NOT NULL ICKVeDs4V88> SQL X|VMj{F#

solid.ini b)Ve8>D~{M76mo=#

SET SYNC MASTER YES; COMMIT WORK;

run.sh KVeCZy>|nP#

TRIG_COUNT() KVeCZ/

java.sql.Connection KVeCZSZ{F#

LockHashSize KVeCZN}{"/}Td?M Windows

argument K`?wJ8>C'r&CLrXka)DE"#

\m8O

D~76m> D~764 UNIX

KVeCZLrzkMLrdv#>} SQL od29CKV e#

}{#

"amu?#

bVy=CZ}Cd{D5r_,;D5PDBZ#BuoM

?wDJb24Ky=i4#

q=a)#1\(/)V{m>20y?

m1.!"<((x

q=JCZ

)

o(m>(<(

Yw53 g{D5|,PXYw53.dDnpDZ],G4WHa=

DG UNIX q=#Microsoft

.s"(Z(EP#d{Yw53+%@Pv#TZ;,DY w539I\P;,DBZxPhv#

Windows q=;Z UNIX q=

solidDB D59CBPo(m>(<(:

m2.o(m>(<(

q=JCZ

INSERT INTO table_name

solid.ini KVe8>D~{M76mo=#

[] =(E8>I!n;g{GVeD>,G4Xk+=(E|,

| z_,CZ+o(PPD=v%b!nVt*#

{} s(ECZTo(PPD;i%b!nxP(g;g{GVe

o(hvICKVe#If;?VIC

Zo(P#

>,G4Xk+s(E|(Zo(P#

Ve#

... !TE8>IT`NX49CTd?#

. . .

I}vciID;Pm>bGH0zkPDSx#

x IBM solidDB: Universal Cache C'8O

1 IBM solidDB Universal Cache Ev

IBM solidDB Universal Cache GCZSY+3DyZELD}]bDbv=8#|O

"K_Y solidDB 0KZf}]b,K}]bJmz9CZsK}]bP&m&CLr :Xyhl&1dD;!?V44PK}L#b+DFT\"a_YHMuYH}1

}K solidDB 0 ture(;F* InfoSphere CDC r CDC)<uxP}]4F#0KMsK}]by*T |,}]b\m53(DBMS)#

":;\+ solidDB Universal Cache k solidDBDZ?_Y:f(:eX)l}#Z ?_Y:fCZ9 solidDB }]b~qwPD I/O Yw|P'

K}]b.b,bv=89{C IBM InfoSphere Change Data Cap-

solidDB Universal Cache De5a9Ev

B<Y}5wK solidDB Universal Cache DdMdCDe5a9MX|i~#

1. solidDB Universal Cache

e5a9

BfhvKi~DG+M&\#

solidDB - IrdP"SP4F}]D0K}]b#y]4F#M,solidDB ITG4

M/r?j}]b#

}]~qw - IrdP"SP4F}]DsK}]b# TG4M/r?j}]b#

CDC 5} - CZX( 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,zITZk}ZKP solidDB DZc`,SDNNZcO20MhC CDC for solidDB zmLr#

dC$_ - CZdCM4( CDC 5}DIS(yZ GUI D)$_#ZdC5}1, &a)CZkd` CDC 53(EDKZEMCZ,SA}]bDG<E"

CJ~qw - Jm\mXF(C'CJ CDC 5}"TdxPdCDxL((#w* ~qrX$LrKP)#;,C'ICJ;,D5}#ZCJ~qw20Zd,53*

sza)\mXF(+9CDKZEM\m1G<E"#

\mXF

wV~qwOD4F"8(4FN}T0SM'z$w>t/"BM5qYw#

(}Z“CJ\mw”8S<P4(}]f"w4*<9C\mXF(#}]f"w G

M`X CDC 5}D_-5e#9CQ(eD}]f"w,IThC$),C$

}]b )|,}]f"wdD}]4F#

;2P}V`MD}]f"w:4"?jT0+X#g{}]f"wQ4(*+X} ]f"w,G4|ITw*4M?jNk$)#

versal Cache dO9C,"RTF3dTQ(eCZ+r4F#g{1>Z0Krcw

*;A1>,G4(e%vOX$)#

ZhCj4Fs,IZM'z$w>OXU\mXF(,x;a0l4~qwk?j

~qw.dn

mzliQzID CDC B~{"#`Swa)X*D'VT,xX`S4FYwMH

}1d#zI(}1SY]<NTs49lG)hf4FdCi~D<#\mX PD`Sw<ZCZh*,xVv}]F/D1dt1D$w73#

Universal Cache dC

solidDB Universal Cache 'V`VdC#BPwZhv#CD?pXK,i\KZ;,

zwO4PD;,z7i~#d{5)2GI\D#

( - ICZdCM`S4FDxP GUI D;%=&CLr#|Jmz\m

(#,+X}]f"wk solidDB Uni-

/D}]4Fn/#\mXF(9|(B~U>M`Sw#B~U>J

CDC for solidDB IT(}>Xk6L JDBC ,S4A!}]T0+}]ek solidDB }]b,rKz;XZ,;ZcOEC CDC 5}M solidDB }]b

TZd{ CDC i~,iv"G\GgK,-rG3)}]b;a)(}6L,S"S &\DU>A! API#

ZNk CDC 4FD?vZcO4(CDC }]f"w5}(1!?p)#CDC ?p! vZQ9CD}]bz7#g{9C

PDNNZcO#XpGZ HA(HotStandby)dCP,*s CDC 5}k solidDB ~

qwZ;,ZcOKP#

CDC for solidDB,G4 CDC 5}I?pZ53

#;x,k"b,

solidDB Universal Cache 1!?p

nr%DhC|(0KPD%v solidDB }]bM%vsK}]b#b)$FZd`& D(C2~OKP#k?v}]bX*D CDC 5}+Zk}]b`,DZcOKP# Zzz73P,CDC \mXF(+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 _ICTD solidDB Universal Cache ?p

g{0K&CLrh*^POXCJ}],G4 solidDB HotStandby <uICZa)_ ICT# yP HotStandby =f(}g,`vMCToeM8COA!)yJCZ

solidDB Universal Cache _ICThC#ZKivB,yP CDC 5}+ZsKZcO KP,"R+T6L==("k solidDB HotStandby TD, ZcOKP#

(}9C solidDB _ICT,I@90KcP Universal Cache DYw"z%;JO#

4 IBM solidDB: Universal Cache C'8O

S#\FXF(+Z%@D

<3._P

solidDB

_ICTD

solidDB Universal Cache

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_ICTD solidDB Universal Cache ?p

&CLrZsK}]bO2I\_Pd{_ICTrVQV4*s#;,}]b~q w9C;,<u45VK`&\#sK}]bT;G%;_-5e,+}]M}ZK

PDxLIV<Z`vZcO#

Zb)ivB,CDC 5}+ZwsK}

]bZcOKP#;x,w*j{DsK}]b

JO*FD;?V,g{sK"zJO,G4+XkZm;zwOXBt/b) CDC 5 }#Kb,9XkT$)xPXBdC,TXB,xA`X5}#

1 IBM solidDB Universal Cache Ev 5

BP solidDB &\I)CZ?p CDC <uDdC:

v 4SbCJ

IT9C4SbCJ(ODBC M JDBC SYwb)9( solidDB &CLr,TdV {CZf}]bT\Ml&T#PX|`E",kND6IBM solidDB 4SbCJC

'8O7#

v solidDB _ICT'V

'V solidDB ~qw TC'8O7#

v wY

g{4F^(]I solidDB ~qwPDVx:X,G4a+&mYHwM(uY)# S&CLrGH45,ba<Bl&1dS$#+4Fw?fk:ex,TcIT

"TsvD:X#9CdCN} MaxLogSize IXF`&Zf:exDs!#

]I;

PX|`E",kND6IBM solidDB \m18O7P:~qwKdCN};;ZD “U>DAw?V”PDU>DAwdCN}#

v QzYwMU>gv

g{4FQ#9rQ' )Ts+M#9C MaxLogSize dCN}4hC[}}]D^F#1[}}]?,

v MaxLogSize N}D51,a"zU>gv,<B;YITxP,=4F#ZC

ivB,h*Z$)O"B#PX| :~qwKdCN};;ZD“U>DAw?V”PDU>DAwdCN}#

v U>DAwoO

m`KP1F}wICZ`S solidDB 6q(solidDB w*4)M&C(solidDB w *?j)xLDYw#mkND:}]

v }]`M'V

PDJO*F#PX|`E",kND6IBM solidDB _IC

\,G4 solidDB ~qwI\aLx&m:X,"[}}]T

`E",kND6IBM solidDB \m18O7P

b^F;;ZPD LOBS `X^F#

yP solidDB }]`MZ4FPy\'V#PX|`E",kNDZ 30 3D:'V D}]`M;;Z#

}]b^F

BP^FJCZw*4M?j}]~qwD solidDB#

v }Cj{T(solidDB w*4M?j)

4M?jOyJm9C}Cj{T<x(b|)#}Cj{TX*Xk^(Z$)6

'Z;b|;IT8r$)TbDm#g{%4Kfr,G4Z5q \a"z}Cj{Tms,Kms+aax4F$)#

mkNDZ 7 3D:CDC ^F;;ZPPXT/4(mM"BD^F#

v }]`M'V

– ^ D m LOB 'V(solidDB w*4)

6 IBM solidDB: Universal Cache C'8O

Zd?jOI

J m ZI 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^FaICTB=(5):"T+ maxiLOB 4k(w*U>DA wVx;?VD)D m'\,"r&CLr5Xms#

– P^ LOB 'V(solidDB w*?j)

g{+ LOB 4k M m",v miniLOB s!^F,G

)OD4F#

v XO(solidDB w*4)

w*$);?VDmO;JmvV TRUNCATE TABLE od#g{%4Kfr,G

4a+ms5XA&CLr#

v w|<x (solidDB w*4)

(i+;?F*s9Cw|#g{4ZmO(ew|,

|B|P'#w||BZTB=f\^F:

– g{Z%PO(ew|,G4;JmxPw|D`P|B#

– fZ`Pw|DivB,g{;a0lw|D;?V,G4JmxP`P|B#

g{%4NNO

v 2,mMY1m (solidDB w*4)

vfr,G4azzms,"ax$)OD4F(5q)#

Dm)Ds_g(ns* 2GB)LOB(maxiLOB)Z4

4a5Xms,"ax$

G49Cw|H4PekM

g{+ solidDB w*4,G42,mMY1my;\G$)D;?V#

v UNIQUE PPD`v NULL (solidDB w*?j)

Z solidDB P,(e* UNIQUE DPPA`;\P;v NULL kd{ NULL +<BvV UNIQUE <x%}Max$)OD4F(5q)#

CDC ^F

d{}]~qwD CDC i~PICDBP&\Z CDC for solidDB O;\'V#

v lY0kM"B

CDC for solidDB ;'VlY0kM"B&\#

v T/4(?jm

g{k*5qDmk}Cj{T<x`X*,G4Z(eB$)1,+^(9CT /4(?jm(4(B Kfr,G4+^(4($)#

^FJCZyPdC0`XDd{ DBMS z7#

v "B

CDC "B&\ZKivB\^F:y]}Cj{T<x,Z$)D?j=NkDmH ;G}Z}C

5}#T<+Me

?jm)D!n#z&C9C3d=VPm!n#g{%4

Dm2;GQ-}CDm#

1 IBM solidDB Universal Cache Ev 7

2+MO$

g{?j=;h*b|,G4k4PTBYw:

1. g{VP?jmQ-"B,G4SmPF}b|<x#

2. 4(;xb|D?jm#

3. 4P"B#

4. mSb|<x#

v P}K

P}K(.=Vx)v1Z4mO(ew|1Ej+pwC#

Nk4FD}]bI}#C'{/\kzF#$#

v zXk* CDC 5}CZCJ}]bDC'{a)kCJM^D}]k*}]`XD

yPX*>$#(iz9C}]b\m1C'{#

v C'{M\kI CDC 53f"Z CDC 5}0d`&DV

O$}]xP`k,4,9CuS\=(xPS\#

v ZyPivB,S\ CDC 5}M}]b.dDw?#ZX(Zz7D JDBC }/L

rPa)rxPS\#

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}]~qwM`XD CDC i~#>Za)_6p20Ev,"}C|`j8D208>E"#

1. 20 IBM solidDB#

PX8>E",kND6kE8O7PD:20 solidDB;;Z#

2. 20sK}]~qw#

PX8>E",

Change Data Capture

kNDCZsK}]~qwD CDC i~f=a)D InfoSphere

nUC'D5

3. 20 InfoSphere CDC for IBM solidDB#

PXj8E",kNDZ 21 3D:20 InfoSphere CDC;;Z#

":20ax1,20Lr9z\;t/dC$_,T4(BD CDC 5}#}GQ 4UZ 11 3D:dC solidDB; ;ZPD8>E"jI solidDB dC=h,qr

Pp!qt/dC$_#

20JCZsK}]~qwD InfoSphere CDC#

PX8>E",kNDCZsK}]~qwD CDC i~f=a)D InfoSphere Change Data Capture

nUC'D5

":20ax1,20Lr9z\;t/dC$_,T4(BD CDC 5}#}GQ 4UCZsK}]bD InfoSphere Change Data Capture

nUC'D5

PD8>E

"jI solidDB dC=h,qrPp!qt/dC$_#

5. 20 InfoSphere CDC CJ~qw#

PX8>E",kNDz7f=D InfoSphere Change Data Capture Access Server and Management Console, Installation Guide#

6. 20 InfoSphere CDC \mXF(

PX8>E",kNDz7f=D InfoSphere Change Data Capture Access Server and Management Console, Installation Guide#

7. liT7#ITCJBmPP>DD5#

3. solidDB Universal Cache

i~ D5;C X|D5

CDC for solidDB |(Z IBM solidDB 6.3

CZsK}]~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

DD5

Lr|P

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

10 IBM solidDB: Universal Cache C'8O

3 dC solidDB Universal Cache

*dC solidDB Universal Cache,zh*HdC0KMsK}]~qw,Tck Uni- versal Cache dO9C,;s4(k}]~qwT&D CDC 5},nshC|G.d

D4F$)#

dC solidDB MsK}]~qw

dC solidDB

*K\;+ solidDB k CDC <udO9C ,zh*^DdC hC,T c CDC for solidDB IT,SA solidDB }]brSP4F}]#mb,9XkhC CLASSPATH 73d?,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 Cw4}]b,h*4PKYw#v'5* “no”#

2. Z solidDB dCD~(solid.ini)PhCBqU>#t1dUds!#

dCN}hC*

9CdCN} MaxLogSize TKxPhC#

[LogReader] MaxLogSize=<MB>

v'5* 10 240(10 GB)#g{QtCU>DAw(kNDOv=h 1),G4a < U j + 9 C y 8( U> D~ #t 1d Ud #g {4 4P 8] ,r _N }

CheckpointDeleteLog 4hC*“Yes”,G4U>D~I\a<C|`Ud#

3. gPX*,k^Dd{dCN}

v DurabilityLevel

1!ivB,solidDB ~qwMCT6phC*mI(DurabilityLevel=1)#g{ solidDB ~qwbbX"zJO,G4byI\a<BnBBq*'Div#

*@9Kiv,kIC“solid.ini”D~PDBPhC,+MCT6phC*Oq:

[Logging] DurabilityLevel=3

":k m IDMCThC`H , O qDMCThCa} 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)#

v IsolationLevel

1!ivB,solidDB tk6phC*d5A(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<udO9C,zI\h*|DddChC#

4( CDC 5}

y]fz7a)D InfoSphere Change Data Capture

sK}]~qw#

9C CDC dC$_IT4( CDC 5}#

nUC'D5

PD8>E"4dC

*<.0

v li solidDB MsK}]bGq}ZKP#

v zT}]b_Pc;DCJX(#

1. 4( CDC for solidDB DB5}#

PXj8D8>E",kNDZ 22 3D:dC InfoSphere CDC (Windows);r Z 25 3D:dC InfoSphere CDC(UNIX M Linux);BZ#

":g{dCI?p solidDB _ICT,G4zh solidDB ~qwDwzX7MKZE#

2. 4(CZsK}]~qw CDC DB5}#

PXj8D8>E",kNDCZsK}]~qwD InfoSphere Change Data Cap-

nUC'D5PDdC

ture

InfoSphere CDC ;Z#

*(ew solidDB ~qwM(z

*c:CZsK}]~qwD CDC DZ(zkG SOLIDDBCACHE#

hC4F$)

4F$)IZ\mXF(P4(#>Za)_6pw}LLEv,"}C InfoSphere Change Data Capture Management Console, Administration Guide PD|`j88>E

*<.0

v li*4FDmGqfZZ solidDB MsK}]bO#g{m4|,b|,G4z2

ITZ4FZd4(m#

v li solidDB MsK}]bGq}ZKP#

v liCZ solidDB D CDC 5}MsK}]~qwGq}ZKP#

v zT}]b_Pc;DCJX(#

v Qy

12 IBM solidDB: Universal Cache C'8O

]5qfr(eyhD4F-r#

1. G<\mXF(/,SACJ~qw#

PXj8D8>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“CJ\mw”8S<P$w,zXkG_P}]

f"wMC'J'\mX(D53\m1#53\m1J'GZ 20\mXF( Zd4(D#

2. hCCZ

solidDB MsK}]bD}]f"w#

a. mSB}]f"w# PXj8D8>E",kND InfoSphere Change Data Cap-

ture Management Console, Administration Guide PD To add a new datastore

;Z#

b. hC,SN}# PXj8D8>E",kND InfoSphere Change Data Cap-

ture Management Console, Administration Guide PD To set connection parameters on a datastore ;Z#

3. +}]f"wVdxC'#

zh**,;C'Vd solidDB }]f"wMsK}]

f"w#

a. gPX*,kmSBC'# *K\;mSBC',zXkG_PC'J'\m

X(D53\m1#PXj8D8>E",kND Management Console Admin-

istration Guide PD Managing user accounts ;Z#

b. +}]f"wVdxC'# PXj8D8>E",kND Management Con-

sole Administration Guide PD Assigning users to datastores ;Z#

c. *9

|Dz',kO*,S,;sXB,SACJ~qw#

1) %wD~ > CJ~qw > O*,S#

2) %wD~ > CJ~qw > ,S#

4. (I!)*,SA}]f"whC,SW!n# z2ITLx9C1!hC#

PXj8D8>E",kND

InfoSphere Change Data Capture Management Con-

sole, Administration Guide PD Setting connection preferences ;Z#

5. *4FhC}]f"w#

a. ,SA solidDB }]f"w#

b. ,SAsK}]f"w#

PXj8D8>E",kND InfoSphere Change Data Capture Management Con- sole, Administration Guide PD Setting up datastores for replication ;Z#

6. (I!)Z solidDB MsK}]f"wOhC53N}#

PXj8D8>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"wG?j#

b. mS$),dPsK}]f"wG4,solidDB G?j#

PXj8D8>E",kND InfoSphere Change Data Capture Management Con- sole, Administration Guide PD Setting up subscriptions ;Z#

8. *=v$)PD4F3dm#

3 dC solidDB Universal Cache 13

PXj8D8>E",kND InfoSphere Change Data Capture Management Con- sole, Administration Guide PD Mapping tables ;Z#

a>:*4P Universal Cache,z&C*4F=(!q“5q”(Change Data Cap- ture)#

9. TZ?vm3d,ky]5qfrhCe;lbMbv#

PXj8D8>E",kND InfoSphere Change Data Capture Management Con- sole, Administration Guide PD Setting conflict detection and resolution ;Z#

10. t/=v$)OD

PXj8D8>E",kND InfoSphere Change Data Capture Management Con- sole, Administration Guide PD Starting and ending replication on subscriptions ;

4F#

14 IBM solidDB: Universal Cache C'8O

4 solidDB Universal Cache JOiv

TBwZEvK;,JOivMyhDV4}L(g{PD0)#

a>:g{V48>E"|,V$Nq,G4z(#IT9Cf CDC a)DE>r|

n49b)NqT/4P#

@" solidDB ~qw"zJO

g{@" solidDB ~qw"zJO,G4$)OD4F2aax#k4gBy>Lx4 PYwTxPV4:

1. V/XBt/ solidDB ~qwMV4}]b#

PX8>E",kND6IBM solidDB \m18O7PD:\m solidDB;;Z#

2. XBt/ CDC 5}#

8>E",kNDZ 28 3D:t/M#9 InfoSphere CDC;;Z#

3. XBt/$)OD4F#

PX8>E",kND InfoSphere Change Data Capture Management Console, Admin- istration Guide PD Starting and ending replication on subscriptions ;Z#

ZXBt/s,aLx4P$)OD4F,"RXB,=}]b#4F+}#Lxx P#

CDC 5}"zJO

g{ CDC 5}"zJO,G4$)OD4F2aax#k4gBy>Lx4PYwT xPV4:

1. XBt/ CDC 5}#

2. XBt/$)OD4F#

ZXBt/s,aLx4P$)OD4F,"RXB,=}]b#4F+}#Lxx P#

g { K J O " z , G 4 solidDB ~ q w a L x & m B q , 1 = | o =

LogReader.MaxLogSize N}8(D^F*9#

PX8>E",kNDZ 28 3D:t/M#9 InfoSphere CDC;;Z#

PX8>E",kND InfoSphere Change Data Capture Management Console, Admin-

istration Guide PD

Starting and ending replication on subscriptions ;Z#

&Z HA ==(HotStandby)PD solidDB ~qw"zJO

BPwZhvK solidDB HotStandby dCPDJOiv#

w solidDB ~qw"zJO

w*j<}L,g{w solidDB ~qw"zJO,G4_ICTXFw(HAC)H_I CT\mwaJO*FA(z solidDB ~qw#g{9C 2-Safe -i,G4aj+# f}]bMU>4,#&CLrlu=JO*F1d;c;k#

v g { solidDB Universal Cache QdC*

K),G4 CDC 5}aT/XB,SABDw~qw,"R4FaLxxP#

v g{ solidDB Universal Cache QdC*;ArA4_Y:f,G4aax$)OD

4F#zh*9C\mXF(r CDC |n dmstartmirror 4XBt/$)

PX8>E",kND InfoSphere Change Data Capture Management Console, Admin- istration Guide PD Starting and ending replication on subscriptions ;Z#

ZTOivZd,CDC 5};1<Z$w#

a>:PX HA(HotStandby)&\M_ICTXFw(HAC)D|`E",kND

6IBM solidDB _ICTC'8O7#

(z solidDB 0K"zJO

;4_Y:f(v+}]S0K4F=s

g{(z0K"zJO,G4;h*xPV/I$#

g{(z0K"zJO,G4(z0KZcaTX(Z20D}#==V4(}g,

T/XB}<)#HAC aT/4Pd`DV4#TZ&CLrr CDC 5},CJO;

IS#

w solidDB ~qwM CDC for solidDB 5}.dD(E47"zJO

g{w solidDB ~qwM CDC for solidDB 5}.dD(E47"zJO,G4$) OD4F2aax#;x,;+I\<G%@47DJO#

k4gBy>Lx4PYwTxPV4:

1. XBt/ CDC 5}#

PX8>E",kNDZ 28 3D:t/M#9 InfoSphere CDC

2. XBt/$)OD4F#

PX8>E",kND InfoSphere Change Data Capture Management Console, Admin- istration Guide PD Starting and ending replication on subscriptions ;Z#

1XBt/s,aLx4P$)OD4F,"RXB,=}]b#4F+}#Lxx P#

;;Z#

g { K J O " z , G 4 solidDB ~ q w a L x & m B q , 1 = | o

LogReader.MaxLogSize N}8(D^F*9#

16 IBM solidDB: Universal Cache C'8O

sK~qwrsKZc"zJO

g{sK~qwrsKZc"zJO,G4$)OD4F2aax#k4gBy>L

x4PYwTxPV4:

1. XBt/sK~qwMV4}]b#

2. XBt/ CDC 5}#

3. XBt/$)OD5q(4F)#

":9CX(ZsK}]

1XBt/s,aLx4P4F,"RXB,=}]b#4F+}#LxxP#

g { K J O " z , G 4 solidDB 0 K a L x & m B q , 1A| o = LogReader.MaxLogSize N}8(D^F*9#

sKw~qw"zJO

g{sKw~qwr{vsKZc"zJO,G4Xky]"zJbDsKz7Df

rM$_4&mV4BK#solidDB ~qw;a)NN|}CivD=(#

;)sK~qww*BDw~qwKP,aZT}#$wDZcXBt/ CDC 5}

<71>#zXk(} CDC $_XBdC$),TXB,SvVJbD CDC 5}# B$)+XkSj+"B(?v=r)LxxP,;sEITt/5q#

Z3)ivB,$)4FD4,I\a*',rKh*j+"B#

bz7D$_M}LITT/4POv=h#

4 solidDB Universal Cache JOiv 17

18 IBM solidDB: Universal Cache C'8O

5 JOoO

>Za)KdCr9C solidDB Universal Cache 1gN@9rJOoO#{JbD8 >E"M<r#

u<,S;I&

Xk4UZ 9 3D2 B, :20 solidDB Universal Cache; M Z 11 3D3 B, :dC solidDB Universal Cache; PhvD3r20MdC solidDB Universal Cache Di~#

i4TB=h,7#qUKK20MdC=h#

203r

v 0K(solidDB)MsK}]~qw#

v CDC for solidDB MCZsK}]~qwD CDC#

v CJ

v \mXF(

*c:CDC for solidDB MCZsK}]~qwD CDC 20ax1,20Lra>z t/dC$_,T4(B CDC 5}#;*!qt/dC$_,}GQ-y]Z 11 3D

:dC solidDB; MZ 12 3D:dCsK}]~qw;PD8>E"dC ]~qw#

~qw

KT&D}

dC3r

v 0KMsK}]~qw

v CDC 5}

v CJ~qwM\mXF(

4FP9CDi~.dD@5X5

*Z}]b.dhC4F,zh*(eM4(`%@5DwV5eki~#b)5e Mi~Xk4BP3rxP4(,"49rxP^Dr>}#PX|`j8E"M8

>E",kND InfoSphere Change Data Capture Management Console, Administration Guide#

1. }]b

2. CDC 5}

3. }]f"w

4. $)

5. m3d

|D4F$)

g{h*|D4F$),G4XkHax$)OD4F#PX|`j8E"M8>E ",kND InfoSphere Change Data Capture Management Console, Administration Guide

PD Ending replication on a subscription ;Z#

20 IBM solidDB: Universal Cache C'8O

6 CDC for solidDB

XZ>Z

>Z|,PXgN20MdCCZ solidDB Universal Cache M CDC 4FPD IBM InfoSphere Change Data Capture for IBM solidDB i~Dj88>E"#>Z9|,X (Z CDC D|nMd{N<E"#

hC solidDB Universal Cache r CDC 4F1,k4U53620MdC8>E"x PYw,"ZX*1N<>Z#

Z>ZP,InfoSphere CDC ;JCZm>

XZ InfoSphere CDC for IBM solidDB

IBM InfoSphere Change Data Capture(InfoSphere CDC r CDC)G;V4Fbv=

8,Jmz+}]4FA\'VD}]brSb)}]bP4F}]#y]\mXF

(PdCDm3dj8E",|2ITS\'VD}]bSUQ4FD}]#

InfoSphere CDC Jmz,$ICZ5M&m*zMxgw? ,x4P4F,ryZ;|D(ZX4P4F#S4~qw+M}]1,ITZ?j

73PXB3drd;}]#

20 InfoSphere CDC

>Za)PXgN20 InfoSphere CDC Dp=8>E"#

9C;%=20420 InfoSphere CDC

ITZ Windows ~qwr_ UNIX r Linux®~qwO20 InfoSphere CDC#

*20 InfoSphere CDC(Windows)

1. +w20D~#InfoSphere CDC 20r<+r*#

2. %wB;=#

3. g{,bmIun,G4!qRS\>mI-iDun,;s%wB;=#

4. !q*ZdP20 InfoSphere CDC DD~P,;s%wB;=#

5. g{H0Q20 InfoSphere CDC,G420Lr+a>z}

}6C20#

6. !qz7<jD;C,;s%wB;=#

7. i420\a,;s%w20#

8. ( I!)Z2 0s,! q t/dC$_Tt/dC $_#dC $_Jmz mS

InfoSphere CDC D5}#

9. %wjITKv20#

InfoSphere CDC for solidDB#

DQ4FD}]b#zIT

6C20#%w7(T

*20 InfoSphere CDC(Unix M Linux)

XZKNq

":g{Q20 X-Windows,G420LraZ<N73Pt/dC$_#}K;Xt /M#95}.b,CdC}Lk Windows `F#

1. G<z* InfoSphere CDC hCDJ'#

2. 4FJCZ Linux =(D InfoSphere CDC 20D~#

3. 920LrI*I4PD~#

4. (}dk20

5. ZriA;O4 Enter |,TT>mI-i#4UA;OD8>E"4/@CmI

-i#

6. *S\CmI-i,kdk 1#

7. dk20?<DxT76,r4 Enter |TS\1!5#

D~{4KP20Lr#

":8(D ?<Xk**CZ2 <,G453aa>z8(m;?<#

8. i420\a#4 Enter |T*<20#

9. 20jIs,InfoSphere CDC aa)t/ InfoSphere CDC DdC$_D!n#

10. dk 1 Tt/dC$_#

0DJ'y 5P#g{20Lr ^(4(C?

9C2,20420 InfoSphere CDC

2,20Jmz(}8(_PwV N}D|n4T/20 InfoSphere CDC#TZsM InfoSphere CDC ?p,IT(}+2,20|n6kE>49CK`20=(#

*4P InfoSphere CDC D2,20(UNIX M Linux)

1. G<z* InfoSphere CDC hCDJ'#

2. 4F InfoSphere CDC 20D~#

3. 920LrI*I4PD~#

4. 9CBP|n20 InfoSphere CDC "zIl&D~:

<setup.bin> -r <response-file>

5. Zm;53O,k(}KPBP|n44P2,20:

<setup.bin> -i silent -f <response-file>

dP:

v <response-file> G20D~Dj{76#

dC InfoSphere CDC (Windows)

Z20 InfoSphere CDC .s,20Lrat/dC$_#dC$_Jmz*73dC InfoSphere CDC#zXkdC InfoSphere CDC,;sEITt/4F#

22 IBM solidDB: Universal Cache C'8O

dC InfoSphere CDC 5}(Windows)

zITmS"`-r>} InfoSphere CDC D5}#9C InfoSphere CDC dC$_4

&m5}#

*mS InfoSphere CDC DB5}(Windows)

*<.0

Z20.s,g{*dC InfoSphere CDC DZ;v5},G4ITLx4PK}LD

=h 3#

1. Z|na>{&,(}Z8(?<P"vBP|n4t/dC$_:

\<InfoSphere CDC Installation Directory>\bin\dmconfigurets

2. ZvV6-{"1,%w7(TLx#

3. Z IBM InfoSphere CDC B(5}T0rOD5}xrP,ITdCBP!n:

!n hv

{F dk InfoSphere CDC 5}D{F#K{FXk

(;#

~qwKZ dk InfoSphere CDC CZkKP\mXF(D

M'z$w>Md{~qw(EDKZE#

":20Z,;~qwODd{&CLr^(

9CKKZE#Z\mXF(DCJ\mw8 S<P*

CK K ZE#InfoSphere CDC aT>1! TCP/IP KZ 11101#PX|`E",kND\

mXF(D5#

":g{Z,;ZcO20`v5},G4? v5}DKZEXk(;#

T/"VKZ !qCr,;sdkCZSCJ~q

T/"Vc%D UDP KZE#PXT/"VD

|`E",kND\mXF(D5#

JmDnsZf dk*Vdx InfoSphere CDC Dns RAM

?# z X k * d CD ? v 5} n Y V d 64 MB#1!ivB,2P 512 MB RAM IVd

x 32 ;5},1024 MB RAM IVdx 64 5}#

;f> (}!qBPdP;v!n4!qzD}]b

D;f>:

v 32 ;

v 64 ;

}]f"w8(CJN}1,z+9

w"MD

;

g{Z 32 ;~qwO20 InfoSphere CDC,

G4;atCb)!n#

4. Z Windows ~qxrP,zIT8(CZt/ InfoSphere CDC ~qDJ'#!

qBPdP;v!n:

6 CDC for solidDB 23

!n hv

>X53J' (}>X53\m1J't/ InfoSphere CDC

~q#

KJ' (}8(DC'J't/ InfoSphere CDC ~

zXkICTBq=48(CJ':<domain>\ <user name>,dP <domain> G73PrD{

F,<user name> G8(rPP'DG<C'

{#g{Fcz;GrD;

8( <computer name>\<user name>#

Z\kM7O\krP,dk10ky! Win- dows C 'J ' X * D\ k# g { Z 20 InfoSphere CDC s|D Windows C'J'D \k,G4Xk9C“Windows ~q”T0r,

T|D10*?v InfoSphere CDC ~qhCD \k#

?V,G4zIT

5. Z}]bxrP,ITdCT|,*CZ4FDmD}]bDCJ(#*jIK=

h,zh*53\m1X(#;s,ITZ\mXF(DCJ\mw8S<Pm S

}]f"w,"*C'a)TK}]bDC J(#PX|`E",k

ND\mXF

(D5#

!n hv

C'{ dk8(D}]bDC'{#

\k dk8(D}]bD\k#

*}]#= !q+CZ InfoSphere CDC *}]mD}]b

#=#

I+OfdkDC'{Cw1!5#}KIC ZX(}]bDd{Q20 InfoSphere CDC 5 }9CD#=.b,IT8(

w*20Hvu~D;?V,zXkhCK#

=rICK#=# ": 7#T*}]#=9C“s4”V8#1! ivB,solidDB PDyP#={(?<{)<

*s4#

_6 _64%9z\;^D solidDB JDBC }/L

rDdCN}#PX

`E", kND IBM solidDB Programmer Guide#

JDBC }/LrN}D|

d`NN#=#

6. Z~qwxrP,zITdC*+}]4FAdPrSP4F}]D solidDB ~q

w,K~qw|,yP*CZ4FDm#zITdC%v~qw,2ITdC HA d

C(HotStandby)#

!n hv

%v~qw dk8(D solidDB ~qwDwz{MKZ

24 IBM solidDB: Universal Cache C'8O

!n hv

HA dC(HotStandby) dk8(Dw solidDB ~qwM(z solidDB

~qwDwz{kKZE#

7. %w7(T#f InfoSphere CDC 5}DdChC#

8. %w&CT#fdC$_PD|D#

B;=v24

ZjIdCs,ITt/ InfoSphere CDC#

*`- InfoSphere CDC D5}(Windows)

1. g{Q(}9C dmshutdown |nt/ InfoSphere CDC,G4+d#9#

2. Z|na>{&,(}Z8(?<P"vBP|n4t/dC$_:

\<InfoSphere CDC Installation Directory>\bin\dmconfigurets

3. g{*^DD5}Qt/,G4Z5}xrP+d!(,;s%w#9#

4. Z5}xrP,!q5},;s%w`-#

InfoSphere CDC `-5}T0r+r*#

5. zITZKT0rO^D1mS5}18(DNN5#

6. %w&CT#f|D,;s

%wXU#

dC$_+^DC5}#

7. Z5}xrP,!qQ^DD5},;s%wt/Tt/C5}#

*>} InfoSphere CDC D5}(Windows)

1. g{Q(}9C dmshutdown |nt/ InfoSphere CDC,G4+d#9#

2. Z|na>{&,(}Z8(?<P"vBP|n4t/dC$_:

\<InfoSphere CDC Installation Directory>\bin\dmconfigurets

3. g{*>}D5}Qt/,G4Z5}xrP+d!(,;s%w#9#

4. Z5}xrP,!q5},;s%w>}#

5. %wGT@C>}C5}#

dC InfoSphere CDC(UNIX M Linux)

Z20 InfoSphere CDC .s,20Lrat/dC$_#dC$_Jmz*73dC InfoSphere CDC#zXkdC InfoSphere CDC,;sEITt/4F#

dC InfoSphere CDC 5}(UNIX M Linux)

zITmS"`-r>} InfoSphere CDC D5}#9C InfoSphere CDC dC$_4

&m5}#

6 CDC for solidDB 25

*mS InfoSphere CDC DB5}(UNIX M Linux)

*<.0

Z20.s,g{*dC InfoSphere CDC DZ;v5},G4ITLx4PK}LD

=h 4#

1. Z|na>{&,(}Z8(?<P"vBP|n4t/dC$_:

/<InfoSphere CDC Installation Directory>/bin/dmconfigurets

2. ZvV6-{"1,4 Enter |TLx#

3. dk 2,;s4 Enter |TmS InfoSphere CDC DB5}#

4. dk InfoSphere CDC 5}D{F,;s4 Enter |#5}{FXk(;#

5. dk InfoSphere CDC CZkKP\mXF(DM'z$w>Md{~qw(ED

KZE#InfoSphere CDC aT>1!KZ 11101#

":20Z,;~qwODd{&CLr^(9CKKZE#Z \mXF(DC J\mw8S<P*}]f"w8(CJN}1,z+9CKKZE #PX|` E",kND\mXF(D5#

4 Enter |#

":g{Z,;ZcO20`v5}

,G4?v5}DKZEXk(;#

6. dkT/"V UDP KZEr4 Enter |T9C1!5 DISABLE#KKZECZ

SCJ~qw"MDT/"Vc%#PXT/"VD|`E ",kND\mXF

(D5#

7. dk*Vdx InfoSphere CDC Dns RAM ?# zXk*d

CD?v5}nY

Vd 64 MB#1!ivB,2P 512 MB RAM IVdx 32 ;5},1024 MB RAM IVdx 64 ;5}#

8. !q*dCD solidDB ~qwdC`M#

!n hv

%v~qw dk 1,;s4 Enter |#

HA dC(HotStandby) dk 2,;s4 Enter |#

9. y]dC`Mdkwz{MKZE#

!n hv

%v~qw

1. dk8(~qwDwz{,;s4 Enter

2. dk8(~qwDKZE,;s4 Enter

|#1!5* 1964#

26 IBM solidDB: Universal Cache C'8O

!n hv

HA dC(HotStandby)

1. dk8(w~qwDwz{,;s4 Enter

2. dk8(w~qwDKZE,;s4 Enter

|#1!5* 1964#

3. d k 8 ( ( z~ q w D wz { , ; s 4

Enter |#

4. d k 8 ( ( z~ q w D KZ E , ; s 4

Enter |#1!5

":w~ qwM(z~qwD1!KZ E

`,,b Gr*RGY(w~qwM(z ~qw; Z;,ZcO#}g,g{* K s5,z Dw~qwM(z~qw;Z,

;ZcO ,G4=_D1!KZE;\ `

10. gPX*,dC_6N}(JDBC N})#

!n hv

9C1!hC dk n,;s4 Enter |#

^DhC

1. dk y,;s4 Enter |

2. 9Co( <parameter>=<value>;<parameter>=<value>;...

dkN}hC

":Z HA hCP,N} solid_tf_level Z1!ivBQh C*“CONNECTION”(,S)#

* 1964#

11. dk8(D}]bDC'{,;s4 Enter |#

12. dk8(D}]bD\k,;s4 Enter |#dC$_VZ+Qw}]bTiR#

13. dkkz*9CD*}]#=`T&D}V,;s4 Enter |#

14. dk*CZIzek=}]bD?<D7

6#4 Enter |#solidDB }]bM

InfoSphere CDC TK?<Xk5PA4(^#

"M:

v z&CT InfoSphere CDC D?v5}9C;,D?<#

v K?<I\|,CZ4FD}]bm#Z7(TK?<DC'CJ(1,z&

C+b;rX<GZZ#

15. dC$_4( InfoSphere CDC 5},;

sa>zt/5}#dk y Tt/C5

":g{dC*2GVP5}D*}],G4dC$_+aa>z#

*`- InfoSphere CDC D5}(UNIX M Linux)

1. g{Q(}9C dmshutdown |nt/ InfoSphere CDC,G4+d#9#

2. (}Z8(?<P"vBP|n4t/dC$_:

/<InfoSphere CDC Installation Directory>/bin/dmconfigurets

6 CDC for solidDB 27

3. dk 1,;s4 Enter |TP> InfoSphere CDC DQ205}#G<*^DD5

}D{F#

4. dk 3,;s4 Enter |T^D InfoSphere CDC D5}#

5. dk*^DD5}{F,;s4 Enter |#

dC$_Jmz`-ZmS5}18(D`v5#

6. Z|D.s,dk 5,

4 Enter |T*z|D#

*>} InfoSphere CDC D5}(UNIX M Linux)

1. g{Q(}9C dmshutdown |nt/ InfoSphere CDC,G4+d#9#

2. (}Z8(?<P"vBP|n4t/dC$_:

/<InfoSphere CDC Installation Directory>/bin/dmconfigurets

3. dk 1,;s4 Enter |TP> InfoSphere CDC DQ205}#G<*>}D5

}D{F#

4. dk 4,;s4 Enter |T>} InfoSphere CDC D5}#

5. dk*>}D5}{F,;s4 Enter |#

t/M#9 InfoSphere CDC

;s4 Enter |T&C|D"5XAwK%#dk 6,;s

>Za)PXgNt/M#9 InfoSphere CDC 5}Dp=8>E"#

t/ InfoSphere CDC

Z\'VD Windows ~qwO20 InfoSphere CDC 1,zITZu<dC.sV/ +dt/#t/ InfoSphere CDC at/ Windows PD~q#ZXB}<s,~q+

T/t/#

Z\'VD Linux ~qwO20 InfoSphere CDC 1,zIT"v|n+dt/#20 InfoSphere CDC .s,+dt/TcITZ\mXF

*t/ InfoSphere CDC(Windows)

1. Z|na>{&,(}Z8(?<P"vBP|n4t/dC$_:

\<InfoSphere CDC Installation Directory>\bin\dmconfigurets

2. Z5}xrP,!q*t/D5},;s%wt/#

dC$_t/ InfoSphere CDC D5}#

B;=v24

z2IT9C“Windows ~q”T0r4t/M#9 InfoSphere CDC ~q#

*t/ InfoSphere CDC(UNIX M Linux)

(P*K5}4(}]f"w#

y]z}ZKP InfoSphere CDC DYw53,"vBPdP;vt/|n:

v dmts32-I<instance_name> v dmts64-I<instance_name>

28 IBM solidDB: Universal Cache C'8O

#9 InfoSphere CDC

1z*9C InfoSphere CDC dC$_4|DdChC1,I\PX*#9 InfoSphere CDC#

Z Windows O,#9 InfoSphere CDC a#9 Windows PD~q#ZXB}<s, ~q+T/YNt/#

Z UNIX M Linux O,zIT"v|n4#9 InfoSphere CDC#Z9~qwr}]b QzT),$r}6 InfoSphere CDC .0,k

*#9 InfoSphere CDC(Windows)

1. (}Z8(?<P"vBP|n4t/dC$_:

/<InfoSphere CDC Installation Directory>/bin/dmconfigurets

2. Z5}xrP,!q*t/D5},;s%w#9#

dC$_t/ InfoSphere CDC D5}#

B;=v24

z2IT9C“Windows ~q”T0r4t/M#9 InfoSphere CDC ~q#

*#9 InfoSphere CDC(UNIX M Linux)

9CC|n#

1. Z\mXF(PaxyP$)OD4F#PXgNax$)OD4FD|`E",

kND\mXF(D5#

2. y]z*gN#9 InfoSphere CDC,"vBPdP;v#9|n:

!n hv

dmshutdown -I <instance_name> 9CK|nT}#XU InfoSphere CDC#

dmterminate -I <instance_name> 9CK|n4*}Z Linux ~qwOKPDy

Z\mXF(PtC SQL od

ZT?jm&Cm6pe}r"BYw.s,InfoSphere CDC Jmz4P SQL od# zITZ\mXF(PDd{ SQL T0rP8( SQL od#*K2+p{,1!i

vB,Z InfoSphere CDC P{CK&\#(}Z20K InfoSphere CDC D}]bP 4({* TS_SQL_EXECAUTH Dm,zITtCK&\ ZdC InfoSphere CDC Zd9Ck*}]m`,D#=44(Cm#PXZ\mXF

(P8( SQL odD|`E",kND\mXF(D5PD“8( SQL TXF"BY

w”#

g{Z,;v Linux ~qwO_P`vn/ InfoSphere CDC 20,"Rz*+|G+?X U,G4S?v InfoSphere CDC 5}D20?

<KPK|n#

P5}U9+? InfoSphere CDC xL

dmshutdown |n^(j+XU InfoSphere CDC

1,k9CK|n#

#19C

#Cma9";X*,zXk

6 CDC for solidDB 29

*Z\mXF(PtC SQL od

1. Z?j~qwOR=z* InfoSphere CDC 4(D}]b#S9C InfoSphere CDC

D==x(,bGz* InfoSphere CDC 4FArSP4FD}]b#

":Z20Zd,InfoSphere CDC +*}]mCZ InfoSphere CDC xLyXhD }]bP#

2. g{z#{\;8( SQL odf6,G4Z}]bP4({* TS_SQL_EXECAUTH

Dm#

":CmIT_PNNa9,"RzXkICZdC InfoSphere CDC 18(D#= xP4(#

InfoSphere CDC 'VD}]`M

1Z\mXF(P3d*CZ4FD4PM?jP1,z&C*@D)}]`MGf

]D#PXgN3d*CZ4FDmD|`E",kND\mXF(D5PD“3dm ”;Z#

'VD}]`M

>Zhv InfoSphere CDC IT4FD}]`M#

v bigint

v binary

v blob

v char

v clob

v date

v decimal

v double precision

v float

v integer

v long varbinary

v long varchar

v nchar

v nclob

v numeric

v nvarchar

v real

v smallint

v time

v timestamp

v tinyint

v varbinary

v varchar

30 IBM solidDB: Universal Cache C'8O

PX'VD}]`MD|`j8E",kND6IBM solidDB SQL 8O7#

'VD3d

>Z8>KCZ'VD}]`MD\'V\mXF(3d#

"<D}]`M 'VD3d

bigint NN}V"~xFr LOB }]`M

binary NN~xFr LOB }]`M

blob NN~xFr LOB }]`M

char NNV{"IdV{"CLOB"~xFrd{

clob NNV{"IdV{" CLOB" ~xFrd{

date N

decimal NN}V"~xFr LOB }]`M

double precision NN}V"~xFr LOB }]`M

float NN}V"~xFr LOB }]`M

integer NN}V"~xFr LOB }]`M

long varbinary NN~xFr LOB }]`M

long varchar NNV{"IdV{"CLOB"~xFrd{

nchar NNV{"IdV{"CLOB"~xFrd{

nclob NNV{"IdV{"CLOB"~xFrd{

nvarchar NNV{"IdV{"CLOB"~xFrd{

numeric NN}V"~xFr LOB }]`M

real NN}V"~xFr LOB }]`

smallint NN}V"~xFr LOB }]`M

tim NN1d}]`M

timestamp NNUZ"1dr1dAG}]`M

tinyint NN}V"~xFr LOB }]`M

varbinary NN~xFr LOB }]`M

varchar NNV{"IdV{" CLOB"~xFrd{

LOB }]`M

N}]`M

LOB }]`M

InfoSphere CDC *}]m

InfoSphere CDC ,$;im,|G5wPX104FdCD}]#vZwV-r,zI \*8]b)mr4Pd{`FDNq#;x,}G IBM zmksz^Db)mDZ

],qrPpb4v#

InfoSphere CDC 4(D*}]mD{FgBy>:

v TS_AUTH

6 CDC for solidDB 31

":TZZ\mXF(DCJ\mw8S<PmSDyPC',7#a)T TS_AUTH *}]mD GRANT SELECT X(#PXgNZ\mXF(DCJ\mw8S<P mSC'D|`E",kND\mXF(D5#

v TS_BOOKMARK

v TS_CONFAUD

InfoSphere CDC ZdC}LZdz8(D}]

g{*Z InfoSphere CDC T?jm&Cm6p"Bre}Yw.s8( SQL od, G4h*4(M,$ TS_SQL_EXECAUTH m#

CZ InfoSphere CDC D|n

>ZV[ InfoSphere CDC PICD|n#9Cb)|n,zITXF4F"\mCZ 4FDm"`S4FM4Pd{wVNq#

9C InfoSphere CDC |n

zITZ|nPa>{&"v InfoSphere CDC |nrw*z&mD~D;?Vr shell

E>"v|n#|n;Z InfoSphere CDC 20?<D bin ?<#/@AK?<TKP |n#

":*P>ICD|nj>M?vj>DrLhv,kZ|na>{&dkx -? j>

|n{,;s4 Enter |#}g,dmterminate -?#

|nq=

TZ?v|n,a)BPE"n:

v o( - j6|n{F"P>|nN}#

v N} - hv|nPD?vN}T0j6I8(D5#

v a{ - 8>ZI&4PDivBI|n5XD5#b)5T`FE>\PC#K?

V98(Kw*4P

v >} - a);vr`vwC|nD>}#

bk#=P4(M20b)m#

|nDa{xT>ZA;ODE"(g{PD0)#

N}q=

k"b|nN}(ePDBP<(:

v b(E(<>)8>XhN}#

v =(E([])8>I!N}#g{!TCN},G4 InfoSphere CDC 9C1!5#

v Vt;vr`vN}Dz_(|)8>;\9CPmPDdP;vN}#1;ur`

_vVZI=(E [](p4DN}PmP1,!nv^ZPmPDN},+z

I!q;8(NNN}#

v !TE(...)m>IT`NX49CN}r!n#

v }GmPyw,qr|nJCZ Linux M Windows Yw53#

32 IBM solidDB: Universal Cache C'8O

hC TSINSTANCE 73d?

Z9C|n.0,zIT+ TSINSTANCE 73d?hC* InfoSphere CDC 5}D{F#

ZhC TSINSTANCE 73d?.s,1"v|n1,z;YXk8(5}{F#

Windows =(

Z|na>{&"vBP|n:

SET TSINSTANCE=<instance_name>

dP:

v <instance_name> G InfoSphere CDC 5}D{F#

Linux =(

"vBP|n:

EXPORT TSINSTANCE=<instance_name>

dP:

v <instance_name> G InfoSphere CDC 5}D{F#

XF4F|n

>Z|,Z InfoSphere CDC PXF4FD|n#

dmendreplication - ax4F

9CK|n4axQ8(D$)OD"Br5q#ZI&axQ8($)OD4F.

s,K|nKv#

dmendreplication -I <instance_name> [-c|-i] <-A|-s <subscription_names> ...> [-L <locale>]

-I <instance_name>

8(**dax4FD InfoSphere CDC 5}#Kb,IT8( TSINSTANCE 7 3d?4zfK5#

-c 8( InfoSphere CDC IC\XFD==ax4F#K!nJm InfoSphere CDC j

IyP}ZxPPDYw,"&CT?jmD]R|D#g{!T c M i !n, G4 InfoSphere CDC Z1!ivBaIC

-i 8( InfoSphere CDC "4ax4F#K!naPONN10Yw#InfoSphere CDC

;a&CT?jmD]R|D#

-A 8( InfoSphere CDC axZyP$)OD4F#

-s <subscription_names>

8( InfoSphere CDC axZQ8>D$)OD4F#g{8(`v$),G4a

P>b)$)#

-L <locale>

CZ InfoSphere CDC 5}DoT73D

{F#1!5*zzwDoT73#

6 CDC for solidDB 33

g{K|n4PI&,G4a5X5 0;g{K|n4P'\,G4a5XGc5#

dmendreplication -I myinstance -c -s Finance

InfoSphere CDC *Q8(5}IC\XFD==axT Finance $)D4F#

dmrefresh - "B$)

9CK|n4"B8(D$)#1 "B$)1,InfoSphere CDC 7#?jmk4m, =#(#,ZzDmO+4F=(hC*"B1,+a"B?jm#

;x,z2IT"B+4F=(hC*“5q”D?jm#1"B*5qdCD m1, InfoSphere CDC a"B?jm,

qDp<c#

ZI&"B8(D$).s,K|nKv#g{ZKLrTKP1+dU9,G4 InfoSphere CDC a"4axQ8($)D4F#

dmrefresh -I <instance_name> [-a|-f] <-A|-s <subscription_names> ...> [-L <locale>]

Tc|k4m,=,;sZU>PhCU>;Cw*5

-I <instance_name>

8(* * d " B;vr`v$)D InfoSphere CDC 5 } # Kb,IT8( TSINSTANCE 73d?4zfK5#

-a 8( InfoSphere CDC "B$)PDyP?jm#

-f 8( InfoSphere CDC v"BG)jGT)"BD?jm#g{!T -a M -f !

n,G4 InfoSphere CDC Z1!ivBaIC -f#

-A 8( InfoSphere CDC "

-s <subscription_names>

8( InfoSphere CDC "BQ8>D$)#g{8(`v$),G4aP>b)$ )#

-L <locale>

CZ InfoSphere CDC 5}DoT73D{F#1!5*zzwDoT73#

ByP$)#

g{K|n4PI&,G4a5X5 0;g{K|n4P'\,G4a5XGc5#

dmrefresh -I new_instance -a -s Finance

InfoSphere CDC "B Finance $)PDyP?jm#

34 IBM solidDB: Universal Cache C'8O

dmstartmirror - t/5q

9CK|nZ8(D$)Ot/5q#K|nT4F=(*5qR4,*"Brn/ DNNmt/5q#Zt/5q.0,nuaZ$)O"B4F=(*5qR4,* "BDyPm#g{t/,x5q,G4Z8(D$)OI&t/5

+Kv#g{t/;|D5q,G4Z8(D$)OjI;|D5q.s,K|n+ Kv#

dmstartmirror -I <instance_name> [-c|-n] <-A|-s <subscription_names> ...> [-L <locale>]

-I <instance_name>

8(**dt/5qD InfoSphere CDC 5}#Kb,IT8( TSINSTANCE 7 3d?4zfK5#

-c 8( InfoSphere CDC t/,x5q#g{!T c M n !n,G4 InfoSphere CDC

Z1!ivBaIC c#

-n 8( InfoSphere CDC t/;|D5q#

-A 8( InfoSphere CDC TyP$)t/5q#

q.s,K|n

-s <subscription_names>

8( InfoSphere CDC TQ8>D

b)$)#

-L <locale>

CZ InfoSphere CDC 5}DoT73D{F#1!5*zzwDoT73#

g{K|n4PI&,G4a5X5 0;g{K|n4P'\,G4a5XGc5#

dmstartmirror -I myinstance c -s Finance

InfoSphere CDC T Finance $)t/,x5q#

}]bBqU>|n

>Z|,Iozz\m}]bBqU>ri)D|n#

dmdecodebookmark - T>_`i)E"

9CK|n4T>PXi)D_`E"#

$)t/5q#g{8(`v$),G4aP>

dmdecodebookmark -I <instance_name> (-b | -f) [-d] [-L <locale>]

6 CDC for solidDB 35

-I <instance_name>

InfoSphere CDC 5}D{F#zIT+ TSINSTANCE 73d?hC* InfoSphere CDC 5}D{F#jIKYws,1"v|n1,z;YXk8(C5}#

-b <bookmark>

i)w*.yxF`kDV{.#

-f <bookmark_file>

i)D~w*~xFD~#

[-d] <database_version>

g{i)I InfoSphere CDC DOgf>zI,G4a8 f>#

-L <locale>

CZ InfoSphere CDC 5}DoT73D{F#1!5*zzwDoT73#

(zICi)D}]bM

g{K|n4PI&,G4a5X5 0;g{K|n4P'\,G4a5XGc5#

dmdecodebookmark -f bookmark.txt

InfoSphere CDC T>PX bookmark.txt D~DE"#

dmsetbookmark - hCi)

9CK|n4|D$)DNc#

dmsetbookmark -I <instance_name> -s <subscription_name> (-b | -l | -f | -t) [-a] [-L <locale>]

-I <instance_name>

InfoSphere CDC 5}D{F#zIT+ TSINSTANCE 73d?hC* InfoSphere CDC 5}D{F#jIKYws,1"v|n1,z;YXk8(C5}#

-s <subscription_name>

InfoSphere CDC *dhCi)D$)D{F#

-b <bookmark>

8(+7(}]bU>PDcDi),z#{ InfoSphere CDC SCcLx4P5 qYw # B N

dmshowbookmark |nqCD.yxF`kDV{.#

-l <bookmark>

8>BNcDi)#i)GS dmdecodebookmark |nqCDV{.#PX|`E

",kND Z 35 3D:dmdecodebookmark - T>_`i)E";#

InfoSphere CDC 5q1,|+ZX(;C & N w# i)GS

-f <bookmark_file>

8(|,i)D~xFD~,Ci)

36 IBM solidDB: Universal Cache C'8O

7(}]bU>PD3vc,z#{ InfoSphere

CDC SCcLx4P5qYw#BN InfoSphere CDC 5q1,|+ZX(;C&

Nw#i)D~Gf"C;CD~xFD~#

-t <datetime>

8(BNz#{ InfoSphere CDC ZX(UZk1d=|G<Du?&Lx4PN wYw#

-a TBNcp,+$)PDyPm(Q#ED

-L <locale>

CZ InfoSphere CDC 5}DoT73D{F#1!5*zzwDoT73#

m}b)hC*n/#

g{K|n4PI&,G4a5X5 0;g{K|n4P'\,G4a5XGc5#

dmsetbookmark -I MYINSTANCE -b 2FC5GJHKLKSJLKJL458K9K809IK9

-s FINANCE

InfoSphere CDC *Q8(5}Z Finance $)OhCi);C#K|n8(+Z}]

bU>PQ8>D;C&Lx4P5qYw#

dmshowbookmark - T>i)E"

9CK|n4i4Z?jOQd5D$)DnB4F;C#

dmshowbookmark -I <instance_name> -s <subscription_name> [-f] [-v] [-L <locale>]

-I <instance_name>

InfoSphere CDC 5}D{F#zIT+ TSINSTANCE 73d?hC* InfoSphere CDC 5}D{F#jIKYws,1"v|n1,z;YXk8(C5}#

-s <subscription_name>

8(*dT>i)D$)D{F#

[-f] <file_name>

*i)dv8(~xFD~D{F#

[-v]

T>PXi)D_`E",dP|( Z4}fD`MMf>#<UT>.yxF`kDV{.#|G dmdecodebookmark

|nT>DZ]D;?V#g{48(,G4vT>.yxF`kDV{.#

-L <locale>

CZ InfoSphere CDC 5}DoT73D{F#1!5*zz

.yxF`kDV{.#yT>DE"?!v

wDoT73#

g{K|n4PI&,G4a5X5 0;g{K|n4P'\,G4a5XGc5#

6 CDC for solidDB 37

dmshowbookmark -I myinstance -s master

InfoSphere CDC T>w$)Di)E"#

dmshowlogdependency - T>U>@5X5

9CK|n4T>PXI InfoSphere CDC 9CR4Fh*D}]bU>DE"#9C K|n45VU>#t1d_T#(}K|n,zITT>BPE":

v 8(D5}yhD}]bU>DPm#

v 8(D5}101YD}]bU>DPm#

8(D5}D}]bU>Pngr*DBq#

v InfoSphere CDC DQ8(5}10Z4OA!D}]bU>#

v InfoSphere CDC DQ8(5}10Z?jO&CD$)D}]bU>#

dmshowlogdependency -I <instance_name> (-c | -i | -t | -l) (-s <subscription_name> | -A) [-v] [-L <locale>]

-I <instance_name>

InfoSphere CDC 5}D{F#zIT+ TSINSTANCE 73d?hC* InfoSphere CDC 5}D{F#jIKYws,1"v|n1,z;YXk8(C5}#

-c li"T>Q8(5 }101YR4Fh*DQi5}]bU>DPm#Z9C

InfoSphere CDC t/4F.0,XkV4b) nDdvaT>“OK”(}#)#zITZE>rz&mD~Pbvdv#

-i T>Q8(5}yhD}]bU>Dj{Pm#t/4Fh*b)U>,|G|,

P4T?j&CD}]#

-t T>Q8( InfoSphere CDC

G|,?j7OD10;CDU>#

-l T>Q8( InfoSphere CDC 5}10A!D104}]bU>#bG|,10N

w;CDU>#

-s <subscription_name>

8(**dT> InfoSphere CDC 10A!D?j}]bU>D$)D{F#+ N}k -t N}dO9CTT>?j}]bU>#

-A 8(yP$)

-v 8(_`dv(qr,+dvq=/TCZE>`F)#

-L <locale>

CZ InfoSphere CDC 5}DoT73D{F#1!5*zzwDoT73#

5}10}ZA!D$)D10?j}]bU>#b

U>#g{;P1YU>,G4K|

g{K|n4PI&,G4a5X5 0;g{K|n4P'\,G4a5XGc5#

dmshowlogdependency -I MyInstance

38 IBM solidDB: Universal Cache C'8O

\m*CZ4FDm|n

>Z|,Iozz\m*(} InfoSphere CDC 4FDmD|n#

dmdescribe - hv4m

9CK|n+4m3d|D"MA?j#

ZI&hv8(D$).s,K|nKv#

dmdescribe -I <instance_name> <-A|-s <subscription_names> ...> [-L <locale>]

-I <instance_name>

8(**d+4m3d|D"MA?jD InfoSphere CDC 5}#Kb,IT8( TSINSTANCE 73d?4zfK5#

-A 8( InfoSphere CDC +TyP$)ywD4m3d|D"MA?j#

-s <subscription_names>

8( InfoSphere CDC +Q8>$)D4m3d|D"MA?j#g{8(`v$ ),G4aP>b)

-L <locale>

CZ InfoSphere CDC 5}DoT73D{F#1!5*zzwDoT73#

$)#

g{K|n4PI&,G4a5X5 0;g{K|n4P'\,G4a5XGc5#

dmdescribe -I new_instance -s Finance

InfoSphere CDC *Q8(5}+ Finance $)PD4m3d|D"MA?j#

dmflagforrefresh - jGT)"B

9CK|n4jG4mT)"B#1jGmT)"B1,!q+4*"BDm#1! q"Bw*$)OD4F=(1,&9CK}L#

dmflagforrefresh -I <instance_name> -s <subscription_names> <-A|-t <schema>.<table> ...> [-L <locale>]

-I <instance_name>

8( InfoSphere CDC 5}D{F#Kb,IT8( TSINSTANCE 73d?4z fK5#

-s <subscription_names>

8($)D{F#g{8(`v$),G4aP>b)$)#

-A 8( InfoSphere CDC Z$)PjGyP4mT)"B#

6 CDC for solidDB 39

-t <schema>.<table>

8(Z$)P InfoSphere CDC jGT)"BD4mD{F#zXkICq= schema.table 8(m{#g{8(`vm,G4aP>b)m#

-L <locale>

CZ InfoSphere CDC 5}DoT73D{F#1!5*zzwDoT73#

g{K|n4PI&,G4a5X5 0;g{K|n4P'\,G4a5XGc5#

dmflagforrefresh -I myinstance -s Finance -A

InfoSphere CDC *Q8(5}jG Finance $)PDyP4mT)"B#

dmmarktablecapturepoint - Z4mOjGm6qc

9CK|nZ4mOjGm6qc,"+mFAn/4,#g{Z4PK|n.0| DCm,G4+;4FG)|D#

*2GQ|D}]wPDVP;C1,Z4mOjGm6qc#1zQ9C}\mX F(.bD&CLr(}g,9C}]b= M?jmR*@4k?jKK,=D1dc1,bGPI\5VD#InfoSphere CDC S

Q|D}]wPD10;C5qT?jmD|D#Z“3dm”r<P3dm.s,1 z!q5q(Change Data Capture)1,K;CI InfoSphere CDC hC#g{ 2GI InfoSphere CDC hCD;C,G4ITZ\mXF(PV/jGm6qc#1

v(t/$)OD5q1,InfoSphere CDC aj6zQhC*1dcD;C,"SC; C6qM4FT?jD}]b|D#

(D<kr<v&\),=("B)4m

dmmarktablecapturepoint -I <instance_name> -s <subscription_names> <-A|-t <schema>.<table> ...> [-L <locale>]

-I <instance_name>

8( InfoSphere CDC 5}D{F#Kb,IT8( TSINSTANCE 73d?4z fK5#

-s <subscription_names>

8($){F#g{8(`v$),G4aP>b)$)#

-A 8( InfoSphere CDC 2G$)PyP4mOQ|D}]wPD10;C#

-t <schema>.<table>

8($)P4mD{F,InfoSphere CDC ZK$)OjGm6q = schema.table 8(m{#g{8(`vm,G4aP>b)m#

-L <locale>

CZ InfoSphere CDC 5}DoT73D{F#1!5*zzwDoT73#

c#zXkICq

g{K|n4PI&,G4a5X5 0;g{K|n4P'\,G4a5XGc5#

40 IBM solidDB: Universal Cache C'8O

dmmarktablecapturepoint -I myinstance -s Finance -A

InfoSphere CDC 2G Finance $)PyP4mOQ|D}]wPDVP;C#

dmmarktablecapturepoint -I myinstance -s Finance -t myschema.mytable

InfoSphere CDC Z Finance $)P+8(DmFAn/4,#

dmpark - #Em

9CK|n4#E4m#(}#E4m,+af* InfoSphere CDC z;k6q$)P

X(mD|D#1#Em1,InfoSphere CDC ;a4FzZ4mOywDNNsx| D,bI\<B4mM?jm;;B#

":Z#E4m.0,g{*+Cm5qA?j,G4h* |`E",kNDZ 33 3D:dmendreplication - ax4F;#

ax$)OD4F#PX

dmpark -I <instance_name> -s <subscription_names> <-A|-t <schema>.<table> ...> [-L <locale>]

-I <instance_name>

8( InfoSphere CDC 5}D{F#Kb,IT8( TSINSTANCE 73d?4z fK5#

-s <subscription_names>

8($){F#g{8(`v$),G4aP>b)$)#

-A 8( InfoSphere CDC #E$)PDyP4m#

-t <schema>.<table>

8( InfoSphere CDC #ED$)PD4mD{F#zXkICq= schema.table 8 (m{#g{

-L <locale>

CZ InfoSphere CDC 5}DoT73D{F#1!5*zzwDoT73#

8(`vm,G4aP>b)m#

g{K|n4PI&,G4a5X5 0;g{K|n4P'\,G4a5XGc5#

dmpark -I myinstance -s Finance -A

InfoSphere CDC #E Finance $)PDyP4m#

dmreaddtable - |B4m(e

9CK|n4|B InfoSphere CDC *}]P4mD(e#Z9C RDBMS |D4m( e.s,KPK|n#

dmreaddtable -I <instance_name> <-A|-t <schema>.<table> ...> [-L <locale>]

6 CDC for solidDB 41

-I <instance_name>

8( InfoSphere CDC 5}D{F#Kb,IT8( TSINSTANCE 73d?4z fK5#

-A 8( InfoSphere CDC |BICZ4FDyP4mD(e#

-t <schema>.<table>

8( InfoSphere CDC *d|B(eD$)PD4mD{F#zXkICq= schema.table 8(m{#g{*8(`vm,G4P>b)m#

-L <locale>

CZ InfoSphere CDC 5

}DoT73D{F#1!5*zzwDoT73#

g{K|n4PI&,G4a5X5 0;g{K|n4P'\,G4a5XGc5#

dmreaddtable -I new_instance -A

InfoSphere CDC |BICZ4FDyP4mD(e#

dmreassigntable - |B?jm(e

9CK|n4|B InfoSphere CDC *}]P?jmD(e#Z9C RDBMS |D?j m(e.s,KPK|n#

dmreassigntable -I <instance_name> -s <subscription_names> <-A|-t <schema>.<table> ...> [-L <locale>]

-I <instance_name>

8( InfoSphere CDC 5}D{F#Kb,IT8( TSINSTANCE 73d?4z fK5#

-s <subscription_names>

8(|,CmD InfoSphere CDC $)#g{8(`v$),G4aP>b)$)#

-A 8( InfoSphere CDC |B$)PyP?jmD(e#

-t <schema>.<table>

8( InfoSphere CDC *d|B(eD$)PD?jmD{F#zXkIC schema.table 8(m{#g{8(`vm,G4aP>b)m#

-L <locale>

CZ InfoSphere CDC 5}DoT73D{F#1!5*zzwDoT73#

g{K|n4PI&,G4a5X5 0;g{K|n4P'\,G4a5XGc5#

42 IBM solidDB: Universal Cache C'8O

dmreassigntable -I new_instance -s Finance -A

InfoSphere CDC |B Finance $)PyP?jmD(e#

dmsetreplicationmethod - hC4F=(

9CK|n*$)PDm|D4F=(#1KPK|n1,InfoSphere CDC +NNn/ mD4,|D*"B#

":ZKPK|n.0,zXkax$)OD4F#

dmsetreplicationmethod -I <instance_name> <-r|-m> -s <subscription_names> <-A|-t <schema>.<table> ...> [-L <locale>]

-I <instance_name>

8( InfoSphere CDC 5}D{F#Kb,IT8( TSINSTANCE 73d?4z fK5#

-m 8(m+9C5q(Change Data Capture)w*4F=(#

-r 8(m+9C"B(lU)w*4F=(#

-s <subscription_names>

8($)D{F#

-A 8($)PDyPm+9CQ8>D4F=(#

-t <schema>.<table>

8($)P (m{#g{8(`vm,G4aP>b)m#

-L <locale>

CZ InfoSphere CDC 5}DoT73D{F#1!5*zzwDoT73#

+9CQ8>4F=(D4mD{F#zXkICq= schema.table 8

g{K|n4PI&,G4a5X5 0;g{K|n4P'\,G4a5XGc5#

dmsetreplicationmethod -I myinstance -r -s Finance -A

Finance $)PDyPm+9C"Bw*Q8( InfoSphere CDC 5}PD4F=(#

dmsetreplicationmethod -I new_instance -m -s Finance -t acct.taxcodes

Finance $)PD4m acct.taxcodes +9C5qw*Q8( InfoSphere CDC 5}P D4F=(#

`S4F|n

>Z|,Iozz`S InfoSphere CDC PD4FD|n:

6 CDC for solidDB 43

dmclearevents - e}B~

9CK|nS\mXF(DB~U>S<P>}B~#

dmclearevents -I <instance_name> [-S|-T-|-B] <-A|-s <subscription_names> ...> [-L <locale>]

-I <instance_name>

8( InfoSphere CDC 5}D{F#Kb,IT8( TSINSTANCE 73d?4z fK5#

-S 8( InfoSphere CDC e}4T4DB~#

-T 8( InfoSphere CDC e}4T4M?jDB~#g{48( S"T M B !n,G

4 InfoSphere CDC Z1!ivBaIC B#

-B 8($)P4mD{F,InfoSphere CDC ZK$) = schema.table 8(m{#g{8(`vm,G4aP>b)m#

-A 8( InfoSphere CDC e}yP$)DB~#

-s <subscription_names>

8( InfoSphere CDC e}Q8>D$)DB~#g{8(`v$),G4aP>

b)$)#

-L <locale>

CZ InfoSphere CDC 5}DoT73D{F#1!5

OhCU>;C#zXkICq

*zzwDoT73#

g{K|n4PI&,G4a5X5 0;g{K|n4P'\,G4a5XGc5#

dmclearevents -I myinstance -S -A

InfoSphere CDC *Q8(5}e}4T4DyP$)DB~#

dmclearevents -I myinstance -T -s Finance Marketing

InfoSphere CDC *Q8(5}e}4T4M?jD Finance k Marketing $)DB

dmgetsubscriptionstatus - q!$)4,

9CK|n4lw8>$)D104,DE","+a{"MAj<dv#

dmgetsubscriptionstatus -I <instance_name> [-p] <-A|-s <subscription_name> ...> [-L <locale>]

44 IBM solidDB: Universal Cache C'8O

-I <instance_name>

8( InfoSphere CDC 5}D{F#Kb,IT8( TSINSTANCE 73d?4z fK5#

-p 8( InfoSphere CDC +4,E""MAj<dv#

-A 8( InfoSphere CDC *yP$)lw4,E"#

-s <subscription_name>

8(*dlw4,E"D$)D{F#g{8(`v$),G4aP>b)$)#

-L <locale>

CZ InfoSphere CDC 5

}DoT73D{F#1!5*zzwDoT73#

K|n5XBPdP;n:

v 0 - g{Q8(D$)_P;n/4,# v 1 - g{NNQ8(D$)_P};n/.bD4,#

v :5 - g{Zlw4,E"1vVms#

dmgetsubscriptionstatus -I myinstance -p -A

InfoSphere CDC *yP$)lw4,E","+a{"MAQ8(5}Dj<dv#

dmshowevents - T> InfoSphere CDC B~

9CK|nrj<dvT> InfoSphere CDC B~#zIT9CK|nw*Z\mXF (D“B~U>”S<PT> InfoSphere CDC B~D8!=(#

K|nDdv41dHs3rT>B~,"RZPmPWHT>nBDB~#

dmshowevents -I <instance_name> <-a|-s <subscription> ... |-t <source_ID> ...|-s <subscription> ... -t <source_ID> ...> [-h] [-c max_msg] [-L <locale>]

dmshowevents -I <instance_name> <-a|-s <subscription>|-t <source_ID>> ...> [-h] [-c max_msg] [-L <locale>]

-I <instance_name>

8( InfoSphere CDC 5}D{F#Kb,IT8( TSINSTANCE 73d?4z fK5#

-a 8( InfoSphere CDC T>yP$)DB~#

-s <subscription>

8( InfoSphere CDC *dT>B~D4$)D{F#g{8(`v$),G4a

P>b)$)#

6 CDC for solidDB 45

-t <source_ID>

8( InfoSphere CDC *dT>B~D4j6#g{8(`v4j6,G4aP>

b)4j6#

-h 8( InfoSphere CDC ZB~Pm.0T>jb#K!nozzj6*?vB~T >D?;nE"#

-c max_msg

8( InfoSphere CDC T>DB~Dns}?#g{!TKN}r8(D5sZ

~\},G4 InfoSphere CDC aT>Q8($)M/r4j6DyPB~#

v n!hC - 0#;T>B~#

v nshC - 2147483647

-L <locale>

CZ InfoSphere CDC 5}DoT73D{F#1!5*zzwDoT73#

g{K|n4PI&,G4a5X5 0;g{K|n4P'\,G4a5XGc5#

dmshowevents -I new_instance -s Finance

InfoSphere CDC *Q8(5}T> Finance $)DyPB~#

dmshowevents -I myinstance –a –h

InfoSphere CDC T>yP$)D+?B~#jbT>ZQ8(5}DB~Pm0f#

dmshowevents -I newinstance –s Finance –t Atlanta –s Marketing –h –c 20 dmshowevents -I myinstance –s Finance Marketing –t Atlanta –h –c 20

InfoSphere CDC T> Finance k Marketing $)T0 Atlanta 4j6DnB 20 v B~#jbT>ZQ8(5}DB~Pm0f#

y>dv

2006-04-21 17:23:08.817|T|ATLANTA|95|Information|class com.datamirror.ts.target. publication.c|Transformation Server Communications ending.

2006-04-21 17:23:08.614|T|ATLANTA|1538|Information|class com.datamirror.ts.target. publication.c|---Transformation Server for ATLANTA terminating normally.

2006-04-21 17:23:08.333|T|ATLANTA|1537|Information|class com.datamirror.ts.target. publication.c|Describe conversation with ATLANTA completed successfully.

2006-04-21 17:23:07.911|T|ATLANTA|1536|Information|class com.datamirror.ts.target. publication.c|Describe conversation started by ATLANTA.

2006-04-21 17:23:07.333|T|ATLANTA|1531|Information|class com.datamirror.ts.target. publication.c|Communication with ATLANTA successfully started on Data channel.

2006-04-21 17:23:06.973|T|ATLANTA|1534|Information|class com.datamirror.ts.engine.a |Code page conversation from the source database's code page 1252 to the target database's code page Cp1252 for ATLANTA will be performed by the Remote system

? v G < P D V N I z _ ( | ) V t # d v DZ; P P j 6 K b ) V N # Z

EVENTSOURCE VNP,S 8>4,T 8>?j#

46 IBM solidDB: Universal Cache C'8O

<vM<kdC|n

>Z|,Jmz<vM/r<k InfoSphere CDC +VdCD|n#

dmexportconfiguration - <v InfoSphere CDC dC

1z20 InfoSphere CDC D5}1,9CK|n4<vQ-hCDdCj8E"#+ dCj8E""MA XML dCD~#IT9C dmimportconfiguration |nT+(

}C|n4(D XML D~<kA InfoSphere CDC Dm;5}P#

":K|n;a<vZ\mXF(PdCDX(Z$)Dh +X(Z$)DhC<v= XML D~#PX|`E",kND\mXF(D5#

K|nG;%=|n,+a>zdk\k#z;\ZE>P9CK|n#

C#zIZ\mXF(P

dmexportconfiguration <path_to_configuration_file> [-L <locale>]

<path_to_configuration_file>

8r*<vD XML dCD~D`TrxT76#`T76`TZ InfoSphere CDC D20#

-L <locale>

CZ InfoSphere CDC 5}DoT73D{F#1!5*zzwDoT73#

g{K|n4PI&,G4a5X5 0;g{K|n4P'\,G4a5XGc5#

dmexportconfiguration c:\configurations\configuration.xml

InfoSphere CDC + XML D~<v=8(D`T76#

dmimportconfiguration - <k InfoSphere CDC dC

9CK|nSz(} dmexportconfiguration |n4(D XML D~<k InfoSphere CDC dChC#

":zITZE> P 9 C K | n," k 2 , 2 0 dO$w , T Z ` v53O ? p

InfoSphere CDC#

dmimportconfiguration <path_to_configuration_file> [-L <locale>]

<path_to_configuration_file>

8rz*<kD XML dCD~D`TrxT76#`T76`TZ InfoSphere CDC D20#

-L <locale>

CZ InfoSphere CDC 5}DoT73D{F#1!5*zzwDoT73#

6 CDC for solidDB 47

g{K|n4PI&,G4a5X5 0;g{K|n4P'\,G4a5XGc5#

dmimportconfiguration c:\configurations\configuration.xml

InfoSphere CDC S8(D`T76<k XML dCD~#

d{|n

>Z|,d{|n,|GJmz7 ( InfoSphere CDC f>"i$(E"XUMU9 InfoSphere CDC(v^Z UNIX ~qw)"hC53N}T08]*}]#

dmbackupmd - 8]*}]

9C K|n44( *}]}] bD8]1> # +Z InfoSphere CDC 20?<D

instance/<instance_name>/conf/backup ?<P4(8]1>#Z|D$)dCMm4

,.sxP8]#zITZ InfoSphere CDC KP18]*}]#

dmbackupmd -I <instance_name> [-L <locale>]

-I <instance_name>

8( InfoSphere CDC 5}D{F#Kb,IT8( TSINSTANCE 73d?4z fK5#

-L <locale>

CZ InfoSphere CDC 5}DoT73D{F#1!5*zzwDoT73#

g{K|n4PI&,G4a5X5 0;g{K|n4P'\,G4a5XGc5#

dmset - hC InfoSphere CDC 53N}

9CK|n4i4r|D InfoSphere CDC 53N}#z2ITZ\mXF(P|D5 3N}#PX|`E",kND\mXF(D5#

":zIT9CK|nhCNN53N}#;x,|+vT>QhC*G1!5D5 3N}#

dmset -I <instance_name> [<parameter_name>[=[<parameter_value>]]] [-L <locale>]

-I <instance_name>

8( InfoSphere CDC 5}D{F#Kb,IT8( TSINSTANCE 73d?4z fK5#

<parameter_name>

8( InfoSphere CDC 53N}D{F#

48 IBM solidDB: Universal Cache C'8O

<parameter_value>

8(*Vdx53N}D5#

-L <locale>

CZ InfoSphere CDC 5}DoT73D{F#1!5*zzwDoT73#

g{K|n4PI&,G4a5X5 0;g{K|n4P'\,G4a5XGc5#

dmset -I myinstance

T>QhC*G1!5DyP53N}#

dmset -I myinstance global_unicode_as_char=false

+ global_unicode_as_char 53N}hC* false#

dmset -I myinstance global_unicode_as_char

T>Q8(N}D105#

dmset -I myinstance stop_replication=

>} stop_replication 53N}#

dmshowversion - T> InfoSphere CDC f>

9CK|n4T> InfoSphere CDC f>M9(E#Zk IBM zm*5.0,KPK |n,TcITa)z}ZKPD InfoSphere CDC Df>M9(E#

dmshowversion [-L <locale>]

-L <locale>

CZ InfoSphere CDC 5}DoT73D{F#1!5*zzwDoT73#

g{K|n4PI&,G4a5X5 0;g{K|n4P'\,G4a5XGc5#

dmshutdown - XU InfoSphere CDC

9CK|nT}#XU InfoSphere CDC#Z9~qwr}]bQzT),$r+ InfoSphere CDC }6AnBf>.0,zIT9CK|n#

ZKPK|n.0,ax\mXF(PyP$)OD4F,T7#jIXU#PX| `E",kND\mXF(D5#

K|n^(j+XU InfoSphere CDC,G49C dmterminate |n4?F4Pj

g{ +XU#

6 CDC for solidDB 49

dmshutdown -I <instance_name> [-L <locale>]

-I <instance_name>

8( InfoSphere CDC 5}D{F#Kb,IT8( TSINSTANCE 73d?4z fK5#

-L <locale>

CZ InfoSphere CDC 5}DoT73D{F#1!5*zzwDoT73#

g{K|n4PI&,G4a5X5 0;g{K|n4P'\,G4a5XGc5#

dmterminate - U9 InfoSphere CDC xL

":K|nZ Windows O;\'V#

TZ(} dmshutdown |n^(j+XUDZ UNIX r Linux ~qwOKPDyP5

},I9CK|n4U9+? InfoSphere CDC xL#InfoSphere CDC vU9I UNIX

J'CZKPK|nxt/DxL#

Z9~qwr}]bQzT),$r+ InfoSphere CDC }6AnBf>

9CK|n#

9C dmshutdown |nT}#XU InfoSphere CDC#g{ dmshutdown ^(j+XU

InfoSphere CDC,G49C dmterminate TU9Zz"v dmshutdown .sTVxDN Nn/ InfoSphere CDC xL#

.0,zIT

dmterminate [-L <locale>]

-L <locale>

CZ InfoSphere CDC 5}DoT73D{F#1!5*zzwDoT73#

g{K|n4PI&,G4a5X5 0;g{K|n4P'\,G4a5XGc5#

dmts32 - t/ InfoSphere CDC

9CK|n4t/ InfoSphere CDC 32 ;f>#

dmts32 -I <instance_name> [-L <locale>]

-I <instance_name>

8(*t/D InfoSphere CDC 5}#

50 IBM solidDB: Universal Cache C'8O

-L <locale>

CZ InfoSphere CDC 5}DoT73D{F#1!5*zzwDoT73#

g{K|n4PI&,G4a5X5 0;g{K|n4P'\,G4a5XGc5#

dmts32 -I -I myinstance

InfoSphere CDC t/8(D5}#

dmts64 - t/ InfoSphere CDC

9CK|n4t/ InfoSphere CDC 64 ;f>#

dmts64 -I <instance_name> [-L <locale>]

-I <instance_name>

8(*t/D InfoSphere CDC 5}#

-L <locale>

CZ InfoSphere CDC 5}DoT73D{F#1!5*zzwDoT73#

g{K|n4PI&,G4a5X5 0;g{K|n4P'\,G4a5XGc5#

dmts64 -I myinstance

InfoSphere CDC t/8(D5}#

CZ InfoSphere CDC DC'vZ

C'vZICz(e;iYw,Z8(DmO"z}]bB~0s,InfoSphere CDC I T4Pb)Yw#C'vZJmz(F73Tzc5qhs#

™

Z`k Java dCC'vZD|`E",kND\mXF(D5PD“dCC'vZ”#

f InfoSphere CDC 20D Javadoc(API)E"a)KZ InfoSphere CDC PICD Java

`C'vZDj8`kSZf6#*?

`rf"}LC'vZ.s,zITZ\mXF(PdCC'vZ#PX

vSZj6IwCD\'V=(#

C'vZD Javadoc(API)D5;ZBP?<:<system drive>:\<installation direc-

tory>\docs\api#*Z/@wPr*oz,k%w index.html#

y>C'vZQf InfoSphere CDC a)#zIT)9r^Db)y>TJOzD73#

6 CDC for solidDB 51

CZmMP6pYwDf"}LC'vZ

f"}LGTom==f"Z}]bZDLr(r}L)#f"}LDEcZZ:1z KP|Tl&C'ks1,}]b}fa1SKP|,b(#GZ%@D}]b~q wOKP,"RZ&m}]bks1YH(#a|l#

Z`4M`kC'

vC'vZcwCC'vZ(|HITGZP6pYw0/s,2ITGZm6pYw 0/s)#

vZLrs,zITZ\mXF(DC'vZ!n(O8(*ZD

(ef"}LC'vZ

Z InfoSphere CDC P(ef"}L1,&<GBPwn:

v ,:If"}L;\'V#

v f"}LXkAY_P=vN},b=vN}Xk4UBP3rWHxP(e:

– result - ;v{}dvN},CZrB~U>5XyPmszk# – returnMsg - ;vV{dvN

f"}LC'vZ}]b,S

f"}LC'vZLrM InfoSphere CDC 9C,;2m,Sw*,SA}]bD1!

=(#KhC7# InfoSphere CDC TmywD|DZ1!ivBTf"}LC'vZ LrGISD#

9Cf"}LC'vZ4lw}]

IT(}+53N}+]=f"}L4lw4mPD}]#zITlwBP}]`

v lw535(s$)- 1+]=f"}L1,s$ 0:94}]bPD535ICZf

"}L#}g,s$entry j6K InfoSphere CDC KPC'vZDkZc#

v lwU>XFV

NICZf"}L#}g,j$USER j6KT4mxP|BDK1DC'j6#g{

*9Cf"}L4sF4mOQ"zDm6prP6pYw,G4b+aG#P C#

v lw}]

dICZf"}L#}g,I9C b$ 4lw4PD03q

N(j$)- 1+]=f"}L1,j$ 0:94}]bPDU>XFV

5 - S+]=f"}LD0:x(,zITlw4}]bPD}],"9

},CZ5X*G<Dms{"#

b)5yICwz`4Df"}LC'vZDdkN}#Sz*9CDz7x(,C Zlw}]Dq=TP;,:

TZ InfoSphere CDC,q=G <x>$<value>

dP <x> m>0:,<value> m>*lwD5D{F#

52 IBM solidDB: Universal Cache C'8O

9C s$ 0:4lw535

K0:CZlw535#Bmi\"r*hvKb)5#

0:M5 }]`M hv

s$entry NUMBER m>SPwCf"}LDkZ

c#zITSBPkZcwC

f"}L:

v 1 - 8> InfoSphere CDC

Q-Zme}(XO)Yw

.0wCf"}L

v 2 - 8> InfoSphere CDC

Q-Zme}(XO)Yw

.swCf"}L

v 3 - 8> InfoSphere CDC

Q-ZPek

f"}L

v 4 - 8> InfoSphere CDC

Q-ZPekYw.swC

f"}L

v 5 - 8> InfoSphere CDC

Q-ZP|BYw.0wC

f"}L

v 6 - 8> InfoSphere CDC

Q-ZP|BYw.swC

f"}L

v 7 - 8> InfoSphere CDC

Q-ZP>}Yw.0wC

f"}L

v 8 - 8> InfoSphere CDC

Q-

ZP>}Yw.swC

f"}L

v 9 - 8> InfoSphere CDC

Q-Zm"BYw.0wC

f"}L

v 10 - 8> InfoSphere CDC

Q-Zm"BYw.swC

f"}L

s$srcSysId VARCHAR (;Xj64}]D;C#

s$srcTabId VARCHAR m>+4FD}]"MA?j

D4}]bP4mD{F#

s$tgtTabId VARCHAR m>S4SU

j}]bP?jmD{F#

Yw.0wC

4FD}]D?

9C j$ 0:4lwU>XFVN

K0:CZlwPX453O"zDYwDE"#zIT+ jb$ k InfoSphere CDC d

O9CTlw`,DE"#

6 CDC for solidDB 53

IC5P>gB:

0:M5 }]`M hv

j$CCID VARCHAR j69Cek"|Br>}Y

wDBq#

j$CODE VARCHAR j 6U > rG <u ? D`M

“U”(m>"BYw)r“R”

(m>5q)#

j$CTRR r j$CNTRRN VARCHAR j6G<KU>/G<u?D4

mD`TG<E#

":1Z9I"BDeku?

OwCf"

CNTRRN |,PbeDE"#

j$ENTT r j$ENTTYP VARCHAR zIZ453Oj6Yw`M

DU>rG<zk#

j$JRN r j$JOURNAL VARCHAR InfoSphere CDC }ZSPA!

ek"|Br>}YwDU>/

G<D{F#

j$JOB VARCHAR j6Z453OxPek"|

Br>}Dw5D{F#

j$MBR r j$MEMBER VARCHAR j64mD{

j$NBR r j$JOBNO VARCHAR j6}ZxPek"|Br>

}YwD4mODLrDxL j6#

j$PGM r j$PROGRAM VARCHAR j6453OxPe k"|B

r>}YwDLrD{F#

j$SEQN r j$SEQNO VARCHAR j6U>rG<Pe k"|B

r>}YwDrE#

j$SYNM r j$SYSTEM VARCHAR j6453Dw

j$USER VARCHAR j6Z4OxPek"|Br

>}YwD}]bC'{#

j$USPF VARCHAR j6Z4OxPek"|Br

>}YwDYw53C'{#

j$TSTP r j$TIMSTAMP VARCHAR j6Z4OxPek"|Br

> } Yw r" B DUZ M 1

d # Z' V" k +H D 7 3 P,KU>XFV

1dq=* YYYY-MM-DD- HH:MM:SS.UUUUUU# q r,InfoSphere CDC +"ki I?V UUUUUU hC* 0,

ry>;+d|(ZZ#

}L1,CTRR r

Frdp{#

z{#

NDUZM

54 IBM solidDB: Universal Cache C'8O

9C b$"a$"k$ M d$ 0:4lw}]5

9CDV0:4lw}]:

0: == hv

b$<4P{F> dk CZl w 4P P } ]D 0 3

q#03qGTd&CNNd ;.04mPPDu<3q#

}g,zI\QT4mxPB

P|B:

UPDATE source_table set MYCOLUMN = 2 where MYCOLUMN = 1;

b+ T y PP hC 2 , d P MYCOLUMN Zz4PK SQL od.0G 1#

1(ef"} }Llw MYCOLUMN D0

3q1,&8(BPn:

b$MYCOLUMN;

b+5X5 1#

a$<4P{F> dk CZl w4 P P}] D s3

q#s3qG4mPPQ*;

D}]#}g,QIzDmo =*;D}]#

}g,zI\QT4mxPB

P|B

UPDATE source_table set MYCOLUMN = 2 where MYCOLUMN = 1;

b+ T y PP hC 2 , d P MYCOLUMN Zz4PK SQL od.0G 1#

1(ef"}LMv(*f" }Llw MYCOLUMN Ds

3q1,&8(BPn:

a$MYCOLUMN;

LMv(*f"

b+5X5 2#

k$<?j|P{F> dk CZCJ?jmTiRh*^

DDP#

":|P;I)sF

d$<?jP{F> dk/dv CZlwd;.s+C4|B

?j}]bPDmD}]5#

;Pb)5IT;f"}L^

6 CDC for solidDB 55

f"}LC'vZD>}

BPzkNGf"}LC'vZD>}#

zk "M

create or replace procedure PROD.AUDIT_STPROC (

result OUT INT, returnMsg OUT CHAR, s$entry IN NUMBER, s$srcSysId IN CHAR, s$srcTabId IN CHAR, s$tgtTabId IN CHAR, j$ENTT IN CHAR, a$IDNO IN NUMBER, a$PRICE IN NUMBER, a$DESC IN CHAR, a$LONGDESC IN CHAR, a$TRANSDATE IN DATE, d$IDNO IN NUMBER, d$PRICE IN NUMBER, d$DESC IN CHAR, d$LONGDESC IN CHAR, d$TRANSDATE IN DATE )

ENTRYPOINT VARCHAR(50); BEGIN

CASE s$entry WHEN 16 THEN ENTRYPOINT := 'User Exit program called Before Insert'; WHEN 1048576 THEN ENTRYPOINT := 'User Exit program called After Insert'; WHEN 64 THEN ENTRYPOINT := 'User Exit program called Before Update'; WHEN 4194304 THEN ENTRYPOINT := 'User Exit program called After Update'; END CASE;

zyw"*+]Af"}LDN}XkGP'D}]`M#

BPN}GXhN},XkZf"}LPyw:

result - 5XCZ8>f"}LI&4PD5“0”,r5XI\G{ }Dms#

returnMsg - ZB~U>P5Xms{"#

BPN}QZKf"}

v s$entry - lwwCf"}LDkZc#ZK>}P,InfoSphere

CDC Z?vkZcwCC'vZ#

v s$entry - lwwCf"}LDkZc#ZK>}P,InfoSphere

CDC Z?vkZcwCC'vZ#

v s$srcSysId - lw4}]D;C

v s$srcTabId - lw4

v s$srcTabId - lw4mD{F

v s$tgtTabId - lw?jmD{F

v j$ENTT - lwCZ8>Z4mO"zDYw`MDU>zk

v a$ - lw IDNO"PRICE"DESC"LONGDESC M TRANSDATE

4PDs3q

a$ - lw IDNO"PRICE"DESC"LONGDESC M TRANSDATE

4PDs3q

v d$ - lw IDNO"PRICE"DESC"LONGDESC M TRANSDATE

?jPPQ*;D}]

v d$ - lw IDNO"PRICE"DESC"LONGDESC M TRANSDATE

?jPPQ*;D}]

ITSb)kZcwCKf"}LC'vZ#

LPyw:

mD{F

56 IBM solidDB: Universal Cache C'8O

zk "M

insert into PROD.AUDIT_TABLE1 values ( s$entry, s$srcSysId, s$srcTabId, s$tgtTabId, j$ENTT, a$IDNO, a$PRICE, a$DESC, a$LONGDESC, a$TRANSDATE, d$IDNO, d$PRICE, d$DESC, d$LONGDESC, d$TRANSDATE, ENTRYPOINT);

result := 1;

returnMsg := 'OK';

END AUDIT_STPROC;

Kf"}LC'vZ+b)5ek PROD.AUDIT_TABLE1#

Kf"}LC'vZI&# ":g{f"}L5X“0”,G4aZB~U>PzI{"#

CZ InfoSphere CDC Dy>C'vZ

InfoSphere CDC a)Ky>C'vZ,zIT4-y9Cb)C'vZ,2ITTdx P^DTJOzD$w73:

v UserExitSample - )D4FB~Tlw"zDB~Dj8E"#

v UserExitSample1 - G<Qek?jODmDBP,"+|Gf"ZD>D~P#

C'+D>D~

v DEUserExitSample - CZ9C %USER P/}Dmo=P#|Fcmo=PC'

a)DN}D\M,"R5XT 1 *v?D\M#

v SPUserExitSample - Ky>9C4T4D3qwCf"}L#

v PopWindow - Ky>r*_P(*E"DT0r#g{_Png

`D GUI Bfw,G4Ky>+k UNIX M Linux 20dO$w#

D{F8(*N}#

X-Windows .

*KPy>C'vZx;^D|G,zXkZ\mXF(P8(Q`kC'vZDj

< 7 6 ; } g ,

com.datamirror.ts.target.publication.userexit.sample.UserExitSample#

Q`kDy>C'vZ;Z ts.jar D~P,zIZ <InfoSphere CDC installation directory>/lib PR=#k"b,

ts.jar D~PQ`kDC'vZ_P *.class )9

g{*^Dy>C'vZ,G4XkZ|D4zks`kCC'vZ#>Z|,Z Win- dows M Linux =(OK}LD8>E"#

PXgNZ\mXF(P8( Java `rf"}LC'vZD|`E",kND

\mX

F(D5#

":C'vZ`2XkZ`76P#

*`ky>C'vZ(Windows)

1. #9 InfoSphere CDC#

2. + samples.jar D~b9uA InfoSphere CDC 20D~PD lib D~PP#7

#Zb9uC jar D~1,VD~Pa9#

Zb9uC jar D~s,z+_P`FTBDD~Pa9:

<InfoSphere CDC installation folder>\lib\com\datamirror\ts\target \publication\userexit\sample

6 CDC for solidDB 57

3. Ty>C'vZxP|D#

4. `kQ^DDC'vZ#}g,g{*`k UserExitSample.java,G4r*|n0

Z,/@A lib D~P,;s"vBP|n:

javac -classpath ts.jar;. com\datamirror\ts\target\publication\userexit\sample \UserExitSample.java

g{K|nI&KP,G4A;O+;PNNdv#

":zD53Xk_PKPK|nD Java JDK#

5. ZI&KP|ns,/@ABP?<"7OQ4( UserExitSample.class D~:

<InfoSphere CDC installation directory>\lib\com\datamirror\ts\target \publication\userexit\sample

6. t/ InfoSphere CDC#

7. dCC'vZDns=hGZ\mXF(P8( UserExitSample Dj<76#}g:

com.datamirror.ts.target.publication.userexit.sample.UserExitSample

":Pp8( .class )9{#

B;=v24

PXgNZ\mXF(P8( Java `C'vZD|`E",kND\mXF(D5#

":g{rcZz773P9Cy>C'vZ,G4XkbTb)y>,;sEIT ?p|G#IBM TQ^Dr(FDC'vZ`<BD:fa{;P#

NNpN#

*`ky>C'vZ(UNIX M Linux)

1. #9 InfoSphere CDC#

2. + samples.jar D~b9uA InfoSphere CDC 20?<D lib ?<P#7#Z

b9uC jar D~1,V?<a9#

Zb9uC jar D~s,z+_P`FTBD?<a9:

<InfoSphere CDC installation directory>/lib/com/datamirror/ts/target /publication/userexit/sample

3. Ty>C'vZxP|D#

4. `kQ^DDC'vZ#}g,g{*`k UserExitSample.java,G4r*|n0

Z,/@A lib ?<,;s"vBP|n:

javac -classpath ts.jar:. com/datamirror/ts/target/publication/userexit/sample /UserExitSample.java

g{K|nI&KP,G4A;O+;PNNdv#

":zD53Xk_PKPK|nD Java JDK#

5. ZI&KP|ns,/@ABP?<"7OQ4( UserExitSample.class D~:

<InfoSphere CDC installation directory>/lib/com/datamirror/ts/target /publication/userexit/sample

6. t/ InfoSphere CDC#

7. dCC'vZDns=hGZ\ mXF(P8( UserExitSample Dj<76#}

com.datamirror.ts.target.publication.userexit.sample.UserExitSample

58 IBM solidDB: Universal Cache C'8O

":Pp8( .class )9{#

B;=v24

PXgNZ\mXF(P8( Java `C'vZD|`E",kND\mXF(D5#

":g{rcZz773P9Cy>C'vZ,G4XkbTb)y>,;sEIT ?p|G#IBM TQ^Dr(FDC'vZ`<BD:fa{;P#

e;bvsFm

1 InfoSphere CDC bv4mk?jm.dDe;1,aZ TS_CONFAUD mPG<P Xbv=8DE"#InfoSphere CDC 20LraZdC InfoSphere CDC Zd8(D?

j*}];C4(Km#

Z>ZP,z+KbTBZ]:

e;bvsFmDa9

zIT9C TS_CONFAUD m4zYe;bvgN0l?jm#}g,zITi/ AFTERIMG PTKbT?jmxP|DD1d#;s,zITi4 BEFOREIMG M AFTERIMG PDZ],TKb<B?jmOD}]D4m|D#bIozj6e;bv

_TPDJb#

NNpN#

e;lbMbvZ

\mXF(PxPdC#PX|`E",kND\mXF(D5#

TS_CONFAUD mDa9gBy>#

P hv

CNFTIME 1lb=e;1?jODUZM1d#

SRCTIME T4m&Ce;}]D1d#

SRCSYSID $)D4j6#

SRCSCHEMA 4mD#=rb{#

SRCNAME 4mD{F#

SRCMEMBER KVN*U#

TGTSCHEMA ?jmD#=rb#

TGTNAME ?jmD{F#

OPTYPE <Be;D4ODP6pYw#C5*T

v 1 - Z4mPekP#

v 2 - Z4mP|BP#

v 3 - S4mP>}P#

CNFTYPE Qlb=De;D`M#C5*TBdP;v:

v 1 - Z4mPekP#CPD|Z?jmPQ-fZ#

v 2 - Z4mP|Br>}P#CPD|Z?jmO

v 3 - Z4mP|Br>}P#4mM?jmD3q;%

v 4 - Qlb=bbDe;#

BdP;v:

6 CDC for solidDB 59

P hv

RESMTD Q9CDe;bv=(#C5*TBdP;v:

v 1 - IC4

v 2 - IC?j

v 3 - ICns5

v 4 - ICn!5

v 5 - C'vZ

g{bv=(G^,G4+;aZKmPdkP#PXb )=(D|`E",kND InfoSphere CDC D5#

CNFRES 8

BEFOREIMG |D.04mPPD5w#PXKPDq=D|`E",

BEFORETRNC 8>GqQXOf"Z BEFOREIMG PD03q#C5*

AFTERIMG |D.s4mPPD5w# PXKPDq=D|`E",

AFTERTRNC 8>GqQXOf"Z AFTERIMG PDs3q#C5*T

TGTIMG "z4F.0?

TGTTRNC 8>GqQXOf"Z TGTIMG PD3q#C5*TBd

WINIMG "ze;bv.s?jmPns;PD5w#PXKPD

WINTRNC 8>GqQXOf"Z WINIMG PD3q#C5*TBd

>e;GqQbv#C5*TBdP;v:

v Y - Qbve;#

v N - 4bve;#

kND:P3qq=;#

TBdP;v:

v Y -

v N - 4XOC5#

kND:P3qq=;#

BdP;v:

v Y - QXOC5#

v N - 4XOC5#

E",kND:P3qq=;#

P;v:

v Y - QXOC5#

v N - 4XOC5#

q=D

P;v:

v Y - QXOC5#

v N - 4XOC5#

QXOC5#

jmPPD5w#PXKPDq=D|`

|`E",kND:P3qq=;#

P3qq=

sFmPD BEFOREIMG"AFTERIMG"TGTIMG M WINIMG PT>4r?jmP DPD5w#

b)PPD3q\?j*}]}]bOD VARCHAR }]Dns$H^F#}K raw" ~xFr LOB PPD}].b,3q|,PPyP5#?vPD}]ICBPq=T

60 IBM solidDB: Universal Cache C'8O

(length:value)

ZTOq=P,value GPPD}],length GCZm>}]DV{}?#3q+}V} ]T>*V{.,"R+ NULL 5T>* null#

P3qk4mMe;bv=8sFmPDP3r`%d#g{3q$H,}?j*} ]}]bP VARCHAR }]Dns$H

;GmPDZ;P,G4|I\a;XO#

,G4b)3qI\a;XO#g{mD|P

XOD3q

g{P3q$H,} VARCHAR PDns$H,G4+a;XO#sFmPP;vP,

|a8>?v3qPGqQXO#}g,g{ WINTRNC G Y,G4 WINIMG D5 Q;XO#XODPDq=gB:

(-length:value)

ZTOq=P,value GXOD5,length GQXOV{.PDV{}?#

4sFD}]`M

sFm4+BP}]`MDP|(Zd3qP:

v IMAGE

v NTEXT

v TEXT

g{4mr?jm|,_Pb)}]`MDP,G43qaj+vT|G#~xF} ]+w*.yxF`kDV{vVZ3qP#3q;af"4T;\'VDPDNN

Management Console Administration Guide D=<

>Za)PXX(Z solidDB DC'vZM53N}DE"#>ZG InfoSphere Change Data Capture Management Console, Administration Guide D=<#

dCC'vZ

C'vZICz(e;iYw,Z8(DmO"z}]bB~0s,InfoSphere CDC I TKPb)Yw#19C InfoSphere CDC 1,}]bB~Q(e*P6pYwrm6

pYw#P6pYw|(ek" |Br>}# m6pYw|("BrXOYw# } g,zI

D>}Yw.s"M/(#

C'vZITVi*0C'vZrsC'vZ:

v 0C'vZ - Z InfoSphere CDC +NNP6prm6pYw4FA?jm.0K

v sC'vZ - Z InfoSphere CDC +NNP

TdCP6pC'vZLr,CLraZ InfoSphere CDC 4FX(?jmO

6prm6pYw4FA?jm.sK

TBPmj6CZZP6prm6pYw0s*"C'vZLrD#C=8:

v (F InfoSphere CDC N1+P6pYw4FA?jm#}g,zIT*"CZe

k"|Br>}YwD_-,Tcy]3)8(Du~(

g-<"1UZ)4"z

6 CDC for solidDB 61

b)Yw#InfoSphere CDC ITKPC'vZT0y]-<"1UZ(g 2004 j 1 B"2004 j 2 B"2006 j 11 BH)T`&?jm&CP6pYw(ek"|B

r>})#

v {C1!P6prm6pYw,"(}wC4P(FYwDC'vZLr4f;b

)

1!Yw#}g,*Kl&m6pXOYw,zIT*"JmzZ?jmO4P] 1>}(xG@C>})DC'vZ#

* InfoSphere CDC for IBM solidDB dCC'vZ

9C InfoSphere CDC for IBM solidDB,zITdC Java `C'vZ#

TZ Java `C'vZ,=({Q$H(e#bb6Ez;\tCM{CC'vZLr# zh*dC Java PCZ5VI InfoSphere CDC for IBM solidDB a)D UserExitIF

SZ`DC'vZ#

Java

`dCC'vZ:

1. %wdC → $)#

2. !q$)#

3. %wm3dS<"!qm3d#

4. R|%w"!q`-3dj8E"#

5. %wC'vZ!n(#

6. SC'vZ`MPmP!q Java `#

7. Z`{rPdkI5V UserExitIF SZD Java `C'vZD{F#

}g,z

I\Q<k UserExitIF SZ,"RzD/}P5VKSZDC'vZLr

`_PBP(e:public class UE1 implements UserExitIF

Z`{rP,zh*dk:

!n hv

UE1 g{|G@"`

<Java package>.UE1 g { ` Q | ( Z Java | ( } g ,

com.datamirror.interface.UE1)P#

S`kC'vZLrzIDD~Xk;ZI CLASSPATH 73d?}CDbrD ~PP#

8. ZN}rP,dk*a)xC'vZLrDN}#

Zu</}LP,(}wC getParameter( ) =(,ITCJC'vZLr`PD

N}#^8(N}D<(#ZKrPdk

D5ITGTIq=#N}5V{.D

$H;\,} 255 vV{#

9. ZBP;vr`vYwTdk* InfoSphere CDC wCDC'vZLrD{F:

!n hv

ek0 InfoSphere CDC Z4FekYw0KPC'v

eks InfoSphere CDC Z4FekYwsKPC'v

62 IBM solidDB: Universal Cache C'8O

!n hv

|B0 InfoSphere CDC Z4F|BYw0KPC'v

|Bs InfoSphere CDC Z4F|BYwsKPC'v

>}0 InfoSphere CDC Z4F>}Yw0KPC'v

>}s InfoSphere CDC Z4F>}YwsKPC'v

"B0 InfoSphere CDC Z4F"BYw0KPC'v

s InfoSphere CDC Z4F"BYwsKPC'v

XO0 InfoSphere CDC Z4FXOYw0KPC'v

XOs InfoSphere CDC Z4FXOYwsKPC'

10. %w&C#

InfoSphere CDC for IBM solidDB D53N}

53N}9zITXF InfoSphere CDC DP*#g{4F73h*X(dC,G4I T9C53N}4^D InfoSphere CDC P1!YwDP*#1!53N}hCJOs

`}20#,Vb)1!hC,1Azl$ InfoSphere CDC DdC#

InfoSphere CDC a)CZXF4M?j}]f"wP*D

53N}#

"M:

v g{Zn/4FZd|D53N},G4Xk#9MXBt/ InfoSphere CDC,T9

|Dz'#

v 1}6AO_f>D InfoSphere CDC 1,+,VyPH0fZD53N}hC#

(*53N}

(*53N}CzITXFGq*X(B~ZB~U>PzI InfoSphere CDC {"#

global_shutdown_after_no_heartbeat_response_minutes

9CK53N}I8(Z#9$)Dn/ InfoSphere CDC xL.0(E;n/DVx 1d(TVSF)#g{8(,vIS\6'D5,G4+a9C1!hC#

&CTs - 4

1!hC - 15 VS

n!hC - 3 VS

nshC - 999 VS

global_conversion_not_possible_warning

6 CDC for solidDB 63

9CK53N}IXF InfoSphere CDC ZBPivBGqaZ\mXF(B~U>P

zI/f:

v X(}]5^(xP}]*;#

v v=,v6'DQ*;D}]`M#

+KN}hC*BPdP;v:

true - g{X(}]5^(xP}]*;,rv=

4ZB~U>PzI/f#

false - g{X(}]5^(xP}]*;,rv=,v6'DQ*;D}]`M,G

4;ZB~U>PzI/f#

&CTs - ?j

1!hC - False

,v6'DQ*;D}]`M,G

ns/LB?53N}

InfoSphere CDC 53N}I9zs?uY?j}]bZ5qZdD$w:X#InfoSphere CDC aZ?jO&CxLiBq,TuY$w:X#?j}]bPD?vd5+k4O

Dd5;B#;x,|I\;a4P?vQZ4O4P}Dd5#}g,g{44P

K}vwT|,;vYwD!Bq,G4?jI\a+yP}vYww*%vBqD ;?VxPd5#zIT9CK53N}iO4s?uY?j}]byhDJ4#1 !hCJCZs`}}]b,+Gg{?j53J4P^RzITS\

$,G4IJ1w{hC#

mirror_commit_after_max_transactions

K53N}8(Zd5.0Vi=;pDnsBq}?#(#,"v=?j}]bD d5GT4OKPD&CLry"vDd5xPl&#(}XFd5"v=?j}]

bD5J,zIT9CK53N}\md5#K=(ICZuY51d *z#

H}1dS

5=}]bD

&CTs - ?j

1!hC - 10

n!hC - 1

mirror_commit_after_max_seconds

K53N}8(d5!Bq=?j}]b0D1d?(TkF)#(#,"v=?j} ]bDd5GT4OKPD&CLry"vDd5xPl&#(}XFd5"v=? j}]bD5J,zIT9CK53N}\md5#K=(ICZu ]bD*z#

&CTs - ?j

1!hC - 1 k

n!hC - 1

64 IBM solidDB: Universal Cache C'8O

Y51d5=}

mirror_commit_after_max_operations

K53N}8("vd50Xk&C=?j}]bDYwN}#(#,"v=?j} ]bDd5GT4OKPD&CLry"vDd5xPl&#(}XFd5"v=? j}]bD5J,zIT9CK53N}\md5#K=(ICZuY5 ]bD*z#

&CTs - ?j

1!hC - 1000

n!hC - 1

1d5=}

mirror_commit_on_transaction_boundary

K53N}8> InfoSphere CDC Z?j}]bO4PDd5Gq+<Uk4}]bO "zDd5;B#g{!qvT4}]bDd5XF,G4 InfoSphere CDC aJmz

i4sBqD?Va{#

+KN}hC*BPdP;v:

v true - ;vT4}]bDd5XF

C(}7#vr?j"MQd5Bq4a)f}DBq;BT#

v false - vT4}]bDd5XF#K5a{CBq&mDd5XF#5qZd;a

"T#VBq;BT#

&CTs - ?j

C - true

1!h

refresh_commit_after_max_operations

K53N}j6K|,"BZd?vBqDPD}?#*KuY"BZd?j}]b OD$w:X,InfoSphere CDC a(Zr?j}]bd5|D,x;Gw*%;sBq

44P"B#

&CTs - ?j

#vQd5BqPDG<E;5q=?j#Kh

1!hC - 1000

n!hC - 1

`k53N}

TZ;)53N},IThC&mQ(e Unicode PP}]D1!=(,"R*}]b hC1!V{`k#

global_unicode_as_char

K5 3N}8 >&mQ(e Unicode PP}] D1!=(#TZ~qwOD?v InfoSphere CDC 20,K53N}(e&m Unicode PP}]D531!=(#g{ Unicode PQhC*531!5,G4a9CK53N}(eD10531!=(#

+KN}hC*BPdP

;v:

6 CDC for solidDB 65

v true - InfoSphere CDC + Unicode PPDyP}]S*%VZV{#Z Unicode

P|,%VZV{}]19CKhC#

v false - InfoSphere CDC + Unicode PPDyP}]S*,x;w#Z Unicode P

|,G%VZV{}]19CKhC#+K53N}hC* false,T7# InfoSphere CDC 4kH0 InfoSphere CDC "P

":+KN}hC* false ;\7# Unicode PP;4FDG%VZV{}]aZ? jO}7T>#TZ4FDG%VZV{}],zI\Xk&CC'vZLrrd

{(F,T}7T> Unicode PPD}]#PXC CZzD=(D InfoSphere CDC

&CTs - 4

1!hC - false

f`,D=(&mG%VZV{}]#

'vZLrD|`E",kNDJ

nUC'D5

ELJ453N}

;)53N}XF InfoSphere CDC PDZf9C?#*KDFT\,g{ z\;* InfoSphere CDC Java ibzVdH1!5 512 MB |`DZf,G4ITw{ELJ

453N}T9CvSDZf#

mirror_memory_txqueue_total_mb

K53N}XFCZZ4Of"}]DZf?#*qCnQT\,K53N}&Cc ;s,Tc]IZ4}]bOfZD4d5}]Dns}?#

&CTs - 4

1!hC - 15 WVZ

mirror_memory_txqueue_each_mb

K53N}XFCZZ4Of"}]DZf?#*qCnQT\,K53N}&Cc ;s,Tc]I4O"zDnsBqD}]#

&CTs - 4

1!hC - 3 WVZ

global_memory_lob_cache_mb

K53N}XFCZZ?jOf" LOB 5DZf?#*qCnQT\,K5&Cc; s,Tc]I+4FDns LOB 5D+?}]#

1!hC - 2 WVZ

&CTs - ?j

mirror_queue_for_buffers_between_cdc_threads_operations

K53N}XF InfoSphere CDC DU>Nw\&Tc{C`v&mw#1!hCJC Zs`}iv#zITvsK5TCZI_H}673#

&CTs - 4

66 IBM solidDB: Universal Cache C'8O

1!hC - 100 vu?

n!hC - 100 vu?

&CxL53N}

;)53N}aw{ InfoSphere CDC &CP"P}]Mms&mD==#

mirror_end_on_error

9CK53N}I8>Z?j}]bO"z&CmssGqax5q#

+KN}hC*BPdP;v:

v true - ?j}]bO"z&Cmssax5q#

v false - ?j}]bO"z&Cmss;ax5q#

&CTs - ?j

1!hC - true

refresh_end_on_error

9CK53N}I8>Z"z&CmssGqax"B#

+KN}hC*BPdP;v:

v true - vV&Cmssax"B#

v false - vV&Cmss;ax"B#

&CTs - ?j

1!hC - true

6 CDC for solidDB 67

68 IBM solidDB: Universal Cache C'8O

}G-} Solid Information Technology Ltd. r_ International Business Machines Cor- poration ifZ(,qr;\TNN==9C>z7PDNN?V#

>z7\@z({ 6144941"7136912"6970876"7139775"6978396 M 7266702 D#

*Kz78(D@zvZ\FV``EG ECCN=5D992b#

>E"G*Z@za)Dz7M~q`4D#

IBM I\

yZxrDz7M~qDE",krz1XD IBM zmI/#NNT IBM z7"L rr~qD}C"GbZw>r5>;\9C IBM Dz7"Lrr~q#;*;V

IBM D*6z(,NN,H&\Dz7"Lrr~q,<ITzf IBM z7"Lrr ~q#+G,@@Mi$NNG IBM z7"Lrr~q,rIC'TP:p#

IBM +>I\Q5Pr}Zjkk>D5Z]PXDwn({#a)>D5"4 '9Cb)({DNNmI#zITCif==+mIi/Dy:

IBM Director of Licensing IBM Corporation North Castle Drive Armonk, NY 10504-1785 U.S.A.

PX+VZ(DBCS)E"DmIi/,kkzyZzRrXxD IBM *6z(?E* 5,rCif==+i/Dy:

IBM World Trade Asia Corporation Licensing 2-31 Roppongi 3-chome, Minato-ku Tokyo 106-0032, Japan

Zd{zRrXx;a)>D5PV[Dz7"~qr&\XT#PXz10

ZhC

>un;J C"zrNNbyD unk1X

TIONAL BUSINESS MACHINES CORPORATION“4V4”a)>vfo,;=PNN

V`D(^[Gw>D9G5,D)#$,|(+;^Z5,DPXGV("JzM JCZ3VX(C>D#$#3)zRrXxZ3);WP;Jmb}w>r5

#$#rK>unI\;JCZz#

>E"PI\|,<u=f;;<7DX=r!"ms#K&DE"+(Z|D;b

)|D+`k>JODBf>P#IBM ITf1T>JOPhvDz7M/rLrxPD xM/r|D,x;mP(*#

(I;;B DzRrXx: INTERNA-

>E"PTG IBM Web >cDNN}C<;G*K=cp{Ea)D,;TNN==

d1TG) Web >cD#$#G) Web >cPDJO;G IBM z7JOD;?V, 9CG) Web >cx4DgU+IzTPP##

IBM IT4|O*J1DNN==9CrV"

pN#

>LrD;mI=g{*KbPXLrDE"To=gB?D:(i)JmZ@"4( DLrMd{Lr(|(>Lr).dxPE";;,T0(ii)JmTQ-;;DE

"xP`%9

IBM Canada Limited Office of the Lab Director 8200 Warden Avenue Markham, Ontario L6G 1C7 CANADA

;*qXJ1Du~Mun,|(3)iNBD;(}?D6Q,<IqCb=fD E"#

>JOPhvDmILr0dyPICDmIJOyI IBM @] IBM M'-i"IBM zJm~mI-irNN,H-iP

K&|,DNNT\}]<GZ\X73PbCD#rK,Zd{Yw73PqCD }]I\aPwTD;,#P)b?I\GZ*"6D53OxPD,rK;#$k

;cIC53OxPDb?a{`,#Kb,P)b? {I\aPnl#>D5DC'&1i$dX(73DJC}]#

C,kkBPX7*5:

Duna)#

zya)DNNE"x^kTzP#NN

G(}Fcx@FD,5Ja

f0G IBM z7DE"ISb)z7D)&L"dvf5wrd{I+*qCDJO Pq!#IBM ;PTb)z7xPbT,2^(7OdT\D {XZG IBM z7Dyw#PXG IBM z7T\DJb&1rb)z7D)&La

yPXZ IBM 44=rrbrDyw<If1|DrUX,x;mP(*,|Gvv

m>K?jMb8xQ#

>E"|,ZU#5

>},>}PI\a|(vK" +>" 7FMz7D{F# yPb){V<Gi9 D,tV5znP5J5qs59CD{VMX7kK`F,?tIO#

f(mI:

>E"|(4oTN=Dy>&CLr,b)y>5w;,Yw=(OD`L=(#

g{G*4UZ`4y>LrD Yw=(OD&CLr`LSZ(API)xP&CLr D*""9C"-zrV"*?D,zITNNN=Tb)y>LrxP

D"V",x^kr IBM 6Q#b)>}"4ZyPu~Bw+fbT#rK,IBM ;\##r5>b)LrDI?T"I,$Tr&\#

2b)5}LrD?]=4rdNN?VrNN\zz7,<Xk|(gBf(y w:

qYwP9CD}]M(fD>}#*K!I\j{X5wb)

+7T"f]TrNNd

4F"^

70 IBM solidDB: Universal Cache C'8O

IBM"IBM Uj"ibm.com®"Solid®"solidDB"InfoSphere"DB2"Informix®M WebSphere®G International Business Machines Corporation Z@zM/rd{zRrX xDLjr"aLj#g{b)LjMd{ IBM "aLjZ>JOPZ;NvV1j

PLj{E(

z~."aDLjrU((Lj#b)Lj2I\GZd{zRrXxD"aLjr U((Lj#Z Web ODf(MLjE"(www.ibm.com/legal/copytrade.shtml)&a

)K IBM LjDnBPm#

®r™

),G4b){Em>|GG"<>JO1i IBM yPD-}@

Java MyPy

Z Java DLjMUjG Sun Microsystems, Inc. Z@zM/rd{zRr

XxDLj#

Linux G Linus Torvalds Z@zM/rd{zRrXxD"aLj#

Microsoft and Windows M Microsoft Corporation Z@zM/rd{zRrXxD"aL

UNIX G The Open Group Z@zMd{zRrXxD"aLj#

d{+>"z7r~q

{FI\Gd{+>DLjr~qjG#

yw 71

򔻐򗗠򙳰

Pz!"

S151-1149-00

IBM solidDB User Manual

Specifications and Main Features

Frequently Asked Questions

User Manual

6 CDC for solidDB