IBM kE8O User Manual

Download

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

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

_64F

“_64F”<um>;VyZl =-'D=(#|JmC'Z`v}]b~qw.d V"}],P1r9*9}],=#_64F9C;VwX/1>#M#ZK#MP,

%vZc+5P}]DwX1>#x;vr`v1>Zc9IT_P; ryPwX}]D1>#xR,?v1>9IT_P;X(ZC1>D}]#

ITxP+r4F;1>ZcIT+}]OXAwXZc,2ITSwXZcBX} ]#g{1>Zca;K`e;D}],G4wXZcIT\x

sY9|I)yP1>Zc9C#y4FD}]Gy]inD"</$)#MxP\ m D#\mSZIC SQL oTD=P)9DN=#

r_DdK}],;

?VwX}]

9C_64FDl==(1,53<UGinD;g{3)ZcrNN-rx# G41|GXBt/r_XB,SA531,IT9b)ZcXB,=#bMJmn

g PDA rJG>gTHF/h8ksQ|BD}],kxgO*,S,TsYXBk xg,S#C'IT!qT}]xP,=D5J#

PX|`E

",kND IBM solidDB Advanced Replication User Guide#

InfoSphere CDC <u

IT9C IBM InfoSphere Change Data Capture (InfoSphere CDC) <u45VZwV }]b.dxPl=4F#InfoSphere CDC <uyZl=FM#M#IT4(%r $

),T+4KD}]|D51+MA?jK#IT(}hC=v$),|G_P5q D4(eM?j(e,4qC+r$)\&#

solidDB M

v Z solidDB P,IT9C InfoSphere CDC <uZNN solidDB ~qw5}T.d

4F}]#}g,|tCKXm;C_`\&,r_JmZ;vn//n/hCPd C=v solidDB 5},SxITZNN;K,HX&m,;}]D=

PX|`E",kNDIBM solidDB Replication with InfoSphere CDC User Guide#

v Z solidDB Universal Cache P,IT9C InfoSphere CDC <u4hC solidDB

0K_Y:f,Ta_CJf"ZsK}]~qwPDT\X|}]DYH#

solidDB Universal Cache b=vz7P<9CK InfoSphere CDC <u#

v1>#

6 IBM solidDB: kE8O

PX|`E",kNDIBM solidDB Universal Cache C'8O7#

Zb=vhCP,?v solidDB ~qw5}9ITG;v

InfoSphere CDC <uP|(X(Z}]bDi~,b)i ~ w*@"xL(F* InfoSphere CDC 5})KP#9|(CZ\m4F$)M}]3dD\mXF(#

solidDB HotStandby T#

2 z7M|0E"

solidDB M solidDB Universal Cache z7I solidDB M InfoSphere CDC i~iI#

BmT>K solidDB M solidDB Universal Cache z7Lr|Py|,Di~#yP> D?vi~<Xk%@20#

3. solidDBMsolidDB Universal Cache

i~ solidDB solidDB Universal Cache

IBM solidDB X X

InfoSphere Change Data CapturesolidDB X

InfoSphere Change Data Capture \mXF

(

InfoSphere Change Data Capture CJ~q

InfoSphere Change Data Capture

~qw

BPdP;n:

v InfoSphere Change Data Capture DB2

Linux"UNIX M Windows

v InfoSphere Change Data Capture Informix

v InfoSphere Change Data Capture Microsoft

SQL Server

v InfoSphere Change Data Capture Oracle

Trigger

v InfoSphere Change Data Capture Oracle

Redo

v InfoSphere Change Data Capture Sybase

v InfoSphere Change Data Capture DB2

z/OS

v InfoSphere Change Data Capture DB2

iSeries

IBM Data Server Driver for ODBC and CLI

V9.7

;PZ?pS;v solidDB 4F=m;v solidDB(InfoSphere CDC 4F)D InfoSphere CDC

<uDdCPEh*#

z7Lr|Di~

sK}]

;PZG)CZ?p SQL +]D solidDB Universal Cache dC(dPsK}]~qwG IBM

}]~qw)PEh*Kn#

solidDB ~qwLr|

solidDB Lr||,;{W solidDB m~,dP|( JDBC M ODBC }/LrMwV

5CLr#

solidDB Lr|Gk@@mI$$iD~ solideval.lic ;p;6D#@@mI$Jmz Z 90 l.ZTC solidDB#*q!@CmI$,kk IBM +>*5#

?<a9

solidDB 6.5 D1!20+4(;vF* solidDB6.5 D?<#

Bm5wK solidDB6.5 20?<PDD~MS?<#

;C 5w

y?< y?<P|,gBy>DZ]:

bin solidDB ~xFD~

doc_html M

doc_txt

eval_kit/standalone solidDB ~qw@@f>D$w?<#

eval_kit/cdc solidDB ~qw@@f>CZk Universal Cache

include C oTLr7

jdbc solidDBD Java }]b,S(JDBC)}/Lr

4. solidDB6.5

?<a9

v C4cZZ}]b@@WNKPy>DE>

v @@mI$D~

v CZCJLr|D5D welcome.html D~

IC HTML q=MD>q=DLr|D5

K?<|

,y> solid.ini dCD~M@@mI$D~

(solideval.lic)#

r InfoSphere CDC 4F;p9CD$w?<#

K?<|,y> solid.ini dCD~M@@m

I$D~ (solideval.lic)#

lib Lrb

licence mI$MywD~

manuals IT+ PDF q=D"DfVaBX=KD~P

procedures CZ4(MKP}]JdM"BDf"}LD

samples ITZ}] b@@WNM+4D&CLr

bD~{

solidDB TI4SbDN=a)Km`D~#

b)bD~s`}<ITikBP`p.;:

v ODBC }/Lr

v solidDB 2mZfCJM4SbCJD~

v (EbD~

v SA(~qw API)bD~#

CZ WebSphere

P,;s(}6-3fPDVa4S4CJ

SQL E>

WN9CDy>

D}]f"(zX~f5

8 IBM solidDB: kE8O

";GyP=(O<_POv?vD~#}g,;P Windows 73PEa)K3)( EbD~#

3)bD~G2,D,4,1z4P`k"4SYw1,b)bD~Ma4SAM' z&CLrDI4PLr#d{bD~G/,D:b)D~k

I4PD~GV*f"

D#14PLr1,Ma+b)D~0kZfP#TZm`b,solidDB Z3)=(r yP=(O<,1a)K2,bM/,b#

bD~#fZBfDdP;v?<B:

v “bin”

v “lib”

(#,“bin”?<B|,/,b(}KI4

PD~Tb),x“lib”?<B|,2,b#

“lib”?<B9|,CZ Windows 73D<kb#

PXbD~{D|j8E",kND solidDB Lr|PD“SDK 5w”,I(} solidDB 20?<D6-3fCJCD5#

ODBC"JDBC M(P`LSZ

solidDB *M'za)K ODBC M JDBC SZ,BPwZPr*hvKb)SZ#P X|`j8E",kND IBM solidDB Programmer Guide#

solidDB JDBC }/Lr 2.0

5. solidDB JDBC

f]T JDBC 2.0,|, JDBC 2.0 I!Lr|D!P&\?~

}/Lr;C <solidDB 20?<>/jdbc/SolidDriver2.0.jar

JDBC URL q= jdbc:solid://<hostname>:<port>/<username>/<password>[?<property-name>=<value>]...

}/Lr`{ solid.jdbc.SolidDriver

}/Lr

}g:

"jdbc:solid://localhost:1964/dba/dba"

2.0

X|E"

j<;BT

solidDB JDBC 2.0 }/Lr'V JDBC 2.0 f6#Kb,9'V JDBC 2.0 I!Lr

|(T0F*“j<)9”)D,SX"JNDI }]4MP/#

QkT JDK V1.2.2"V1.3 M V1.4 I&bTK solidDB JDBC }/Lr#"RT JDBC

API bTW~ 1.3.1 xPKO$#

;)Gj<&\?~I'V IBM WebSphere

T0CZXF,1D)9#

solidDB JDBC 2.0 }/Lr10'VI!Lr|DBP&\?~:

v ,SOC(solid.jdbc.ConnectionPoolDataSource `)

