How it Works
IBM
Loading...
S
Loading...
Loading...
solidDB
User Manual
174 pgs2.04 Mb0
User Manual
2 pgs406.06 Kb0
User Manual
84 pgs1.22 Mb0
User Manual V6.3
276 pgs2.33 Mb0
User Manual V6.3
52 pgs926.07 Kb0
Table of contents
Loading...

IBM solidDB User Manual V6.3

IBM solidDB IBM solidDB Universal Cache
V6.3
򔻐򗗠򙳰
\m18O
S151-1144-00
IBM solidDB IBM solidDB Universal Cache
V6.3
򔻐򗗠򙳰
\m18O
S151-1144-00
yw
Z9C>JO0d'VDz7.0,kDAZ 257 3D:yw;PDE"#
© Solid Information Technology Ltd. 1993, 2008
?<
< .................vii
m .................ix
XZ>Va .............xi
!"<( ...............xi
o(m>(<( .............xii
1 (} solidDB 4\m}] ......1
solidDB }]\mi~ ...........1
`LSZ(ODBC M JDBC) ........1
xg(Ec ..............2
SQL bvwME/w...........2
solidDB ...............2
53$_M5CLr ...........3
solidDB e5a9 .............4
yZELDmD}]f"w.........4
yZZfDmD}]f"w.........5
solidDB SQL E/w ...........5
solidDB xg~q ............7
`_L&m ..............7
2 \m solidDB............9
30E"................9
9C solidDB Embedded Engine V2.20 r|Mf>
D}]b...............9
XbD}]b\mG+ ..........9
T/\mMV/\m ..........10
t/ solidDB ..............10
4(B}]b ..............11
G< .................12
XZ solidDB }]b ...........12
solidDB dCD~(solid.ini) .......12
hC}]bDis!M;C ........12
(e}]bTs ............13
,S= solidDB .............13
i4 solidDB {"U>
{9dv{"U> ...........14
9CzYD~ .............15
tC{"k .............15
zY'\DG<"T ..........15
`S solidDB ..............15
li}]b{e4, ..........15
q!10Q,SDC' ..........16
^}Q,SD solidDB C' ........16
i/n|;N8]D4, .........16
j8 DBMS `SMJOoO........17
zI4,(f .............25
XU solidDB ..............26
4P8]
MV4 .............27
4P>X8] .............27
..........14
(}xg4P8] ...........28
dCT0T/4P8] ..........29
8]Zd"zDiv ..........30
\mxg8]~qw ..........31
`SMXF8] ............32
|}'\D8] ............33
4P8]1DdMJb ..........33
V48] ..............33
BqU>G< .............34
4(lic ..............35
XU}]b ..............36
Z
;(FczOKP`v~qw ........36
dk(1|n ..............36
9u}]bD~ .............37
24G}]bXi? ..........37
}]bXi&\gN$w? ........37
}]bXi|nP!n ..........37
T}]bxPS\ ............38
tCS\ ..............38
#$S\\? .............38
4(-}S\D}]b ..........38
t/-}S\D}
|DS\\?D\k ..........39
T}]bxPb\ ...........39
S\i/ ..............39
8] ................39
HSB................39
SYw ...............40
T\0l ..............40
]b ..........38
3 dC solidDB ...........41
dCD~MN}hC ...........41
nX*DM'zKN} ...........42
(exg{(Com Z) .........42
nX*D~qwKN} ...........43
(exg{(Com Z) .........43
\m}]bD~M_Y:f(IndexFile Z) ...43
8(>X8]?<(General Z) ......45
8(xg8]?<(General Z) ......46
8(CZb?Er
hCCZ4P&mD_L}(Srv Z).....47
hC SQL zY6p(SQL Z) ......47
8(xg(EzY(Com Z) .......48
\m~qwKN} ............48
9C ADMIN COMMAND 4i4MhCN} ..48
Z solid.ini Pi4MhCN} .......51
#?N}5 .............51
wc(D?<(Sorter Z) ..47
4 9C solidDB }]\m$_ .....53
SD~Pdk\k ............53
solidDB 6LXF(solcon) .........54
iii
t/“solidDB 6LXF”.........54
Z“solidDB 6LXF”Pdk|n ......55
solidDB SQL `-w(solsql) ........55
t/ solidDB SQL `-w ........55
9C solidDB SQL `-w44P SQL od ..57
solidDB lY0kw ............58
XFD~ ..............58
<kD~ ..............59
{"U>D~ .............59
dCD~ ..............60
t/ solidDB lY0kw .........60
0kL(q=DG< ..........69
0kd$G
9C Solload 4KPy>0k .......70
PXa_0kYHDa> .........71
solidDB <v ..............71
t/“solidDB <v”...........72
solidDB }]Vd ............73
t/“solidDB }]Vd”.........73
$_y>:XB0k}]b .........75
XB0k}]b ............75
< .............69
5 T\w{ .............77
U>G<kBqMCT ...........78
30 ................78
=bT\k2+T ...........79
mIBqMCTgNa_T\ .......79
j<;BT .............79
BqMCTDV^T ..........80
!qBqtk6p ............80
hCtk6p .............81
XFZfDC? .............81
XFxLs! .............81
w{Yw53 .............83
}]b_Y:f ............84
Er
................85
9CZf}]b ............86
w{xg{" ..............86
w{ I/O...............86
V< I/O..............86
hC MergeInterval N} .........87
w{lic ..............88
(}d5Bqu! Bonsai wDs! ......89
@9 Bonsai w}Hvs .........89
TT\;QJbxPoO ..........91
6 \mxg,S ...........93
M'zk~qw.dD(E .........93
\mxg{ ..............93
i4~qwy'VD-i .........94
i4~qwDxg{ ..........94
mSM^D~qwDxg{ ........95
S~qwP}%xg{ ..........95
xg{Dv'5 ............96
M'zD,SV{. ...........96
+_-}]4{F3d=,SV{. .....96
1!,S
(E-i ...............98
2mZf ..............98
TCP/IP ...............98
UNIX \@ .............99
|{\@ ..............100
NetBIOS ..............101
-i** ..............102
_-}]4{F.............102
V{. ............97
7 oOkE}JO ..........105
zYM'zk~qw.dD(E .......105
xgzY$_ ............105
Ping $_ ..............107
Jb(f ...............108
Jb`p ...............109
solidDB ODBC API Jb ........110
solidDB ODBC }/LrJb .......110
solidDB JDBC }/LrJb .......110
CZ solidDB D UNIFACE }/LrDJb . . 111
M'zk~qw.dD(E ........111
}]bELij{T ..........111
=< A. ~qwKdCN} ......113
(} solid.ini dCD~hCN} .......113
solid.ini D~Dq=/fr ........113
(} ADMIN COMMAND 4|DN} .....117
dCN}Dhv.............118
Accelerator Z .............118
Cluster Z...............118
Communication Z ............119
[General]Z .............122
HotStandby Z .............130
IndexFile Z ..............135
Logging Z ..............138
LogReader Z .............141
MME Z ...............142
Sorter Z ...............146
SQL Z ...............147
Srv Z ................150
Synchronizer Z .............159
=< B. M'zKdCN} ......161
(} solid.ini dCD~hCM'zKN} ....161
M'zK solid.ini D~Dq=/fr .....161
M'zKdCN}Dhv..........162
Communication Z ............162
Data Sources ..............163
Client ................163
=< C. solidDB |nP!n .....165
=< D. msk ...........169
ms`p ...............169
solidDB ,=ms ............170
solidDB SQL ms ............185
iv IBM solidDB: \m18O
solidDB SQL API ms ..........192
solidDB }]bms ...........194
solidDB I4PD~ms ..........202
solidDB 53ms ............203
solidDB mms .............206
solidDB ~qwms ...........220
solidDB (Ems ............223
solidDB (E/f ............226
solidDB }Lms ............227
solidDB Erwms ...........230
solidDB lY0kw5CLr(solload)ms ...230
=< E. solidDB ADMIN COMMAND
o( ...............233
ADMIN COMMAND ...........233
'V73 ..............233
C( ...............233
w} ...............247
yw ...............257
?< v
vi IBM solidDB: \m18O
<
1. solidDB i~ ............3
vii
viii IBM solidDB: \m18O
m
1. !"<(..............xi
2. o(m>(<( ...........xii
3. t/~qw .............10
4. ,S= solidDB ...........14
5. Perfmon F}w ...........18
6. backup |nD!n ..........27
7. netbackup |nD!n .........28
8. kCZ4P>X8]D solid.ini D~`T&DN
} ................29
9. kCZ4Pxg8]D solid.ini D~`T&DN
} ................29
10. ICD8]Mxg8]|n .......32
11. ;
12. ,SV{.!n ...........43
13. solcon |n!n ...........54
14. “6LXF”yXPD|n ........55
15. solsql |n!n ...........56
16. solload |n!n ...........60
17. lY0kw#tV ..........61
18. XFD~Dj{o( ..........62
19. }]Zk .............64
20. solexp |n!n ...........72
21. soldd |n!n ...........73
22. 7(|n4, ............89
23. 7(D),SxPQd5DBq ......90
24. TT\;QJbxPoO ........91
25. ,SV{.q= ...........96
26. solid.ini D~P9CDq=........98
27. solid.ini D~P9CDq=........98
28. solid.ini D~P9CDq= .......100
29. solid.ini D~P9CDq= .......100
30. solid.ini D~P9CDq= .......101
31. solidDB -iMxg{ .........102
32. &CLr-i
,(1|nDTd?M1!5 ......37
Mxg{ ........102
33. Ping $_6p ...........107
34. Accelerator N} ...........118
35. Cluster N} ............118
36. Communication N} .........119
37. General N} ............122
38. HotStandby N}...........130
39. IndexFile N} ...........135
40. Logging N} ............138
41. LogReader N} ...........141
42. MME N} ............143
43. Sorter N} ............146
44. SQL N} .............147
45. Srv N} .............150
46. Synchronizer N} ..........159
47. Communication N} .........162
48. Data Source N} ..........163
49. Client N} ............163
50. solidDB |nP!n .........165
51. solidDB ms`p ..........169
52. solidDB ,=ms ..........170
53. solidDB SQL ms ..........185
54. solidDB SQL API ms
55. solidDB }]bms .........194
56. solidDB I4PD~ms ........202
57. solidDB 53ms ..........203
58. solidDB mms ...........206
59. solidDB ~qwms .........220
60. solidDB (Ems ..........223
61. solidDB (E/f ..........226
62. solidDB }Lms ..........227
63. solidDB Erwms .........230
64. solidDB lY0kw5CLr(solload)ms 230
65. ADMIN COMMAND o( .......234
........192
ix
x IBM solidDB: \m18O
XZ>Va
IBM®solidDB®G(CD}]b\m53,|HJCZ!MD6k=53,2JCZs f#53#zIT9CwV&\T IBM solidDB i~4~qZXbhs#K`i~|
(:
v Zf}]b
v _HICDH8CdC
v _6l=4F
v CZ+&CLr1Sk~qwzk4
SDb
OvyPi~<G};D,4,|GITZd{i~fZDivB9C#solidDB D\
m1IT9CwVdC!nM$_TnOJD==hCz7#
!"<(
>8OhvgNhC"`S"\mME/>z7Dy>}]b~qw&\#`XV
a)KPXdCX( solidDB i~D|`j8E"#
>8OY(A_FU;cD DBMS *6"l$ SQL#
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#
KVeCZLrzkMLrdv#>} SQL od29CKV
e#
a
TRIG_COUNT() KVeCZ/
java.sql.Connection KVeCZSZ{F#
LockHashSize KVeCZN}{"/}Td?M Windows
argument K`?wJ8>C'r&CLrXka)DE"#
\m8O
bVy=CZ}Cd{D5r_,;D5PDBZ#BuoM
?wDJb24Ky=i4#
}{#
®
"amu?#
xi
m1.!"<((x
q=JCZ
D~76m> D~764 UNIX
)
<#
®
q=a)#1\(/)V{m>20y?
o(m>(<(
Yw53 g{D5|,PXYw53.dDnpDZ],G4WHa=
DG UNIX q=#Microsoft
.s"(Z(EP#d{Yw53+%@Pv#TZ;,DY w539I\P;,DBZxPhv#
®
Windows q=;Z UNIX q=
solidDB D59CBPo(m>(<(:
m2.o(m>(<(
q=JCZ
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
o(hvICKVe#If;?VIC
Zo(P#
>,G4Xk+s(E|(Zo(P#
D
K
Ve#
... !TE8>IT`NX49CTd?#
. . .
xii IBM solidDB: \m18O
I}vciID;Pm>bGH0zkPDSx#
1 (} solidDB 4\m}]
IBM®solidDB DKDGX5}]b~qw#K}]b~qwS\T SQL oT`4D i/#(#,b) SQL i/I“M'z”&CLra;,s_+ SQL od"M=~q
w"SU~qw5XDa{#
"R,solidDB 9a)K,=&\,b)&\Jm+;v solidDB P-
M=;vr`vd{ IBM solidDB#solidDB 9J mICH8CdCKP;T IBM solidDB,"Jm+M'z&CLr1S4S=}]b~qw}LTca_ T\T0| t\XXF~qw#>BDfs?VTb)Vp;F*“H8C”M“4SbC
wKhv#
>BhvKWci~MxL,|G9 solidDB I*1q4SV<=5373PmkDV <=}]\mbv=8#>B9a)KZxg73P\mM,$ solidDB 1XhD30
E"#
solidDB }]\mi~
solidDB |,BPwZyhvDi~#
`LSZ(ODBC M JDBC)
*r}]b~qwa;i/(4 SQL od),M'zXk\;kK}]b~qwxP
(E#km`d{}]b~qw`,,solidDB 29C“}/Lr”4'VK(E#M'z &CLrwC}/LrPD/},;sI}/Lr&mk~qwxP(E
Bq#}g,zIT`4+wC ODBC }/LrPD/}D C oTLr,2IT`4 +wC JDBC }/LrPD/}D Java
™
}|BD}]"
J”D&\
Md{_e
Lr#
ODBC
solidDB a)Kk solidDB xP(ED ODBC M JDBC }/Lr#solidDB ODBC } /Lr{O Microsoft ODBC 3.51 API j<#solidDB ODBC }/Lr'VD/}I
(} solidDB ODBC API xPCJ,C API G solidDB }]bDwC6SZ(CLI)
"k ANSI X3H2 SQL CLI ;B#
JDBC
solidDB JDBC }/LrJm Java &CLr9C JDBC 4CJ}]b#solidDB JDBC }/Lr5VK JDBC 2.0 f6PDs?VZ]#
(PSZ
solidDB 9a)K(PSZ#}g,b)SZJm C Lr1SwC}]b~qwPD/ }#b)(PSZI solidDB 4SbCJ&\(fshv)=xa)#
PX ODBC"JDBC T0 solidDB D(P`LSZD|`j8E",kND IBM solidDB Programmer Guide#
1
xg(Ec
solidDB \;ZyPww`MDxgPKP"'VyPww(E-i(}g TCP/IP)#
*"_IT4(CZ;,V`Fc73DV<=&CLr#PXxg(ED|`j8 E",kNDZ 93 3D6 B, :\mxg,S;#
SQL bvwME/w
solidDB 9CyZ SQL j< ANSI X3H2 M IEC/ISO 9075 D SQL o(#|+f'
V SQL-89 ~6j<T0 SQL-92 kE6j<#Kb,9'Vj{ SQL-92 M SQL-99 j<Dm`XT#solidDB a)K;vyZ*zD_6E/w,s_7#|*4SDi
/2\;_'XKP#KE/wT/,$PX
53FV<ivDE"#
PX solidDB SQL E/wD|`j8E",kNDZ 105 3D7 B, :oOkE}J O;;Z#
E/wa>
E/wa>(bGT SQL D)9)G(}i/odP6kD1"M8(D18n#E /w+lbb)18nra>,"`&X9|Di/4P=8TK*y!#E/wa
>Jmy]}]"i/`MM}]bDwVivT&CLrxPE K<;"zDi/T\JbDbv=8,9+l&1dXF(S53F;xC'#
ms!"mPP}"ICw}T0w}
/#|G;va)

solidDB

PXE/wa>D|`j8E",kND6IBM solidDB SQL 8O7#
solidDB +&m(} solidDB SQL a;D}]ks#Z 3 3D< 1 y>D solidDB ~
qw+}]f"Z}]bP"SC}]bPlw}]#
2 IBM solidDB: \m18O
1. SA API G solidDB T:D API,CZkSYwbdO9C#PXj8E",kND6IBM solidDB 4SbCJC'
8O7#
<
1. solidDB
i~
53$_M5CLr
solidDB 9a)KBPCZ\m}]D$_:
XF($_
solidDB a)K=vyZ ASCII DXF( $_4\m}]b,4“solidDB 6LXF ”(solcon)M“solidDB SQL `-w”(solsql)#b)$_9C|nPgf#PXj8E ",kNDZ 53 3D4 B, :9C solidDB }]\m$_;#
1 (} solidDB 4\m}] 3
CZ&mb? ASCII }]D$_
solidDB a)KBPCZ&m ASCII }]D$_:
v
v
v
PXj8E",kNDZ 53 3D4 B, :9C solidDB }]\m$_;#
solidDB e5a9
>Za)EnTE",b)E"PzZzKbgNdC solidDB Tzc&CLrM=( Dhs#>Z`XZ{vBPwn:
v
solidDB lY0kw(solload)+b? ASCII D~PD}]0k= solidDB }]b#
K$_\;ekV{q=DV{}]#solidDB lY0kw+F} SQL bvw"( }4P0kYw41S4}]bD~,Sxa_0kYH
“solidDB <v”(solexp)+ solidDB }]bPDZ]4kV{q=DD~#K$_ \;4 solidDB lY0kwy9CDXFD~,Tc4P}]0kYw#
“solidDB }]Vd”(soldd)CZ4}]bD}]Vd#K$_+zI;v SQL E
>,s_|,CZhv}]
ba9D}](eod#
#
}]f"w
–
wf"w
–
Bonsai w`f>XFM"PXF
v
/, SQL E/
v
xg~q
v
`_L&m
yZELDmD}]f"w
CZf"yZELDm(D m)Dw}]a9G;V B wde#~qw9Cb)a9 PD=V;“wf"w”fE@C}],F*“Bonsai w”Dnpw}wY1f"“B”}], 1=C}]ITFAwf"w*9#
:pf" D mD~qwZ??~F*“y
4 IBM solidDB: \m18O
ZELD}f”(DBE)#
wf"w
wf"w|,~qwPDyP}],dP|(mMw}#ZZ?,~qw+yP}] <f"Z“w}”P - ;P%@Dm#?vw}<|,j{Dw|(4,;PPDyP }])r(z|(SQL +KF*“w}”- vvG|,Z SQL w}PD FsTs(BLOB)Md{$P5Tb,}]P;P%@Df"=(#
yPw}<f"Z%;DwP,CwF*wf"w#ZCwP,w}(}53(eD w}j6`%Vt,Kj6+ek=?v|50f#bVzF+w}wV w}Sw,dP,;vw}D|5`%/:=;p# PX}]/:Mw|w}Dj8E ",kND6IBM solidDB SQL 8O7PPXw|w}DV[#
P5)#}~x
*`v_-
solidDB Bonsai w`f>XFM"PXF
Bonsai wG!MDn/“w}”(}]f"w),|ZPkZfP_'Xf"B}](>
}"ekM|B),,1,$`f>E"#Z Bonsai wP,,;PD`vf>(If >MBf>)IT2f#I}]MB}]<CZ"PXFT07#yPBqDA6
;B,x;alINNx(*z#hz Bonsai w,ITTxuYxP"PXFyhD K$#
Bqt/1,|;3h,xDBqt/E(TSN)#TSN CwBqD“A6p”;yPZK .sSd{,Sek=}]bD|5TZ10BqP4P a);BDw}A6p,MqAYwZCBqt/1T-S==4P;y#by,M
IT7#AYwfr;BD}]S<xP,x;h*4P*zO_Dx(Yw#
DQwxT<;IS#b+
p
If>DP(T0G)PDBf>)+f"Z f>DBq,M;1#VbV4,#ZyP}CIf>DBqjIs,+S Bonsai w
POz“I”f>D}],"RBd5D}]+S Bonsai wFAwf"w#$HErD| 5+(}k#f}]bYw"PDs b#ZO"Zd,+Tom==}%Q>}D|5#
w}9u
Z Bonsai wMf"wP,9C=V=(4f"|5#WH,v#f<B;v|5kH 0|5PyxpDE"#4,T|5xP“0: 9u”#dN,Zw}wDO_c,S
)2*<XO|5_g;4,T|GxPs:9u#
yZZfDmD}]f"w
solidDB Jm4($tZZfPDm,4 M m# M mDEcZZT\#M mZMC TMIV4T=fDtTkyZELD+3m(D m)`,# (;DxpZZ,wf
"wD;C;,#M mw*f"ZwZfP,bm>Zf}]b=s,| CDUd=s#}5J}]Tb,M mDw}2ZwZfP9(#solidDB 9CF*“T =”DwZfE/w}<u45Vw}# *@@f" M m0dw}yhDZf?,k ND6IBM solidDB Zf}]bC'8O7#
:pf" M mD~qwZ
Bonsai wP,;*fZh*i4G)I
(YwxPO"#b+TxE/ I/O "5V:Xy
ZwZfP<
??~F*wZf}f(MME)#
solidDB SQL E/w
solidDB SQL E/wGyZ*zDE/w,CZ7# SQL od_'X4P#KE/w kyZfrDE/w9C`,D<u,4,@?;i$H`EDfr47((ya{
DnL76#}g,SQL E/w+<Gw}GqfZ"w}Gq(;T0w}GyZ
%
1 (} solidDB 4\m}] 5
;mP9G;imP#+G,kyZfrDE/w;,,KE/wPyZ*zD&\ \;y]}]bD5JZ](}g,P}T0wvPD5V<iv)xPwZ#
solidDB T/,$PX5J}]D3FE",Sx7#T\nQ#49}]D ]Pyd/,KE/w2T\;7((y}]DnP'76#
}?MZ
i/&m
i/&mV*`v!MD=h4P,T7#;nD1DYw;ah{m;&CLrD ks#i/(};v|,BPWNDrPxP&m#
o(Vv
+T SQL i/xPVv,"R~qw+zIo(ro(msDbvw#bvod1, +Q4PCodyXhDE"0k=od_Y:f#;*od_Y:f|,;vod D4PE",CodMIT444P,x;XxPXBE/#
4(4P<
+y]i/bvw4(_PBPXTD4P<#
v 4Sod;`4I3;"R|r%Dq=#
v g{\;a_T\,G4+Q OR u~*;* UNION Sd#(PX OR k UNION
D | ` j8E " , k N D 6 IBM solidDB SQL 8 O 7 P P X CONVERTORSTOUNIONS DV[#)
v 4PG\,S<
PX4P=8P?vYwr%*Dj8E",kND6IBM solidDB SQL 8O7PPX EXPLAIN PLAN FOR odDV[#
x+],TczI\;uL,S}L4P1dDPd,Sa{#
&m4P<
T4P<xPD&mV*}v,xDWN4P:
v
`M@@WN
y]WcDmMS<(e4FOa{/DP}]`M#
v
@c@@WN
@@lw08PT0lw{va{/D*z,"y]kCods(DN}54/,
X!qJ1DQw_
SQL E/w9*z@cyZT/,$DPX|5V<iv"ms!Md{/,3F} ]DE"#z;h*TV/==|Bw}1=<rNNd{@cE"#
v
PlwWN
lwi/Da{P"+d5X=M'z&CLr#
T#
6 IBM solidDB: \m18O
solidDB xg~q
solidDB xg~qyZ6L}LwC(RPC)6},s_9(ESZr%WC# 1M' zr~qw"Mks1,|MqGwC>X/};yYw#xg~qT;IS==+
Cks0dN}+]=~qw,ZC~qwO,RPC ~qw+wC5JD~q ~q/}jIs,5XN}+;"MX=wC&CLr#
ZV<=53P,I\aP`v&CLr,1ks~qw4P`nYw#*KnsL HXa_"PT,solidDB xg~q+9CICDYw53_L4a)^lD`C''
V#Z%_L
Yw53O,xg~q(}c:9Cl=Yw4nsLHXa_T\#
(Ea0c
solidDB (E-i DLL(r2,b)a)K?V-iDj<Z?SZ#(Ea0cDn Mc?~w*|0w$w,|:p!qkx(X7E"`XD}7-i DLL rb#Z K.s,a0D5J-iE"&Z~X4,#
solidDB IT,1l}`V-i#
`_L&m
solidDB D`_Le5a9'VZ&CLrP_'X2m&mw# _LGIVIDzk i,|vv5PQ;"Dfw(Z_L4PZd)0dEH6#|kxLPDyPd
{n/_L2myPd{Z]#k4(xL`H,4(_LD53*z*MC LIzk"}]T0r*DD~Mr*DSP.`Dd{J4iI)#
/}#C
`(x
_Lw*wCLrDiI?V0k=ZfP;rK,wC_L1;XCJEL#_L
IT9C+Vd?"B~MEExP(E#
g{Yw53'V;,&
mw#
mw.dDTF`_L<u,G4 solidDB +T/{C`v&
_L`M
solidDB _L<u53I(C_LM(C_LiI#
(C_L
(C_L4P~qwDNq53PDNq#|G4PDNq|(*C'ksa)~
q"4(8]"4P(1|n"O"w}T04(lic(+;BD}]f"=E
L)#
(C_LSNq53Pq!Nq,4PNq=h1AjI,;sP;=N
m;vNq#Nq53T-7==$w,SxZ;,_L.dyHXV"M'zY w#
zITZ solid.ini dCD~PhC(C_LD}?#
(C_L
q53PD
(C_L)X(Yw(C#Z~qwP,I\fZBP(C_L:
v
I/O \mw_L
1 (} solidDB 4\m}] 7
K_LCZxPG\EL I/O E/T0:Xyb#yP I/O ks<(} I/O \mw, s_7(G+?v I/O ks+]=_Y:f9GZd{ I/O ks.dTdxP2E#
I/O ks4|GD_-D~X7Er#xPErPzZE/D~ I/O,bGr*,Z
ELOC
v
(EA_L
&CLr<U,S=KPZ!qw_LPDl}wa0#(",Ss,IT*?v M'z4((CDA_L#
v
?V-i;v(E!q_L(F*!qw_L)
JDD~X7`k`|,b+uLELA!7DF/`k#
(#,?
k+2{"SP#
v
(E~qw_L(2F* RPC ~qww_L)
K_LS+2{"SPPA!ks"(}wCyksD~q/}*&CLra)~ q#
V-iP;v(E!qw_L#?vKPPD!qw_L<++kks4
8 IBM solidDB: \m18O
2 \m solidDB
>BhvgN,$y20D solidDB#>B{vD\mNq|(:
v 4Py>D solidDB Yw,}gt/M#9~qw
v 8]~qw
v T}]bxPS\
*c: Z_P4SbCJ&\D solidDB P,d\mkj< solidDB P;)xp#X *1,>B+}C6IBM solidDB
DE"#
30E"
9C solidDB Embedded Engine V2.20 r|Mf>D}]b
S solidDB Embedded Engine V2.3 *<1=10f>,1!{mrPhC*j< Latin-1#9C V2.20 r|Mf>4(D solidDB Embedded Engine }]bk Latin-1 {
mrP;%d#*+ V2.20 }]bPD}]*;= Latin-1,XkS}]bDmP<v }]b,i!}](e,;s+G)m0k=B}]bP#P 75 3D:$_y>:XB0k}]b;#
4SbCJC'8O7Ta)X(Z4SbCJ&\
Xj8E",kNDZ
XbD}]b\mG+
solidDB |,BPCZxP\mM,$$wDG+:
v SYS_ADMIN_ROLE
bG}]b\m1G+,KG+TyPm" w}MC'5PX(, "RP(9C “solidDB 6LXF”(solcon)#b2G}]b4(_DG+#
v SYS_CONSOLE_ROLE
KG+P(9C“solidDB 6LXF”,+;_Pd{\mX
v SYS_SYNC_ADMIN_ROLE
bGCZ4Pk,=&\`XD\mYw(}g>}{")D\mG+#(“{"” CZZw}]bkd1>.d4X+]E"#}g,}G9C,="B==,qr
*"Bw}]b"<PD}],1>}]bh"M REFRESH {"#)NN
J ( D K 1 < + T / ; Z h y P Z ( G + # K G + T / | (
SYS_SYNC_REGISTER_ROLE#
v SYS_SYNC_REGISTER_ROLE
KG+vCZrw}]b"ar"z1>}]b#
zIT9C GRANT ROLE od4(e b)G+#PXj8E ",kND6IBM solidDB SQL 8O7PD:\mC'X(MG+;#
(#
_PKC
9
T/\mMV/\m
solidDB hFIT^KU4==VxYw,"R?prc#|;*sz4PnY?D,
$$w#\mYw(dP|(8])IT(} SQL )9T`L==4P,b))9I TT/KP,2ITZ\m1DksBKP#
t/ solidDB
+G,P1h*TV/==
\m53#>B95wKICZ4PV/\m$wD$_
M=(#*4P\mNq,zITZ solidDB SQL `-w(solsql)P"v solidDB SQL
T:D ADMIN COMMAND#*q!j{ D|nPm,kNDZ 233 3D=< E, :solidDB ADMIN COMMAND o(;r_6solidDB SQL 8O7PD:=< B;#
g{z}Z9C
_P4SbCJ&\D solidDB,G4“XF”API +9C'&CLr\
;(}LrXFNqD4P#zIT9C;v“XF”API /}T}]b8]"}]bl
icM Bonsai wO".`DNq8(EH6#y8(DEH67(Nq4PsDKP
PXj8E",kND6solidDB 4SbCJC'8O7#
3r#
“solidDB 6LXF”(solcon)JmzZ;9C ADMIN COMMAND o(DivBdk \m|n#PXj8E",kNDZ 54 3D:solidDB 6LXF(solcon);#
":
>ZDZ]vJCZj< solidDB#g{z}Z9C_P4SbCJ&\D solidDB,G
4kND6solidDB 4SbCJC'8O7PD`&BZ#
1 solidDB t/1,|+li}]bGqQfZ#~qw+HiR solid.ini dCD~" A! FileSpec N}D5# ;s,~
qw+liGqfZ_P FileSpec N}y8({F
M76D}]bD~#g{R=}]bD~,G4 solidDB +T/r*C}]b#g{ R;=}]b,G4~qw+4(B}]b#
m3.t/~qw
Yw53 *t/~qw...
UNIX/Linux Z|na>{&dk|n solid#Z;Nt/~qw1,kZ|na
>{&dk solid -f |nT?F~qwZ0(KP#
Microsoft Windows %w“*<”K%PjP“solidDB ~qw”Dl]==#Kb,2IT
(}|na>{S~qwD
PD bin\ ?<)Pdk solid |n#*t/~qwT9dZs(K
P,kdk start solid |n#
*E= VMS Z|na>{&dk run solid |n#
$w?<(1!ivB,bG20?<
PX FileSpec N}Dj8E",kNDZ 44 3D:FileSpec_[1...N] N};#
10 IBM solidDB: \m18O
4(B}]b
g{}]b;fZ,G4 solidDB t/1+T/4(B}]b#Z Microsoft Win- dows 73P,4(}]b1,+WHT>;vT0rTa>dk}]b\m1DC'{
M\kT01!}]b?<D{F#PXj8E",kND6solidDB SQL 8O7PD :\m}]bTs
Zd{73P,g{;fZVP}]b,G4+T>TB{":
}]b;fZ#*4(B}]bp(y/n)?
g{Xp“Yes”,G4 solidDB +a>zdk}]b\m1DC'{M\kT01!} ]b?<D{F#
C'{XkAY|, 2 vV{#nsV{}G 80#C'{XkTV8rB._*7#
;#
\kXkAY|, 3 vV{#nsV{}G 80#\kIT9 V*7#IT9C!4V8 a = z"s4V8 A = Z"B._V{“_”T0}V 0 =
9#
;\Z\kP9C+}E(″)V{#?R(iz;*9C2E(’)"VE(;)rU
q(“”),bGr*3)$_Z\
!4V{+;*;*s4#
?<{XkAY|, 1 vV{#nsV{}G 39#
mkNDZ 53 3D:SD~Pdk\k;#
":
g{zF.9C solcon,G4k;*4(|,G ASCII V{D\k,bGr* solcon ;aTNNdk4
"b:
?<{;\|,Uq#
": zXkG!C'{M\k,Tc\;,S= solidDB#;P1!C'{;z4(}
]b1dkD\m1C'{G(;ICZ,S=B}]bDC'{#
P UTF-8 *;#
kP;S\b)V{#
CNNV8"B._r}
S\}]b\m1DC'{M\k.s,solidDB +4
1!ivB,}]b+;4(I solidDB $w?<PD;vD~(solid.db)#;|,5 3mMS<DU}]bs<<C 4 WVZDELUd# 4(}]byhD1d!vZ
zy9CD2~=(#g{zP;vG#!D}]b(! 9CDELUd?!Z 4 WVZ,G4k+ solid.ini dCD~P ExtendIncrement N }D5hC*!Z 500(1!5)#Z 113 3D=< A, :~qwKdCN};TKN} Md{N}wKV[#
4(}]bjIs,solidDB +*<Zxg dows 73P,+T> solidDB <j,+Zs`}73P,solidDB w*X$xLT;
IS==Zs(KP#
Pl}M'z,Sks#Z Microsoft Win-
(B}]b#
Z 4 WVZ),"R#{7#
2 \m solidDB 11
G<
solidDB }]b*sC'9C{GDC'{M\k4G<=}]b#
g{z"T9C;}7DC'{M/r\kG< 4 N,G453+h{zD IP X7" R1dn$Io 60 k#K&\^(xPdCrXU#
XZ solidDB }]b
>Zhv solidDB }]ba9T0z4( solidDB }]b18(;,5D==#
solidDB dCD~(solid.ini)
t/ solidDB 1,|+S solid.ini dCD~PA!dCN}#
solid.ini D~8(ITozz(FME/ solidDB }]b~qwDN}#}g,solid.ini D~PD FileSpec N}8(~qwCZf"C'}]D}]D~D?<MD~{#m;
vN}8(}]bDis!#is!+ Z+T FileSpec M BlockSize N}xPhv#
zITZZ 113 3D=< A, :~qwKdCN};PR=yPN}Dj{hv"PX solid.ini D~D}7q=Dj8E"T0PX8( solid.ini dCN}D8>E"#PX
N}D|`j8E",kNDZ 41 3D3 B, :dC solidDB;#
hC
0lT\,"R9+^FnsG<s!#B;
hC}]bDis!M;C
1!ivB,solidDB }]b+}]bD~Dis!hC* 8192 VZ(8KB)#solidDB 9C 2KBD6}#n!is!G 2KB,ns5G 64 KB#}]bDnss!G 64
TB#
g{*C solidDB 4(_Pm;is!D}]b,G4XkHhCBD#?5,;sY 4( B
(.log)FAm;v?<;ZG,BNt/ solidDB 1,+4(B}]b#
*^DB}]bD#?5,k*= solidDB ?<"Z solid.ini D~PmSBPwP(a )TVZFDs!
}gyPks!`XDN};y,s!%;G 1 VZ#Kb,9'V"(iz9C%;
{E K M M(Vpzm KB M MB)#
Z#fD~"t/ solidDB .s,|+4(_P solid.ini D~PDB#?5D}]b#
,y,z2IT(}^D FileSpec N}4(e
v
v
}] b # g { f Z VPD}]b,G4qX+I}]b ( .db) M U > D~
):
[Indexfile] Blocksize=size_in_bytes
}]bD~D;C(1!;CG solidDB ?<PD solid.db)
BPwn:
}]bD~ITo=Dnss!(TVZF,1!5G 2147483647,4 2G-1 VZ)# nsD~s!G (4G-1)*is!#TZ1!D 8KB is!,b+G 32TB - 1#
12 IBM solidDB: \m18O
z9IT9C FileSpec N}+}]bD~.V*`vD~"f"Z`vELO#g{z k4(sMDom}]b,G4I\Xkbyv#
PXgNdC FileSpec N}Dj8E",kNDZ 43 3D:\m}]bD~M_Y:
f(IndexFile Z);#
(e}]bTs
solidDB }]bTs|(?<"#="m"S<"w}"f"}L"%"wMrP#1 !ivB,}]bTs{ITsyP_DC'j6T053?<{^(,s_IzZ ;N4(}]b1r_+I}]b*;*Bq=18(#z9IT8(( }]bTsxP^(#PXj8E",kND6solidDB SQL 8O7PD:\m}]b
Ts;#
5JO,solidDB y'VDm"PMw}D}?;\^F#V{.M~xF}]TId $Hq=f"#K&\ITZ!ELUd#b99C*"_D rGV{.r~xFVND$H;XL(#%;P5Dnss!G 2G-1 VZ#
(}dC MaxBlobExpressionSize N},IThCV{./}P9CD LONG VARCHAR(r CLOB)PDnss!#(Ks!ITIC'VZ(K)rWVZ(M)
*%;8(#
*Ka_'J,solidDB IT+ BLOB }]f"Zmb?#1Ts"<q"S5"<N
M}V/yt.`D BLOB(~xFsTs)sZX(s!1,solidDB +T/lb=
bViv"+G)Tsf"=;vXbD~ PE/#z;h*4P\mYw#PX|`E",kND6solidDB SQL 8O7D=<
:}]`M;PPX“BLOB M CLOB”DV[#
}#={T
`L$w|*r%,-
)1!ivB,Ks!* 1MB(1 WVZ)#
xr,CxrDis!QkTsMD~x
,S= solidDB
":
>ZDZ]vJCZj< solidDB#g{z}Z9C_P4SbCJ&\D solidDB,G
4kND6solidDB 4SbCJC'8O7PD`&BZ#
t/ solidDB .s,zIT9C solidDB g+rV$_“SQL `-w”r“6LXF”S $w>,S=~qw,SxbT
_DiI?V)Dj8E",kNDZ 53 3D4 B, :9C solidDB }]\m$_;#
*,S= solidDB,k4PBPYw:
1.
i4}]b?<PD solmsg.out D~,KbICZ,S= solidDB DP'xg{#
BP{"+
Listening of 'ShMem Solid' started. Listening of 'tcp hobbes 1313' started.
2.
t/BPdP;v&CLr,"8(~qwDxg{w*|nPN}:
8>IT9CD{F#
dC#PXb)5CLr(|GG solidDB }]\m$
2 \m solidDB 13
m4.,S=
$_ |n
solidDB
solidDB 6LXF(solcon)
solidDB SQL `-w(solsql)
;C.s,z+4=;u{"8>Q-k~qw(",S#
i4 solidDB {"U>
(}li solidDB ?<PD{"U> solmsg.out,7#}]bt/14vm#zITZ D>`-wPi4KD~#
solidDB +,$BP{"U>D~:
v
solcon "networkname"[userid [password]]
}g:
solcon "tcp hobbes 1313"
g{4Z|nPP8(}]b\m1DC'{M\k,G4 solcon +a>zdkb)Z]#
solsql "networkname"[userid [password]]
}g:
solsql "tcp hobbes 1313"
g{4Z|nPP8(}]b\m1DC'{M\k,
a>zdkb)Z]#
G4 solsql +
solmsg.out U>D~|,#fN<B~,}g,S"O*,S"lic"8]T0' \DG<HH#g{"zZ?ms,
v
g{"zB|ms"<B~qw@#,G4 solerror.out D~+|,PXCmsD|
`j8E"#>D5;GP!qXTZ?msxP{v#
{9dv{"U>
zIT{9zI{"U>D~#IZ;Pb)D~+QToOJb,rK(iz;* byv#XU{"U>G<&\+a_T\"5MELUd9C?;+G,Zs`}
ivB,T\DFyH"vd"#K!nvZ1{DivBPC,}g
”(3)9CAfD53PDiv),r_53D}]f"Ud+*P^"R{"U> D~g;>}+;1[}#
*{CU>D~,kZ solid.ini dCD~D [Srv] ZP8( DisableOutput N}"+K N}hC* Yes(1!ivB,KN}hC*“No”)#g
T(}S solid.ini D~P}%KN}r_+dhC* Yes 4JmzIU>D~#T solid.ini D~ywD|D1=zXBt/~qwsEaz'#
G4Cms+;4k solmsg.out D~#
I/O I>“_:
{Q{9zIU>D~,G4I
14 IBM solidDB: \m18O
9CzYD~
*KxPJOoO,solidDB 9ITzI|,oOE"DI!zYD~#Z~qwU# YwZd,"GXk4P`SzYD~b;Yw#zYD~w*CZTl#B~xP
JOoO#PX solidDB oOD|`j8E",kNDZ 105 3D7 B, :oOkE JO;#
tC{"k
ZZ?,?umsM4,{"<I;v 8 V{(;zkj6#g{(}Lr4&m{" D~,"R{"D~|,{"k,G4IT|=cXbv{"#*Jmdv{"k, k+ [Srv] N} PrintMsgCode hC*“Yes”#
zY'\DG<"T
G<'\1,+G<PXC"TDE"T7#2+#'\D"T+<U:
v
}p SYS_EVENT_ILL_LOGIN B~,"R
v
+{",1r!= solmsg.out M solerror.out#
}g,{"|,xPC"TD IP X7MC'{#{"Do(gBy>:
timestamp [message code] User username tried to connect from {hostname | unnamed host} with an illegal username or password. [SOLAPPINFO is solappinfo value.]
}
`S solidDB
li}]b{e4,
>}:
Thu May 12 17:55:17 2005
12.05 17:55:17 User 'FOO' tried to connect from localhost.localdomain (127.0.0.1) with an illegal username or password.
":
;PZ solid.ini PtCK{"kr!&\DivB,Ea|({"k?V#;PZM'
FczOhCK`&73d?DivB,Ea|( SOLAPPINFO ?V#
BPwZhvCZi/ solidDB }]b4,D=(#
zITZ solidDB SQL `-w(solsql)P9CTB|n4lw;c~qw4,:
ADMIN COMMAND 'status'; RC TEXT
-- ---­0 solidDB started at 2008-05-21 09:51:59 0 Current directory is C:\work\java\commdemodb\clientDB 0 Using configuration file C:\work\java\commdemodb\clientDB\solid.ini 0 Memory statistics: 0 9778 kilobytes 0 Transaction count statistics: 0 Commit Abort Rollback Total Read-only Trxbuf Active Validate
2 \m solidDB 15
0 2426 0 475 2901 1876 382 1 0 0 Cache count statistics: 0 Hit rate Find Read Write 0 100.0 167027 59 76 0 Database statistics: 0 Index writes 17377 After last merge 1218 0 Log writes 10771 After last cp 605 0 Active searches 7 Average 7 0 Database size 1232 kilobytes 0 Log size 1810 kilobytes 0 User count statistics: 0 Current Maximum Total 02312
a{/VNDhvgB:
v Zf3FE"T> solidDB SYw53PVdDZf?#K}?;|(I4PD~>
mDs!#
v BqF}3FE"T>TSt/s;,BqYwD}?#
v _Y:fF}3FE"T>TSt/sD_Y:f|PJT
0_Y:fYw}#(
#,_Y:f|PJ&C_Z 95%#g{MZ 95%,G4k<Gvs_Y:fs!#
v }]b3FE"T>TSt/sDm`nX*}]bYw#Zbo,Index writes -
After last merge G;nX*D8j#K8jR> solidDB D`f>f"w(F*
“Bonsai w
”)Ds!#K5=!,~qwT\=C#OsD5mw}fPfZ$1d
KPDn/Bq#"b,}sD Bonsai w+<BT\B5#PXu! Bonsai ws !Dj8E",kNDZ 89 3D:(}d5Bqu! Bonsai wDs!;#
v C'F}3FE"T>
""C'D10}?Mns}?#
q!10Q,SDC'
z9IT(}Z solidDB SQL `-w(solsql)PdkTB|n4q!Q,SC'DP m:
ADMIN COMMAND ’userlist’;
K|n+a)TB`MDa{/:
RC TEXT
-- ---­0 User name: User id: Type: Machine id: Login time: 0 DBA 1 SQL Local 27.05 16:13:22
^}Q,SD solidDB C'
*O*%;C'k~qwD,S,kZ solidDB SQL `-w(solsql)PdkTB|n:
ADMIN COMMAND 'throwout user_id';
"b,K|n^}C',S;b";aPOH8Cw~qwkH8C(z~qw.d
D,S#
i/n|;N8]D4,
*q!n|KPD>X8]D4,,kZ solsql PdkTB|n:
ADMIN COMMAND ’status backup’;
*q!n|KPDxg8]D4,,kdkTB|n:
16 IBM solidDB: \m18O
Loading...
+ 246 hidden pages
Buy Points How it Works FAQ Contact Us Questions and Suggestions Privacy Policy Cookie Policy Terms of Use