IBM kE8O User Manual

IBM solidDB IBM solidDB Universal Cache

V6.5

kE8O



G151-1276-01

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

Z;f,Z;^)f

Kf>&CZIBM solidDB V6R5(z7`E 5724-V17)MIBM solidDB Universal Cache V6R5(z7`E 5724-W91)

0yPsx"PfM^)f,1=ZBf>PmPyw*9#

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

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

|D\a ..............ix

XZ>Va .............xi

!"<( ...............xi

o(m>(<( .............xii

(z&\!n ..............xii

1 IBM solidDB z75PEv ......1

XZ solidDB De5a9Ev .........1

XZ solidDB Universal Cache De5a9Ev ...3

w*XTM&\ .............4

2 z7M|0E" ...........7

solidDB ~qwLr| ...........7

?<a9...............8

bD~{...............8

ODBC"JDBC M(P`LSZ .......9

53$_M5CLr ..........11

y> ................11

InfoSphere CDC m~| ..........12

IBM Data Server Driver for ODBC and CLI Lr| 13

D5Lr| ..............13

solidDB D5 .............13

InfoSphere CDC D5 ..........14

3 20 ...............17

53hs ...............17

Yw53C'^Fhs(Linux M UNIX) ...18

20 solidDB ..............18

<Ngf20 .............18

XF(20 .............19

2,20 ..............20

s20Nq .............21

20 JDBC M ODBC }/Lr........22

20 solidDB JDBC }/Lr .......22

20 solidDB ODBC }/Lr .......23

20 solidDB D5Lr| ..........24

20^)| ..............24

6X solidDB ..............26

4 i$ solidDB 20 .........27

$w?<M solid.ini dCD~ .......27

t/ solidDB "4(Z;v}]b .......28

WN,SA solidDB ............29

9C solidDB SQL `-w,SA}]b ....30

i4}]bMdC4, ..........31

9C solidDB SQL `-w4P SQL od ....32

#9;sXBt/}]b ..........33

9C solidDB SQL `-w#9}]b .....33

XBt/}]b(>}

#9;sXBt/}]b ..........34

) .........34

5 + solidDB k<N SQL M'z;p9

C .................35

6 KPy> .............37

7 + solidDB }6AB"Pf6p ...39

w} ................41

yw ................43

iii

iv IBM solidDB: kE8O

1. solidDB 6.5 z7 ...........1

2. solidDB Universal Cache e5a9 .....3

3. solidDBSQL `-wQ,S ........31

4. solidDB SQL `-w(solsql)zzD>}dv 32

vi IBM solidDB: kE8O

1. !"<(..............xi

2. o(m>(<( ...........xii

3. solidDB M solidDB Universal Cache z7Lr|

Di~ ..............7

4. solidDB6.5 ?<a9 ..........8

5. solidDB JDBC }/Lr 2.0 X|E" ....9

6. InfoSphere CDC 203q ........12

7. InfoSphere CDC i~DD5 .......14

8. FvD ulimit 5 ...........18

vii

viii IBM solidDB: kE8O

|D\a

^)f 01 D|D

v mSK Yw53C'^Fhs(Linux

M UNIX®)#

v |BKs20Nq!Z:20.s,;Yh*V/4P copy_licenses E>#VZ,

solidDB

20Lra+@@mI$D1>ECZ?vy>?<P#

v mSKB!Z:

– IBM

Data Server Driver for ODBC and CLI Lr|

– + solidDB k<N SQL M'z;p9C

x IBM solidDB: kE8O

XZ>Va

!"<(

>8OT IBM solidDB z75PxPKEv#|9a)KPXgNWNhC solidDB T 0gNKPy>D8>E"#

>8O4a)PXgN20MdC solidDB Universal Cache r_gN*<9C solidDB

z7a)D;,&\?~M&\D8>E"#PXgN9lD5DE",kND

OPDD5;Z#

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"#

\m18O

D~76m> }GmPyw,qrD~764 UNIX q=m>#1\(/)

Yw53 g{D5|,PXYw53.dDnpDZ

KVeCZLrzkMLrdv#>} SQL od29CKV e#

}{#

"amu?#

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

?wDJb24Ky=i4#

V{m>20y?<#

DG UNIX q=#Microsoft

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

Windows q=;Z UNIX q=

],G4WHa=

o(m>(<(

solidDB D59CBPo(m>(<(:

m2.o(m>(<(

q=JCZ

(z&\!n

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

... !TE8>IT`NX49CTd?#

. . .

o(hvICKVe#If;?VIC

Zo(P#

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

I}vciID;Pm>bGH0zkPDSx#

Ve#

(z&\IozPzm1]DC'(}g,P/;crS&;C) 3 {9Cm~z 7#BPwZ8(K solidDB PDw*(z&\#

|LdkM<=

|Ldk

|L<=

ITv9C|riO|4/@ solidDB C'gf#PX9C|riO|4/@|nPg fD|`E",kND`&DYw53D5#

WZT>

solidDB 'Vj<Yw53T>hC,}g,_THHMVehC#

VehC

IT9Cj<Yw53Yw4!qD>DU+"s!MVe#PX8(VehCD| `E",kND`&DYw53D5#

xii IBM solidDB: kE8O

;@5ZU+

;h*xVU+MIT9C solidDB PDNN&\#

kd{(z<uDf]T

solidDB (}j< API kYw53xP;%,b) API 'Vk;)(z<u;%,S

xJmz9CA;JAwMd{(z$_#

WZCJDD5

solidDB DD5GIE"PDT HTML q=a)D,Zs`} Web /@wP<IT

i4#E"PDJmzy]/@wPhCDT>W!n4i4D5#|9Jmz9C A;JAwMd{(z<u#

PXE"PD(z&\!nD|`j8E",kND

solidDB E"PDW3#

XZ>Va xiii

xiv IBM solidDB: kE8O

1 IBM solidDB z75PEv

IBM solidDB z75PDXcZZ9CKZfMX5}]b<u#bV<u\;a)G #lDKPYH,HyZELD+3}]bDKPYHl.6#IBM solidDB(r_r4