v Q,SDP/(solid.jdbc.rowset.SolidJDBCRowSet `)

v Q5VD JDBC }]4:

– solid.jdbc.DataSource(CZ5V javax.sqlDataSource)

2 z7M|0E" 9

– solid.jdbc.SolidConnectionPoolDataSource( CZ5 V

javax.sql.ConnectionPoolDataSource)

v JTA(Java Bq API)– Java D XA SZ(C45V javax.transaction.xa.XAResource

M javax.transaction.xa.Xid)

IBM solidDB Programmer Guide P|,K solidDB JDBC }/LrDj{D5#

solidDB JDBC }/Lr)9

'VBfP>DGj<)9#PX|`E",kND IBM solidDB Programmer Guide#

v JDBC URL q=:JmzZ URL V{.PhC,StT5

,1:,S,1G8CZwC(},SWSVxPD}]+dDNN JDBC wC

v ,S

Dl&,1#g{Zy8(D1dZ4SU=l&{",G4+Wv I/O l##JDBC

j<(2.0/3.0);'VhC,S,1#solidDB z7IT9C=V=(4jIKNq: ;VG9C

vB,1d%;<GAk#

v G<,1:Z,S1%",1#KhCG(},StT5VD#KtT+2GId

{=(8(D JDBC DG<,1(}g,}/Lr\mwPDG<

v ,SUP,1:g{,S&Z;n/4,o=Ky8(D1d,~qwMaXUK

,S#bG(},StT45VD,d5+2GKa0D~qwN}hC#

v od_Y:f:solidDB JDBC }/Lr9C'\;Z4(,SZd+y

od_Y:fs!hC*;VtT#

v 8w,S'V:solidDB JDBC }/Lrj+'V solidDB 8w,S(TC),dP|

(8wJO*FM:Xyb#PX8w,SDC(D|`E",kND6IBM solidDB _ICTC'8O7#

v 2mZfCJ(SMA),

v SQL +]:JmhC SQL +]==

v ?<M#={FtT:JmhC solidDB }]bD?<{FM#={F

v WebSphere 'V:Z solidDB L r|D“jdbc”?<B,Z;v % @ DD~

SolidDataStoreHelper.jarPa)K;vF*“SolidDataStoreHelper”D}]4J d

Gj<}/Lr\mw)9=(,m;VG9CtTzF#Zb=Vi

,1N})#

x(,SD

S:Jm,SA SMA ~qw

solidDB ODBC }/Lr 3.5.x

solidDB a)K=v ODBC }/Lr,;vCZ Unicode V{/,m;vCZ ASCII V{/#PXb)}/LrD|`E",kND IBM solidDB Programmer Guide#

;'VBP/}:

v SQLBrowseConnect

v SQLSetScrollOptions

v SQLParamOptions

v SQLNativeSql

v SQLMoreResults

ODBC )9

10 IBM solidDB: kE8O

solidDB ODBC }/Lr|,`v)9,b))9k,1XF"od_Y:fP*M' V8w,S`X*#PX|`E",kND IBM solidDB Programmer Guide#

(PSZ

}g,solidDB &CLr`LSZ(SA API)M solidDB ~qwXF API(SSC API)

Jm C Lr1SwC}]b~qwPD/}#b)(PSZG(} solidDB 2mZf CJ(SMA)M4SbCJ(LLA)ba)D#

53$_M5CLr

solidDB |,CZ}]\mM\mD=vXF($_,solidDB6LXF (solcon) M solidDB SQL `-w (solsql),9|,CZT solidDB }]b<v}]"0k}]D|

nP5CLr#

solidDB }]\m$_|,Z solidDB Lr|P,;Z solidDB20?<PD“bin”?<#

XF($_:solidDB SQL `-w(solsql)M solidDB 6LXF (solcon)

v solidDB SQL `-w (solsql) G;VXF($_,CZ"v SQL odMZ|na>

{Br(}4P|, SQL odDE>D~"v solidDB \m|n (ADMIN COM-

MAND)#

v solidDB 6LXF (solcon) G;V\mXF($_;_P\m(^DC'ITZ|n

a>{B,r(}4P|,\m|

MAND)#hz solcon,I+\m|n (ADMIN COMMAND) w* solcon t/|n

PD;?V4"v#

nDE>D~4"v\m|n (ADMIN COM-

CZ<vM0k}]D$_

solidDB a)TBCZ<vM0k}]D$_:

v solidDB lY0kLr(solloado r solload)a+}]Sb?D~0k= solidDB }

]bP#

v solidDB <v (solexp) a+}]S solidDB }]b<vAD~#|2CZ4(I

solidDB lY0kLr(solloado r solload)CZ4P}]0kYwDXFD~#

v solidDB }]Vd (soldd) a<v}]bD}]Vd#|azI SQL E>,dP|

,hvC}]ba9D}](eod#

solidDB Lr|P|,`v9C C oT"SQL M Java oT`4Dy>Lr,Toz

z*<9C solidDB D&\?~#

y>ME>;Z solidDB 20?<BD“samples” ?<P#?vy>?<B9|,;v

readme.txt D~,CZa)PXgN9Cb)y>D8>E"#

2 z7M|0E" 11

InfoSphere CDC m~|

InfoSphere CDC i~Gw*I%@?pDLr|;6D#

6. InfoSphere CDC

InfoSphere CDC i~{F 20m~| Z]

InfoSphere Change Data CapturesolidDB

(InfoSphere CDC for solidDB)

sK}]~qwD

Data Capture

":v|,Z solidDB Universal Cache P

203q

InfoSphere Change

Linux M UNIX:

setup-<platform>-solid.bin

}g:

setup-linux-x86-solid.bin

Windows:

setup-x86-solid.exe

Linux M UNIX:

setup-<platform>-<back-

end_dataserver>.bin

}g:

setup-aix-power-udb.bin

v dC$_M solidDB D InfoSphere CDC 5}Dm~#

v solidDB JDBC } / L r( /lib ? < PD

v $_"5CLrMy>(/samples ?<)

v InfoSphere CDC API D5(/docs ?<)

v dC$_MCZ

v PDF q= InfoSphere Change Data Capture nUC'D5

v y> Java C'vZM SQL E>(/samples ?<)

v InfoSphere CDC API D5(/docs ?<)

SolidDriver2.0.jar)

– T//$_"5CLrT0CZ`Fn#C InfoSphere

CDC NqE>Dy>(ucutils

uchsbmonitor ?<)

– Java C'vZM SQL E>D(C InfoSphere CDC y

sK}]~qw

Dm~

(/docs ?<)

"ucpassthrough M

D InfoSphere CDC 5}

Windows:

setup-x86-<back-

end_dataserver>.exe

InfoSphere Change Data Capture CJ~qwLinux M UNIX:

setup-<platform>-accessserver.bin

}g:

setup-solaris-sparc-

accessserver.bin

Windows:

setup-win-x86-accessserver.exe

InfoSphere Change Data Capture \mXF(Linux M UNIX:

;JC - vJCZ Windows

Windows

setup-x86-dmclient.exe

v CZXFT4F73DCJDm~

v CZdCM`S solidDB Universal Cache M InfoSphere

CDC 4FdC20PD InfoSphere CDC C'CJM4F

$)Dm~

v PDF q= InfoSphere Change Data Capture \mXF(\

m8O(/documentation ?<)

v ,Soz(I(}\mXF(C'gfPD“oz”K%C

v IBM Java SDK MKP1738O(/docs ?<)

12 IBM solidDB: kE8O

IBM Data Server Driver for ODBC and CLI Lr|

The IBM Data Server Driver for ODBC and CLI T9uD~DN=a)#g{sK}

]~qwG IBM }]~qw,G4a+|k solidDB Universal Cache PD SQL + ]&\;p9C#

v Windows Yw53:ibm_data_server_driver_for_odbc_cli_<platform>.zip

v Linux M UNIX Yw53:ibm_data_server_driver_for_odbc_cli_<platform>.tar.Z

;PCZ IBM Data Server Driver for ODBC and CLI D20Lr#`4,zXk(

}b9uCD~4V/20}/Lr#

