IBM kE8O User Manual

IBM solidDB IBM solidDB Universal Cache
V6.5
kE8O

G151-1276-01
yw
Z9C>JO0d'VDz7.0,kDAZ 43 3D:yw;PDE"#
Kf>&CZIBM solidDB V6R5(z7`E 5724-V17)MIBM solidDB Universal Cache V6R5(z7`E 5724-W91)
0yPsx"PfM^)f,1=ZBf>PmPyw*9#
© Solid Information Technology Ltd. 1993, 2010
?<
< .................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
v
vi IBM solidDB: kE8O
m
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
ix
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
>8
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=
xi
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#
D
I}vciID;Pm>bGH0zkPDSx#
K
Ve#
(z&\IozPzm1]DC'(}g,P/;crS&;C) 3 {9Cm~z 7#BPwZ8(K solidDB PDw*(z&\#
|LdkM<=
|Ldk
ITv9C|L4Yw solidDB#IT9C|riO|44PyPYw#j<Yw53 w|CZj<Yw53Yw#solidDB 'Vj<DYw53|L(z&\#PX9C| riO|44PYwD|`E",kND`&DYw53D5#
|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
z7
XZ solidDB De5a9Ev
>Zhv solidDB D53e5a9#
1
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
4
}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"#
<E
w*XTM&\
SZCJ\mw8S<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
$)
#
G}
'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]FMr“-'”Yw#M4xP4F#ZFM#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{9CTJ&MCT,G4NN1r"z%vJO1<a #$Bq#
k_64FM“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#
9,
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#
m
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
w
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
1
;PZ?pS;v solidDB 4F=m;v solidDB(InfoSphere CDC 4F)D InfoSphere CDC
<uDdCPEh*#
z7Lr|Di~
1
1
X
1
X
sK}]
®
®
®
X
X
X
X
2
X
2
;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#
7
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?<#
m
;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
m
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
w#
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-
y>
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#
m
6. InfoSphere CDC
InfoSphere CDC i~{F 20m~| Z]
InfoSphere Change Data CapturesolidDB
(InfoSphere CDC for solidDB)
CZ
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'gfPDozK%C
J)
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#
D5
Lr|M InfoSphere Change Data Capture
D5
L
D5
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 #{&\:
6
IBM solidDB
v
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_64FDYw:
v IBM solidDB Advanced Replication User Guide
kE8O7
\m18O7
8O7
2mZfCJM4SbCJC'8O7
C'8O7
_ICTC'8O7
Zf}]bC'8O7
ZTBvfoPhvK“InfoSphere CDC 4FDYw:
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
m
7. InfoSphere CDC
i~ D5 D5D;6
InfoSphere CDC for
solidDB
D5
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 )
D5
Lr|P#I(}\mXF(Do
D5
Lr|#
IBM solidDB 6.5
D5
Lr|
14 IBM solidDB: kE8O
m
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|
5
v \mXF(*zoz
v f\m XF(;p20D API D
PDF VaM Javadoc
;P%@DD5,kND\mXF( D5
v InfoSphere Change Data Capture
5
Lr|
v \mXF(*zoz
v fsK}]~qwD InfoSphere CDC
;,20D PDF Va
D
D
InfoSphere CDC D5Da9
v InfoSphere Change Data Capture Management Console, Administration Guide Phv
K InfoSphere CDC \m$_(4,\mXF(MCJ~qw”)DKD&\#
v ZX(Z}]~qwDD5“InfoSphere Change Data Capture nUC'D5Pa)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
17
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
5
}?( k Y w5 3 M &CLr I C DW S VP
X)
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
}L
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~:
a{
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#
}L
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?<#
a{
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#
}L
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#
}L
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?
X
+ 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
3#
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#
}L
1. R=IBM solidDB
v Zy;6DomiJP,D5Lr||,ZlYkE”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>#
D5
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
D5
Lr|Pf=D6IBM InfoSphere Change
\m8O
7
v #9 InfoSphere CDC
20CZCJ~qwD^)|
*c:Xk+\mXF(MCJ~qw|B=`,D^)|6p#
1. 6XCJ~qw#
D5
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(#
D5
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
20
*c:g{*20
-20K
CZsK}]~qwD
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#
D5
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
D5
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
7
}L
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#
27
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#
a{
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#
a{
1zt/ solidDB 1,|+li}]bGqQ-fZ#g{4R=NN}]b,solidDB +T/9CTBG<}]Z eval_kit\standalone ?<B4(F* solid.db DB}]
b:
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
D
^D
Windows
l]==
;Z#
(EKZ(}9C solid.ini D~D [Com] ZPD Listen N}(
T eval_kit\standalone ?<PD solidDB@@f>,(eKTB(EKZ:
e#
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#
}L
*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
^D
Zt/
Windows
l
a{
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#
}L
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>}#
}L
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#
}L
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’;
a{
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"#
}L
!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~
®
O
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:
35
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#
}L
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#
37
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=
6
=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
}L
1. Fw}]bD~Msolid.ini dCD~D8]1>#
6
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#
39
"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?<BDjdbc?<#
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
r
solid -x convert
-x autoconvert !nCZ*;}]b"t/ solidDB#
-x convert !nCZ*;}]b"Kv solidDB#
40 IBM solidDB: kE8O
w}
[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
S
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
T
TCP/IP 2
[XpV{]
-x autoconvert(|nP!n) 39
-x convert(|nP!n) 39
[Q]
t/ solidDB 28
[S]
}6
|nP!n
-xautoconvert 39
-xconvert 39
}]b
#9 33
[X]
6X 26
J
JDBC 2
41
42 IBM solidDB: kE8O
yw
Copyright © Solid®Information Technology Ltd. 1993, 2010.
All rights reserved.
}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“4V4a)>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-
43
>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
v#
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
©(s+>D{F)(j)#K?VzkGy] IBM Corp. +>Dy>Lr\zv4 D#
© Copyright IBM Corp.(dkj]). All rights reserved.
Lj
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
j#
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
Loading...