IBM m18O User Manual
IBM solidDB
IBM solidDB Universal Cache
V6.5
\m18O
S151-1280-01
yw
Z9C>JO0d'VDz7.0,kDAZ 301 3D:yw;PDE"#
Z;f,Z;^)f
Kf>&CZIBM solidDB V6R5(z7`E 5724-V17)MIBM solidDB Universal Cache V6R5(z7`E 5724-W91)
0yPsx"PfM^)f,1=ZBf>PmPyw*9#
© Solid Information Technology Ltd. 1993, 2010
?<
< .................vii
m .................ix
|D** ..............xi
XZ>Va .............xiii
!"<( ...............xiii
o(m>(<( .............xiv
1 solidDB y>*X ..........1
solidDB }]\mi~ ...........1
`LSZ(ODBC M JDBC) ........2
xg(Ec ..............3
SQL bvwME/w...........3
solidDB ...............4
53$_M5CLr ...........4
T/\mMV/\m ...........5
solidDB e5a9 .............6
yZELDmD}]f"w.........6
yZZfDmD}]f"w.........7
solidDB SQL E/w ...........7
solidDB xg~q ............8
`_L&m
..............8
2 \m solidDB ...........11
CZxP}]b\mDC'G+ ........11
t/ solidDB ..............11
G< ................12
^D solidDB ~qwM solidDB SQL `-w
(solsql)D Windows l]== .......12
4(B}]b ..............13
C'{"\kM53?<{ ........14
Unicode M?V Unicode }]b== .....15
hC}]b73 ............16
solidDB dCD~(solid.ini) ......17
hC}]bis!(BlockSize)M
(FileSpec) .............17
(e}]bTs ............18
,S= solidDB .............18
XU}]b ..............19
XU solidDB ..............19
+ solidDB w* Windows ~qKP ......20
WN+ solidDB w*~qt/ .......20
t/M#9 solidDB ~q .........22
}% solidDB ~q ...........22
Z;(FczOKP`v~qw ........22
i4ms{"MU>D~ ..........23
XF{"U>dv ...........23
9C
ADMIN COMMAND 'errorcode' 4i4ms{"
hv ................24
;C
9CzYD~ .............25
zY'\DG<"T ..........25
`S solidDB ..............25
li}]b{e4, ..........25
q!10Q,SDC' ..........26
^}Q,SD solidDB C' ........26
i/n|;N8]D4, .........26
zI4,(f .............27
T\F}w (perfmon) ..........27
9C solidDB sFzY(AuditTrailEnabled)...38
tCM{CsFzY ..........38
i/ SYS_AUDIT_TRAIL 53mPDsFzY}
] ................39
4P8]MV4 .............39
4P>X8] .............39
(}xgxP8] ...........40
dCT0T/4P8] ..........41
8]ZdavVDiv ..........42
\mxg8]~qw ..........44
`SMXF8] ............44
|}'\D8] ............45
4P8]1
V48] ..............45
BqU>G< .............46
4(lic ..............47
dk(1|n ..............47
9u}]bD~ .............48
24G}]bXi ...........48
}]bXiD$w== ..........48
}]bXi|nP!n ..........49
T}]bxPS\ ............49
T}]bMU>D~xPS\ .......49
{CS\ ..............50
t/-}S
|DS\\k .............51
T}]bxPb\ ...........51
i/}]bS\6p ..........52
8]-}S\D}]b ..........52
TH8C~qwxPS\ .........52
S\MT\ .............52
DdMJb ..........45
\D}]b ..........51
3 dC solidDB ...........53
\mN} ...............53
dCD~MN}hC ..........54
9C ADMIN COMMAND 4i4MhCN} ..55
(} solid.ini dCD~hCN} ......59
dCN}D{Fq=M5q= .......61
nX*D~qwKN} ..........62
nX*DM'zKN} ..........67
9C solidDB |nP!n ..........69
hCX(Z solidDB D73d? .......69
iii
4 9C solidDB }]\m$_ .....71
solidDB 6LXF(solcon) .........71
t/ solidDB 6LXF(solcon) ......72
Z solidDB 6LXF(solcon)Pdk|n ...73
solidDB SQL `-w(solsql) ........73
t/ solidDB SQL `-w ........73
9C solidDB SQL `-w44P SQL od ..76
SD~P4P SQL E> .........76
solidDB lY0kw(solloado M solload) ....77
D~`M ..............78
t/“solidDB lY0kw”(solloado M
PXa_0kYHDa> .........81
>} ................81
XFD~o( .............83
solidDB <v(solexp) ..........91
t/“solidDB <v”(solexp) ........91
solidDB }]Vd(soldd) .........93
t/“solidDB }]Vd”(soldd) .......93
SD~Pdk\k ............96
dCD~ ...............96
+ solidDB $_k Unicode dO9C ......97
>}:9C solidDB $_XB0k}]b ....98
solloado) 78
5 T\w{.............101
U>G<kBqMCT ..........101
30 ...............101
=bT\k2+T ...........102
mIBqMCTgN\;a_T\......103
j<;BT .............103
BqMCTDV^T ..........103
!qBqtk6p ............103
hCtk6p ............104
XFZfDC?.............104
XFxLs! ............104
w{Yw53 ............106
}]b_Y:f............106
Er ...............108
9CZf}]b............108
w{xg{" .............109
w{ I/O...............109
V< I/O..............109
hC MergeInterval N} .........109
w{lic ..............110
(}d5Bqu! Bonsai wDs! ......111
@9 Bonsai w}Hvs .........111
TT\;QJbxPoO..........113
_-}]4{F............120
(E-i ...............121
TCP/IP -i .............121
UNIX \
|{\@ ..............123
-i** ..............124
@ .............122
7 JOoOM'V ..........125
TJbxPJOoO ...........125
CZxPJOoOD$_.........126
T solidDB Universal Cache xPJOoO ...132
T SMA xPJOoO .........134
Qw*6b ..............136
q!^) ...............136
IBM m~'Vz9(JCZ solidDB M solidDB
Universal Cache) ............137
k IBM 'Vz9*5 .........137
U/oO}] ............138
$)“'V”Md{|B .........143
=< A. ~qwKdCN} ......145
Accelerator Z .............145
Cluster Z...............146
Communication Z ............146
General Z ..............148
HotStandby Z .............156
IndexFile Z ..............159
Logging Z ..............161
LogReader Z .............164
MME Z ...............166
Passthrough Z .............169
SharedMemoryAccess Z ..........171
Sorter Z ...............171
SQL Z ...............173
Srv Z ................176
Synchronizer Z .............187
=< B. M'zKdCN} ......189
Client Z ...............189
Communication Z ............190
Data sources Z .............191
SharedMemoryAccess Z ..........191
=< C. solidDB |nP!n .....193
=< D. 73d? ..........197
6 \mxg,S ...........115
M'zk~qw.dD(E .........115
xgl}{F (Com.Listen) .........115
i4~qwy'VD-i.........117
i4~qwDxg{ ..........117
mSM^D~qwDxg{ ........117
}%~qwDxg{ ..........118
M'zD,SV{. ...........118
1!,SV{. (Com.Connect).......119
iv IBM solidDB: \m18O
=< E. msk ...........199
solidDB 53ms ............201
solidDB }]bms ...........203
solidDB mms .............212
solidDB a0ms ............227
solidDB (Ems ............227
solidDB ~qwms ...........230
solidDB }Lms ............236
solidDB API ms ............239
solidDB Erwms ...........239
solidDB RPC msM{" .........240
solidDB ,=ms ............241
solidDB HotStandby ms .........256
solidDB SSA (SQL API) ms ........257
solidDB COM((E){" .........258
solidDB SRV(~qw)ms ........259
solidDB DBE(}]b}f)msM{" ....260
solidDB CP(lic){" .........262
solidDB BCKP(8]){" ........262
solidDB AT((1|n){" ........263
solidDB LOG(G<){" .........263
solidDB INI(dCD~){" ........264
solidDB HSB (HotStandby) msM{"
solidDB SNC(,=){" .........267
solidDB XS(b?Erw)msM{" .....267
.....264
solidDB FIL(D~53){" ........267
solidDB TAB(m){" ..........268
solidDB SMA(2mZfCJ)ms ......268
solidDB PT(+])ms ..........269
solidDB SQL ms ............269
solidDB I4PD~ms ..........275
solidDB lY0kw(solloado M solload)ms . . 276
=< F. solidDB ADMIN COMMAND
o( ...............279
ADMIN COMMAND ...........279
w} ...............291
yw ...............301
?< v
vi IBM solidDB: \m18O
<
1. solidDB i~ ............2 2. solidDB i~ ............4
vii
viii IBM solidDB: \m18O
m
1. !"<( .............xiii
2. o(m>(<( ...........xiv
3. t/~qw .............12
4. solidDB 1!D~ ..........16
5. ,S= solidDB ...........19
6. Perfmon F}w ...........28
7. backup |nD!n ..........40
8. netbackup |nD!n .........40
9. kCZ4P>X8]D solid.ini D~`T&
DN} ..............42
10. kCZ4Pxg8]D solid.ini D~`T&
DN} ..............42
11. ICD8]Mxg
12. ;,(1|nDTd?M1!5 ......48
13. ,SV{.!n ...........67
14. solidDB 73d? ..........69
15. solcon |n!n ...........72
16. X(Z solcon D|n .........73
17. solsql |n!n ...........74
18. solloado M solload |n!n .......79
19. lY0kw#tV ..........83
20. XFD~Dj{o( ..........84
21. }]Zk .............85
22. solexp |n!n ...........91
23. soldd |n
24. CZ ?V Unicode M Unicode }]bD
solidDB $_D|nP!n .......98
25. 7(|n4, ...........112
26. 7(D),SxPQd5DBq .....112
27. TT\;QJbxPoO ........113
28. xgl}{F!n ..........116
29. ,SV{.!n ...........118
30. xgl}{F (Com.Listen) PD TCP/IP -
i ...............121
31. M'z,
TCP/IP -i ............122
32. xg{PD UNIX \@-i .......123
33. xg{PD|{\@-i ........123
34. solidDB -iMxg{ .........124
35. &CLr-iMxg{ ........124
36. “SQL E"”6p...........128
37. Ping $_6p ...........131
38. SOLSMASTART 1!X7Ud ......135
39. solidsupport ............138
40. solidDB Support Assistant (solidsupport) !n 140
41. Accelerator N} ...........145
42. Cluster N} ............146
43. Communication N} .........146
44. General N} ............148
SV{. (Com.Connect) PD
8]|n .......44
P!n ...........94
45. HotStandby N}
46. IndexFile N} ...........159
47. Logging N}............161
48. U>DAwN} ...........164
49. MME N} ............166
50. SQL +]N} ...........169
51. 2mZfCJN} ..........171
52. Sorter N} ............171
53. SQL N} .............173
54. Srv N} .............176
55. Synchronizer N} ..........187
56. Client N} ............189
57. Communication N} .........190
58. Data source N} ..........191
59. 2mZfCJN}(M'zK) .....191
60. solidDB 73d? ..........197
61. solidDB ms`p ..........199
62. solidDB 53ms ..........201
63. solidDB }
64. solidDB a0ms ..........227
65. solidDB (Ems ..........227
66. solidDB ~qwms .........230
67. solidDB SA API ms .........239
68. solidDB Erwms .........239
69. solidDB RPC msM{" ........240
70. solidDB ,=ms ..........241
71. solidDB HotStandby ms ........256
72. solidDB SSA (SQL API) ms ......257
73. solidDB COM((E){" .......258
74. solidDB SRV ms ..........259
75. solidDB DBE msM{" .......260
76. solidDB CP(lic){" .......262
77. solidDB BCKP(8]){" .......262
78. solidDB AT((1|n){" ......263
79. solidDB LOG(G<){"
80. solidDB INI(dCD~){" ......264
81. solidDB HSB msM{"........264
82. solidDB SNC(,=){" .......267
83. solidDB XS(b?Erw)ms .....267
84. solidDB FIL(D~53){" ......267
85. solidDB TAB(m){" ........268
86. solidDB SMA(2mZfCJ)ms ....268
87. solidDB +]ms ..........269
88. solidDB SQL ms ..........269
89. solidDB I4PD~ms ........275
90. solidDB lY0kw(solloado M solload)m
s ...............276
91. ADMIN COMMAND o(M!n .....280
...........156
]bms .........203
.......263
ix
x IBM solidDB: \m18O
|D**
T^)f 01 D|D
v Z TCP/IP -i;ZPmSKPX TCP/IPv6 -iDE"#
v Z~qwKdCN};ZPvSKBN}:
– MME.MaxTransactionSize
– MME.MemoryPoolScope
– Passthrough.ComplexNumNonindexedConstr
– Passthrough.ComplexNumOrderedRows
– Passthrough.ComplexNumTables
v Z perfmon F}wDj{Pm;ZPvSKBDT\F}w:
Passthrough complex by num non indexed constraints
Passthrough complex by num ordered rows
Passthrough complex by num tables
v Z~qwKdCN};ZPmSKPX IndexFile.DirectIO M Logging.DirectIO N
®
}'VDE":b)N}Z Windows
73P^';Z Windows 73P,}]bD
~<U9C“1S I/O”#
®
v solidDB
lY0kw(solloado M solload);ZPD solidDB lY0kw(solloado
M solload)|B
– QvSBDyZ ODBC D solloado#
– Z DATE"TIME M TIMESTAMP ;ZP* DATE M TIMESTAMP ZkvS
DBB]q= B(T"Dm>D}vV8iIDu4,}g,01-DEC-2010)#
v vSBD;ZJOoOM'V,
dP|(PX^)| 2 P}kD solidDB Support
Assistant Dj8E"#
v Z Srv Z;ZPvSKBN}:
– Srv.StackTraceEnabled
v ZM'zKdCN};ZPvSKBN}:
– SharedMemoryAccess.SignalHandler
– SharedMemoryAccess.Signals
v Z perfmon F}wDj{Pm;ZPvSKBDT\F}w:
Log availq items – Number of records added to available items queue
Time sec – Printout time of this pmon in seconds
v Zmszk;ZPvSKBDmszk
21330,Communication,Error,Failed to accept a new client connection, too many open files
30805,XS,Message,Maximum number of files for external sorting reached
v ZxPxg4F;ZP,vSK1YDCZ ADMIN COMMAND ’netbackup’ D!n -I
M -i#
v Q+,S(A),1Dv'5S 60 000 Ak|}* 0(^^);ZM'zD,SV
{.M Communication Zb8ZPQ|BM'zKN} Com.ClientReadTimeout M
Com.Connect !n -rmilliseconds#
xi
v Q|B SQL Z;Z:Z Unicode }]bP,SQL.CharPadding=yes N}hC;
z';<UOz CHAR 5PDUWV{#
v Zt/{IDEP206A: R;=D~#} SQL `-w;ZP,vSK1YD solidDB SQL
`-w (solsql) t/!n -S <schema name> M -C <catalog name>#
v Z Accelerator ZPvSKBN} Accelerator.ReturnListenErrors#
v Z Passthrough ZPvSKBN} Passthrough.Force32bitODBCHandles#
v Q|B perfmon F}wDj{Pm;Z#
v Z~qwKdCN};ZPvSK1YDN}:
– General.UseEncryption(Y1^) 01)
– SQL.SQLInfo
– MME.MaxBytesCachedInPrivateMemoryPool
v Z General ZP,Q+N} General.LockHashSize Dv'5S 1000 |D*
1000000(Y1^) 01)#
v Q+mszk;Z|B*k ADMIN COMMAND ’errorcode all’ dvT&#ZBPw
ZP,QvSH04G<D{":
– API ms
–AT((1|n){"
– BCKP(8]){"
– COM((E){"
–CP(lic){"
– DBE(}]b}f)msM{"
– FIL(D~53){"
– HSB (HotStandby) msM{"
– INI(dCD~){"
– LOG(G<){"
– RPC msM{"
– SMA(2mZfCJ)ms
– SNC(
– SRV(~qw)ms
– TAB(m){"
–XS(b?Erw)msM{"
v vSKBD;Z:9C ADMIN COMMAND ’errorcode’ 4i4ms{"hv
v Z Unicode M?V Unicode }]b==;ZPvSKPX“T Unicode ==4(}
]b”DE"#
v Z HotStandby Z;ZP,Q|}N} HotStandby.TCConnect Dv'1
fZv'5#
v Z perfmon F}wDj{Pm;ZP|BKT\F}wDPm#
v Q|BT}]bxPS\;Z;vSKPXgN{CS\DE"#
,=){"
!5;;
xii IBM solidDB: \m18O
XZ>Va
!"<(
IBM®solidDB G(CD}]b\m53,S!MD6k=53=sf#53<JC#
zIT9CwV&\T solidDB i~4~qZXbhs#K`i~|(:
v Zf}]b
v _HICDH8CdC
v _6l=4F
v CZ+&CLr1Sk~qwzk4SD
b
OvyPi~<G};D,4,|GITZd{i~fZDivB9C#solidDB D\
m1IT9CwVdC!nM$_TnOJD==hCz7#
>8OhvgNhC"`S"\mME/>z7Dy>}]b~qw&\#`XVa
)KPXdCX( solidDB i~D|`j8E"#
a
>8OY(A_FU;cD}]b\m53(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#
TRIG_COUNT() KVeCZ/
java.sql.Connection KVeCZSZ{F#
LockHashSize KVeCZN}{"/}Td?M Windows "amu?#
argument K`?wJ8>C'r&CLrXka)DE"#
\m18O
D~76m> }GmPyw,qrD~764 UNIX
KVeCZLrzkMLrdv#>} SQL od29CKV
e#
}{#
bVy=CZ}Cd{D5r_,;D5PDBZ#BuoM
?wDJb24Ky=i4#
®
q=m>#1\(/)
V{m>20y?<#
xiii
m1.!"<((x
q=JCZ
)
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?#
.
.
.
I}vciID;Pm>bGH0zkPDSx#
xiv IBM solidDB: \m18O
1 solidDB y>*X
solidDB DKDGX5}]b~qw#K}]b~qwS\T SQL oT`4Di/#
(#,b) SQL i/I
~qw5XDa{/#
"R,solidDB 9a)K,=&\,TJm+;v solidDB PQ|BD}]"M=;v
r`vd{ solidDB#
solidDB 9JmICH8CdCKP;T solidDB,"Jm+M'z&CLr1S4S=
}]b~qw}LTca_T\T 0|t\XXF~qw#b)&\F*“H8C”M
2mZfCJ(SMA)r4SbCJ(LLA)#
TBwZhvKWci~MxL,|G9 solidDB I*1q4SV<=5373Pmk
DV<=}]\mbv
D30E"#
solidDB }]\mi~
B<T>K solidDB }]\mi~,fsDBZT|GxPhv#
M'z
&CLra;,s_+ SQL od"M=~qw"SU
=8#b)BZa)KZxg73P\mM,$ solidDB yXh
1
1. SA API G solidDB T:D API,k2mZfCJ(SMA)r4SbCJ(LLA)bdO9C#PXj8E",kN
D6IBM solidDB 2mZfCJM4SbCJC'8O7#
<
1. solidDB
i~
`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
2 IBM solidDB: \m18O
™
Lr#
Md{_e
ODBC
solidDB ODBC }/Lr{O Microsoft ODBC 3.51 API j<#solidDB ODBC }/
Lr'VD/}I(} solidDB ODBC API xPCJ,C API G solidDB }]bD
wC6SZ(CLI)"k ANSI X3H2 SQL CLI ;B#
PX solidDB ODBC }/LrD|`j8E",kND IBM solidDB Programmer
Guide#
JDBC
solidDB JDBC }/LrJm Java &CLr9C JDBC 4CJ}]b#solidDB JDBC
}/Lr5VK JDBC 2.0 f6PDs?VZ]#
PX solidDB JDBC }/LrD|`j8E",kND IBM solidDB Programmer
Guide#
(PSZ
solidDB 9a)K=v(PSZ solidDB &CLr`LSZ(SA API)M solidDB ~
qwXF API(SSC API)#}g,b)SZJm C Lr1SwC}]b~qwPD
/}#b)(PSZd8K solidDB 2mZfCJ(SMA)M4SbCJ(LLA)b#
PX solidDB (P`LSZD|
4SbCJC'8O7
xg(Ec
solidDB \;ZyPw w`MDxgPKP"'VyPww(E-i(}g TCP/
IP)# *"_IT4(CZ;,V`Fc73DV<=&CLr#PXxg(ED|`
j8E",kNDZ 115 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 7 3D:solidDB SQL E/w;
;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'#
`j8E",kND6IBM solidDB
M IBM solidDB Programmer Guide#
ms!"mPP}"ICw}T0w}
2mZfCJM
/#|G;va)
PXE/wa>D|`j8E",kND6IBM solidDB SQL 8O7#
1 solidDB y>*X 3
solidDB
solidDB +&m(} solidDB SQL a;D}]ks#< 2 y>D solidDB ~qw+}
]f"Z}]bP"SC}]bPlw}]#
1. SA API G solidDB T:D API,k2mZfCJ(SMA)r4SbCJ(LLA)bdO9C#PXj8E",kN
D6IBM solidDB 2mZfCJM4SbCJC'8O7#
<
2. solidDB
i~
53$_M5CLr
solidDB |(;WCZxP}]\mD$_#
4 IBM solidDB: \m18O
XF($_:solidDB SQL `-w(solsql)M solidDB 6LXF
(solcon)
v “solidDB SQL `-w”(solsql) G;vXF($_,CZZ|na>{&r(}4P
|, SQL odDE>D~4"v SQL odM solidDB ADMIN COMMAND#
v “solidDB 6LXF”(solcon) G;vCZ\mDXF($_;_P\m1(^DC'I
TZ|na>{&r(}4P|,|nDE>D~4
C solcon,ADMIN COMMAND Iw* solcon t/|nPD;?V"v#
CZ<vM0k}]D$_
solidDB a)KTBCZ<vM0k}]D$_:
v “solidDB lY0kw”(solloado r solload)+}]Sb?D~0k= solidDB }]
bP#
v “solidDB <v”(solexp) +}]S solidDB }]b<v=D~P#|9a4(“solidDB
lY0kw”(solloado r solload)CZ4P}]0kYwDXFD~#
v “solidDB
>|,hv}]ba9D}](eod#
}]Vd”(soldd) <v}]bD}]Vd#|azI;v SQL E>,CE
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#
"v ADMIN COMMAND#{
X*1,z2ITV/\
solidDB a)KBPCZ4PV/\mD$_M=(:
v ADMIN COMMAND
*4P\mNq,zITZ solidDB SQL `-w(solsql)P"v solidDB SQL T
:D ADMIN COMMAND#*q!j{D|nPm,kND Z 279 3D=< F,
:solidDB ADMIN COMMAND o(;#
v solidDB ~qwXF API(SSC API)
g{z}Z9C_P4SbC
API)+9C'&CLr\;(}LrXFNqD4P#SSC API /}ICZT}]
b8]"}]blicM Bonsai wO".`DNq8(EH6#y8(DEH67
(Nq4PsDKP3r#PXj8E",k
SbCJC'8O7#
v solidDB 6LXF(solcon)
“solidDB 6LXF”(solcon)JmzZ;9C ADMIN COMMAND o(DivB
dk\m|n#PXj8E",kNDZ 71 3D:solidDB 6LXF(solcon);#
m solidDB#
J&\D solidDB,G4 solidDB ~qwXF API(SSC
ND6IBM solidDB 2mZfCJM4
1 solidDB y>*X 5
solidDB e5a9
>Za)EnTE",b)E"PzZzKbgNdC solidDB Tzc&CLrM=(
Dhs#>Z`XZ{vBPwn:
v }]f"w
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#
– wf"w
– Bonsai w`f>XFM"PXF
:pf" D mD~qwZ??~F*“y
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(|(SQL +KF*“w}”- vvG|,Z SQL w}PDP
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}Dj8
E",kND6IBM solidDB SQL 8O7PPXw|w}DV[#
5)#}~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”;yPZ
K.sSd{,Sek=}]bD|5TZ10BqP4P
+a);BDw}A6p,MqAYwZCBqt/1T-S==4P;y#by,
MIT7#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#
6 IBM solidDB: \m18O
Bonsai wP,;*fZh*i4G)I
(YwxPO"#b+TxE/ I/O "5V:Xy
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"Zwf"wP,bm>Zf}]b=s,|
P<CDUd=s#}5J}]Tb,M mDw}2Zwf"wP9(#solidDB 9C
F*“T=”Dwf"wE/w}<u45Vw}# *@@f" M m0dw}yhDZ
f?,kND6IBM solidDB Zf}]bC'8O7#
Zwf"w
:pf" M mD~qwZ
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
;mP9G;imP#+G,kyZfrDE/w;,,KE/wPyZ*zD&\
\;y]}]bD5JZ](}g,P}T0wvPD5V<iv)xPwZ#
solidDB T/,$PX5J}]D3FE",Sx7#T\nQ#49}]
]Pyd/,KE/w2T\;7((y}]DnP'76#
i/&m
i/&mV*`v!MD=h4P,T7#;nD1DYw;ah{m;&CLrD
ks#i/(};v|,BPWNDrPxP&m:
v o(Vv
v 4(4P<
v &m4P<
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/#
??~F*wf"w}f(MME)#
%
D}?MZ
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{#
1 solidDB y>*X 7
&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@cyZPX|5V<iv"ms!Md{/,3F}]DT/,
$E"#z;h*TV/==|Bw}1=<rNNd{@cE"#
v PlwWN
lwi/Da{P"+d5X=M'z&CLr#
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#
T#
/}#C
ZV<=53P,I\aP`v&CLr,1ks~qw4P`nYw#*Ko=n
s"PT,solidDB xg~q+9CICDYw53_L4a)^lD`C''V#Z
%_LYw5
(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)#
_Lw*wCLrDiI?V0k=ZfP;rK,wC_L1;XCJEL#_L
IT9C+Vd?"B~MEExP(E#
g{Yw53'V;,&
mw#
3O,xg~q(}c:9Cl=Yw4nsLHXa_T\#
`(x
mw.dDTF`_L<u,G4 solidDB aT/{C`v&
_L`M
solidDB _L<u53I(C_LM(C_LiI#
(C_L
8 IBM solidDB: \m18O
(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
q53PD
m;vNq#Nq53T-7==$w,SxZ;,_L.dyHXV"M'zY
w#
zITZ solid.ini dCD~PhC(C_LD}?#
(C_L
(C_L)X(Yw(C#Z~qwP,I\fZBP(C_L:
v I/O \mw_L
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 ks
4|GD_-D~X7Er#xPErPzZE/D~ I/O,bGr*,Z
ELOCJDD~X7`k`|,b+uLELA!7DF/`k#
v (EA_L
&CLr<U,S=KPZ!qw_LPDl}wa0#(",Ss,IT*?v
'z4((CDA_L#
M
v ?V-i;v(E!q_L(F*!qw_L)
(#,?V-iP;v(E!qw_L#?vKPPD!qw_L<++kks4
k+2{"SP#
v (E~qw_L(2F* RPC ~qww_L)
K_LS+2{"SPP
q#
A!ks"(}wCyksD~q/}*&CLra)~
1 solidDB y>*X 9
10 IBM solidDB: \m18O
2 \m solidDB
>ZhvgN,$y20D solidDB#>Z{vD\mNq|(:
v 4Py>D solidDB Yw,}gt/M#9~qw
v 8]~qw
v T}]bxPS\
*c: g{z} Z9C_P2mZfCJ(SMA) r4Sb CJ(LLA)&\D
solidDB,G4kj< solidDB
6
IBM solidDB
6
DE"#
CZxP}]b\mDC'G+
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
2mZfCJM4SbCJC'8O7
`H,Z\m=fP;)np#X*1,> B+}C
7Ta)X(Z SMA r LLA
t/ solidDB
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(eb)G+#PX j8E ", k N D
SQL
8O7
PD:
\mC'X(MG+
(}Z|na>{&"v|n solid [options],rZ Windows 73P,(}9C*
< → Lr → IBM solidDB K%76,It/ solidDB#
CZt/ solidDB Do(gB:
solid [options]
;#
(#
_PKC
6
IBM solidDB
TZ options,kND Z 193 3D=< C, :solidDB |nP!n;#
11
*t/ solidDB,P'mI$D~Xk;Z$w?<Pr;Z9C SOLIDDIR 73d?
8(D;CP#
m3.t/~qw
Yw53 *t/~qw...
®
M UNIX Z$w?<P,Z|na>{&dk|n solid [options]#
Linux
Z;Nt/~qw1,k9C|nP!n -f T?F~qwZ0(KP:
solid -f
Windows
v (}*< → Lr → IBM solidDBK%76%wjPt/ IBM solidDB ~qwD<j#
v Z$w?<P,Z|na>{&dk|
v *t/~qwT9dZs(KP,kdk|n start solid#
n solid [options]#
1 solidDB t/1,|+li}]bGqQfZ#~qw+HiR solid.ini dCD
~"A! FileSpec N}D5#;s,~qw+liGqfZ_P FileSpec N}y8
({FM76D}]bD~#g{R=}]bD~,G4 solidDB +T/r*C}]
b#g{R;=
}]b,G4~qwa4(B}]b#
":
>ZDZ]vJCZj< solidDB#g{z}Z9C_P2mZfCJ(SMA)r4S
bCJ(LLA)&\D solidDB,kND6
C'8O7
7TKbPXgNt/ solidDB SMA r LLA ~qwD8>E"#
IBM solidDB
2mZfCJM4SbCJ
6
`XN<
Z 193 3D=< C, :solidDB |nP!n;
`XE"
Z 63 3D:FileSpec_[1...n] N};
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#
^D solidDB ~qwM solidDB SQL `-w(solsql)D
Windows l]==
1!ivB,*< → Lr → IBM solidDBK%76PDt/ IBM solidDB ~qwM
solsql SQL `-w<jITt/ eval_kit\standalone ?<PDLr#*|D1!h
C,k^Dl]==DtT#
^Dt/ IBM solidDB ~qwl]==
(}^Dt/ IBM solidDB ~qwl]==DtT,zIT8(t/ solidDB 19C
D$w?<"G<}]M53?<{FT0d{|nP!n#
1. R|%wt/ IBM solidDB ~qw<j#
2. !qtT,;s!ql]==!n(#
12 IBM solidDB: \m18O
3. *|DG<}]M?<{F(rd{t/!n),k^D?j VNPa)D|nP
!n:
v -C - 53?<{F
v -P - \k
v -U - C'{
}g:
″C:\Program Files\IBM\solidDB\solidDB6.5\bin\solid.exe″ -C mycatalog -P mypassword
-U myname
*qCICD solidDB t/!nPm,kND Z 193 3D=< C, :solidDB |n
P!n;;Z#
4. *|D$w?<,k^Dp<;CVNPD?<76#
}g:
″C:\Program Files\IBM\solidDB\solidDB6.5\eval_kit\mytest\″
^D solsql SQL `-wl]==
(}^D solsql SQL `-wl]==DtT,zIT8( solidDB SQL `-w
(solsql),SAD solidDB ~qwD,SE"MG<}]#
1. R|%w solsql SQL `-w<j#
2. !qtT,;s!ql]==!n(#
3. *|D,SE"MG<}],k^D?jVNPa)D
k#
~qw{F"C'{M\
4(B}]b
}g:
″C:\Program Files\IBM\solidDB\solidDB6.5\bin\solsql.exe″″tcp 2315″ myname mypassword
Kb,z9ITZ?jVNP8(t/!n#*qCICD solsql t/!nPm,
kNDZ 73 3D:t/ solidDB SQL `-w;;Z#
solidDB }]bGZ solidDB ~qwt/14(D#
1 solidDB t/1,|+li}]bGqQfZ#g{}]b;fZ,G4 solidDB +
a>z4(BD}]b#
v Z Windows 73P,;vT00Zaa>zdk}]b\m1DC'{"\kM1
!(53)?<D
v Z Linux M UNIX 73P,+T>TB{":
}]b;fZ#*4(B}]bp(y/n)?
g{Xp“Yes”,G4 solidDB aa>zdk}]b\m1DC'{"\kM1!(5
3)?<D{F#
S\}]b\m1DC'{M\k.s,solidDB +4(B}]b#
{F#
2 \m solidDB 13
1!ivB,}]b+;4(I solidDB $w?<PD;vD~(solid.db)#
;|,53mMS<DU}]bs<<C 4 WVZDELUd# 4(}]byhD1
d!vZzy9CD2~=(#g{zP;vG#!D}]b(!Z 4 WVZ),
#{7 # 9 CD E LU d ? !Z 4 W V Z ,G 4 k+ solid.ini dC D ~ P
IndexFile.ExtendIncrement N}D5hC*!Z 500(1!5)#Z 145 3D=< A,
:~qwKdCN};TKN}Md{N}wKV[#
"R
4(}]bjIs,solidDB +*<ZxgPl}M'z,
P,+T> solidDB <j,+Zs`}73P,solidDB w*X$xLT;IS==Z
s(KP#
C'{"\kM53?<{
4( solidDB }]b1,+a4 (}]b5 3\m1J ';}]b D4(__P
SYS_ADMIN_ROLE C'G+#4(}]b1,9a4(53?<{,"RTs;\|
D53?<{#
*c:zXkG!C'{M\k,Tc\;,S= solidDB#;P1!C'{;z
}]b1dkD\m1C'{G(;ICZ,S=B}]bDC'{#
*c:C'{"\kM53?<{PD!4V{+a*;*s4#
C'{
v n!$H:2 vV{#
v ns$H:80 vV{#
v C'{XkTV8rB._*7#IT9C!4V8 a = z"s4V8 A = Z"B
._V{“_”T0}V 0 = 9#
\k
v n!$H:3 vV{#
v ns$H:80 vV{#
v \kIT9CNNV8"B._r}V*7#IT9C!4V8 a = z"s4V8 A
= Z"B._V{“_”T0}V 0 = 9#
v ;\Z\kP9C+}E(″ )V{#?R(iz;*
Uq(“”),bGr*3)$_Z\kP;S\b)V{#
v g{zF.9C solcon,G4k;*4(|,G ASCII V{D\k,bGr* solcon
;aTNNdk4P UTF-8 *;#
v Kb,z9ITSD~dk\k#P
\k;#
Sks#Z Windows 73
4(
9C2E(’)"VE(;)r
X|`E",kNDZ 96 3D:SD~Pdk
53?<
v n!$H:1 vV{#
v ns$H:39 vV{#
v 53?<{;\|,Uq#
CZ}]bTscNa9D solidDB o(gBy>:
catalog_name.schema_name.database_object
14 IBM solidDB: \m18O
1!#={kC'{`,#
1Z solidDB P4(Ts1,g{;8(?<M#={,G4~qw+9CTs4(_
D53?<MC'{47(*9CDTs#
PX solidDB ?<M#=Dj8E",kND
}]bTs
;;Z#
Unicode M?V Unicode }]b==
S V6.5 *<,I(}TB=V==4( solidDB }]b:Unicode ==r?V Uni-
code ==(1!5)#K}]b==yZ solidDB ~qwPV{}]`M(CHAR M
VARCHAR H)D`k#m;V{}]`M(WCHAR M WVARCHAR H)G(}b
=V==xP Unicode `kD#
v Unicode ==
6
IBM solidDB SQL
8O7
PD:
\m
Z Unicode
m;V{}]`MDZ?m>(* UTF-16#
v ?V Unicode ==
Z?V Unicode ==B,V{}]`MDZ?m>(;a9CNNX(D`k;xG
+}]f"ZVZV{.P,,1Y(C'&CLr*@Ki
*;#
m;V{}]`MDZ?m>(* UTF-16#
(} solidDB V6.3 r|Mf>4(D}]b*?V Unicode `M#
*c:6.5 PD1!}]b==*?V Unicode#
==B,V{}]`MDZ?m>(* UTF-8#
v"ZX*1&mC
4( Unicode }]b
solidDB }]b==G(}N} General.InternalCharEncoding XFD#
v Unicode ==:General.InternalCharEncoding=UTF8
1 InternalCharEncoding hC*“UTF8”1,V{}]`MDZ?m>(* UTF-8#
aZ solidDB ~qwk&CLr.d*;V{}]`MMm;V{}]`M#
v ?V Unicode ==:General.InternalCharEncoding=Raw
1 InternalCharEncoding hC*“Raw”1,V{}]`MDZ?m>(
NX(D`k;xG+}]f"ZVZV{.P,,1Y(C'&CLr*@Ki
v"ZX*1Q&mC*;#aZ solidDB ~qwk&CLr.d*;m;V{}]
`M#
(} solidDB V6.3 r|Mf>4(D}]b*?V Unicode `M#
*c:4(}
g{}]bQZdP;V==BfZ,"RC}]b==kN}D5`,\,G4~
qwt/'\,"RTBms{"avVZ solerr.out P:
N} General.InternalCharEncoding kVP}]b==`,\
]b1,Xk(e}]b==,"RTs;\T}]b==xP|D#
;a9CN
2 \m solidDB 15
hC}]b73
1!ivB,solidDB }]bD~"U>"{"MzYD~GZ solidDB $w?<P4
(D#TZzz73,}g,zI\khC}]bD~"8]D~MU>D~;Z;
,DELOD73#
1!$w?<hC
$w?<
GbyD;v?<:|,kKPX( solidDB 5}`XDD~#
BmT>Kn#CD solidDB D~"CD~Dv'5;CT0^D;CD==#
m
4. solidDB
D~ v'5;C ^D==
mI $ D ~(solid.lic"
soliduc.lic r
solideval.lic)
solid.ini dCD~ $w?< Z SOLIDDIR 73d?P(e76
}]bD~(solid.db) $w?< 9CIndexFile.FileSpec N}(e
B q U > D ~
(sol#####.log)
{"D~(solmsg.out) $w?< ;\|D;CM{F;<UZ$w?<Pdv
msD~ (solerror.out) $w?< ;\|D;CM
zYD~(soltrace.out) $w?< 9C Com.TraceFile N}(e
8]D~s<$ w ? <
1!D~
$w?< Z SOLIDDIR 73d?P(e76
$w?< 9C Logging.LogDir N}(e;C
r_
9
C Logging.FileNameTemplate N}(e;
CMD~{
":g{8(CZU>D~D?<,G4Zt
/ solidDB .0,C?<XkfZ:solidDB ;
\4(?<#
solmsg.out D~#
{F;<UZ$w?<Pdv
solerror.out D~#
9C General.BackupDirectory N}(e
>/backup
":8] solidDB .0,CZ8]D~D?<X
kfZ:solidDB ;\4(?<#
XZzz73D(i
v g{;kZzz73ZcOKP20Lr,G4Z@"DZcO20 solidDB,;s
+I4PD~"bM}/LrV/4F=zzZc(g{JCZzD20D0)#
v *K@9Z"zELJO1*'}],k+}]bD~MBqU>D~
Dom}/wO#b9+a)nQT\,XpGZ4P}]blicZd,1T}
]bD~MBqU>D~xP4Yw1#
v +>XEL(x;GxgEL)CZf"}]bD~MU>D~#
TZ solidDB HotStandby hC,bXpX*#TZxP
D73,a+ HotStandby dCw*?j,"RbnC(}9w}]bk(z}]b
;Z;,Zc(?v<9C>XEL)O4jI#xgEL_Pw*53P_-/ o
m%JOcDgU#
16 IBM solidDB: \m18O
f"Z;,
;2mNNZ]De5a9
Loading...