D5Lr|

solidDB DD5IIBM solidDB

r|iI#

“solidDB D5”Lr|GTZ_E"PDN =M PDF q=a)D,||, InfoSphere CDC for solidDB i~DD5#“InfoSphere CDC D5”Lr||, InfoSphere CDC \

mXF("InfoSphere CDC CJ~qwMsK}]~qwD InfoSphere CDC i~DD 5#

solidDB D5

Z solidDB 6.5 M solidDB Universal Cache 6.5 E"PDPZ_a)K solidDB D5,

,19IC PDF q=a)KKD5#E"PD<Uaa)nBE"#

solidDB D5D;6

solidDB 6.5 M solidDB Universal Cache 6.5 E"PD

ZE"PD(http://publib.boulder.ibm.com/infocenter/soliddb/v6r5/)Pa)KnBD solidDB

D5#

IC PDF q=D solidDB Va

ISBP;CBXb) PDF Va:

v solidDB 'V Web 3f:ftp://ftp.software.ibm.com/software/data/soliddb/info/6.5/

man/#

v IBM vfoPD:http://www.elink.ibmlink.ibm.com/publications/servlet/pbi.wss#

Lr|M InfoSphere Change Data Capture

Kb,9T IBM solidDB

IBM Passport Advantage®PDm~|;p;6D,r_G(}y;6DomiJPD“ lYkE”DVD ;6D#

a>:g{z+"DfD PDF D~BX= solidDB 20?<BD manuals ?<P, G49IT(} solidDB m~|D6-3f4CJb)Va#PXj88>E",kN

DZ 24

3D:20 solidDB D5Lr|;b;Z#

Lr|DN=a)K PDF q=DVa#KLr|Gk

2 z7M|0E" 13

solidDB D5Da9

BPvfoP5wKw*@"~qwr_w* Universal Cache D;?VD solidDB D #{&\:

IBM solidDB

v6IBM solidDB

v IBM solidDB Programmer Guide

v6IBM solidDB SQL

v6IBM solidDB

ZTBvfoPhvK solidDB Universal Cache DYw:

v IBM solidDB Universal Cache

ZTBvfoPhvK_ICT(HotStandby):

v6IBM solidDB

ZTBvfoPhvKZf}]b&\:

v6IBM solidDB

ZTBvfoPhvK“_64F”DYw:

v IBM solidDB Advanced Replication User Guide

kE8O7

\m18O7

8O7

2mZfCJM4SbCJC'8O7

C'8O7

_ICTC'8O7

Zf}]bC'8O7

ZTBvfoPhvK“InfoSphere CDC 4F”DYw:

v IBM solidDB Replication with InfoSphere CDC User Guide

InfoSphere CDC D5

IBM solidDB

