IBM solidDB User Manual

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

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#

© Solid Information Technology Ltd. 1993, 2008

?<

< . . . . . . . . . . . . . . . . . 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 6 CDC for solidDB . . . . . . . . . 21

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 '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 DC'vZ . . .	. . .		. 51
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

yw . . . . . . . . . . . . . . . . 69

iii

iv IBM solidDB: Universal Cache C'8O

<

1.	solidDB Universal Cache e5a9	. .	.	.	. 2	3. _P solidDB _ICTD solidDB Universal
2.	solidDB Universal Cache 1!?p	. .	.	.	. 4	Cache ?p . . . . . . . . . . . . . 5

v

vi IBM solidDB: Universal Cache C'8O

m

1.	!"<(. . . . . . . . . . .	.	.	. ix	3. solidDB Universal Cache DD5 . . . . . . 9
2.	o(m>(<( . . . . . . . .	.	.	. x

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 Universal Cache 1h*>Z;|a)KkCZsK}]~qwD InfoSphere Change Data Capture nUC'D5C'Va`TUDE"#

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

!"<(

solidDB D59CBP!"<(:

m 1. !"<(

	q=	JCZ
	}]bm	KVeCZyPU(D>#
	NOT NULL	ICKVeDs4V88> SQL X|VMj{F#
	solid.ini	b)Ve8>D~{M76mo=#
	SET SYNC MASTER YES;	KVeCZLrzkMLrdv#>} SQL od29CKV
	COMMIT WORK;
		e#
	run.sh	KVeCZy>|nP#
	TRIG_COUNT()	KVeCZ/}{#
	java.sql.Connection	KVeCZSZ{F#
	LockHashSize	KVeCZN}{"/}Td?M Windows® "amu?#
	argument	K`?wJ8>C'r&CLrXka)DE"#
	\m8O	bVy=CZ}Cd{D5r_,;D5PDBZ#BuoM
		?wDJb24Ky=i4#
	D~76m>	D~764 UNIX® q=a)#1\(/)V{m>20y?
		<#

ix

m 1.	!"<( (x)
q=		JCZ
Yw53		g{D5|,PXYw53.dDnpDZ],G4WHa=
		DG UNIX q=#Microsoft® Windows q=;Z UNIX q=
		.s"(Z(EP#d{Yw53+%@Pv#TZ;,DY
		w539I\P;,DBZxPhv#

o(m>(<(

solidDB D59CBPo(m>(<(:

m 2. o(m>(<(

	q=	JCZ
	INSERT INTO table_name	o(hvICKVe#If;?VICKVe#
	solid.ini	KVe8>D~{M76mo=#
	[ ]	=(E8>I!n;g{GVeD>,G4Xk+=(E|,
		Zo(P#
	|	z_,CZ+o(PPD=v%b!nVt*#
	{ }	s(ECZTo(PPD;i%b!nxP(g;g{GVe
		D>,G4Xk+s(E|(Zo(P#
	...	!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 d#

}K solidDB 0K}]b.b,bv=89{C IBM InfoSphere Change Data Capture(;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'#

1

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#y]4F==,sK}]bI

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

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( - ICZdCM`S4FDxP GUI D;%=&CLr#|Jmz\m wV~qwOD4F"8(4FN}T0SM'z$w>t/"BM5qYw#

(}Z“CJ\mw”8S<P4(}]f"w4*<9C\mXF(#}]f"wG }]bM`X CDC 5}D_-5e#9CQ(eD}]f"w,IThC$),C$ )|,}]f"wdD}]4F#

;2P}V`MD}]f"w:4"?jT0+X#g{}]f"wQ4(*+X}

]f"w,G4|ITw*4M?jNk$)#(#,+X}]f"wk solidDB Universal Cache dO9C,"RTF3dTQ(eCZ+r4F#g{1>Z0Krcw

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

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

~qw.dn/D}]4Fn/#\mXF(9|(B~U>M`Sw#B~U>J mzliQzID CDC B~{"#`Swa)X*D'VT,xX`S4FYwMH

}1d#zI(}1SY]<NTs49lG)hf4FdCi~D<#\mXF(

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#

CDC for solidDB IT(}>Xk6L JDBC ,S4A!}]T0+}]ek solidDB }]b,rKz;XZ,;ZcOEC CDC 5}M solidDB }]b#;x,k"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 CDC for solidDB,G4 CDC 5}I?pZ53 PDNNZcO#XpGZ HA(HotStandby)dCP,*s CDC 5}k solidDB ~ qwZ;,ZcOKP#

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^FdTN;}]b

~qwT\D0l#

1 IBM solidDB Universal Cache Ev 3

< 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,S#\FXF(+Z%@D

ZcOKP#

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

4 IBM solidDB: Universal Cache C'8O

< 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_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:

v4SbCJ

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

'8O7#

vsolidDB _ICT'V

'V solidDB ~qwPDJO*F#PX|`E",kND6IBM solidDB _IC

TC'8O7#

vwY

g{4F^(]I solidDB ~qwPDVx:X,G4a+&mYHwM(uY)#

S&CLrGH45,ba<Bl&1dS$#+4Fw?fk:ex,TcIT

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

PX|`E",kND6IBM solidDB \m18O7P:~qwKdCN};;ZD

“U>DAw?V”PDU>DAwdCN}#

vQzYwMU>gv

g{4FQ#9rQ'\,G4 solidDB ~qwI\aLx&m:X,"[}}]T

)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|`E",kND6IBM solidDB \m18O7P

:~qwKdCN};;ZD“U>DAw?V”PDU>DAwdCN}#

vU>DAwoO

m`KP1F}wICZ`S solidDB 6q(solidDB w*4)M&C(solidDB w

*?j)xLDYw#mkND:}]b^F;;ZPD LOBS `X^F#

v}]`M'V

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

D}]`M;;Z#

^F

}]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,G4Z5qZd?jOI

\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

J m Z I C s ! ^ F Z R # t Z M m ( Z f m ) P D y P L O B ( 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(yZELDm)Ds_g(ns* 2GB)LOB(maxiLOB)Z4 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,G4a5Xms,"ax$

)OD4F#

v XO(solidDB w*4)

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

4a+ms5XA&CLr#

vw|<x (solidDB w*4)

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

|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{%4NNOvfr,G4azzms,"ax$)OD4F(5q)#

v2,mMY1m (solidDB w*4)

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

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

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

CDC ^F

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

vlY0kM"B

CDC for solidDB ;'VlY0kM"B&\#

vT/4(?jm

g{k*5qDmk}Cj{T<x`X*,G4Z(eB$)1,+^(9CT

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

Kfr,G4+^(4($)#

^FJCZyPdC0`XDd{ DBMS z7#

v"B

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

;G}Z}CDm2;GQ-}CDm#

1 IBM solidDB Universal Cache Ev 7

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#

2+MO$

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

vzXk* CDC 5}CZCJ}]bDC'{a)kCJM^D}]k*}]`XD yPX*>$#(iz9C}]b\m1C'{#

vC'{M\kI CDC 53f"Z CDC 5}0d`&DVCTf"bP#+f"D

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

vZyPivB,S\ CDC 5}M}]b.dDw?#ZX(Zz7D JDBC }/L rPa)rxPS\#