* solidDB)9Cl$D SQL od,9&CLr\;Z?kSZqCC8rvBq,

1dG4"kFcD#

xl&

IBM solidDB 6.5 z75PI=vz7iI:

IBM solidDB Universal Cache G5gDWvX5MZf_Y:fm~#|(}+T \X|}]_Y:f=;vr`v solidDB Zf}]b5}P4a_yZELD+3X

5}]b~qwDYH#

IBM solidDB G;v&\+f

CT,Tzc51&CLrTT\MI?TD*s#|IT9%v solidDB 5}P,1

|,ZfmMyZELDm#|9_Pd{Xc,}g,_ICT5VM`n;,D 4F<u#

DZfX5}]b,|a)KG#lDYHMG#_DI

1. solidDB 6.5

XZ solidDB De5a9Ev

>Zhv solidDB D53e5a9#

solidDB 9CM'z/~qw#M#5JO,solidDB a0G(}-w~qwMM'zx

LjID#~qwxL:p\m}]bD~,S\M'z&CLr,SA}]bDk s,T}]b4PIM'zksDYw#

M'zxLCZ(}~qwxL+XhDNq+]

x}]b#M'z`MP`V:M

'zITG|nP$_"<N&CLrr_}]b,$$_#(#,wVwyD&C

Lr+w*M'z,SA solidDB#

M'zM~qwIT;Z;,Dwz(Zc)O,ZbVivB,|G(}xgxP (E#solidDB I

T,1'V`Vxg-iM,S`M#}]b~qwMM'z&CL

rIT9C`V;,Dxg-i,1,SA`v>c#

solidDB 9ITZ&CLrxLPKP#bG(}solidDB

SbCJ