\mXF("InfoSphere CDC CJ~qwMsK}]~qwD InfoSphere CDC }fD D5<|,Z InfoSphere Change Data Capture

zK%49C InfoSphere Change Data Capture

InfoSphere CDC i~DD5;6M;C

7. InfoSphere CDC

i~ D5 D5D;6

InfoSphere CDC for

solidDB

Lr|P|, InfoSphere CDC for solidDB D5#InfoSphere CDC

i~DD5

IBM solidDB Universal Cache C' 8O7 M IBM solidDB Replica-

tion with InfoSphere CDC User GuidePD InfoSphere CDC for

solidDB

InfoSphere CDC for solidDB(nU

C'D5);Z#

( n U C ' D 5 )

Lr|P#I(}\mXF(Do

Lr|#

IBM solidDB 6.5

Lr|

14 IBM solidDB: kE8O

7. InfoSphere CDC

i~ D5 D5D;6

InfoSphere CDC \

mXF(

InfoSphere CDC C

J~qw

InfoSphere CDC for

the back-end data

server

i~DD5(x

v InfoSphere Change Data Cap-

ture CJ~qwM\mXF(2

08O

v InfoSphere Change Data Cap-

\mXF(\m8O

ture

v InfoSphere Change Data Cap-

ture API

;P %@DD5,kND“\mX

F(”D5

InfoSphere Change Data Capture n

UC'D5

)

M\mXF(|nN<

v InfoSphere Change Data Capture

Lr|

v \mXF(*zoz

v f\m XF(;p20D API D

PDF VaM Javadoc

;P%@DD5,kND“\mXF(” D5

v InfoSphere Change Data Capture

Lr|

v \mXF(*zoz

v fsK}]~qwD InfoSphere CDC

;,20D PDF Va

InfoSphere CDC D5Da9

v InfoSphere Change Data Capture Management Console, Administration Guide Phv

K InfoSphere CDC \m$_(4,“\mXF(”M“CJ~qw”)DKD&\#

v ZX(Z}]~qwDD5“InfoSphere Change Data Capture nUC'D5”Pa)K

X(Zd{}]~qwD?v InfoSphere CDC D20MdC8>E"#

Z IBM solidDB Universal Cache C'8O7M IBM solidDB Replication with InfoSphere CDC User GuideD InfoSphere CDC for solidDB

(nUC'D5)

InfoSphere

CDC for solidDB(nUC'D5)BZ|, InfoSphere CDC for solidDB D`ME

2 z7M|0E" 15

16 IBM solidDB: kE8O

3 20

53hs

BPwZa)KPX20 solidDB ~qwM solidDB D5Lr|D8>E"#

g{z*?p solidDB Universal Cache r_ InfoSphere CDC 4F,kNDIBM solidDB Universal Cache C'8O7MIBM solidDB Replication with InfoSphere CDC User Guide,TKbPXgN20yh*DyP InfoSphere CDC i~D8>E"#

solidDB z75P'V 30 vTOD;,=(,?v=(<I2~`MMYw53iO

xI#(#,10DyP#C=(M;)I=(<\'V#

PX solidDB z75PD10=(DPm,kND solidDB Web 3f(http://www-

01.ibm.com/software/data/soliddb/)#

solidDB 20hs

g{*20 solidDB,zh*:

v s< 48 MB ELUd,dP|(%@20DD5y<CDUd(y]y9CD=(

;,,K}?aTxd/)

v Z1!dCP,AYP 40 MB D RAM

v CZ}]bDc;DELUd(;vU}]b(#h*s< 16 MB DEL

v g{9CZfm,G4h*nbDZf4f"b)m

v g{9CK InfoSphere CDC <u(r_tCK solidDB U>DAw),G4h*P

c;DELUd4]I#tDBqU>D~TCZ4FV4(,=4F):1!i vB,yhDU>#fUd* 10 GB

v h* Java KP173 (JRE) r Java Development Kit (JDK) V1.4.2 r|Bf>

– solidDB 20Lr

Ud)

":Z Linux 53O,20Lr;'VCZ Java D GNU `kw (GCJ)#

– 2mZfCJ (SMA) M4SbCJ (LLA)

mb,Z Linux M UNIX 73P,zI\h*^D53DC'xLJ4^F (ulimit) D

hC #PX j8E" ,

UNIX);#

kN DZ 18 3D :Y w5 3 C' ^ Fh s (Linux M

InfoSphere CDC for solidDB 20hs

InfoSphere CDC for solidDB h*:

v s< 220 MB ELUd

v AYP 500 MB D RAM

d{ InfoSphere CDC i~D20hs

*Kbd{ InfoSphere CDC i~D53hs,kND solidDB Web 3f(http://www-

01.ibm.com/software/data/soliddb/)r_f?v InfoSphere CDC i~a)DD5#

Yw53C'^Fhs(Linux M UNIX)

Z Linux M UNIX 73P,zI\h*^D53DC'xLJ4^F (ulimit) DhC#

g{4zcyhD ulimit 5,G4 solidDB av=bbDYw53J4;cms,} g:SOLID (Ems 21309:4\S\BDM'z,S,TCP/IP J4;c#

g{*Z53O@ChCJ

4^F,k^D data"nofiles M fsize J4D2Yw53

ulimit(h* root C'r53\m1(^)#

m8.FvD

2 ulimit J

4 hv Fv5

}] Jm?vxLy(CDnsZf? ^^

nofiles Jm?vxLyr*DD~rD ~ hv{Dns

fsize yJmDnsD~s! ^^

ulimit

}?( k Y w5 3 M &CLr I C DW S VP

65536 r^^

PXgNi/M^D ulimit 5D8>E",kNDYw53D5#

*i/2 ulimit 5:

ulimit -Ha

-t: cpu time (seconds) unlimited

-f: file size (blocks) unlimited

-d: data seg size (kbytes) unlimited

-s: stack size (kbytes) 100000

-c: core file size (blocks) unlimited

-n: file descriptors 2048

-v: virtual memory size (kb) unlimited

*+2 nofiles 5hC* 65536:

ulimit -Hn 65536

20 solidDB

solidDB I(}<NC'gfD%/20Lrr|nP20,r9C2,20=(20#

<Ngf20

GUI 20a)K<N/D=(T20 solidDB#

*<.0

Z Windows Vista M Windows 2008 Server P,Xh5P\m1(^EIT20 solidDB#

18 IBM solidDB: kE8O

1. g{9;P20 Java KP173(JRE)r Java Development Kit(JDK),V1.4.2

r|BDf>,k+d20#

h* JRE r JDK 1.4.2 r|BDf>4KP solidDB 20Lr#

":Z Linux 53O,;'VCZ Java D GNU `kw(GCJ)#

2. ZBX203qr20 DVD O,R=CZzDYw53

v solidDB-6.5-<platform>.exe(Windows)

v solidDB-6.5-<platform>.bin(Linux M UNIX)

3. +w20LrD~# solidDB 20r<+t/#

4. q-Cr<D8>TjI20#

":Z Linux M UNIX Yw53P,zXh5PCZ20D?<D4(^#g{2 0Lr^(4(K?<,G4+a>z8(

m;v?<#

D20LrD~:

zQ -2 0K solidDB# *i 4 solidDB Lr | D5 , kr *20 ?< BD welcome.html#r_,zITCJ“doc_text”?<BIC ASCII q=DD~#

B;=v24

v P X 2 0 Z d y v m s D E " , k 4 s ; Z 2 0 y ? < D U > D ~

(IBM_solidDB_6.5_InstallLog.log)#

v mkNDZ 21 3D:s20Nq;#

XF(20

9CXF(20=(S|nPgf20 solidDB#

*<.0

Z Windows Vista M Windows 2008 Server P,Xh5P\m1(^EIT20 solidDB#

1. g{9;P20 Java KP173(JRE)r Java Development Kit(JDK),V1.4.2

r|BDf>,k+d20#

h* JRE r JDK 1.4.2 r|BDf>4KP solidDB 20Lr#

":Z Linux 53O,;'VCZ Java D GNU `kw(GCJ)#

2. ZBX203qr20 DVD O,R=CZzDYw53

v solidDB-6.5-<platform>.exe(Windows)

v solidDB-6.5-<platform>.bin(Linux M UNIX)

3. S|nPt/20Lr#9CTB|n:

v Windows

D20LrD~:

<installation_program> -i console

3 20 19

}g,Z Windows 32 ;Yw53P:

solidDB-6.5-w32.exe -i console

v Linux M UNIX

sh <installation_program> -i console

}g,Z Linux 64 ;Yw53P:

sh solidDB-6.5-linux-x86_64.bin -i console

4. q-T>D8>TjI20#

":Z Linux M UNIX Yw53P,zXh5PCZ20D?<D4(^#g{2 0Lr^(4(K?<,G4+a>z8(m;v?<#

zQ-20K solidDB#*i4Lr|D5,kr*20?<BD welcome.html#r _,zITCJ“doc_text”?<BIC ASCII q=DD~#

B;=v24

v P X 2 0 Z d y v m s D E " , k 4 s ; Z 2 0 y ? < D U > D ~

(IBM_solidDB_6.5_InstallLog.log)#

v mkNDZ 21 3D:s20Nq;#

2,20

9C2,20=(,Z^hC';%DivB20 solidDB#}g,I+K=(CZ solidDB Dsf#?p,ZdP+2,20|n6k=E>P#

1. g{P4Z+*20 solidDB DyP53O20 Java KP173(JRE)r Java

2. +20LrD~SBXD

3. S|nP9CTB|n4t/20Lr"zIl&D~:

Development Kit(JDK)V1.4.2 r|Bf>,k+d20#

h* JRE r JDK 1.4.2 r|BDf>4KP solidDB 20Lr#

":Z Linux 53O,;'VCZ Java D GNU `kw(GCJ)#

203qr20 DVD 4F=z53ODY1?<#9C*

zDYw53a)D20Lr:

v solidDB-6.5-<platform>.exe(Windows)

v solidDB-6.5-<platform>.bin(Linux M UNIX)

v Windows

<installation_program> -r <response-file>

}g,Z Windows 32 ;Yw53P:

soliddb-6.5–w32.exe -r response.txt

v Linux M UNIX

sh <installation_program> -r <response-file>

20 IBM solidDB: kE8O

}g,Z Linux 64 ;Yw53P:

sh solidDB-6.5-linux-x86_64.bin -r response.txt

solidDB 20r<+t/#

4. q-T>D8>TjI20#

":Z Linux M UNIX Yw53P,zXh5PCZ20D?<D4(^#g{2 0Lr^(4(K?<,G4+a>z8(m;v?<#

5. Z20jIs,lizzIDl&D~Gq|,h*

D!n# l&D~;Z20y

?<P#

a>:solidDB 20?<Ba)DF* installer-response-file.txt Dy>l& D~IC#

6. Zm;v53O,(}KPTB|n44P2,20:

v Windows

<installation_program> -i silent -f <response-file>

}g,Z Windows 32 ;Yw53P:

soliddb-6.5–w32.exe -i silent -f response.txt

v Linux M UNIX

sh <installation_program> -i silent -f <response-file>

}g,Z Linux 64 ;Yw53P:

sh solidDB-6.5-linux-x86_64.bin -i silent -f response.txt

s20Nq

Z20 solidDB s,zI\k*&Cj{z7mI$\?,li solidDB JDBC }/

LrhC"tCy>D9C#

1. g{:rKsolidDB r solidDB Universal Cache,k+mI$D~(solid.lic r

soliduc.lic)SmI$$i3q4FAsolidDB $w?<#

a> :solidDB D 1 !2 0 +Z solidDB2 0? < B| ( ;v @ @m I $

(solideval.lic)#@@mI$JmzZ 90 l.ZTC solidDB#

2. g{zF.9C solidDB JDBC }/Lr,+zyZ

hC*|, solidDB JDBC }/Lr .jar D~2076# solidDB JDBC }/Lr (SolidDriver2.0.jar);Z solidDB20?<BD ‘jdbc’ ?<P#

v Windows

v Linux M UNIX

73D CLASSPATH 73d?

20}LT/+1! solidDB JDBC }/Lr2076mSA53 CLASSPATH

73d?#

IT(}XFfeliMhC53 CLASSPATH 73d?:

Ffe → 53 → _6 → 73d?

+ z D CLASSPATH 7 3d ?h C *| , solidDB JDBC } /L r

(SolidDriver2.0.jar)2076#

3 20 21

}g,Z C shell P,9CTB|n:

set CLASSPATH = <solidDB installation directory>/jdbc/SolidDriver2.0.jar . $CLASSPATH

g{z9CDG UNIX shell x;G C shell,G4k`&X^DK|nTJOz

y9CD shell#

20 JDBC M ODBC }/Lr

solidDB JDBC }/LrM solidDB ODBC }/Lr|,Z solidDB ~qw20Lr |P#1!ivB,Z20 solidDB Zda20b=v}/Lr#

20 solidDB JDBC }/Lr

Z solidDB20}LP+20 solidDB JDBC }/Lr(SolidDriver2.0.jar)#!v

ZzyZD73,Z9C solidDB JDBC }/Lr.0, zI\h*hC`ndCh C#

1!20?<

1!ivB,Z solidDB20}LP,solidDB JDBC }/Lr+20A solidDB20?

<BD“jdbc”?<#

jdbc ? < 9 | , CZ WebSphere D solidDB } ] f"( z X ~ ` (SolidDataStoreHelper.jar)#

solidDB20?<BD samples/jdbc ?<|,K9C solidDB JDBC }/LrD Java

zky>#PXKPy>D8>E",kND readme.txt B#

D~,CD~;Z,;?<

Java 73hs

v 7#5P;v'V JDBC API f6"Pf 2.0 D}#$wD Java KP1r*"7

v li Java 73D5T7OdGqI9C9uVZk#SolidDriver2.0.jar |,9u

VZkq=D solidDB JDBC }/Lr`,ICZs`} Java ibz#;x,3)

73(}g,Microsoft J++)*s49uVZk k,G4zXk9C'V$D~{D$_4i! SolidDriver2.0.jar D~#

#g{zyZD73*s49uVZ

hC CLASSPATH 73d?

zyZ73D CLASSPATH 73d?h*|, solidDB JDBC }/Lr .jar D~20

76#

v Windows

20}LT/+1! solidDB JDBC }/Lr2076mSA53 CLASSPATH 7 3d?#

IT(}XFfeliMhC53 CLASSPATH 73d?:

v Linux M UNIX

22 IBM solidDB: kE8O

XFfe → 53 → _6 → 73d?

+ z D CLASSPATH 7 3 d? h C * | , solidDB JDBC } / L r

(SolidDriver2.0.jar)2076#

}g,Z Bourne shell P,9CTB|n:

export CLASSPATH=<solidDB installation directory>/jdbc/SolidDriver2.0.jar:$CLASSPATH

g{z9CDG Bourne shell .bDd{ shell,G4k`&X^DK|nTJOz y9CD shell#

20 solidDB ODBC }/Lr

solidDB 20Lra20=v ODBC }/Lr,;vCZ Unicode V{/,m;vC Z ASCII V{/#Unicode f>G ASCII f>D,/;I+dk Unicode r ASCII V{/;p9C#2IT9C solidDB 20LrTv20 ODBC}/Lr#

Windows

Z Windows 73P,solidDB 20LraT/20 ODBC }/LrMTB53}]4

{F (DSN)#z2ITmSzT:DC' DSN#

v Windows 32 ;Yw53:

– IBM solidDB 6.5 32 ; ANSI

– IBM solidDB 6.5 32 ; Unicode

v Windows 64 ;Yw53:

– IBM solidDB 6.5 64 ; ANSI

– IBM solidDB 6.5 64 ; Unicode

Linux M UNIX

Z Linux M UNIX 73P,ODBC }/LrbD~+20ATB?<:

v <solidDB 20?<>/bin/:/,bD~

– sac<platform><version>.sa or sac<platform><version>.so – ANSI

– soc<platform><version>.sa or soc<platform><version>.so – Unicode

v <solidDB 20?<>/lib/:2,bD~

– solidodbca.sa or solidodbca.so – ANSI

– solidodbcu.sa or solidodbcu.so – Unicode

D~)9{ .sa r .so !vZYw53#

20 ODBC }/Lrx;20 solidDB

g{*20 ODBC }/Lrx;20 solidDB:

1. t/ solidDB 20Lr#

2. !q(F20#

3. !q ODBC(!{!q~qwMy>)#

4. q-T>D8>TjI20#

3 20 23

20 solidDB D5Lr|

g{zkZ20K solidDB ~qwDZcOCJIC PDF q=D"Df solidDB D 5,G4ITBX solidDB D5Lr|"+|i!= solidDB 20?<BD“manuals”

?<P#

1. R=IBM solidDB

v Zy;6DomiJP,D5Lr||,Z“lYkE”DVD P#

v g{zS IBM Passport Advantage PBXm~,G4kR=D5Lr|#

v g{zS solidDB FTP >c (ftp://ftp.software.ibm.com/software/data/soliddb/info/

6.5/man/) BX solidDB,G4kR="DfVaD .zip D~#

2. BXD5Lr|,"+|i!= solidDB 20?

20^)|

a+^)|w*%v20LrD~4V"#

v :20CZ solidDB D^)|;

v :20CZ InfoSphere CDC i~D^)|;

20CZ solidDB D^)|

1. Fw}]bD~"U>D~M solid.ini dCD~D8]1>#

Lr|#

<BD“manuals”?<P#

PX8>E",kND6IBM solidDB

2. XU solidDB#

PX8>E",kNDXU solidDB#

3. 4U20 solidDB PD8>E"4KP solidDB ^)|20Lr#

solidDB ^)|T%v20D~DN=a)#g{*f;VP solidDB 20,k9 CZdP20K solidDB D`,20?<#

g{z;kZVP solidDB 2

9C%@D?<,"V/4FJCZzD20DI4PD~"bM}/Lr#

0O(}g,Zzz73ZcO)KP20Lr,k

\m18O7PD4P8]MV4

;Z#

20CZ InfoSphere CDC i~D^)|