vCDC 5}.dDw?4-}S\#

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",kNDCZsK}]~qwD CDC i~f=a)D InfoSphere Change Data Capture 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$_#

4.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'D5PD8>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#

m 3. solidDB Universal Cache DD5

i~	D5;C	X|D5
CDC for solidDB	|(Z IBM solidDB 6.3 D5Lr|P	6IBM solidDB Universal Cache C'8
		O7,:CDC for solidDB;Z
CZsK}]~qwD CDC	|(Z InfoSphere Change Data Capture v6.3	InfoSphere Change Data Capture nU
	D5Lr|P	C'D5
CDC \mXF(	|(Z InfoSphere Change Data Capture v6.3	InfoSphere Change Data Capture Man-
	D5Lr|P	agement Console, Administration Guide
CDC CJ~qw	^@"D5,kND\mXF(D5	^@"D5,kND\mXF(D5

9

10 IBM solidDB: Universal Cache C'8O

3 dC solidDB Universal Cache

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

D4F$)#

dC solidDB MsK}]~qw

dC solidDB

*K\;+ solidDB k CDC <udO9C,zh*^DdChC,Tc 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 dCN}hC*

“yes”#

[LogReader]

LogReaderEnabled=yes

*K\;Z CDC 4FP+ solidDB Cw4}]b,h*4PKYw#v'5*

“no”#

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

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 1 d U d # g { 4 4 P 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

":kmIDMCThC`H,OqDMCThCa}pT\p'#g{T solidDB HA(HotStandby)dC&C 2-Safe 4F-i(1!5),G4IT9C mIDMCT,x;afZ}]*'D#U#

vDefaultStoreIsMemory

1!ivB,solidDB mf"`MhC* M m(DefaultStoreIsMemory=yes)#

11

vIsolationLevel

1!ivB,solidDB tk6phC*d5A(IsolationLevel=1)#

4.liGqQhC CLASSPATH 73d?,Tc||( solidDB JDBC }/Lr

.jar D~# PX8>E",kND solidDB 20?<PD JDBC TvD~

(jdbcreadme.html r jdbcreadme.txt)#

dCsK}]~qw

*K\;+sK}]~qwk CDC 4F<udO9C,zI\h*|DddChC#

y]fz7a)D InfoSphere Change Data Capture nUC'D5PD8>E"4dC sK}]~qw#

4( CDC 5}

9C CDC dC$_IT4( CDC 5}#

*<.0

vli solidDB MsK}]bGq}ZKP#

vzT}]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*(ew solidDB ~qwM(z solidDB ~qwDwzX7MKZE#

2.4(CZsK}]~qw CDC DB5}#

PXj8D8>E",kNDCZsK}]~qwD InfoSphere Change Data Capture nUC'D5PDdC InfoSphere CDC ;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

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

ITZ4FZd4(m#

vli solidDB MsK}]bGq}ZKP#

vliCZ solidDB D CDC 5}MsK}]~qwGq}ZKP#

vzT}]b_Pc;DCJX(#

vQy]5qfr(eyhD4F-r#

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

12 IBM solidDB: Universal Cache C'8O

PXj8D8>E",kND InfoSphere Change Data Capture Management Console, 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'GZ20\mXF(

Zd4(D#

2.hCCZ solidDB MsK}]bD}]f"w#

a.mSB}]f"w# PXj8D8>E",kND InfoSphere Change Data Capture Management Console, Administration Guide PD To add a new datastore

;Z#

b.hC,SN}# PXj8D8>E",kND InfoSphere Change Data Capture 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 Administration Guide PD Managing user accounts ;Z#

b.+}]f"wVdxC'# PXj8D8>E",kND Management Console 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 Console, 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 Console, Administration Guide PD Setting up datastores for replication ;Z#

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

PXj8D8>E",kND InfoSphere Change Data Capture Management Console, 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 Console, Administration Guide PD Setting up subscriptions ;Z#

8. *=v$)PD4F3dm#

3 dC solidDB Universal Cache 13

PXj8D8>E",kND InfoSphere Change Data Capture Management Console, 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 Console, Administration Guide PD Setting conflict detection and resolution ;Z#

10.t/=v$)OD4F#

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

Z#

14 IBM solidDB: Universal Cache C'8O