(LLA)a)D#ZbVivB,&CLr+4SAfKz7;pa)D/

2mZfCJ

(SMA)M

}b#4SD&CLr(}1SwC/}45Vk~qw(E,SxZ!KM'zk ~qw.d(}ng TCP/IP Hxg-ixP(E1yh*D*z#(}9C>X/}

wC4f;xg,S,Sx+sa}KT\#PX|`E",kND6IBM solidDB 2 mZfCJM4SbCJC'8O7#

*r}]b~qwa;i/(2MG;v SQL od),M'zXk\;kK}]b~ qwxP(E#km`d{D}]b~q

w;y,solidDB 29C

}/Lr

4'VK(

E#M'z&CLrwC}/LrPD/},;sI}/Lr&mk~qwxP(E Md{_eBq#}g,zIT`4+wC(ODBC)}/LrPD/}D C oTL

™

r,2IT`4+wC(JDBC)}/LrPD/}D Java

Lr#

PX ODBC M JDBC }/LrT0gN+|GkM'z&CLrdO9CD|`E

",kND IBM solidDB Programmer Guide#

2 IBM solidDB: kE8O

XZ solidDB Universal Cache De5a9Ev

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

2. solidDB Universal Cache

e5a9

BfhvKwvi~DG+M&\#

solidDB * z+}]4FAMSdP4F}]D0K}]b#!vZ4F#MD;,,

solidDB ITG4}]bM/r?j}]b#

}]~qw * z+}]4FAMSd

P4F}]DsK}]b#!vZ4F==D;

,,sK}]bITG4}]bM/r?j}]b#

™

InfoSphere

CDC 5} * x( DBMS D InfoSphere CDC }fDKP15}#*

hC InfoSphere CDC 5},XkZ}KPyV[D DBMS DZcO20K`&D

1 IBM solidDB z75PEv 3

InfoSphere CDC zmLrm~(}g,InfoSphere CDC for DB2®r_ InfoSphere CDC for solidDB)#TZ solidDB,ITZk}ZKP solidDB DZc`,DNNZcO2 0MhC InfoSphere CDC for solidDB zmLr#

dC$_ - CZdCM4( InfoSphere CDC 5}D GUI $_ryZXF(D$_#

ZdC5}1,a)CZkd` InfoSphere CDC 53xP(EDKZET0CZ,S A}]bDG<

CJ~qw * ;vxL((#w*;n~qr;vX$xLKP),|Jm\mXF (C'CJMdC InfoSphere CDC 5}#;,DC'ITT;,D5}_PCJ(# Z20CJ~qwZd,+*sza)\mXF(*9CDKZEM\m1G

\mXF( * ;v_P GUI D;%=&CLr,ITC4dCM`S4F#|Jm

z\mwv~qwOD4FYw,8(4FN},T0SM'z$w>Pt/"BM `SYw#

E"#

w*XTM&\

SZ“CJ\mw”8S<P4( }]f"w4*<9C ]bM`X InfoSphere CDC 5}D_-5e#(}9Cy(eD}]f"w,ITh

CCZ_eeV+}]S;v}]f"w4F=m;v}]f"wD

;2P}V`MD}]f"w:4"?jT0+X#+X}]f"wITw*4M?

jNk$)#(#,+X}]f"wCZ solidDB Universal Cache,"R*+r4F(

eKTF3dT#g{1>rcZ0K}]~qwPw*;A1>,G4a(e%v

OX$

jIKhC4F.s,ITZM'z$w>OXU\mXF(,x;a0l4~qw k?j~qw.dDn/}]4Fn/#\mXF(9|,;vB~U>M`Sw#

B~U>JmzliQzID InfoSphere CDC B~{"#`Swa)KXhD ,x`S4FYwMH}1d#CZhv4FdCDwvi~D<G(}1S&m<

NTs49lD#\mXF(PD`SwCZT1d*s\OqD$w73,b)7 3h*,xVv}]F/iv#

\mXF(#

}]f"w