*<.0

*K7#Z20 Z d # t5}" } ] f"w M$)D d C E ",Z* < 2 0 NN

InfoSphere CDC i~.0,kHjIBP=h:

1. axTyP$)D4FYw#

2. O*kCJ~qwD,S#

3. Kv\mXF(#

4. #9 InfoSphere CDC for solidDB dC$_MCZsK

dC$_PDyP InfoSphere CDC 5}#

}]~qwD InfoSphere CDC

24 IBM solidDB: kE8O

PX8>E",kND

v InfoSphere Change Data Capture

Data Capture Management Console

Lr|Pf=D6IBM InfoSphere Change

\m8O

v #9 InfoSphere CDC

20CZCJ~qwD^)|

*c:Xk+\mXF(MCJ~qw|B=`,D^)|6p#

1. 6XCJ~qw#

2. 4U InfoSphere Change Data Capture

Server and Management Console

208O

Lr|Pf=D6IBM InfoSphere Access

7PD8>E"4KPCJ~qw^)|

20Lr#

v 9CCZ20T0f>DCJ~qwD`,20?<#

v z^(Z`,ZcO,1KP=vf>DCJ~qw#

20CZ\mXF(D^)|

*c:Xk+\mXF(MCJ~q

w|B=`,D^)|6p#

1. 6X\mXF(#

2. 4U InfoSphere Change Data Capture

Server and Management Console

208O

Lr|Pf=D6IBM InfoSphere Access

7PD8>E"4KP\mXF(^)|

20Lr#

":9CCZ20T0f>D\mXF(D`,20?<#

20CZ InfoSphere CDC for solidDB D^)|

*c:g{*20CZ InfoSphere CDC for solidDB D^)|,G4XkQ-20K InfoSphere CDC for solidDB#

1. 4U20 InfoSphere CDC PD8>E"4KP InfoSphere CDC for solidDB ^)

Lr#

|20

":9CCZ20T0f>D InfoSphere CDC for solidDB D`,20?<;20 Lr+a>zT20xP}6#

CZsK}]~qwD

