IBM solidDB
IBM solidDB Universal Cache
V6.5
kE8O
G151-1276-01
yw
Z9C>JO0d'VDz 7.0,k DAZ 43 3 D:yw ;PDE"#
Z;f, Z;^)f
Kf>&CZIBM solidDB V6R5(z7 `E 5724-V17) MIBM solidDB Universal Cache V6R5(z7 `E 5724-W91)
0yPsx"Pf M^)f,1=Z Bf>Pm Pyw*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 De5a 9Ev .........1
XZ solidDB Universal Cache De5a 9Ev ...3
w *XTM&\ .............4
2 z7M|0E" ...........7
solidDB ~qwLr| ...........7
? <a9...............8
b D~{...............8
ODBC"JDBC M(P`LSZ .......9
5 3$_M5CLr ..........11
y > ................11
InfoSphere CDC m~| ..........12
IBM Data Server Driver for ODBC and CLI Lr| 13
D 5Lr| ..............13
solidDB D5 .............13
InfoSphere CDC D5 ..........14
3 20 ...............17
53hs ...............17
Y w53C' ^ Fhs(Linux M UNIX ) ...18
20 solidDB ..............18
< Ngf20 .............18
X F(20 .............19
2 ,20 ..............20
s 20Nq .............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
i 4}] b MdC4, ..........31
9C solidDB SQL `-w4P SQL od ....32
# 9;s X Bt/}]b ..........33
9C solidDB SQL `-w#9 }]b .....33
X Bt/}]b( > }
# 9;s X Bt/}]b ..........34
) .........34
5 + solidDB k<N SQL M'z;p9
C .................35
6 KPy> .............37
7 + solidDB }6AB"Pf 6p ...39
w } ................41
y w ................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|
D i~ ..............7
4. solidDB6.5 ?<a9 ..........8
5. solidDB JDBC }/Lr 2.0 X|E" ....9
6. InfoSphere CDC 203q ........12
7. InfoSphere CDC i~DD 5 .......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>E CZ?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
X Z>Va
!"<(
>8OT IBM solidDB z75PxPKEv#|9a)KPXgNWNhC solidDB T
0 gNKPy>D8> E "#
>8O4a)P XgN20 MdC solidDB Universal Cache r_ gN*<9 C solidDB
z7a)D ;,&\ ?~M&\D8>E"#P Xg N9lD5D E",k ND
>8
OPDD 5;Z#
solidDB D59CBP !"<(:
m1.!"<(
q=JCZ
}]bm KVeCZy PU(D >#
NOT NULL ICKVeD s 4V88> 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}{"/ } T d?M Windows
argument K`?w J 8>C'r &C LrX k a)D E "#
\m18O
D~76m> }GmPyw, qr D~764 UNIX q=m >#1 \( /)
Y w53 g{D5|,P X Y w53.dD n pDZ
K VeCZLr z kMLrd v #>} SQL od2 9 C K V
e#
}{#
®
"amu?#
bVy=CZ} Cd{D5r _,;D5P D BZ#BuoM
?wDJb24Ky=i4#
V{m>2 0y?<#
DG UNIX q =#Microsoft
.s"(Z (E P #d{Yw53+%@Pv # TZ;,D Y
w539I\P; ,DBZxPhv#
®
Windows q=;Z UNIX q=
],G4WHa=
xi
o(m> (<(
solidDB D59CBP o (m > (<(:
m2.o(m> (<(
q=JCZ
(z&\!n
INSERT INTO table_name
solid.ini KVe8>D~{M76m o=#
[] =(E8>I!n;g{ GVeD>,G4 Xk+ =(E| ,
| z_,CZ+ o(PPD=v%b! nVt*#
{} s(ECZT o(PPD;i%b!nx P(g;g{G Ve
... !TE8 >IT`NX4 9CTd?#
.
.
.
o(hvI CKVe#I f;?V I C
Z o(P#
> ,G4 X k+s(E| (Zo(P#
D
I }vciI D ;Pm>b G H0zkP D Sx#
K
Ve#
(z&\Io zPzm1]D C'(}g ,P/;c rS&;C) 3 { 9 Cm~z
7 #BPwZ8( K solidDB PD w *( z &\ #
|LdkM< =
|Ldk
I Tv9C|L4Yw solidDB# I T9C|riO | 44Py P Yw#j < Y w53
w|CZj<Y w53Y w#solidDB 'V j<DY w53 |L(z&\#P X9C |
riO|44PY wD|`E",kND `& DY w53D5#
|L<=
I Tv9C|riO|4/ @ solidDB C'gf# P X9 C | r i O|4/ @ |nPg
fD|`E",kND `& DYw53D 5#
WZT>
solidDB 'Vj<Y w53 T>h C,}g ,_TH HMVeh C#
VehC
I T9Cj<Y w 53Y w 4!qD > DU+"s!MVe # P X8(Veh C D|
`E",kND `&DYw 53D5#
xii IBM solidDB: kE8O
;@5ZU+
;h*xVU+MI T9C solidDB PDNN&\#
kd{(z<uD f]T
solidDB (}j< API kYw53xP ;%,b) API 'Vk;)( z<u;%,S
xJmz9CA ;J AwM d{(z$_#
WZCJD D5
solidDB DD 5GIE"P DT HTML q=a)D,Zs` } Web /@wP<IT
i 4#E"P D J m zy]/@wPh C DT>W !n 4 i 4D5#|9Jmz9C
A;JA wM d{(z<u#
PXE"P D(z &\!nD|` j8E ",kND
solidDB E"P DW3#
XZ>Va xiii
xiv IBM solidDB: kE8O
1 IBM solidDB z75PEv
IBM solidDB z75PDX cZZ9 C KZfMX5}]b< u#bV<u\;a )G
# lDKPYH,HyZELD+3}]bDKPYHl.6#IBM solidDB(r_r4
* solidDB)9C l $D SQL od,9 &C Lr\;Z?kS Z qCC8rvB q ,
1d G4"kFcD#
xl&
IBM solidDB 6.5 z75PI =v z7iI:
IBM solidDB Universal Cache G5gD W vX5MZf _ Y:fm~# | (}+T
\X|}]_Y:f=;v r`v solidDB Zf}]b 5}P 4a_yZELD+3X
5}]b~qwDYH#
IBM solidDB G;v&\+f
CT,Tzc51&C LrT T\MI? TD*s#|I T9%v solidDB 5}P, 1
| ,Zfm M yZELDm#| 9 _Pd{Xc,}g ,_I C T5V M `n;,D
4F<u#
D ZfX5}]b,|a)KG#lDYHMG#_DI
<
1. solidDB 6.5
z7
XZ solidDB De5a 9Ev
>Zhv solidDB D53e 5 a9#
1
solidDB 9CM 'z /~qw#M#5JO, solidDB a0G(}-w~qwMM 'zx
L j I D#~qwx L :p\m}]bD~,S \ M'z&C L r,SA}]bDk
s,T}]b4PI M'z ksDYw#
M'z xLCZ (}~qw xL +XhDNq+ ]
x }]b# M 'z`MP`V: M
'zITG|nP$_"< N &CLrr_}]b, $$_#( #,wV wyD &C
L r+w*M'z, S A solidDB#
M'z M~qw IT;Z;,Dwz(Z c)O ,ZbVi vB,|G(} xgxP
(E#solidDB I
T ,1'V` V x g- i M,S`M#}]b~qw M M'z&CL
rIT9C`V;,D xg -i,1,SA`v>c#
solidDB 9ITZ&CLrx L P K P#bG(} solidDB
SbCJ
(LLA )a)D#ZbVivB ,&C Lr+4 SAfKz7;pa)D/
2mZfCJ
(SMA )M
4
} b#4SD&C Lr(}1 S wC/ } 4 5 Vk~qw(E,SxZ !KM'z k
~qw.d(} ng TCP/IP Hxg-ix P (E1y h* D*z#(}9C> X/}
w C4f;xg,S,Sx+ s a}KT\#PX|`E",kND6IBM solidDB 2
mZfCJM4Sb CJC'8 O7#
* r}]b~qwa;i/( 2 MG ;v SQL od),M'zXk\; k K}]b~
qwxP(E#k m` d{D}]b~ q
w;y,solidDB 29C
}/Lr
4'VK(
E #M'z&C L r wC}/L r PD/},; s I}/L r &mk~qwx P (E
Md{_eBq#}g,zIT`4+wC (ODBC )}/LrPD /}D C oTL
™
r ,2I T ` 4 +wC(JDBC )}/L r PD/} D Java
Lr#
P X ODBC M JDBC }/LrT0g N +|G k M'z&C LrdO9 C D|`E
",kND IBM solidDB Programmer Guide#
2 IBM solidDB: kE8O
X Z solidDB Universal Cache De5a 9 Ev
B <5wK solidDB Universal Cache DdMdC D e 5 a9M X |i ~ #
<
2. solidDB Universal Cache
e 5a9
BfhvKwvi~DG+M&\#
solidDB * z+}]4FA MSdP4F}]D0K}]b#!vZ4F#MD;,,
solidDB ITG4 }] bM /r?j}]b#
} ]~qw * z+}]4FAMSd
P4 F}]DsK }]b#! vZ4 F==D;
,,sK}]bIT G4 }]b M/r?j}]b#
™
InfoSphere
CDC 5} * x( DBMS D InfoSphere CDC }fDKP15} #*
h C InfoSphere CDC 5},XkZ} K P yV[D DBMS D Z c O 20K`&D
1 IBM solidDB z75PEv 3
InfoSphere CDC zmLrm~( }g,InfoSphere CDC for DB2 ®r_ InfoSphere CDC
for solidDB)#TZ solidDB,ITZk} ZKP solidDB DZ c`, DNNZ cO2
0 MhC InfoSphere CDC for solidDB zmLr#
d C$_ - CZ dCM4( InfoSphere CDC 5}D GUI $_ry ZX F (D$_#
Z dC5} 1 ,a)CZk d` InfoSphere CDC 53xP (EDKZET0 CZ ,S
A}]bDG<
C J ~ qw * ;vxL((# w* ;n~qr ;vX$xLKP),| J m\mXF
(C'CJMdC InfoSphere CDC 5}#;,D C 'ITT;,D5}_ P CJ(#
Z 20CJ ~ qwZ d,+*sza)\ mXF ( * 9CDKZEM \m 1 G
"#
\mXF( * ;v_P GUI D;%= &CLr,I TC4dCM`S4 F #|Jm
z \mwv ~qwOD4FYw, 8 ( 4 FN},T0SM'z $ w>Pt/"BM
`SYw#
E"#
< E
w*XTM&\
S Z“CJ\mw ” 8S < P 4 ( }] f" w4*<9 C
]bM`X InfoSphere CDC 5}D_- 5e#( }9Cy(eD } ]f" w,ITh
C CZ_eeV+} ] S;v} ] f"w4 F =m;v}]f"w D
;2P}V`MD}]f" w:4"?j T0+X# +X}]f" wI Tw*4M?
jNk$)#(#,+X}]f" wCZ solidDB Universal Cache,"R*+r4F(
e KTF3d T #g{1>rcZ0 K }]~qwPw * ; A 1>,G4a ( e %v
)#
OX$
j IKhC4 F. s,ITZ M 'z $w> O XU \ mXF(,x;a0l4~qw
k?j~qw.dDn/}]4 Fn/#\mX F(9|,;vB~U >M`S w#
B ~U>Jmz l iQzID InfoSphere CDC B ~{" # ` S wa)KXhD
,x`S4FYwMH} 1 d#CZ hv4Fd CD wvi ~D<G (}1S&m <
N Ts49lD# \ m XF(P D`SwCZ T 1d*s\OqD$w73,b )7
3h*, xVv} ]F/iv#
\mXF(#
}]f" w
$)
#
G}
'VT
Zfm
Z fm+|GD y P}]I C kTw Z fCJxPKE/D}] a 9 f" Zw Z f
P#+}]f" Z wZf PDC&ZZi/ H}1dOLxLB ? O s#y]&C L
r D h *,I T +Zf}]mdC*V C } ]mr2, } ]m# K b,in
\Jm z(eVCmh *DBq MCT6p(|(j+ MCT)#
DG<&
4 IBM solidDB: kE8O
PX|`E",kND6IBM solidDB Zf}]b C'8O7#
yZELDm
y ZELDmG + 3DX5}]bm, H [ Z Zd{ y ZELD}]bz7PR =D
m#}K9CZf mTb, 2I TZ}]bP 9C}#Dy ZELD m#(#,yZ
E LDmZNN1 r <;P;?V}]$t Z wZ f P#IT g Z f mMyZ E LD
mxPi/#}g,(} SQL , SYwIT +Zf mky ZELD m,Sp4; mD
5 J;CTZC' G 8wD#
yZELDm D<C?O!"RIT
k =53P#!\Kz7D s !O !,+ G | T; 'Vm`_6&\,} g %"w"
B~Mf"}L#
4 P^KU4DYw,rK solidDB n JOCZ 6
2mZfCJ(SMA )M4Sb CJ(LLA )
2mZfCJ(SMA )M4Sb CJ(LLA )Jm&C L r1S4 S A solidDB ~q
w ,^h(} x g-i(}g,TCP/IP)4xP(E#SMA J m 4S`v&C Lr,x
LLA Jm4S;v&CLr#(}9C>X/}wC4f;xg,S,Sx+sa}K
T\#
P X|`E",kND6IBM solidDB 2 mZfCJM4Sb C J C '8O7#
4F<u
Z solidDB z75P P,IT ( }} V ;,D<u44F } ], 4 , _ 6 4F"
InfoSphere CDC 4FT0 solidDB _ICT( HotStandby)#
4FITG,= 4Frl= 4F#xP,= 4F1,Z"pK 4PBq}L Pa+}
] V C +]xSUK# x Pl= 4 F1,
K#ITy]“FM ”r “-'”Yw#M4x P 4F #Z“FM ”#MP,+I"p K4$
n 4F#Z“-'” #M P ,+I S UK4"p 4 F#
+Zd5 -<B q.sE +}]+]x SU
solidDB _ICT( HotStandby)
solidDB _ICTr_r%D HA r HotStandby,Ia_}]D ICT#~qwGIT
dCD,g{;v~qw'\ ,m;v~qwMI TSf$w# w~qw PD}]+
;4F= (z~qw P, (z~q w ;Cw“H 8C”%*#g{w~qw;I
g,Z"z2~JOr _xP(Z,$DivB ),G4&C LrIT,SA(z~
q w""4Lx$w, "R ;a*'NNQd 5 D B q #
Z solidDB HA P,9Cy Z FMD4 F -i+ w ~qwPDyP}]|D + M A (z
~qw#IT+
q wP&mD#g{ w ~ q w'\,G4(z~ q w+S f$w(4P J O*F)"
w*BDw~ qwLx&m:X#9C,= 4F -i1,ZJO *FZd;fZ*
}]DgU#
8w,S
)K J O*F8wT T 0w~qwk( z ~qw . d D8w:Xyb#
ITT HotStandby 9C mIMCTMOq MCT#9P;v MCT6pF*
1 w~qwM( z ~qw<&Zn / 4,1M 9 CmIMCT, x w ~qw@"KP
1M 9COqMCT#g{ 9C“ T J&”MCT, G4NN 1r"z%vJO 1<a
# $Bq#
k “_6 4 F ” M“InfoSphere CDC 4F”`H,9C “solidDB HA” 1,
D }]bP D yP}]#T( C SQL |nN=a) K ;)/,XF#
K-ihC*,= (2-Safe ) r l= (1-Safe )#Bq:Xy>O GZw~
G solidDB ODBC M JDBC }/LrD;VX b,S= =,|*&CLra
<U+4 F~qw
C(}
T J&
'
;
1 IBM solidDB z75PEv 5
P X|`E",kND6IBM solidDB _ I C T C '8O7#
_6 4F
“ _6 4 F ” <um > ;VyZ l =-'D=(#|JmC' Z `v } ]b~qw. d
V"}],P 1r9* 9}],=#_6 4F 9C; VwX/1>#M#ZK #MP,
% vZ c +5P }] D wX1>#x; v r`v1 >Z c 9IT_P ;
ryPwX}]D1>#xR,? v1> 9IT_P;X( ZC1>D} ]#
I TxP+r4F; 1 > Z c I T+}]OXAw X Zc,2 I TSw X ZcBX}
]#g{1>Zca ;K`e;D} ],G4wXZc IT \x
s Y9|I) y P1>Zc 9 C#y4FD } ] G y]inD"</ $ )#Mx P \ m
D#\mSZIC SQL oT D=P)9 DN=#
r_DdK}],;
? VwX}]
9C_6 4FDl==( 1,53 <U GinD;g{3)Z crNN- rx#
G 41| G XBt/r_ X B,S A 531,IT 9 b)Zc X B,=#bMJ m n
g PDA rJG > gT H F/h 8 ks Q|BD}],kxgO*,S ,TsYX B k
xg,S#C'IT!qT}] xP ,=D5J#
PX|`E
",kND IBM solidDB Advanced Replication User Guide#
9,
InfoSphere CDC <u
I T9C IBM InfoSphere Change Data Capture (InfoSphere CDC) < u 4 5 VZwV
}]b.dxPl=4 F#InfoSphere CDC < uyZl=FM#M#I T4(%r $
),T+4 KD}]|D51 +MA?j K#IT(}hC=v$ ),|G_P 5q
D4(eM?j (e,4q C+r$)\&#
solidDB M
v Z solidDB P,IT9C InfoSphere CDC < u ZNN solidDB ~qw 5 }T .d
4 F}]#}g,|tCKX m ; C _`\&,r_Jm Z ; v n// 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 < u 4h C solidDB
0K_Y:f,Ta _CJf"Zs K}]~qwPDT\X| }]DY H#
solidDB Universal Cache b=vz7P<9C K InfoSphere CDC <u#
v1>#
6 IBM solidDB: kE8O
P X|`E",kNDIBM solidDB Universal Cache C '8O7#
Zb=vhCP,? v solidDB ~qw5}9IT G; 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#
B m T >K solidDB M solidDB Universal Cache z7Lr|Py | ,Di~#y P >
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(d P sK}]~qwG IBM
}]~qw)PEh*Kn#
solidDB ~qwLr|
solidDB Lr ||,;{W solidDB m~,dP|( JDBC M ODBC }/LrMwV
5CLr#
7
solidDB Lr|Gk@@ m I$$iD~ solideval.lic ;p;6D# @ @ m I$J m z
Z 90 l.ZTC solidDB#*q!@CmI$,k k IBM +>*5#
?<a9
solidDB 6.5 D1!20+4 (;vF* solidDB6.5 D?<#
B m5wK solidDB6.5 20?<PDD~M S ?<#
m
;C 5w
y?< y?<P|,gBy>D Z]:
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 solidDB D Java }]b,S(JDBC )}/Lr
4. solidDB6.5
?<a9
v C4c ZZ}]b@@WN KPy>DE >
v @@mI$D~
v CZCJLr| D5D welcome.html D~
IC HTML q=MD> q=DLr|D 5
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"Df VaBX=KD~P
procedures CZ 4(MKP}]Jd M"BD f"}LD
samples ITZ}] b@@WNM +4D&C Lr
bD~{
solidDB TI4S bDN=a)K m`D~#
b)bD~s`} < ITikBP`p. ;:
v ODBC }/Lr
v solidDB 2mZfCJM4Sb CJD~
v (EbD~
v SA(~qw API)bD~#
CZ WebSphere
P,;s(}6-3f PDVa4S4CJ
SQL E>
WN9CDy>
®
D }]f"(zX~ f 5
*"
8 IBM solidDB: kE8O
";GyP=(O<_ P O v ?vD~#}g,;P Windows 73 P E a)K3)(
EbD~#
3 )bD~G2,D, 4 ,1 z 4P`k"4S Y w1,b )bD~Ma4S A M'
z&C LrDI4 P Lr#d{bD~G/,D:b )D~k
I4PD~GV *f"
D # 1 4PL r 1,Ma+b )D~0kZf P #TZm ` b,solidDB Z3)=(r
yP=(O<,1 a)K2 ,bM/ ,b#
bD~#fZBfDdP;v?< B:
v “bin”
v “lib”
(#,“bin” ?<B|,/,b (}KI4
P D~Tb),x“lib”?<B|,2,b#
“lib”?<B9|,CZ Windows 73D<kb#
P XbD~{D|j8 E",kND solidDB Lr|PD“SDK 5w”,I(} solidDB
20?<D6-3fCJC D 5#
ODBC"JDBC M(P`LSZ
solidDB *M'za)K ODBC M JDBC SZ,BPw Z Pr*hvKb) S Z#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 }/Lr1 0'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{D 5#
solidDB JDBC }/Lr)9
'VBfP>DGj<)9#PX|`E",kND IBM solidDB Programmer Guide #
v JDBC URL q=:Jmz Z URL V{.Ph C ,StT 5
,1:,S,1G 8CZ wC(},SWSV x PD}]+ d DNN 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 z7IT 9 C=V=( 4jIKNq:
;VG9 C
vB,1d%;< GAk#
v G<,1:Z,S1%", 1#KhC G(} ,StT 5VD#K tT +2G Id
{=(8(D JDBC DG<,1(}g ,} /Lr\mw PDG<
v ,SUP,1:g{,S&Z;n/4, o = K y8(D1d,~qwMa X UK
,S#bG(} ,StT4 5VD,d5 +2GKa0D~qwN}hC#
v od_Y:f:solidDB JDBC }/Lr9C'\;Z4(,S Zd + y
od_Y:fs!hC*; Vt T#
v 8w,S'V:solidDB JDBC }/Lrj+' V solidDB 8w,S(TC), dP|
(8wJO*FM:Xyb#PX8w,SDC(D|`E",kND6IBM solidDB
_ICT C'8O7#
v 2mZfCJ(SMA ),
v SQL +]:JmhC SQL +]==
v ?<M #={F tT:JmhC solidDB }]bD?<{FM # ={F
v WebSphere 'V:Z solidDB L r|D“jdbc” ?<B, Z;v % @ DD~
SolidDataStoreHelper.jarPa)K;vF* “SolidDataStoreHelper”D}]4 J d
w#
G j<}/Lr\mw )9 =( ,m;VG9 CtTz F #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)}/L rD|` 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" o d _ Y:fP*M'
V8w,S`X *#PX|`E",kND IBM solidDB Programmer Guide #
(PSZ
}g,solidDB &C Lr` LSZ (SA API )M solidDB ~qwXF API (SSC API )
J m C L r 1SwC}]b~qw P D/}#b )(PSZG(} solidDB 2 mZf
CJ(SMA )M4Sb CJ(LLA )ba)D#
53$_M5CLr
solidDB |, CZ}]\mM \mD=vXF( $ _, solidDB6LXF (solcon) M
solidDB SQL `-w (solsql),9|,CZT solidDB }]b<v }]"0k }]D|
nP5CL r#
solidDB }]\m$_|,Z solidDB Lr |P,;Z solidDB20?<PD“bin”?<#
XF($_:solidDB SQL `-w (solsql )M solidDB 6L XF
(solcon )
v solidDB SQL `-w (solsql) G;VX F ($_,CZ "v SQL o d MZ|n a >
{Br(}4P|, SQL odDE>D~ "v solidDB \m|n (ADMIN COM-
MAND)#
v solidDB 6LXF (solcon) G; V \m X F($_;_ P \ m(^DC' I T Z |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~ 0 k= solidDB }
]bP#
v solidDB <v (solexp) a+}]S solidDB } ]b < vAD~#|2CZ 4(I
solidDB lY0kLr( solloado r solload)CZ4P}]0kY wDX FD~#
v solidDB }]Vd (soldd) a < v } ]bD } ]Vd#|azI SQL E>,dP|
,hvC }]ba9D }](eo d#
solidDB Lr|P | ,`v9C C oT" SQL M Java oT`4D y >Lr,Toz
z*<9C solidDB D& \?~#
y >ME > ;Z solidDB 20?<BD“samples” ? <P#?vy>?<B9|,;v
readme.txt D~,CZa) PXgN9 Cb)y>D8> E"#
2 z7M|0E" 11
InfoSphere CDC m~|
InfoSphere CDC i~G w*I%@?p DLr|;6 D#
m
6. InfoSphere CDC
InfoSphere CDC i~{F 2 0m~| 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 ~q wLinux 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 - v J CZ Windows
Windows
setup-x86-dmclient.exe
:
v CZXFT4 F73DCJ Dm~
v CZdCM`S solidDB Universal Cache M InfoSphere
CDC 4Fd C20 PD InfoSphere CDC C'CJM4F
$)Dm~
v PDF q= InfoSphere Change Data Capture \mXF( \
m8O(/documentation ?<)
v ,Soz(I(}\ mX F (C' g fPD“o z ”K%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,zX k(
}b9uCD~4V/20} /Lr#
D5Lr|
solidDB DD 5IIBM solidDB
r|iI#
“solidDB D5”Lr|GTZ_ E"P DN =M PDF q=a)D,||, InfoSphere
CDC for solidDB i~DD 5# “InfoSphere CDC D5”Lr ||, InfoSphere CDC \
m XF("InfoSphere CDC CJ ~ qwMs K}]~qwD InfoSphere CDC i~ D D
5#
solidDB D5
Z solidDB 6.5 M solidDB Universal Cache 6.5 E"P DP Z_a)K solidDB D5,
,19IC PDF q =a)KKD5#E"P D <Uaa)nBE"#
solidDB D5D;6
solidDB 6.5 M solidDB Universal Cache 6.5 E"P D
ZE"PD(http://publib.boulder.ibm.com/infocenter/soliddb/v6r5/)Pa)KnBD solidDB
D5#
IC PDF q=D solidDB V a
ISBP;C BXb) 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;6 D,r_G(}y;6 Domi JPD“
l YkE”DVD ;6D#
a >:g{z+"DfD PDF D ~BX= solidDB 20 ? <BD manuals ? <P,
G49IT(} solidDB m~|D6- 3 f4CJb)Va#PXj88>E",kN
DZ 24
3 D:20 solidDB D 5 Lr|;b ;Z#
Lr|D N=a)K PDF q =D Va#K Lr|Gk
2 z7M|0E" 13
solidDB D5Da9
B PvfoP5w K w*@ "~qwr_w * Universal Cache D;? V D 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“_6 4 F”DYw:
v IBM solidDB Advanced Replication User Guide
kE8O7
\ m18O7
8O7
2 mZfCJM4Sb C JC'8 O 7
C'8O7
_ ICT C '8O7
Zf}]bC'8 O7
ZTBvfoPhvK“InfoSphere CDC 4 F”DYw:
v IBM solidDB Replication with InfoSphere CDC User Guide
InfoSphere CDC D5
IBM solidDB
\ mXF("InfoSphere CDC CJ~ qwMs K}] ~ qwD InfoSphere CDC }f D
D5<|,Z InfoSphere Change Data Capture
zK%49C InfoSphere Change Data Capture
InfoSphere CDC i~DD 5 ;6M;C
m
7. InfoSphere CDC
i~ D5 D5D;6
InfoSphere CDC for
solidDB
D5
L r|P | , InfoSphere CDC for solidDB D5# InfoSphere CDC
i ~DD5
IBM solidDB Universal Cache C'
8 O7 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(}\ m X F(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~DD 5 (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 %@ DD 5,kND“\mX
F (”D5
InfoSphere Change Data Capture n
UC'D5
)
M\mXF(|nN<
v InfoSphere Change Data Capture
Lr|
5
v \mXF(*zo z
v f\m XF(;p20D API D
PDF VaM Javadoc
;P%@ D D5 ,kND“\mXF( ”
D5
v InfoSphere Change Data Capture
5
Lr|
v \mXF(*zo z
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( ”M “CJ ~qw ”)DKD&\#
v ZX(Z}]~qwD D 5“InfoSphere Change Data Capture nU C 'D5”P a )K
X(Zd{}]~q wD?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,k N DIBM solidDB
Universal Cache C'8O7M IBM solidDB Replication with InfoSphere CDC User
Guide,TKbPXgN20yh *DyP InfoSphere CDC i~D8>E"#
solidDB z75P'V 30 vTOD;,=(,? v=(<I2~`MMYw53 i O
x I#( # ,10 D yP # C=(M;)I = ( < \'V#
PX solidDB z75PD1 0 =(DPm,k ND solidDB Web 3f(http://www-
01.ibm.com/software/data/soliddb/)#
solidDB 20hs
g{*20 solidDB,zh *:
v s< 48 MB ELUd,dP|(%@ 20DD 5y<C DUd(y]y9C D=(
;,,K}?aTxd / )
v Z1!dCP,AYP 40 MB D RAM
v CZ}]bDc; DEL Ud(;v U }]b(#h*s< 16 MB D EL
v g{9CZfm, G4h*nbD Zf4 f"b)m
v g{9CK InfoSphere CDC < u(r_tCK solidDB U>DAw),G4h*P
c ;DELUd4]I#t D BqU> D ~TCZ 4FV 4 (,= 4 F):1 !i
vB,yhDU>#f Ud* 10 GB
v h* Java K P 173 (JRE) r Java Development Kit (JDK) V1.4.2 r | B f>
– solidDB 20Lr
Ud)
":Z Linux 53O,20Lr;' V CZ Java D GNU `kw (GCJ) #
– 2mZfCJ (SMA) M4SbCJ (LLA)
m b,Z Linux M UNIX 73P ,zI \ h* ^ D53DC'xLJ4^F (ulimit) D
hC #PX j8 E" ,
UNIX);#
k N DZ 18 3 D : 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~D2 0 hs
* Kbd{ InfoSphere CDC i~D53hs,k ND solidDB Web 3f(http://www-
01.ibm.com/software/data/soliddb/)r_f?v InfoSphere CDC i~a)DD 5#
Yw53C' ^Fhs(Linux M UNIX )
Z Linux M UNIX 73P,zI\h* ^D53DC'xLJ4^F (ulimit) Dh C#
g{4zcyhD ulimit 5,G4 solidDB av =bb DY w53 J4; cm s,}
g:SOLID (Ems 21309:4\S\BDM'z, S ,TCP/IP J4; c#
g{*Z53O@C hCJ
4 ^F,k^D data"nofiles M fsize J 4 D2Yw53
ulimit(h* root C'r53\m1( ^)#
m8.FvD
2 ulimit J
4 hv Fv5
}] Jm?vxLy(CD nsZ f? ^^
nofiles Jm?vxLyr*DD~r D ~ hv{Dns
fsize yJmDnsD~ s ! ^^
ulimit
5
}?( k Y w5 3 M &CLr I C DW S V P
X)
65536 r^^
P XgNi/ M ^D ulimit 5D 8 > E ",kND Y w 5 3D5#
>}
*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 5h C* 65536:
ulimit -Hn 65536
20 solidDB
solidDB I(} <NC'gfD%/20Lrr|nP20,r9C2,20=(20#
<Ngf20
GUI 20a)K<N/D=(T 20 solidDB#
*<.0
Z Windows Vista M Windows 2008 Server P,Xh5P \m 1 (^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+d 20#
h * JRE r JDK 1.4.2 r| B Df>4K P solidDB 20L r #
":Z Linux 53O,;'VCZ Java D GNU `kw( GCJ )#
2. ZB X203qr 20 DVD O,R=CZz DYw53
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>TjI2 0#
":Z Linux M UNIX Yw53P,zXh5PCZ 2 0 D?< D 4(^#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 3 D :s20Nq ;#
XF(20
9CXF(20=(S|nPg f 20 solidDB#
*<.0
Z Windows Vista M Windows 2008 Server P,Xh5P \m 1 (^EIT20
solidDB#
}L
1. g{9;P20 Java KP173( JRE )r Java Development Kit (JDK ),V1.4.2
r|BDf>,k+d 20#
h * JRE r JDK 1.4.2 r| B Df>4K P solidDB 20L r #
":Z Linux 53O,;'VCZ Java D GNU `kw( GCJ )#
2. ZB X203qr 20 DVD O,R=CZz DYw53
v solidDB-6.5-<platform>.exe(Windows )
v solidDB-6.5-<platform>.bin(Linux M UNIX )
3. S|nPt/20L r#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 >TjI2 0#
":Z Linux M UNIX Yw53P,zXh5PCZ 2 0 D?< D 4(^#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 3 D :s20Nq ;#
2,20
9 C2,20=( ,Z^h C ';% 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"z Il&D~:
Development Kit(JDK)V1.4.2 r|Bf>,k+d 20#
h * JRE r JDK 1.4.2 r| B Df>4K P solidDB 20L r #
":Z Linux 53O,;'VCZ Java D GNU `kw( GCJ )#
2 03qr20 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 >TjI2 0#
":Z Linux M UNIX Yw53P,zXh5PCZ 2 0 D?< D 4(^#g{2
0Lr^(4(K?<, G4+a> z8(m;v ?<#
5. Z20jIs,lizz I Dl&D~Gq | ,h*
D!n# l&D~ ; Z20y
?<P#
a >:solidDB 20?<Ba)DF* installer-response-file.txt D y> l &
D~IC#
6. Zm;v53O, (} KPTB|n44 P2,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>D9 C#
}L
1. g{:rK solidDB r solidDB Universal Cache ,k+mI$D~ (solid.lic r
soliduc.lic)SmI$$i3q4 FAsolidDB $w?<#
a> :solidDB D 1 !2 0 +Z solidDB 2 0? < B | ( ;v @ @m I $
(solideval.lic )#@@mI$J mzZ 90 l. ZTC solidDB #
2. g{zF.9C solidDB JDBC }/Lr,+zyZ
h C*|, 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}L T/+1! solidDB JDBC } /Lr 2076mSA53 CLASSPATH
73d?#
I T(} X FfeliMh C 53 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{z9CD G UNIX shell x; G C shell, G4k`&X^DK |nTJO z
y9CD shell#
20 JDBC M ODBC }/Lr
solidDB JDBC }/LrM solidDB ODBC }/Lr|,Z solidDB ~qw20Lr
|P#1!ivB,Z 20 solidDB Zda 20b=v}/Lr#
20 solidDB JDBC }/Lr
Z solidDB 20}LP+ 20 solidDB JDBC }/Lr(SolidDriver2.0.jar )#!v
Z zyZD73, Z 9 C solidDB JDBC }/Lr. 0 , zI \ h*hC`nd C h
C#
1!20?<
1!ivB,Z solidDB 20}LP ,solidDB JDBC }/Lr+20A solidDB 20?
< BD“jdbc” ? < #
jdbc ? < 9 | , CZ WebSphere D solidDB } ] f"( z X ~ `
(SolidDataStoreHelper.jar)#
solidDB 20?<BD samples/jdbc ? < | ,K9C solidDB JDBC }/LrD Java
z ky>#PXKP y >D8>E",kND readme.txt
B#
D~,C D~ ;Z,;?<
Java 73hs
v 7#5P;v'V JDBC API f6"Pf 2.0 D} #$wD Java KP1r*" 7
3#
v li Java 73D5T7O dGqI 9 C9uVZk#SolidDriver2.0.jar |,9u
VZkq=D solidDB JDBC }/Lr`,ICZ s ` } Java ibz#;x, 3 )
7 3(}g ,Microsoft J++ )*s49uVZk
k,G4 zXk9C'V$D~{D$_4 i! SolidDriver2.0.jar D~#
#g{zyZD73*s49 uVZ
hC CLASSPATH 73d?
zyZ73D CLASSPATH 73d?h*|, solidDB JDBC }/L r .jar D~20
76#
v Windows
2 0}L T /+1! solidDB JDBC } / Lr 2 076mSA53 CLASSPATH 7
3d?#
I T(} X FfeliMh C 53 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 {z9CD G Bourne shell .bDd{ shell , G 4k`&X^DK | nTJO z
y9CD shell#
20 solidDB ODBC }/Lr
solidDB 20Lra 2 0=v ODBC }/Lr,;vCZ Unicode V{/,m;vC
Z ASCII V{/# Unicode f>G ASCII f>D,/;I+d k Unicode r ASCII
V {/;p9C# 2 I T 9C solidDB 2 0 LrTv2 0 ODBC}/Lr#
Windows
Z Windows 73P,solidDB 20Lr aT/2 0 ODBC }/LrMTB5 3}]4
{F (DSN)#z2I TmS zT: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 }/Lr x; 20 solidDB
g {*20 ODBC }/Lr x ; 2 0 solidDB:
1. t/ solidDB 20Lr#
2. !q(F20#
3. !q ODBC(!{ !q~qwMy>)#
4. q-T>D8 >TjI2 0#
3 20 23
20 solidDB D5Lr |
g {zkZ20K solidDB ~qwDZ c O C JIC PDF q=D"D f solidDB D
5,G4ITBX solidDB D 5Lr|"+| i! = solidDB 20?<B D“manuals”
?<P#
}L
1. R=IBM solidDB
v Zy;6Dom iJP,D5Lr||, Z“lYkE ”DVD P#
v g{zS IBM Passport Advantage PBX m~,G4kR=D 5Lr|#
v g{zS solidDB FTP >c (ftp://ftp.software.ibm.com/software/data/soliddb/info/
6.5/man/) BX solidDB,G4kR="DfVa D .zip D~#
2. BXD5Lr|,"+| i! = solidDB 20?
20^) |
a+^)|w*%v 20L rD~4V"#
v :20CZ solidDB D^) | ;
v :20CZ InfoSphere CDC i~D^) | ;
20CZ solidDB D^) |
1. Fw}]bD~"U >D~M solid.ini d CD~D8]1 >#
D5
Lr|#
<BD“manuals”? <P#
PX8>E",kND 6IBM solidDB
2. XU solidDB#
P X8>E",kND X U solidDB#
3. 4U 20 solidDB PD 8>E"4K P solidDB ^) |20Lr#
solidDB ^)|T%v 20D~D N=a)#g {* f;VP solidDB 20,k9
C ZdP20K solidDB D`, 2 0?<#
g {z;kZ V P solidDB 2
9 C%@ D ?<," V /4F J CZzD20 D I4PD~" b M}/Lr#
0O(}g ,Z zz73Zc O)KP2 0Lr,k
\m18O7 PD 4P8]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,kHjI BP= h:
1. axTyP$ )D4FYw#
2. O*kCJ ~qwD,S#
3. Kv\mXF(#
4. #9 InfoSphere CDC for solidDB dC$_M CZsK
d C$_ P DyP 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 ^)|6 p#
1. 6XCJ~ qw#
D5
2. 4U InfoSphere Change Data Capture
Server and Management Console
208O
L r|Pf=D6IBM InfoSphere Access
7PD 8>E"4K PCJ ~qw ^)|
2 0Lr#
":
v 9CCZ20T0 f>DCJ ~qw D`, 20?<#
v z^(Z`,ZcO ,1 KP=vf>D CJ~ 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
L r|Pf=D6IBM InfoSphere Access
7PD 8>E"4K P\mX F(^)|
2 0Lr#
":9CCZ20T0 f >D\mXF( D `, 2 0?<#
20CZ InfoSphere CDC for solidDB D^)|
* c:g{*20CZ InfoSphere CDC for solidDB D^) | ,G4Xk Q -20K
InfoSphere CDC for solidDB#
1. 4U 20 InfoSphere CDC PD 8>E"4K P InfoSphere CDC for solidDB ^)
Lr#
|20
":9CCZ20T0 f >D InfoSphere CDC for solidDB D `, 2 0?<; 2 0
L r+a>zT20 x P }6#
CZsK}]~qwD
20
*c:g{*20
-20K
CZsK}]~qwD
CZsK}]~qwD
1. 4U IBM InfoSphere Change Data Capture
wD6IBM InfoSphere Change Data Capture
CZ sK}]~qwD
InfoSphere CDC D^)|
InfoSphere CDC D20^) |,G4XkQ
InfoSphere CDC#
D5
L r|Pf=DCZsK}]~q
n UC'D5
InfoSphere CDC ^)|20L r #
7PD 8>E"4K P
":9CCZ20T0f>D
CZsK}]~qwD
<;20Lr+a>zT 20xP}6#
20.s XBt/T$ )D4 FY w
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$_M CZsK}]~qwD InfoSphere CDC
d C$_ P D 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>}L r46X 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
Z jI solidDB ~qw20s,IT t / solidDB "4(Z;v}]b T i$20 Q
II T9C Lr|Pa)Dy>4 =w solidDB X TM&\#
Z I&20s,IT Z solidDB 20?<BR=T B ? <:
<20?< >
bin\
..
eval_kit\
standalone\
cdc\
..
samples
..
standalone ?<+4UBf?V T>D= =Zt/ solidDB "4(Z;v }]b 1d1
$w?<
(solideval.lic )#C?<9|,Z; v}]b (solid.db )T0`XDBqU>"
{"MzYD~#
cdc ?<|,CZ solidDB Universal Cache Dy> solid.ini dCD~# cdc ?<I
Z 20 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 Dy Pz7!nM&\#
$w?<M solid.ini dCD~
$ w?<G|,kKPX( solidDB 5 }` X DD~,C?<P|, solid.ini d C
D~#solid.ini dC D~8(KIo z(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~T 0 solid.ini d CD~# I(}4 (
SOLIDDIR 73N}4*mI$ D ~M solid.ini D ~8( ;,D?<#
1zt/ solidDB 1,|+S solid.ini dCD~ P A!dCN}#2I T 9C ;x
d CD~D solidDB , b V i v B + 9 C 1 !h C (v' 5 )#Kb ,g{fZ
solid.ini dCD~,+GX(N } D 5 4h C ,G4 solidDB +TCN}9 Cv'
5#v' 5I\!vZ z}9
~,Jmz@@ solidDB ;N1 d#Z@@
CDYw53#
27
BqU>" {" Mz Y D ~ 2I TC Z z ! qDd{ ? < ; ZKiv B , X kZ
solid.ini dCD~ P( e`&D? <76MD~{# }g, solid.ini D~D
[IndexFile] ZPD FileSpec N}CZ 8(}]bD~D?<M D~{#
CZ @@20D solid.ini dCD~
;Z eval_kit\standalone ?< BDy> solid.ini dC D ~PDN}h C azc
solidDB ~qwDs`} @@h*#
g {h*9Cd{i~,} g solidDB Universal Cache r_ICT&\,G 4X k `
&X^DdCD~#
y>P2|, solid.ini dCD~,C D~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 \m 18O7#
t/ solidDB "4(Z;v}]b
>ZhvgN 9CmI$D~M eval_kit\standalone ?<BD solid.ini d CD~
4 t/ solidDB D @ @f>#
* t/ solidDB,zD$w ? <BXkfZ ;vP'D m I$D~#
Z Linux M UNIX 73Pt/ solidDB
1. g{Z,;(zwO20K`v solidDB ,ki$ 6.5 20D f >GqG1 ! solidDB
20#
a. g{*liZ PATH 73d?P(eD solid I 4 PD~,kZ| n a>{P
dkBP| n:
which solid
b. g{*i$ solid I 4PD~Df>,kZ|na>{ Pd kBP| n:
solid -x version
2. Z eval_kit/standalone ?<PD|na>{& d k solid -f |n#
C#1@@
3. dk y T4(B }]b#
4. *1!}]b?<a)C'{
28 IBM solidDB: kE8O
!n -f CZ?F~qwZ 0(KP#
1 zt/ solidDB 1,|+li } ]b G qQ-fZ#g{4R=}]b,solidDB
+a>z4 (B}]b#
"\kM {F #
"b:
C '{M \ k ; P 1!5#zXkG! C '{M \ k,Tc\;YNCJ}]b#
} g,IT9C dba w*@@ } ] b DC'{M \ k ,r*|r% W G#
*9CK C'{M \k:
a. dkz26D NN{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 x LtZ0(Lx K P#g{*9 solidDB Z s( K P:
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 solidDB K %76BjPt/ IBM solidDB ~q w D<j#
a{
1 zt/ 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 ~q w <jt/ solidDB "Zd{?<r9C
d{G<}]M? <{4(B}]b,I(}R|%wt/ IBM solidDB ~q w<j
"`-l]==tT4^D201 !hC#PX|`E",k ND 6IBM solidDB \
m18O7
WN,SA solidDB
Z z4(Z;v}]bs,solidDB x LV Z MQ - ZK P,zITSNN M 'z&C
LrP9C solidDB x L}Z l}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>, (eK TB(E KZ:
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 > {B d k solsql t/|
n,** ,SAD solidDB ~qw 8(xg{M> $#Z Windows Yw53O,2I
T 9C*< → 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"%w l]==tT4^D20
1 !hC#PX|`E",kND 6IBM solidDB \m 1 8O7D
]==
v ZyPd { 73P, Z Yw53a>{& d k SQL `-wt /|n# | no(* g
By>:
solsql "networkname" [userid [password ]]
}g:
a>:g{Zt/ solidDB SQL `- w14a )C'{M \k,G 4+ aa>z d
k|G#
;Z#
solsql "tcp 2315" dba dba
^D
Zt/
Windows
l
a{
g {Zt/ solidDB SQL `- w 1d k KP'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 ) 4 i4}] b 4,"l iN }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’;
B f T >K solidDB SQL `-wzzD > } d v:
4 i$ solidDB 20 31
<
4. solidDB SQL
`-w(
solsql
)zzD>} dv
2. *i4 N }hC,"v T B|n:
ADMIN COMMAND ’par’;
a>:IT9C solsql |n4i 4X(Z3;?VD N}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
I TZ solidDB SQL `-wP4P SQL od#K?VT>K 4 ( "i 4 M>}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< Q d5,kGC * 4P COMMIT WORK o
d#
# 9;s X Bt/}]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
I T9C solidDB SQL `-w4#9 } ] b #"v|n"Z | n)29C V E # k"
b,Xk9C% }Ex;G+ }E#
}L
1. h99PmbD C ',S A}]b:
admin command ’close’;
2. O*ky PQ,S C'D,S("vK| nD C'}b):
admin command ’throwout all’;
3. XU solidDB:
admin command ’shutdown’;
4. Kv solsql $_:
exit;
":IT+0}v|nf;* T B|n:admin command ’shutdown force’;
a{
solidDB }]bQXU,H0,SDyPC'< QO *,S#
":
X U~qw.s,|+O*k solsql D, S ,R solsql I\aT>;ug B y>Dm
s{":
4 i$ solidDB 20 33
14519: C'QKv~qw;,S QO*#
XBt/}]b( >})
I T(}"v|nr_9C Windows Yw5 3 OD*< → LrK % 4XBt/
solidDB#
XZKNq
>Za)KP XXBt/ eval_kit\standalone ?<BD @ @}]bD8 >E"#
}L
!qBP=(.;4 XBt/}]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 ? <, G 4P;A“eval_kit\standalone” ? <"9
| I*10$w?<,;s( } 4P solid |n4t/ solidDB#
#9;s XBt/}]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
9 C,4/ @ } ]bTs"i 4 M^Dm } ]T0"v SQL |n#
v g{zD*"73Q -9CK Data Studio r Eclipse r \, G 4 IBM Data Studio
Administrator M Eclipse SQL Explorer M'zGnO JD#
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
T s"r/6p"VvM 5 V }]b# = |DD}L#
zIT(}9C Data Studio Administrator D (C JDBC }] b\mw!n,+ Data
Studio Administrator ,SA solidDB }]b#
P XhC Data Studio Administrator k solidDB D|`j8 E",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/@N N k JDBC f]D
}]b,dP|( solidDB#
I+ Eclipse SQL Explorer w*e~m S=VP D Eclipse 73P,2 IT+dw*@
"M'z4KP#
PXhC SQL Explorer k solidDB D|`j8 E",kND ibm.com O DBPDB:
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}]b D*E=4zk Java SQL M
'z Lr#|G@"DM 'z ,I+ddCI(} solidDB JDBC }/L r,SA
solidDB }]b#
P XhC 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 >#?v y> ?<B
9|,;v readme.txt D~,CZa) PXg N9Cb)y>D8 >E"#
*<.0
g {*KPy>,G4 y >?< X k |,P 'm I$D~# 1 !ivB,?;vy>
?<<|,@@mI$ (solideval.lic ) D;v1>#
g {z*+j{z7mI$(solid.lic r soliduc.lic )ky> ;p9C:
1. +mI$D~4 F = 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 "4KP y>#
":3)y>E> a}%;Z y >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"Pf 6p
solidDB 'VS AY=v0"Pf6p} 6# 'VS 6.3 M 6.1 "P f}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"P D 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
T B=hhvK+%v solidDB ~qw}6AB"P f6pD=h#g{Z_ICT=
6
=B 9C solidDB,kND
~qw
;Z#
0"Pf6pD solidDB JDBC M ODBC }/Lrk 6.5 " Pf6p solidDB ~q
w f]#+G,6.5 f> D }/Lr;\CZIf>~q w #rK,XkZ}/L r .
0}6~qw#
v 1zh*9C" P f6p 6.5P}k D B&\1,E h *}6}/L r
":g{z**; 6.3 r 6.1 }]b T 'Vf> 6.5 P } k D + Unicode ==,kN
D IBM solidDB Programmer GuidePD Converting partial-Unicode databases to Uni-
code ;Z#
IBM solidDB
_ ICT C '8O7 P D } 6
#
HotStandby
}L
1. Fw}]bD~Msolid.ini d CD~D8]1 >#
6
PX8>E",kND
2. XU solidDB#
3. 20 solidDB DB f>#
solidDB T%v20D~ DN=a)#g{z;kZzz73ZcOKP20Lr,
I TZ@"ZcO20 solidDB ,Y+JCZ z D 20 D I4PD~"bM}/Lr
V/4F=zzZ c#
PX solidDB ~qwL
|;#
P XgNKP solidDB 20L r D8> E ",kN D Z 18 3 D :20 solidDB;#
4. |BmI$D~#
+ Bm I$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 3 D:solidDB ~qwL r
\ m18O7 P D 4 P8]MV4
|B solid.ini dCD~#
;Z#
39
"P5w
PhvKN } 5D|D#
6. li"|BJCZzyZ73D solidDB JDBC M ODBC }/L r`XhC#
v solidDB JDBC }/Lr
g {+B solidDB JDBC }/L r (SolidDriver2.0.jar )20=;,ZH0 f
> D;C,k+B } /Lr76mS A CLASSPATH 5373 d ?#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,X k^DVP}]4r4( B}]4#
– g{P1S4 S A solidDB ODBC }/LrD&C L r,XkX B ` 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
2 0 22
solidDB ODBC }/Lr
2 0 23
solidDB SDK 8
solidDB SQL `-w
d ki/ 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 if Z(,qr;\T NN= =9C>z7PDNN ?V#
> z7\@z({ 6144941, 7136912, 6970876, 7139775, 6978396, 7266702, 7406489,
7502796, M 7587429 #$#
* Kz78(D@zvZ \ F V``EG ECCN=5D992b#
>E"G*Z@za )Dz7M~ q `4D#
IBM I\Zd{zRrXx
yZxrDz7M~q DE", krz1XD IBM zmI/#NNT IBM z7"L
r r~qD}C" G bZw> r 5>;\ 9 C IBM Dz7"L r r~q#;*;V 8
IBM D*6z(,
~ q#+G,@@Mi$N N G IBM z7"Lrr ~ q,rIC'TP: p #
IBM +>I\Q 5Pr}Zjkk>D5Z]PXDwn({#a)>D5" 4ZhC
'9Cb)(
IBM Director of Licensing
IBM Corporation
North Castle Drive
Armonk, NY 10504-1785
U.S.A.
P X+VZ (DBCS) E"D m I$i/,k*5z y Z z RD IBM *6z(? E,r
+i/TifDN ="MA:
IBM World Trade Asia Corporation
Licensing
2-31 Roppongi 3-chome, Minato-ku
Tokyo 106-0032, Japan
N N,H&\ D z7"Lrr~q,<ITzf IBM z7"Lrr
{ DNNmI#z I TCif= = + m Ii/Dy:
;a)>D5PV[ Dz7"~qr&\XT#PXz10
> un;JC" zrNNbyD u nk1X (I;;BDzRr X x
TIONAL BUSINESS MACHINES CORPORATION“ 4V4”a)>v f o,;=PNN
V `D(^[Gw > D 9G5, D )# $ ,|(+;^Z 5 ,DPXGV("Jz M
JCZ 3VX(C>D# $# 3)zRrXxZ 3);WP;J mb} w >r5,D
#$#rK >unI\
>E"PI\|,<u=f;;<7DX =r!"ms# K&D E"+(Z|D ;b
)|D +`k>JODBf>P#IBM ITf1T>JOPhvDz7M/rLrxPD
xM/r|D,x;mP(*#
;JCZz#
:INTERNA-
43
>E"PTG IBM Web >cD NN}C < ;G*K=cp{Ea)D,;TNN==
d 1TG) Web > cD #$#G) Web > c P D JO;G IBM z 7 J OD;?V,
9CG) Web >cx4 DgU+ IzTPP##
IBM IT4|O*J1DNN= =9CrV"
pN#
> LrD ;mI=g{*KbP X L r DE "To=g B ?D:(i)J m Z@"4(
DLrMd{ Lr(|(> Lr).dx PE";;,T0 (ii )J mTQ-;; DE
"xP `%9
IBM Canada Limited
Office of the Lab Director
8200 Warden Avenue
Markham, Ontario
L6G 1C7
CANADA
;*qXJ1D u~M un,|(3)i NBD ;(}?D6Q, <IqCb=f D
E"#
> JOPhvDmILr0dyPI C DmIJOyI IBM @] IBM M'- i "IBM
zJm ~mI -irNN,H -iP
K& |,DN N T\}]< G Z \ X73Pb CD#rK,Zd{Yw73P q CD
}]I\aPwTD;,# P)b? I\ GZ*"6D53OxP D,rK;#$k
;cIC53OxPDb? a { ` ,#K b , P )b?
{I\aPnl#>D5D C '&1i$dX( 73DJC } ]#
C ,k k BPX7 * 5 :
Dun a)#
z ya)DNNE"x^kTzP#NN
G (} F cx@FD, 5 Ja
f 0G IBM z7DE"ISb ) z 7D)& L "dvf5wr d {I+ * qCDJO
P q!#IBM ;PTb)z7xPbT,2^(7O dT\D
{XZG IBM z7Dyw# P XG IBM z7T\DJb& 1rb ) z7D )&La
v#
yPX Z IBM 44=rrb rDyw<I f1|Dr UX,x;mP(* , |Gvv
m>K? jMb8x Q#
>E"|,ZU#5
> }, > }PI\a| (vK"+> "7FMz 7 D{F # yPb ) {V< G i9
D,tV5znP 5J5qs 5 9C D{VM X7kK`F, ?tIO#
f(mI:
> E"|(4oT N =Dy > &C Lr,b )y > 5w;,Y w=(OD ` L=( #
g {G*4UZ`4y > LrDYw=(O D &C L r ` LSZ(API ) x P&C L r
D*""9C "-zr V"*? D,zITNNN=Tb )y>L rx P
D "V",x^kr IBM 6 Q#b)>}"4ZyPu~Bw+f b T # rK,IBM
;\##r5>b)L r DI?T" I,$T r& \#
2 b)5}L r D? ] =4rdNN? V rNN\zz7,<Xk | ( g Bf (y
w:
q YwP9CD } ]M(fD > }# * K!I\j{X5w b )
+7T"f]Tr NNd
4F"^
44 IBM solidDB: kE8O
©(s+ >D{F )(j )#K?V zkGy] 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{ z RrXx D Lj r "
a Lj#g{b)LjMd{ IBM "aLjZ > J OPZ;NvV1jPL j {E(
r™), G4b){Em>| G G"<>JO 1 i IBM yPD-}@ z ~."a D L
jrU((L j#b)L j2I\GZd{zRrXx D"aL jrU((L j#Z
Web ODf(M L jE"( www.ibm.com/legal/copytrade.shtml )&a)K IBM LjD
n BPm#
®
Java MyPy
Z Java DLjMU j G Sun Microsystems, Inc. Z@zM/rd{ z Rr
Xx DLj#
Linux G Linus Torvalds Z@zM /rd{zR rXx D"aLj#
Microsoft M Windows G Microsoft Corporation Z@zM /rd{zR rXx D"aL
j#
UNIX G The Open Group Z@zMd{ z RrXx D "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