'VT

Zfm

Zfm+|GDyP}]ICkTwZfCJxPKE/D}]a 9 f"ZwZf P#+}]f"ZwZfPDC&ZZi/H}1dOLxLB?Os#y]&CL

rDh*,IT+Zf}]mdC*VC}]mr2,}]m#Kb,in \Jmz(eVCmh*DBqMCT6p(|(j+MCT)#

DG<&

4 IBM solidDB: kE8O

PX|`E",kND6IBM solidDB Zf}]bC'8O7#

yZELDm

yZELDmG+3DX5}]bm,H[ZZd{yZELD}]bz7PR=D m#}K9CZfmTb,2ITZ}]bP9C}#DyZELDm#(#,yZ

ELDmZNN1r<;P;?V}]$tZwZfP#ITgZfmMyZELD mxPi/#}g,(} SQL ,SYwIT+ZfmkyZELDm,Sp4;mD

5J;CTZC'G8wD#

yZELDmD<C?O!"RIT

k=53P#!\Kz7Ds!O!,+G|T;'Vm`_6&\,}g%"w" B~Mf"}L#

4P^KU4DYw,rK solidDB nJOCZ6

2mZfCJ(SMA)M4SbCJ(LLA)

2mZfCJ(SMA)M4SbCJ(LLA)Jm&CLr1S4SA solidDB ~q

w,^h(}xg-i(}g,TCP/IP)4xP(E#SMA Jm4S`v&CLr,x LLA Jm4S;v&CLr#(}9C>X/}wC4f;xg,S,Sx+sa}K

T\#

PX|`E",kND6IBM solidDB 2mZfCJM4SbCJC'8O7#

4F<u

Z solidDB z75P P,IT ( }}V;,D<u44F }],4, _64F" InfoSphere CDC 4FT0 solidDB _ICT(HotStandby)#

4FITG,=4Frl=4F#xP,=4F1,Z"pK4PBq}LPa+}

]VC+]xSUK#xPl=4F1, K#ITy]“FM”r“-'”Yw#M4xP4F#Z“FM”#MP,+I"pK4$

n4F#Z“-'”#MP,+ISUK4"p4F#

+Zd5-<Bq.sE+}]+]xSU

solidDB _ICT(HotStandby)

solidDB _ICTr_r%D HA r HotStandby,Ia_}]DICT#~qwGIT

dCD,g{;v~qw'\,m;v~qwMITSf$w#w~qwPD}]+

;4F=(z~qwP,(z~q w;Cw“H8C”%*#g{w~qw;I g,Z"z2~JOr_xP(Z,$DivB),G4&CLrIT,SA(z~ qw""4Lx$w,"R;a*'NNQd5DBq#

Z solidDB HA P,9CyZFMD4F-i+w~qwPDyP}]|D+MA(z ~qw#IT+

qwP&mD#g{w~qw'\,G4(z~qw+Sf$w(4PJO*F)" w*BDw~qwLx&m:X#9C,=4F-i1,ZJO*FZd;fZ*

}]DgU#

8w,S

)KJO*F8wTT0w~qwk(z~qw.dD8w:Xyb#

ITT HotStandby 9CmIMCTMOqMCT#9P;vMCT6pF*

1w~qwM(z~qw<&Zn/4,1M9CmIMCT,xw~qw@"KP 1M9COqMCT#g{9C“ TJ&”MCT,G4NN1r"z%vJO1<a #$Bq#

k“_64F”M“InfoSphere CDC 4F”`H,9C“solidDB HA”1, D}]bPDyP}]#T(C SQL |nN=a)K;)/,XF#

K-ihC*,= (2-Safe) rl= (1-Safe)#Bq:Xy>OGZw~

G solidDB ODBC M JDBC }/LrD;VXb,S==,|*&CLra

<U+4F~qw

C(}

TJ&

;

1 IBM solidDB z75PEv 5

+ 43 hidden pages