*c:g{*20

-20K

CZsK}]~qwD

1. 4U IBM InfoSphere Change Data Capture

wD6IBM InfoSphere Change Data Capture

CZsK}]~qwD

InfoSphere CDC D^)|

InfoSphere CDC D20^)|,G4XkQ

InfoSphere CDC#

Lr|Pf=DCZsK}]~q

nUC'D5

InfoSphere CDC ^)|20Lr#

7PD8>E"4KP

":9CCZ20T0f>D

CZsK}]~qwD

<;20Lr+a>zT20xP}6#

20.sXBt/T$)D4FYw

20jyP^)|i~.s:

InfoSphere CDC D`,20?

3 20 25

6X solidDB

1. k7# solidDB MsK}]~qw&ZKPP#

2. t/ InfoSphere CDC for solidDB dC$_MCZsK}]~qwD InfoSphere CDC

dC$_PD InfoSphere CDC 5}#

3. G<\mXF(#

4. t/T$)D4FYw#

PX8>E",kND

v t/ InfoSphere CDC

v InfoSphere Change Data Capture

Capture Management Console

Z Windows 73P,k(}XFfe → mSr>}Lr46X solidDB#Z Linux M UNIX 73P,k}%20?<#

Lr|Pf=D6IBM InfoSphere Change Data

\m8O

v Windows:

1. *AXFfe → mSr>}Lr → |Dr>}Lr#

2. !q IBM solidDB,;s%w|D/>}4%#

v Linux M UNIX:

1. }%20?<#

26 IBM solidDB: kE8O

4 i$ solidDB 20

ZjI solidDB ~qw20s,ITt/ solidDB "4(Z;v}]bTi$20Q I&#2IT9CLr|Pa)Dy>4=w solidDB XTM&\#

ZI&20s,ITZ solidDB 20?<BR=TB?<:

<20?<>

bin\ .. eval_kit\

standalone\

cdc\ .. samples ..

standalone ?<+4UBf?VT>D==Zt/ solidDB"4(Z;v}]b1d1

$w?<

(solideval.lic)#C?<9|,Z;v}]b(solid.db)T0`XDBqU>" {"MzYD~#

cdc ?<|,CZ solidDB Universal Cache Dy> solid.ini dCD~#cdc ?<I

Z20 solidDB Universal Cache 1d1$w?<#

# standalone directory |,y> solid.ini dCD~M@@mI$D~

standalone ?<M cdc ?<|,mI$D PIT9C solidDB M solidDB Universal Cache DyPz7!nM&\#

$w?<M solid.ini dCD~

$w?<G|,kKPX( solidDB 5}`XDD~,C?<P|, solid.ini dC D~#solid.ini dCD~8(KIoz(FME/ solidDB DN}#

$w?<

(#$w?<|,TBD~:

v mI$D~

v solid.ini dCD~

v }]bD~

v BqU>D~

v {"MzYD~

ZdM20P,$w?<|,P'mI$D~T0 solid.ini dCD~#I(}4 (

SOLIDDIR 73N}4*mI$D~M solid.ini D~8(;,D?<#

1zt/ solidDB 1,|+S solid.ini dCD~PA!dCN}#2IT9C;x dCD~D solidDB, b V i v B + 9 C 1 !hC(v'5)#Kb,g{fZ

solid.ini dCD~,+GX(N}D54hC,G4 solidDB +TCN}9Cv' 5#v'5I\!vZz}9

~,Jmz@@ solidDB ;N1d#Z@@

CDYw53#

BqU>" {"Mz Y D ~ 2ITC Z z ! qDd{ ? < ; ZKiv B , X kZ

solid.ini dCD~P( e`&D? <76MD~{# }g,solid.ini D~D [IndexFile] ZPD FileSpec N}CZ8(}]bD~D?<MD~{#

CZ@@20D solid.ini dCD~

;Z eval_kit\standalone ?< BDy> solid.ini dCD~PDN}hCazc

solidDB ~qwDs`}@@h*#

g{h*9Cd{i~,}g solidDB Universal Cache r_ICT&\,G4Xk` &X^DdCD~#

y>P2|, solid.ini dCD~,CD~P|,KPCy>yhDdCh

solidDB 0d;,XwM&\1,IT+k`&y>;"a)D solid.ini dCD~w *p<c#

`Xwb

PX solid.ini dCD~T0gN(}CD~hCN},TdC solidDB D|`E",

kND 6IBM solidDB \m18O7#

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

>ZhvgN9CmI$D~M eval_kit\standalone ?<BD solid.ini dCD~ 4t/ solidDB D@@f>#

*t/ solidDB,zD$w?<BXkfZ;vP'DmI$D~#

Z Linux M UNIX 73Pt/ solidDB

1. g{Z,;(zwO20K`v solidDB,ki$ 6.5 20Df>GqG1! solidDB

20#

a. g{*liZ PATH 73d?P(eD solid I4PD~,kZ|na>{P

dkBP|n:

which solid

b. g{*i$ solid I4PD~Df>,kZ|na>{PdkBP|n:

solid -x version

2. Z eval_kit/standalone ?<PD|na>{&dk solid -f |n#

C#1@@

3. dk y T4(B}]b#

4. *1!}]b?<a)C'{

28 IBM solidDB: kE8O

!n -f CZ?F~qwZ0(KP#

1zt/ solidDB 1,|+li}]bGqQ-fZ#g{4R=}]b,solidDB +a>z4(B}]b#

"\kM{F#

"b: C'{M\k;P1!5#zXkG!C'{M\k,Tc\;YNCJ}]b#

}g,IT9C dba w*@@}]bDC'{M\k,r*|r%WG#

*9CKC'{M\k:

a. dkz26DNN{Fw*?<{#

b. dk dba w*C'{M\k#

c. YNdk dba w*\k#

solidDB Z eval_kit/standalone ?<B4(F* solid.db DB}]b#

a+ solidDB xLtZ0(LxKP#g{*9 solidDB Zs(KP:

1. 4 CTRL+Z 4]RCxL#

2. dk bg 4?

a>:mb,zITt/ solidDB,"(}8(}]bMG<}]w*|nP!n,4

4(BD}]b#

}g:

solid -Udba -Pdba -Cdba

baZs(t/ solidDB,"9CBPG<}]4(BD}]b:

v C'{:dba

v \k:dba

v ?<{:dba

FCxLZs(KP#

Z Windows 73Pt/ solidDB

%w*< → Lr → IBM solidDBK%76BjPt/ IBM solidDB ~qwD<j#

1zt/ solidDB 1,|+li}]bGqQ-fZ#g{4R=NN}]b,solidDB +T/9CTBG<}]Z eval_kit\standalone ?<B4(F* solid.db DB}]

v C'{:dba

v \k:dba

v ?

a>:g{#{(}t/ IBM solidDB ~qw<jt/ solidDB "Zd{?<r9C d{G<}]M?<{4(B}]b,I(}R|%wt/ IBM solidDB ~qw<j

"`-l]==tT4^D201!hC#PX|`E",kND 6IBM solidDB \ m18O7

WN,SA solidDB

Zz4(Z;v}]bs,solidDB xLVZMQ-ZKP,zITSNNM'z&C LrP9C solidDB xL}Zl}D(EKZ,SAK}]b#}g,bIT(}9C |nP$_ solidDB SQL `-w (solsql) 4jI#

<{:dba

Windows

l]==

;Z#

(EKZ(}9C solid.ini D~D [Com] ZPD Listen N}(

T eval_kit\standalone ?<PD solidDB@@f>,(eKTB(EKZ:

4 i$ solidDB 20 29

[Com] Listen=tcpip 2315, tcpip 1315, tcpip 1964

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

*9C solidDB SQL `-w(solsql),ZYw53|na>{Bdk solsql t/| n,**,SAD solidDB ~qw8(xg{M>$#Z Windows Yw53O,2I

T9C*< → Lr → IBM solidDB → solidDB SQL `-wK%764t/C`- w#

*t/ solidDB SQL `-w:

v Z Windows Yw53O,%w*< → Lr → IBM solidDB K%76BjP solsql

SQL `-wD<j#

b+t/ solidDB SQL `-w,9C(EKZ“tcp 2315”MC'{“dba”0\k“dba”

,SA solidDB ~qw#

a>:g{#{(} solsql SQL `- w<j9Cd{G<}]r(EK

solsql,IT(}R|%w solsql SQL `-w<j"%wl]==tT4^D20 1!hC#PX|`E",kND 6IBM solidDB \m18O7D

]==

v ZyPd{73P,ZYw53a>{&dk SQL `-wt/|n#|no(*g

By>:

solsql "networkname" [userid [password]]

}g:

a>:g{Zt/ solidDB SQL `-w14a)C'{M\k,G4+aa>zd k|G#

;Z#

solsql "tcp 2315" dba dba

Zt/

Windows

g{Zt/ solidDB SQL `-w1dkKP'C'{M\k,+,SA}]b#B< T>KI&,SA}]b.sD solidDB SQL `-w#

30 IBM solidDB: kE8O

3. solidDBSQL

`-wQ,S

i4}]bMdC4,

}g,IT9C solidDB SQL `-w(solsql)4i4}]b4,"liN}hCrT >IC\m|n(ADMIN COMMAND)#

XZKNq

1zZ solsql P"v ADMIN COMMAND |n1:

v Z|n)29CVE,"R

v Z8(|n{19C%}E,x;G+}E#

1. *i4}]b4,,Z solidDB SQL `-wP"vTB|n:

ADMIN COMMAND ’status’;

BfT>K solidDB SQL `-wzzD>}dv:

4 i$ solidDB 20 31

4. solidDB SQL

`-w(

solsql

)zzD>}dv

2. *i4N}hC,"vTB|n:

ADMIN COMMAND ’par’;

a>:IT9C solsql |n4i4X(Z3;?VDN}hC:

ADMIN COMMAND ’par section_name’;

}g:

ADMIN COMMAND ’par IndexFile;

3. *i4IC ADMIN COMMAND,"vTB|n:

ADMIN COMMAND ’help’;

9C solidDB SQL `-w4P SQL od

ITZ solidDB SQL `-wP4P SQL od#K?VT>K4("i4M>}bT mD>}#

1. (}Z solsql P"vTB|n44(m:

create table testtable (value integer, name varchar); commit work;

32 IBM solidDB: kE8O

insert into testtable (value, name) values (31, ’Duffy Duck’);

commit work;

select value, name from testtable; commit work;

2. 9CTB|n4i4m:

select value, name from testtable;

VALUE NAME

----- ----

1 rows fetched.

commit work;

3. 9CTB|n4>}m:

drop table testtable; commit work;

a>:*K7#?;v}]bYw<Qd5,kGC*4P COMMIT WORK o d#

#9;sXBt/}]b

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

31 Duffy Duck

*#9}]b, X k h 9C', S A } ]b, O * y P Q,SD C ' , ;sXU

solidDB#

XZKNq

IT9C solidDB SQL `-w4#9}]b#"v|n"Z|n)29CVE#k" b,Xk9C%}Ex;G+}E#

1. h99PmbDC',SA}]b:

admin command ’close’;

2. O*kyPQ,SC'D,S("vK|nDC'}b):

admin command ’throwout all’;

3. XU solidDB:

admin command ’shutdown’;

4. Kv solsql $_:

exit;

":IT+0}v|nf;*TB|n:admin command ’shutdown force’;

solidDB }]bQXU,H0,SDyPC'<QO*,S#

XU~qw.s,|+O*k solsql D,S,R solsql I\aT>;ugBy>Dm s{":

4 i$ solidDB 20 33

14519: C'QKv~qw;,SQO*#

XBt/}]b(>})

IT(}"v|nr_9C Windows Yw53 OD*< → LrK%4XBt/ solidDB#

XZKNq

>Za)KPXXBt/ eval_kit\standalone ?<BD@@}]bD8>E"#

!qBP=(.;4XBt/}]b:

v Z Windows P,%w*< → Lr → IBM solidDB K%76BjPt/ IBM

solidDB ~qwD<j#

v Z Linux"UNIX r Windows |na>{B,P;A solidDB 20y?<"dkT

B|n:

bin\solid -c .\eval_kit\standalone

|nP!n -c <directory_path> CZ(e$w?<#

v g{zD76PP solidDB bin ?<,G4P;A“eval_kit\standalone”?<"9

|I*10$w?<,;s(}4P solid |n4t/ solidDB#

#9;sXBt/}]b

34 IBM solidDB: kE8O

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

solidDB ;|(<NC'gf (GUI)#+G,IT+<N SQL M'z(}g IBM Data Studio Administrator"Eclipse SQL Explorer r SQuirrel SQL Client)k solidDB ;p 9C,4/@}]bTs"i4M^Dm}]T0"v SQL |n#

v g{zD*"73Q-9CK Data Studio r Eclipse r\,G4 IBM Data Studio

Administrator M Eclipse SQL Explorer M'zGnOJD#

v SQuirrel SQL Client

4I$w#

OvyPM'z<9C JDBC SZ4,S solidDB#

IBM Data Studio Administrator

IBM Data Studio Administrator G;n&\?s"RinD$_,Iozz\m}]b

Ts"r/6p"VvM5V}]b#=|DD}L#

zIT(}9C Data Studio Administrator D(C JDBC }]b\mw!n,+ Data

Studio Administrator ,SA solidDB }]b#

PXhC Data Studio Administrator k solidDB D|`j8E",kND ibm.com DBPDB:

v Configuring Data Studio Administrator V2.1 for use with solidDB:http://www-

01.ibm.com/support/docview.wss?rs=3457&uid=swg21411299

v Configuring Data Studio Administrator V1.2 for use with solidDB:http://www-

01.ibm.com/support/docview.wss?rs=3457&uid=swg21411276

G;v@"Lr,;h*}M'zM solidDB .bDd{i~

Eclipse SQL Explorer

Eclipse SQL Explorer G;V] SQL M'z,Jmzi/M/@NNk JDBC f]D }]b,dP|( solidDB#

I+ Eclipse SQL Explorer w*e~mS=VPD Eclipse 73P,2IT+dw*@ "M'z4KP#

PXhC SQL Explorer k solidDB D|`j8E",kND ibm.com ODBPDB:

v Configuring Eclipse SQL Explorer for use with solidDB:http://www-01.ibm.com/

support/docview.wss?rs=3457&uid=swg21411273

SQuirrel SQL Client

SQuirrel SQL Client G;VCZk JDBC f]D}]bD*E=4zk Java SQL M 'zLr#|G@"DM'z,I+ddCI(} solidDB JDBC }/L r,SA solidDB }]b#

PXhC SQuirrel SQL Client k solidDB D|`j8E",kND ibm.com ODB

PDB:

v Configuring Squirrel SQL for use with solidDB:http://www-01.ibm.com/support/

docview.wss?rs=3457&uid=swg21411262

36 IBM solidDB: kE8O

6 KPy>

zITZ solidDB 20?<D“samples”?<BR=y>LrME>#?vy>?<B

9|,;v readme.txt D~,CZa)PXgN9Cb)y>D8>E"#

*<.0

g{*KPy>,G4y>?<Xk|,P'mI$D~#1!ivB,?;vy> ?<<|,@@mI$ (solideval.lic) D;v1>#

g{z*+j{z7mI$(solid.lic r soliduc.lic)ky>;p9C:

1. +mI$D~4F= solidDB 20?<Dy?<#

PF* copy_licenses DE>(Z Windows P* copy_licenses.bat)#KE

2. 4

>a+20y?<BDmI$D~4F=yP`&Dy>?<P#

y]y>?<BD readme.txt D~a)D8>E"4KPy>#

":3)y>E>a}%;Zy>S?<BD}]bD~,;sYXB4(}]bD ~#;P eval_kit/standalone M eval_kit/cdc ?<BD}]bEa<U#V;d#

38 IBM solidDB: kE8O

7 + solidDB }6AB"Pf6p

solidDB 'VSAY=v0"Pf6p}6# 'VS 6.3 M 6.1 "Pf}6A solidDB

6.5;+Gh*xP}]bD~*;#g{zh*S|gf>}6,k*5 solidDB <u

'VTqC-z#

*<.0

l$ solidDB 6.3

solidDB Universal Cache 6.5 E"PD P IR = CD 5 ,x 7 * :http:// publib.boulder.ibm.com/infocenter/soliddb/v6r4/index.jsp#

"P5w

PhvDBvM|D&\,Z IBM solidDB 6.5 M IBM

XZKNq

TB=hhvK+%v solidDB ~qw}6AB"Pf6pD=h#g{Z_ICT=

=B9C solidDB,kND

~qw

;Z#

0"Pf6pD solidDB JDBC M ODBC }/Lrk 6.5 "Pf6p solidDB ~q wf]#+G,6.5 f>D}/Lr;\CZIf>~qw#rK,XkZ}/Lr. 0}6~qw#

v1zh*9C"Pf6p 6.5P}kDB&\1,Eh*}6}/Lr

":g{z**; 6.3 r 6.1 }]bT'Vf> 6.5 P}kD+ Unicode ==,kN

D IBM solidDB Programmer GuidePD Converting partial-Unicode databases to Uni- code ;Z#

IBM solidDB

_ICTC'8O7PD}6

HotStandby

1. Fw}]bD~Msolid.ini dCD~D8]1>#

PX8>E",kND

2. XU solidDB#

3. 20 solidDB DBf>#

solidDB T%v20D~DN=a)#g{z;kZzz73ZcOKP20Lr,

ITZ@"ZcO20 solidDB,Y+JCZzD20DI4PD~"bM}/Lr V/4F=zzZc#

PX solidDB ~qwL

|;#

PXgNKP solidDB 20LrD8>E",kNDZ 18 3D:20 solidDB;#

4. |BmI$D~#

+BmI$D~(solid.lic r soliduc.lic)SmI$$i3q4FA solidDB $

w?<#

5. liN}v'5D|D,"ZX*1

IBM solidDB

r|Z]Dhv,kND Z 7 3D:solidDB ~qwLr

\m18O7PD4P8]MV4

|B solid.ini dCD~#

;Z#

"P5w

PhvKN}5D|D#

6. li"|BJCZzyZ73D solidDB JDBC M ODBC }/Lr`XhC#

v solidDB JDBC }/Lr

g{+B solidDB JDBC }/Lr(SolidDriver2.0.jar)20=;,ZH0f

>D;C,k+B}/Lr76mSA CLASSPATH 5373d?#1!iv B, solidDB JDBC }/Lr+20

A solidDB20?<BD“jdbc”?<#

v solidDB ODBC }/Lr

– Z Windows M Linux Yw53P,(eB ODBC }]4#*9CB}/L

r,Xk^DVP}]4r4(B}]4#

– g{P1S4SA solidDB ODBC }/LrD&CLr,XkXB`kC&C

Lr#

7. (}9C -x autoconvert r

-x convert |nP!nt/ solidDB 4*;VP}

]bD~#

Z solidDB $w?<P,4PTB|n:

solid -x autoconvert

solid -x convert

-x autoconvert !nCZ*;}]b"t/ solidDB#

-x convert !nCZ*;}]b"Kv solidDB#

40 IBM solidDB: kE8O

[C]

XBt/

solidDB }]b 34

[G]

2mZfCJ(SMA) 2 $w?< 27

[K]

M'z - ~qwe5a9 2

[L]

,SA solidDB

Z;N 29

4SbCJ(LLA) 2

[P]

@@20 28

solidDB ~qwLr| 8 solidDB ?<a9 8 solidDB dCD~ 27 solidDB JDBC }/Lr

20 22

solidDB ODBC }/Lr

20 23

solidDB SDK 8 solidDB SQL `-w

dki/ 32

solid.ini 27 SQL i/

Z solidDB SQL `-wP4P 32

TCP/IP 2

[XpV{]

-x autoconvert(|nP!n) 39

-x convert(|nP!n) 39

[Q]

t/ solidDB 28

[S]

|nP!n

-xautoconvert 39

-xconvert 39

}]b

#9 33

[X]

6X 26

JDBC 2

42 IBM solidDB: kE8O

}G-} Solid Information Technology Ltd. r_ International Business Machines Cor- poration ifZ(,qr;\TNN==9C>z7PDNN?V#

>z7\@z({ 6144941, 7136912, 6970876, 7139775, 6978396, 7266702, 7406489, 7502796, M 7587429 #$#

*Kz78(D@zvZ\FV``EG ECCN=5D992b#

>E"G*Z@za)Dz7M~q`4D#

IBM I\Zd{zRrXx yZxrDz7M~qDE",krz1XD IBM zmI/#NNT IBM z7"L

rr~qD}C"GbZw>r5>;\9C IBM Dz7"Lrr~q#;*;V8 IBM D*6z(, ~q#+G,@@Mi$NNG IBM z7"Lrr~q,rIC'TP:p#

IBM +>I\Q5Pr}Zjkk>D5Z]PXDwn({#a)>D5"4ZhC

'9Cb)(

IBM Director of Licensing

IBM Corporation

North Castle Drive

Armonk, NY 10504-1785

U.S.A.

PX+VZ (DBCS) E"DmI$i/,k*5zyZzRD IBM *6z(?E,r +i/TifDN="MA:

IBM World Trade Asia Corporation

Licensing

2-31 Roppongi 3-chome, Minato-ku

Tokyo 106-0032, Japan

NN,H&\Dz7"Lrr~q,<ITzf IBM z7"Lrr

{DNNmI#zITCif==+mIi/Dy:

;a)>D5PV[Dz7"~qr&\XT#PXz10

>un;JC"zrNNbyDunk1X(I;;BDzRrXx 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,D

#$#rK>unI\

>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(*#

;JCZz#

: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>LrDYw=(OD&CLr`LSZ(API)xP&CLr D*""9C"-zrV"*?D,zITNNN=Tb)y>Lrx P

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

44 IBM solidDB: kE8O

IBM"IBM Uj"ibm.com"Solid"solidDB"InfoSphere"DB2"Informix M WebSphere G International Business Machines Corporation Z@zM/rd{zRrXxDLjr" aLj#g{b)LjMd{ IBM "aLjZ>JOPZ;NvV1jPLj{E(

r™),G4b){Em>|GG"<>JO1i IBM yPD-}@z~."aDL jrU((Lj#b)Lj2I\GZd{zRrXxD"aLjrU((Lj#Z Web ODf(MLjE"(www.ibm.com/legal/copytrade.shtml)&a)K IBM LjD nBPm#

Java MyPy

Z Java DLjMUjG Sun Microsystems, Inc. Z@zM/rd{zRr

XxDLj#

Linux G Linus Torvalds Z@zM/rd{zRrXxD"aLj#

Microsoft M Windows G Microsoft Corporation Z@zM/rd{zRrXxD"aL

UNIX G The Open Group Z@zMd{zRrXxD"aLj#

d { + > " z 7 r

~ q { F I \ G d { + > D L j r ~ q j G #

yw 45

46 IBM solidDB: kE8O



Printed in China

G151-1276-01

IBM kE8O User Manual

Specifications and Main Features

Frequently Asked Questions

User Manual