IBM solidDB User Manual V6.3

Download

IBM solidDB IBM solidDB Universal Cache

V6.3

򔻐򗗠򙳰

\m18O

S151-1144-00

IBM solidDB IBM solidDB Universal Cache

V6.3

򔻐򗗠򙳰

\m18O

S151-1144-00

Z9C>JO0d'VDz7.0,kDAZ 257 3D:yw;PDE"#

>f>JCZ IBM solidDB(z7`E 5724-V17)M IBM solidDB Universal Cache(z7`E 5724-W91)V6R3 0y Psx"PfM^)f,1=ZBf>PmPyw*9#

< .................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

;(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

................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

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

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

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?#

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#

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#

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

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$_:

PXj8E",kNDZ 53 3D4 B, :9C solidDB }]\m$_;#

solidDB e5a9

>Za)EnTE",b)E"PzZzKbgNdC solidDB Tzc&CLrM=( Dhs#>Z`XZ{vBPwn:

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

/, SQL E/

xg~q

`_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+

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:

`M@@WN

y]WcDmMS<(e4FOa{/DP}]`M#

@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"#

PlwWN

lwi/Da{P"+d5X=M'z&CLr#

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:

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

(EA_L

&CLr<U,S=KPZ!qw_LPDl}wa0#(",Ss,IT*?v M'z4((CDA_L#

?V-i;v(E!q_L(F*!qw_L)

JDD~X7`k`|,b+uLELA!7DF/`k#

(#,?

k+2{"SP#

(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

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 =

;\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

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;#

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

}] 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:

i4}]b?<PD solmsg.out D~,KbICZ,S= solidDB DP'xg{#

BP{"+

Listening of 'ShMem Solid' started. Listening of 'tcp hobbes 1313' started.

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~:

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,

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:

}p SYS_EVENT_ILL_LOGIN B~,"R

+{",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

ADMIN COMMAND ’status netbackup″

g{O;N8]I&,G4a{/gBy>:

RC TEXT

-- ---0 SUCCESS

g{ON8]'\,G4 RC P+5Xmsk#D>*“ACTIVE”D5Xk 14003 mw

C8]10}ZKP#

j8 DBMS `SMJOoO

;NT`S(f

(}4(lU,zITq!PX solidDB T\Dd{E"#kZ solidDB SQL `-w

PdkTB|n:

ADMIN COMMAND ’perfmon’;

K|n5X;va{/,dPD?;P<zmT\E"D;vlU,ClU43Kn |8VSDT\iv#K|nDo(9Jmz8(dv!n#

",kNDZ 233 3D=< E, :solidDB ADMIN COMMAND o(;PD perfmon ! no(#

PXb)!nDj8E

Z;PT>8kSZD=yT\E"#“Total”PT>TS solidDB t/sD=yE"# s?V}5<G?kB~}#G)^(m>*?kB~}D}5(}g}]bs!

TxT5m>#

zITT 100 `vF}wMF?mxPP?#|GDV`gBy>:

D~Yw

_Y:fYw

RPC M(EYw

SQL Yw

SA(m6}]bYw)Yw

)

BqYw

w}4(4}]bD~4)Yw

2 \m solidDB 17

d{Yw

(}a)F}w{FD0:Pm,ITTdvxP^F,}g:

admin command 'pmon db'; RC TEXT

-- ---0 Performance statistics: 0 Time (sec) 43 43 42 30 30 44 42 33 Total 0 DBE insert : 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 DBE delete : 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 DBE update : 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 DBE fetch : 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.7 0 Db size : 12032 12032 12032 12032 12032 12032 12032 12032 12032 0 Db free size : 7816 7816 7816 7816 7816 7816 7816 7816 7816

8 rows fetched.

zI,xDT\`S(f

ADMIN COMMAND ’perfmon’ DdP;Vq=Jmz*<M#9+,xDT\F}w

(fzI=D~#Kq=gBy>:

t/`S:

ADMIN COMMAND 'perfmon diff start filename interval'

}g,**<G<yPF}w,"R1ddt* 1 k:

ADMIN COMMAND ’pmon diff start counter_log.csv 1000’

b+QF}w}]G<=;v“:EVtD5” D~,CD~T;PF}w{F*7,

"R?vIy1d<P;P}]#

*#9`S:

ADMIN COMMAND ’pmon stop’

Perfmon F}wDj{Pm

F}w4U|GZdv(fPDvV3rP>#

5. Perfmon

Perfmon d? hv

Time (sec) Z;NT(fP:b?1ddtD$H(TkF)#nB1ddt

TimeMs Znp(fP:b?1ddt(TAkF)#nID1ddtZm

File open D~r*wCN}/k#

File read D~AwCN}/k#

F}w

ZmDR`#

DZ;P#

File write D~4wCN}

File append D~7SwCN}/k#

File flush D~eVwCN}/k#

/k#

18 IBM solidDB: \m18O

5. Perfmon

Perfmon d? hv

File lock D~x(wCN}/k#

Cache find _Y:fCfN}/k#

Cache read _Y:f4|PN}/k#

Cache write _Y:f3feVN}/k#

Cache prefetch _Y:f$Cf3f}/k#

Cache prefetch wait _Y:fH}$Cf3f}/k#

Cache preflush $eV_Y:f3f}/k#

F}w(x

)

Cache LRU write 4

Cache slot wait

Cache slot replace }]b_Y:f[Q

Cache write storage leaf }]b_Y:fQ+f"wD6S34kEL#

Cache write storage index }]b_Y:fQ+f"wDw}34kEL#

Cache write bonsai leaf }]b_Y:fQ+ Bonsai wD6S34kEL#

Cache write bonsai index }]b_Y:fQ+ Bonsai wDw}34kEL#

RPC messages "M{"\}/k

RPC read A{"\}/k#

RPC write 4{"\}/k#

RPC uncompressed 1 RPC 9u&\&ZtC4,1,bG?k49uVZ}#

RPC compressed 1 RPC 9u&\&ZtC4,1,bG?k9uVZ}#

P LRU f;1,+4_Y:fPDZ]#bb6E,IZ;PI

CDELi,rKM'z_LXkH+;vi4kEL,;sE\

SELPA!Bi#g{K5G#s,G4I\vmw I/O :XO _,2I\mw I/O $eVLr5"GnE#

KF}wmwfZT,;viD""CJ,"R;v_LXkH}

m;v_L#y]_Y:fdCD;,,b9I\mw_Y:fD %bF}"GnE"RfZ1e;#Zbo,1!%bF};a<

B1e;#

;f;,I[Q;}%#

Com sel empty TCP WSV!q5XUZ]N}/k#

Com sel found TCP WSV!qI&N}/k#

SQL prepare SQL <8od}

SQL execute SQL 4Pod}/k#

SQL fetch SQL Cfod}/k#

DBE insert m}fPekN}/k#

DBE delete m}fP>}N}/k#

/k#

2 \m solidDB

5. Perfmon

Perfmon d? hv

DBE update m}fP|BN}/k#

DBE fetch m}fPCfN}/k#

DBE dd operation ~qwQ4P SQL }]VdYw#

Proc exec }L4PN}/k#

Trig exec %"w4PN}/k#

SA insert SA 6PekN}/k#

SA delete SA 6P>}N}/k#

SA update SA 6P|BN}/k#

F}w(x

)

SA fetch SA 6PCfN}/

Trans commit d5DBq}/k#

Trans abort P9DBq}/k#

Trans rollback XvDBq}/k#

Trans readonly ;ABq}/k#

Trans buf 10Bq:exs!#

Trans buf cleanup t/s4Pe}YwD[FN}#

Trans buf added t/smSDBqD[F}?#

Trans buf removed t/s}%DBqD[F}?#

Trans validate n/D

Trans active n/BqD10}?#

Trans read level KF}w8>10BqA6p#KF}wD5+;O]v#IZK

d51i$YwD10}?#

F}wD5G 32 ;d?,rKIT_P:}5,+Z_-O,5T ;GZ]v#Z104Bq4PZd,g{K5$ mwA6p;;v$Bqh{,bI\<BO"h{T0 Bonsai w

vs#

1d;d,G4

Ind write w}4N}/k#

Ind nomrg write 4O"DP(Qd5DPT04d5DP)D}?#

Log write U>G<4N}/k#

Log file write U>i4N}/k#

Log nocp write O;vlic.sD]

RU>G<}#

20 IBM solidDB: \m18O

5. Perfmon

Perfmon d? hv

Log size U>D~D\s!(T KB F)#

Search active m}f6n/Qw}#

Db size ELOD}]b\s!(T KB F)#

Db free size }]bPD3f6ICUd?(T KB F)#

Mem size /,VdDZfD\s!(T KB F)#

Merge quickstep lYO"=h}/k#

F}w(x

)

Merge step j+O"=h

Merge step (purge) ZcVn}pDO"|}/k(g{QtCK&\D0)#

Merge step (user) C'_L$nDO"P}/k#

Merge oper M6O"Yw}/k#

Merge cleanup Bq:exe}wCN}/k(g{QtCVne}&\)#

Merge active G/q(1/0)#

Merge nomrg write }ZH}O"Dw}

Merge file write O"}pDD~4N}/k#

Merge file read O"}pDD~AN}/k#

Merge level 10O"6p(nIn/BqDA6p)#

Backup step }]b8]=h}/k(Zxg8]Mxg4F&\P2fZ)#

Backup active G/q(1/0)#

Checkpoint active G/q(1/0)#

}/k#

u?D10}?#

Checkpoint count TSt/*<DlicrE#

Checkpoint file write licD~4N}/k#

Checkpoint file read licD~AN}/k#

Est read samples @cLry>"BwCN}/k#

Sync repl msg forw 1>}]b:*"{"}/k#

Sync repl msg getr 1>}]b:SU={"&p}/k#

Sync repl msg exec 1>}]b:4P{"}/k#

Sync mast msg read w

}]b:{"AN}/k#

2 \m solidDB

5. Perfmon

Perfmon d? hv

Sync mast msg exec w}]b:{"4PN}/k#

Sync mast msg write w}]b:{"4N}/k#

Sync mast subs w}]b:"BN}/k#

Log flush (L) _-U>eVN}/k(}gd5)#

Log flush (P) omU>eVN}/k#

Log grpcommwkup id5=QN}/k#

Log flush full U>3fzeVN}/k#

F}w(x

)

Log wait flush }

Log writeq full rec U>4SPzsDU>4N}(TG<}F)#

Log writeq records 10U>4LrSPPDG<}#

Log writeq bytes U>4LrSPPDVZ}#

Log writeq pending bytes BNU>4LrSPeVDVZ}#

Log writeq add QmS=U>4LrSPDG<

Log writeq write SU>4LrSP4kU>D~DG<}#

Log writeq full byt (byte size) U>4SPzsDU>4N}(TVZF)#

HSB operation count w~qw/(z~qw:+dDU>G<}/k#

HSB commit count w~qw:d5G<}/k#

HSB packet count w~qw:{"}/k#

HSB flush count w~qw/(z~qw

HSB cached bytes w~qw/(z~qw:yZZfDU>:exD10s!(TVZ

HSB cached ops w~qw/(z~qw:yZZfDU>:exD10s!(TYw

ZH}U>YwDC'_LD10}?#

:{"eVN}/k#

F)#

}(U>G<})F)#

HSB flusher bytes T(z~qw*?jD"MSPPD HSB

HSB notsent bytes HSB U>PQ}[(}g,Z,=4FZd}[)"RP4"M=

(z~qwDVZ}#

HSB grouped acks (z~qw:&pi(om&p)D10}?#

HSB state 10 HSB 4,D{F#

HSB wait cpmes G/ q(1/0);w~ q w:} ZH} 4T( z~q wDl ic

HSB secondary queues (z~qw:]R&mDSPD10}?#

U>VZ}#

22 IBM solidDB: \m18O

5. Perfmon

Perfmon d? hv

HSB log reqcount HSB U>4ks}/k#

HSB log waitct HSB U>H}4ks}/k#

HSB log freespc HSB:Z-i0ZPPUdDU>Yw}#

HSB catchup reqcnt HSB:,=4F&\DU>4ks}/k#

HSB catchup waitcnt HSB:,=4F&\DU>H}4ks}/k#

F}w(x

)

HSB catchup freespc HSB:Z-i0ZPPUdD,=4F&\U>Yw

HSB alone freespc w~qw:(PRIMARY ALONE ==)ZBqU>PPUdDVZ

Thread count 10_L}#

Trans wait readlvl d51A6pDH}N}/k#

Lock ok I&x(ks}/k#

Lock timeout x(,1N}/k#

Lock deadlock @x}/k#

Lock deadlock check 4Px\mw@xliDN}#

Lock deadlock loop 4Px\mw@xli-7DN}#

Lock wait

Lock count x\mwPDx(}#

Dropped search buffers IZ9CD:ex}`xSyZELDmQwP}%DQw:ex

Number of search buffers yZELDmy9CDQw:exD10}?#

NOCHECK operations Q4PD NOCHECK YwDZ?}?#

x(H}}/k#

MME cur num of locks 10 IME x(}#

MME max num of locks TSt/sD IME x(}e

MME cur num of lock chains 10 IME "Pf"x}#

MME max num of lock chains TSt/sD IBM "Pf"x}e5#

MME longest lock chain path IME:n$"Pgv76#

MME mem used by tuples Vdx*iD IME Zf?(T'VZF)#

MME mem used by indexes Vdxw}D IME Zf?(T'VZF)#

MME mem used by page structs Vdx0Sa9D IME Zf?(T'VZF)#

MME inserts with x gate T%

b==4PDekYwD}?#}g,1ek}pw}ZcV

n1,ek+S2m==P;=%b==#

2 \m solidDB

5. Perfmon

Perfmon d? hv

Posted events queue P4;)'9CDQ"vB~D}?#

Index search both ,1Z Bonsai wMf"wP4PQw#

Index search storage vZf"wP4Pw}Qw#

B-tree node search keys DBE B wQwN}/k#

B-tree node search mismatch Q9C B wZcPD;%dw}Qwa944PQw#;%dw}

B-tree node build mismatch Z B wZcP9(KBD;%dw}Qwa9#;%dw}G;V

F}w(x

)

G;VQwa9,+Z B wZcPDC;C }i#bV;%dw}G;VtUD_T}]a9,CZT9uD |E"4PlY(h,TcZ B wZcPiR|;C#|"T+`

XDQwE"9u= 1 A 3 v&mw_Y:f3fP,Sx(}l YCJ&mw

Qwa9,+Z B wZcPDC;C9(;%dw};CD}i#

bV;%dw}G;VtUD_T}]a9,CZT9uD|E" 4PlY(h

wE"9u= 1 A 3 v&mw_Y:f3fP,Sx(}lYCJ &mw_Y:fP4E/Qw#

_Y:fP4E/Qw#

,TcZ B wZcPiR|;C#|"T+`XDQ

9(;%dw};CD

B-tree node split DBE B wZcVnN}/k#

B-tree node relocate QXBVd B wZc#ZZ;N|DtZH0licDi1

zbViv#(#,K5tzZlic.s#

B-tree node delete empty >}KUD B wZc#

B-tree node exclusive T B wxPK@<CJ#}g,ZZcVnivB,HgVnwy

1,I\a"zbViv#

B-tree key read S B wPA!K}#|5#

B-tree key read delete S B wPA!K>}jG

B-tree key read oldversion S B wPA!KIDPf>#

B-tree key read abort S B wPA!KQP9DBqDP#b|(yP4\I&jIDB

B-tree storage leaf len f"wD6SZcD=y$H#

B-tree storage index len f"wDw}ZcD=y$H#

B-tree bonsai leaf len Bonsai wD6SZcD=y$H#

B-tree bonsai index len Bonsai wDw}ZcD=y$H#

Bonsai-tree height 10 Bonsai w

B-tree lock node B wZcx(wCN}#

B-tree lock tree j{ B wx(wCN}#

B-tree lock full path B wj{Zc76x(wCN}#

B-tree lock partial path B w;j{Zc76x(wCN}#

B-tree get no lock B w^x(wCN}#

B-tree get shared lock B w2mx(wCN}#

_H(Tc}F)#

,+"

24 IBM solidDB: \m18O

5. Perfmon

Perfmon d? hv

Pessimistic gate wait H}yZELD/[mEDN}#

Merge gate wait H}O"EDN}#

Storage gate wait H}f"wEDN}#

Bonsai Gate wait H} Bonsai wEDN}#

Gate wait ZETsPfZH}iv#ETsG;VZ?,=zF#

Logreader spm reqcount U>DAwU>UdksN}/k#

F}w(x

)

Logreader spm waitct U>DAwU>U

Logreader spm freespc U>DAw:Z-i0ZPPICUdDU>Yw}#

Logreader logdata queue len U>DAw:}ZH}&mDU>G<i}#

Logreader record queue len U>DAw:}ZH}+%DU>G<}#

Logreader stmt queue len U>DAw:}ZH}xPodd5/XvDod}#

Logreader open cursors U>DA

Logreader records processed U>DAw:&mDU>G<}/k#

Logreader records sent U>DAw:*KxP+%x"MDU>G<}/k#

Logreader commits processed U>DAw:&mDd5ks}/k#

Logreader commits sent U>DAw:"M=+%LrDd5ks}/k#

Logreader messages sent U>DAw:CZ

Logreader catchup state U>DAw,=4F4,#

Logreader catchup queue len U>DAw:,=4FSPPDU>G<}#

w:T SYS_LOG r*DNj}#

dH}N}/k#

r*NjD=Q{"}/k#

Logreader catchup queue size U>DAw:,=4FSPDs!(TVZF)#

Logreader pending queue len U>DAw:ZfU>:exP&Z]R4,DU>G<}#

Logreader memcache queue len U>D

Logreader batch queue len U>DAw:QES*ZB;vzNP&mDYwD10}?#

Logreader flush batch full

Logreader flush batch force U>DAw:QSU>DAwPeU;j{DBqzN#

TS applied transactions

Aw:Zf_Y:fSPD$H(TYw}F)#

U>DAw:QSU>DAwPeUj{DBqzN#

solidDB w*?j}]f"w1 InfoSphere CDC 5}T solidDB & CDBq}#

zI4,(f

*4(PX solidDB D104,D(f,kZ solidDB SQL `-w(solsql)PdkT

B|n:

2 \m solidDB 25

XU solidDB

ADMIN COMMAND 'report report_filename'

K(fw*) solidDB Z?9C,bGr*,||,DE"*szG#j8Xmb solidDB DZ?E"#P1,RGaknUC'zIK(fTcxPJOoO#

>ZDZ]vJCZj< solidDB#g{z}Z9C_P4SbCJ&\D solidDB,G

4kND6solidDB 4SbCJC'8O7PD`&BZ#

zIT(}BP=(4XU solidDB:

S“solidDB 6LXF”r“solidDB SQL `-w”.`D&CLrPT`L==jIY

*K,k4PBP=h#

9C solidDB SQL `-w44PBfD=h 1-3 1,kdkj{D SQL o(,4

ADMIN COMMAND 'command_name'

(}g,ADMIN COMMAND ’close’)

*K@9k solidDB ("B,S,k(}dkTB|n4XU}]b:

"b,IT(}dkTB|n47zTO|nD'{:

open

(}dkTB|n,9 solidDB DyPC'Kv(10,S}b):

throwout all

"b,K|n;aH}Qr*DB

(}dkTB|n,#9 solidDB:

shutdown

qjI;|+P9"XvyPQr*DBq#

9C|,Ov+?wnD ADMIN COMMAND ’shutdown force″ |n#

Z Microsoft Windows 73P,R|%w~qw<j ,;sST>DK%P!qX

26 IBM solidDB: \m18O

4P8]MV4

(} Windows 53~q,9C“net stop”|nT6L==jIYw#"b,z9IT 9C“net start”|nT6L==t/ solidDB#

b)XUzFPD?VzF<+t/,;v}L,C}L+:fDyP}]4k}] bD~,ME_Y:fZf"nUU9~qwLr

#XU~qwD}LI\h*;!

N1d,bGr*,~qwXk+:fDyP}]SwZf4kEL#

8]CZ#$}]bD~Pf"DE"#g{}]bD~p5r_IZ53JOx*

',G4zITy]8]D~4V4}]b#*7#}]49Z53"zJO1`2 +^G,z&C(Z8]w}]b,PI\19&8]1>}]b#

solidDB w

Zf}f'V>X8]T0(}xgxP8](4xg8])#>X8]+z

I10_-}]b(I\I`vD~iI)D1>,4;v}]bD~#xg8]D

Yw``,,+;,.&ZZ,|(}xg+8]}]b"M=xg

8]~qw#

>ZhvgN8] solidDB Zf}]bT0S5 3JOV4#Kb,9a)KCZd

C"\mM`S8]YwD=(#*KbPX8]MV4w}]bT01>}]bD <r,kND solidDB Advanced Replication Guide#

4P>X8]

IT(}Z solsql PdkTB|n4t/>X8]:

ADMIN COMMAND 'backup [-s] [dir backup dir]'

backup |nDIC!n|(:

6. backup

!n hv

-s ,=4P#|nwC+Z8]jI15Xr_IZvmx5X#

dir backup dir G76mo=,CZ7(>XD~53PD8]?<#

|nD!n

g{!T8]?<,G4XkZ solid.ini dCD~P8(K?<#

g{ 8(D8] ?<; fZ, G4+ "z solidDB }

10030#PXKmsD|`E",kNDZ 169 3D=< D, :ms k;#

]b ms

IT(}ZdCD~D [General] ZPhCN} BackupDirectory 4a0hC8]?<#

*q!ICdCN}Dj{Pm,kNDZ 113 3D=< A, :~qwKdCN};#

2 \m solidDB 27

"b:

g{+=v}]b4F=,;v?<,G40;v}]b+;s;v}]b2G#

backup dir XkAYT?v}]b;,#"R,d;IT+}]bD~f"=4~qw OD;,?<MVx,+|G++<;4F=,;v8]?<#yT

]bD~Z8]?<P+"ze;#rK,TZ{F`,DD~xT,;Pns8] DGvD~Z8]?<PEP8]1>#

(}xg4P8]

zIT+xg8]|n"M=NNKP solidDB ~qwDwz#g]8]SU=G+D ~qw;F*“xg8]~qw”#

4Pxg8]

IT(}Z solsql PdkTB|n4t/xg8]:

ADMIN COMMAND 'netbackup [options] [DELETE_LOGS | KEEP_LOGS] [connect connect str] [dir backup dir]'

netbackup |nDIC!n|(:

7. netbackup

!n hv

|nD!n

,{F`,D}

-s ,=4P#|nwC+Zxg8]j I1 5Xr_ IZv m x5

connect connect str Gy>D,SV{., CZ8( k x g 8 ]~q w D ,

g{!T,SV{.,G4XkZ solid.ini dCD~P8(KV{ .#

dir backup dir G76mo=,CZ7(xg8

K76ITGxT76,2IT`TZxg8]y?<#

g{!T8]?<,G4XkZ solid.ini dCD~P8(K?<#

DELETE_LOGS >}4~qwPQ8]DU>D~#9C DELETE_LOGS D8]P

1;F*

KEEP_LOGS Z4~qwP#tQ8]DU>D~#9C KEEP_LOGS D8]P

1;F* DN} NetbackupDeleteLog hC*“No”#

j+8]

1>8]

#bG1!5#

#9CX|V KEEP_LOGS `1Z+ General Z

]~qwPD8]?<#

*Kbj{D,SV{.o(,kNDZ 42 3D:,SV{.Dq=;#*Kbj{ D ADMIN COMMAND o(,kNDZ 233 3D=< E, :solidDB ADMIN COM-

MAND o(;#

"b:

g{+=v}]b4F=,;v?<,G40;v}]b+;s;v}]b2G#} g,backup dir @6

28 IBM solidDB: \m18O

;&C8rxg8]~qwDy?<#

v Z Srv.At dCN}P,;'V ADMIN COMMAND 'netbackup' |n# v ADMIN COMMAND 'status netbackup' k ADMIN COMMAND 'status backup' H,,"

RHT>X8]2Txg8]xP(f#

v ADMIN COMMAND 'netbackuplist’ k ADMIN COMMAND 'backuplist' H,,"RHT

>X8]2Txg8]xP(f#

=fxg8]?<a99G]nxg8]?<a9?

xg8]~qw+"Mx|DyP}]bD~S*;v_-}]b,!\4}]bI \I`vf"Z;,?<T0;,@Cf"h8ODD~iI#1!ivB,xg8

]&\+4}]bDyPD~4F=%;?<,4,C'8(Dxg8]

+G,2ITw78(?<,8]D~D{FMs!+f"=xg8]~qwDD~

53P#*jIKNq,kZxg8]?<P4( backup.ini xg8]dCD~#xg 8]dCD~q- solidDB dCD~P [IndexFile] ZDo(#rK,}|,Z{T

|9|,`vPXD~{Ms!D8(5#}=o(gBy>:

[IndexFile] FileSpec_[1...N]=[path/]file name [maximum file size]

9CK` backup.ini D~Dxg8]~qw++k}]bw*{exPSU,;sy] backup.ini D~PD8(+C}]bVnI N v@"?~"+wv?~f"*D~#

a>:

?<#

#t4~qwD?<a9D;Vr%=(G,4F4~qwD solid.ini "+dX|{* backup.ini,

;s+dFAxg8]~qwPD8]?< # xg8]~qw+;A!

[IndexFile] ZPD FileSpec_[1...N] 8(5,4(`FD?<a9"+8]D~kd-< tT;pf"=xg8]~qw#

dCT0T/4P8]

TZ>X8]Mxg8],ITZ}]bdCD~PBHhC},=4PhC -s Tb DyPI!hC#IZdCN}D{FMo(k ADMIN COMMAND !n;,,rK

BmP>KN}k!n.dD`&dTX5#

CZ4P>X8]D`& ADMIN COMMAND !nMdC

m8.kCZ4P>X8]D

!n 5 solid.ini D [General] ZPDN}

dir backup dir BackupDirectory = backup dir

solid.ini

D~`T&DN}

1!5:;P1!5

CZ4Pxg8]D`& ADMIN COMMAND !nMdCN}

m9.kCZ4Pxg8]D

solid.ini

D~`T&DN}

!n 5 solid.ini D [General] ZPDN}

connect connect str NetBackupConnect = connect str

1!5:;P1!5

2 \m solidDB

m9.kCZ4Pxg8]D

!n 5 solid.ini D [General] ZPDN}

dir backup dir NetBackupDirectory = backup dir

netbackup DELETE_LOGS NetbackupDeleteLog = yes

netbackup KEEP_LOGS NetbackupDeleteLog = no

solid.ini

D~`T&DN}(x

)

1!5:;P1!5

1!5:Yes

*q!dCN}M ADMIN COMMAND !nDj{Pm,kVpNDZ 113 3D=< A, :~qwKdCN};MZ 233 3D=< E, :solidDB ADMIN COMMAND o

(;#

Z ADMIN COMMAND |nPdkD!n+2G solid.ini }]bdCD~P8(D`

&N}#

(}9C(1|n,ITT/4(8]#P |n;#

8]Zd"zDiv

>X8]Mxg8]Yw<a+XhDD~4F=C'8(D8]}]b,Sx4( @"x>m;BD}]b3q#

?v8]<+;vlicw*|DZ;nYw#b+7#I\DV4!I\TB8] *<#by,MITnsLHX

+QBPD~4F=8(D8]?<:

}]bD~;b)D~|,*4(licD}]b>m

U>D~;b)D~|,4(8]1&Zn/4,DBqywD|D

solmsg.out }]b{"D

XhD)

Xj8E",kNDZ 36 3D: dk(1

uLV4}LPYHO}D0v?V#1!ivB,

~(bG*KcZoOJb - ZV4Zd,{"D~;G

solid.ini dCD~;1!ivB9+4FKD~,bGr*,"zEL@#1,-< 1>I\a;F5(ZV4Zd,dCD~;GXhD)

;aT/4F solid.lic mI$D~#

30 IBM solidDB: \m18O

}]bD~D{F0dnss!I solid.ini dCD~P [IndexFile] ZPD FileSpec[1...N]

N}8(#U>D~D{FM;CIdCD~D [Logging] Z8(#

+U>D~4F=8]?<s,(#aS4~qwP+d>},bGr*|GQ;P

C#bG1!8]}L,

+G,zIT+|BBqZ;N1dZzIDyPU>D~<#tZ}]b~qw?

<P#}g,#tyPU>D~d;DQUd,+49z\;Zv9CU>D~Di vB(}XB4PyP|B47#}]bnB#K8]`M;

g{*9C1>8]&\,4,#tj{DU>D~z7G<,G49Xk7#;*

Zlic)2>}U>D~#*K,k7# solid.ini dCD~PD [General] Z4|, CheckpointDeleteLog=yes#

K}LF*

j+8]

1>8]

>X8]

4P>X8]1,+Q}]bMU>D~S}]b?<4F=ITS,;zwCJD C'8(8]?<#

g{C8]?<Q|,,{DD~,G4|G+;2G#g{8(D8]?<;f

Z,G48]Yw+'\,"RwC+5Xm

"b:

k7#8]?<M}]b?<k}]bD~Z;,Domh8T0;,DD~53 P#g{;vEL}/wp5,G4+*'}]bD~r8]D~,+;a,1*'

b=_#,y,49;vD~53"zJO,8]D~r

}]bD~2;a\0l#

xg8]

“xg8]”GCZZ3v6L;Cf"{v}]bD$_#KNq(} solidDB xg8 ]~qwjI,s_D&\G(}xgSU8]#;vxg8]~qwIT,1*` v8]4~qwa)~q#

k>X8]`F,D~+;4kxg8]~qw 8]?<|,,{DD~,G4|G+;2G#k>X8];,,g{8(D6L?

<;fZ,G4+T/4(C?<#

solidDB xg8]~qw*sxg8]DwC__P\m1X(#X(;cDC'IT

}9CI\m14(Df"}L44Pxg8]#ZbVivB,XkZ(CC'

(

4PC}L#

ITZ;,f>D~qw.d4Pxg8],+|GZxg8]=fXkf]#4U

-r,Bf>Dxg8]~qw\;*If>D4~qwa)

SU=xg8]ks1+li-if>"5X“;f]”ms#

PIC'8(D?<#g{?jxg

~q#Zd{ivB,

\mxg8]~qw

S V4.5 *<,?v solidDB }]b~qw9d1xg8]~qw #+G,zXkZ solid.ini dCD~D [Srv] ZPhC;vdCN}:

2 \m solidDB 31

NetBackupRootDir=netbackup root path

K76`TZ$w?<,"R1!5G$w?<#

zIT(}4P}#XUrPT0#f close M shutdown |n4XUxg8]~qw#

ADMIN COMMAND ’close’

;S\BDxg8]ks#

ADMIN COMMAND ’throwout all’

P9xPPD8]Yw#

ADMIN COMMAND ’shutdown″

XU~qw#

`SMXF8]

solidDB a)K;iCZ`SMXF8]D|n#z9ITZ solsql P9C ADMIN COMMAND o(4XF8]#

4~qwKD>X8]Mxg8]

(}Z solsql P9C ADMIN COMMAND -SQL )9,zITi/MXF8]}L# o(gBy>:

ADMIN COMMAND 'command'

dP,command ITGBmPDNN|n#

10.

ICD8]Mxg8]|n

>X8] xg8] hv

status backup status netbackup T>n|4PD8]}LD4,#

backuplist netbackuplist T>n|4PD8]}LD4,Pm#

info bcktime T>n|jID8]}LD1d#

abort backup abort netbackup !{xPPD8]}L#

i/yPQjID8]}L0dI&4,DPm

*i/yPQjID8]}L0dI&4,DPm,k9CTB|n:

ADMIN COMMAND ’backuplist’

32 IBM solidDB: \m18O

P9n/Dxg8]Yw

*P9n/Dxg8]Yw,k9CTB|n:

ADMIN COMMAND ’abort netbackup’

|}'\D8]

1 solidDB 4P8](>X8]rxg8])1,|n

ADMIN COMMAND 'status [backup | netbackup]'

+ 5 X5 “ACTIVE”#1 ! !n G backup# ; )j I8] ,K | nM +5 X “OK”r“FAILED”#

g{8]'\,G4zITZ}]b?<PD solmsg.out D~PR=hv'\-rDm s{"#k|}ms-r,;sYN"T#

4P8]1DdMJb

8]i JDELUd;c

rK,k7#8]f"h8Pc;DELUd#

8]? <D76^'

}g,g{~qwKP UNIX Yw53,G476Vt{XkG1\,x;\G41 \#

>X8 ]?<;fZ

Yw+'\#g{(Z4P8]Yw,G4IT(} solmsg.out D~47#8]I&#

>X8 ]?<k}]bD?< `,

#td-<{F,rK9C`,D4M?j?<+<BD~2me;#

solidDB

DivB"Tt/xg8]+<Bxg8]Yw'\#

V48]

(}4UTB8>E"4PYw,IT+}]bV4=4(8]1|y&D4,#K b,(}9C4(8]szIDU>D~,9IT+8]}]b|B=104,#G

)U>D~|,PXON4P8]sekr|BD}]DE"#

<8*V4Dxg8]D~

ZITy]6L8]D~4V4}]b.0,I\Xk4P=v$8=h#

#4(8]1,+h*ky8]}]b`,DELUd?#

#zdkD8]?<Z~qwYw53PXkGP'D76{#

#8(;fZD8]?<+<B~qwr!ms{","R8]

#IZ8]Yw+Q}]bD~4F=?j?<"

xg8]~qwZ8(D;C;fZ

#Z4}7hC solidDB xg8]~qw

g{49C backup.ini,G4XkS solid.db D~V4}] bD~D-<{FMs

Xk+yP8]D~4F=4PV4DZc#

}b)=hTb,V4xg8]k

V4>X8]`F#

2 \m solidDB 33

9-*ON8]D4,

g{ solidDB }ZKP,G4+dXU#

>} U >D ~?< P Dy PU >D~ # 1! U > D~{ G sol00001.log M sol00002.log,HH#

+}]bD~S8]?<4F=}]bD~?<#

t/ solidDB#

r*;fZNNU>D~,yTK=(;a4PNNV4Yw

y]8]+}]b|B=104,

g{ solidDB }ZKP,G4+dXU#

+}]bD~S8]?<4F=}]b?<#

+U>D~S8]?<4F=U>?<#g{b=v?<PfZ`,DU>D~, G4k;*CI8]U>D~42GBU>D~#

t/ solidDB#

solidDB +

T/9CU>D~44P0vV4#

Sl#XUV4

g{~qwQl#XU,4,g{|;G9CH0hvD}LXUD,G4 solidDB Z BNt/Zd+T/9CU>D~44P0vV4#z;h*4P\m}L4t/V

4Yw#

BqU>G<

BqU>G<&\7#53"zJO1;a*'NNQd5DYw#Z~qwP4P Yw1,CYw9+;#f=BqU>D~#CU>D~CZZ~qwl#XUs4

PV4#

2P=V;,DU>G<==:

y5=(

34 IBM solidDB: \m18O

4(lic

K=(9CU>D~Pn|VdD=vELi44,;v;j{_-ELiD=v nBf>#y5=(Zb=vi.dxPP;,1=;vidz*9#

2G=(

K=(Z?N4Pd51X4;j{Di,1=|dz*9#g{\;P\ns; vU>D~ELiPD}]*'bViv,G4IT9CK=(#

solidDB Jmzv(Gq*9CU>G<&\#g{9CU>G<&\,G4IT+l

#XUD

;\+}]bV4=8]4,#1!ivB,BqU>G<&\&ZtC4,#g{ ;h*4Pj+BqV4Yw,G4IT+U>G<&\{C#*jI [Logging] ZPD LogEnabled N}hC*“No”#

U>G<YwITIC,===rl===xP,b!vZBqMCThC#PXB qMCTD|`E",kNDZ 77 3D5 B, :T\w{;PD“U>G<kBqMCT

”SZ#

licCZ|BELOD}]bD~#_exT,lic+}]b~qwDZf_Y

:fPD3f4F=EL}/wOD}]bD~#~qw4UZBq=f;BD== 4P4F;;xT.,|v4FQd5DBqDa{#rK,}

]<GQjIDBqyd5D}]#49~qwZ=vlic.d"zJO,EL} /w2+|,C}]D;BxP'DlU(!\;;(GnBlU)#

}]bV4=|GZJO"z1y&D4,#g{{CU>G<&\,G4

KNq,k+

]bD~PDyP}

Zlic.d,~qw+Qd5DBq4kBqU>#

ITy]KBqU>4V4NNZO;vlic.sd5DBq#53@#s,}] b+*<y]nBlicV4Bq#

ZEnO,zIT+lickqITELO}]bD~4PDw*4Yw#~qw

a+?v INSERT/UPDATE/DELETE odDa{(uA?vBqDa{)ZCa{v V14kEL;xG,~qw+Qd5DBqw*ZfP-}|BD3fxP[},

"R;ZlicZd+|G4kEL#(~qw9ITZ~qw_Y:fgv1+} bD~DdP;?VCw;;Ud#ZbVivB,~qw9+4}]bD~#)

Z}]bYw.0T0.s,zI\kTV/==4(lic#*(}LrjIKN

q,kZ&CLrP"vTB SQL |n:

ADMIN COMMAND ’makecp’

(4(lic )#Kb,

",kNDZ 36 3D:dk(1|n;#

solidDB P;vT/lic4(X$Lr,s_+ZU>D~;4X(N}s4(li

c#PXXFlic5JD|`E",kNDZ 88 3D

lic2JCZ@CZfm,x;vvJCZyZELDm#

9IT9C( 14PD|n4?F4(lic#PXj8E

g{~qw"zJO,G4z

;

]

:w{lic;#

2 \m solidDB 35

Z}]bP,?N;\P;vlic#I&4(Blic.s,Ilic+;T/A }#g{~qwxLZlic4(}LPU9,G4+9CH0lic44PV4#

XU}]b

licI\*s4Ps?D I/O Yw,rKZlic"zZd,~q \0l#PX|`j8E",kNDZ 88 3D:w{lic;#

zITXU}]b,bb6E;JmTC}]b("B,S#*jIKNq,kZ

solidDB SQL `-w(solsql)P"vTB|n:

ADMIN COMMAND ’close’;

1zk*@9C',S=}]b1,IT9C close |n#}g,ZXU solidDB 1, Xk@9BC',S=}]b#ZXU

D}L,kNDZ 26 3D:XU solidDB;#

XU}]bs,+;S\4T“solidDB 6LXF”D,S#XU}]b";a0lVPD

C',S#XU}]bs,+;S\NNB,S(M'z+SU= solidDB ms{"

14506

*7z close |nD'{,k9CTB|n:

ADMIN COMMAND ’open’;

}LP,k9C close |n#*KbXU}]b

wDitHI\a

Z;(FczOKP`v~qw

Z3)ivB,zI\kZ;(FczOKP=vr|`v}]b#}g,zI\h *;VZ,;(FczOKPzz}]bMbT}]bDdC#

solidDB \;Z?v}]b~qwPa);v}]b,+zITt/`v}f"C?v }f9C

<Pt/}fxL,r_(}9C|nP!n -c directory_name |D$w?<48(d CD~D;C#kG!,?v}]b&C9C;,Dxgl}{#

T:D}]bD~#*Cb)}f9C;,D}]b,kS}]byZD?

dk(1|n

solidDB |,ZCDF1w,bJmzT/4P\mNq#zIT9C(1|n44P

53|n,IT4(8]"licM}]b4,(f,"ITr*MXU}]bT0

O*C'D,S"XU~qw#

*dk(1|n,k`- solid.ini D~P

At = At_string

At_string ::= timed_command [, timed_command] timed_command ::= [ day ] HH:MM command argument day ::= sun | mon | tue | wed | thu | fri | sat

g{48(UZ,G4C|n+?l4P;N#

[Srv] ZD At N}#o(*:

>}:

[Srv] At = 20:30 makecp, 21:00 backup, sun 23:00 shutdown

36 IBM solidDB: \m18O

9CDq=* HH:MM(24 !1q=)#

BmP>KP'D|n:

11.

;,(1|nDTd?M1!5

|n Td? 1!5

backup 8]?< dCD~PhCD1!8]?<

throwout C'{r all ;P1!5,Td?GXhD

makecp ;PTd? ;P1!5

shutdown ;PTd? ;P1!5

report (fD~{;P1!5,Td?GXhD

system 53|n ;P1!5

open ;PTd

close ;PTd? ;P1!5

? ;P1!5

9u}]bD~

24G}]bXi?

solidDB ~qw\;fE}]bDvsxVdBDEL3f#+G,|;aME}]b D~PH0VdDUd,49;Yh*CUd`gK#xG,|,$49CD3fD

PmT)+49C#+G,Z3)&CLrP,Z}]bUd9C?= L]De5,Sx<BVds?ELUd#g{bVe5iv\1{,G4I\Ph

*+49CDUd5X=D~53#}]bD~Xi&\DC>4gK#

}]bXi&\gN$w?

105VJmTQz==Z3f64P}]bD ~9u#“Qz”b6Ey9uD}] bD~;I)~qw9C#“3f6”b6Ev SD~PV4M}%U3f#;4P3

fd9u,4,;Z3f.dF/}]#

"b,9CK& ^(V4KKP2^(V4}]bD~#*K$@K`JO,kZt/XiYw04

(}]b8]#

\1,XiYw;IV4#g{KPXiZd"zJO,G4TsH

fI\avV

}]bXi|nP!n

UPrS(f

solid -x infodbfreefactor

2 \m solidDB 37

a)PX}]bPDIC3f}"ICUd?(T'VZF)T0ICUdy<YV

H5D(f#+(fr!= ssdebug.log MXF(.s,solidDB xL+5XI&5X 5#

solid -x reorganize

wC}]bXiYw#KYw+3fFA}]bD~PNN49CD[#3fX(; jIs,49CDUd+;MEX=D~53;4,D~;XO,4(Blic, solidDB xLU9"5XI&5Xk#yKPDXiD(f+;4k ssdebug.log D

PXd{(}|nP!nwCD5CLrDE",kNDZ 165 3D=< C, :solidDB |nP!n;#

T}]bxPS\

IT9CTF\?}]S\=(T}]b3fxPS\#K&\ICZ#$tP}] ;aIZh8'Tx9)#IZvZ\F,>z7v=x;6u DES(%; DES)c

(#g{&CLrT2+TPOqD*s,G4(iz;*9CKc(#

tCS\

t/~qw1,IT9C|nP!n -E M -S 4JmT{v}]bxPS\#g{9 CD}]b4-S\,G4 -E !n+wC}]bS\&\#-S !nCZ#$TFS\

\?#

#$S\\?

TFS\\?f"Z}]bD~D4-S\D73P#*#$TFS\\?,Xk9 C -S !nr(} -x startpwdfile 48(t/\k#g{8(K -E,G4t/\kGX

hD#g{8(KK\k,G4n!$HG 3 vV{#z2IT!q8(U\k, 9S\\?&Z4\#$4,#

4(-}S\D}]b

IT9C -E M -S !n44(-}S\D}]b,gBy>:

solid -E -S <startup password>

|2+D=(G9C -E M -x keypwdfile:<filename> !n#

solid -E -x keypwdfile:<filename>

t/-}S\D}]b

*t/-}S\DVP}]b,Xk9C -S !n#qr,~qw+a>C'dkt/ \k#

zIT9C|nP!n48(t/\k,gBy>:

solid -S <startup password>

Kb,2IT9CD~M!n:

solid -x keypwdfile:<filename>

38 IBM solidDB: \m18O

k9C -x keypwdfile !n4zf!n -S#Zs`}53O,Z|nPP9C\k";

2+#}g,Z UNIX 53P,d{C'I\aZ ps |ndvP4=\k#|nP! n -S vJCZwTr@@C>#

|DS\\?D\k

*|DS\\?D\k,t/~qw1Xk8(!n -E,"RXk9C -S !n48(

I\kMB\k,gBy>:

solid -E -S <old password> -S <new password>

(iz9Cm;V=(4|Dt/\k,4,9C -x keypwdfile 48(\kD~=N:

solid -E -x keypwdfile:<old key filename> -x keypwdfile:<new key filename>

*XUS\\?#$&\,IT+\kf;*U\k#

T}]bxPb\

IT9C!n -x decrypt T}]bxPb\#*T}]bD~xPb\,Xka)t/ \k:

solid -x decrypt -S <password>

solid -x decrypt -x keypwdfile:< filename>

S\i/

3)&CLr53;JmZ4-S\DD~Pf"}]#&CLrITZ4P"aB

1>.`DYw0li}]b}]D2+6p#*jIKNq,k9CTB/}:

database_encryption_level()

d5X5*:

0 - 4S\

1 - QS\,\?4\#$(U\k)

2 - Q

3 - QS\,9C(FS\=((v^ZSYw)

}]b8]Mxg8]9C,;vS\\?M\k44(-}S\D}]b1>#

S\,\?\m;vt/\k#$

HSB

HSB w?"G(}}]bD~S\&\xPS\#*#$ HSB w?,h*9Cd{2

+T=(#

2 \m solidDB 39

SYw

4P HSB 4Frxg4F1,+TS\N=+d}]bD~MU>,T\bTb)D ~xP_`DS\/b\#Zm[O,ITC HSB ~qwT9C;,DS\\?(uA

9C;,Dc(),+byv";I!#(iD}LG,WHTw}]b ;sTd4P4Frxg4F#

“SYw”API (};vCZhC(FS\c(DSZxP)9#/} SSCSetCipher * SYwhC&CLra)DS\Mb\/}#zXkZ9C SSCStartServer t/~qw

0wCK/}#

void SSC_CALL SSCSetCipher(

void* cipher, char* (SSC_CALL *encrypt)(void *cipher, int page_no, char *page,

int n, size_t pagesize),

int (SSC_CALL *decrypt)(void *cipher, int page_no, char *page,

int n, size_t pagesize));

cipher - cipher }C&CLra)D2+OBD(\kTs),}gS\\k#bvN

}+;+]Xx&CLra)DS\/b\/}#

encrypt - S\/}#5Xd3fN}#

decrypt - b\/}#5X;vGc5,r_~qwKv"5X“\k;%d”ms#

page_no - }ZS\/b\D3fD`E#&CLrPI\vTKN},KN}2I\

;Cw=SDS\/b\N}#

xPS\,

page - K8k8r&CLr/}*S\/b\Dxr#

n - *S\/b\D3f}#

pagesize - *S\/b\D3fDs!#

T\0l

9C-}S\D}]ba0l4PA4Yw1D}]b~qwT\#TAYwDT\ 0lw*I_Y:f|PJ7(,g{_Y:f|PJO_,G4mw0l";T

TZekM|BYwxT,~qw<UTU>D~(g{9CK S\Mb\,ZbVivB,T\0lI\HOwT#

U>D~D0)xP

40 IBM solidDB: \m18O

3 dC solidDB

>BhvgNdC solidDB TzczD73"T\MYwh*#>BTnX*DN}0 dhCwK{v#PXgN9C solidDB 6LXF(solcon)r SQL `-w(solsql)

4i4MhCN}5Dpv=h8>E",kNDZ 48 3D:\m~qwKN};#

g{z}Z9C_P4SbCJ&\D solidDB,G4kND6solidDB 4SbCJC'

8O7TKb|`PX4SbCJ&\yXPDN}DE"#

g{z}Z9CxP“H8C”i~D solidDB,G4kND6solidDB _ICTC'8 O7TKbP

dCD~MN}hC

solidDB S solid.ini D~Pq!|Ds`}dCE"#|7PX5,d5P=v;,D solid.ini dCD~,;v;Z~qwO,m;v;ZM'K#b=vdCD~<;GX hD#g{;PdCD~,G4+9Cv'5#b=v solid.ini dCD~Vp|,M'

KM~qwDdCN}#g{9CK ODBC }/Lr,G4+9CM'KdCD~, "RKD~XkZ&CLrD$w?<P#

X“H8C”yXPDN}DE"#

Z solidDB D5P,T solid.ini D~D}C(#G8~qwKD solid.ini D~#

1 solidDB t/1,|WH+"TS SOLIDDIR 73d?hC

D~#g{ZKd?8(D76PR;=KD~,G4~qwrM'K+"TS10 $w?<Pr*KD~#(10$w?<(#MGzSdPt/ solidDB ~qwr_M

'z&CLrD?<#)zIT9C -c ~qw|nP! |nP!nD|`E",kND6solidDB \m8O7PD:=< B,solidDB |nP

!n;#

dCD~|, solidDB N}DhC#g{Z solid.ini D~P4hCX(N}D5,G4 solidDB +9CKN}Dv'5#v'5I\!vZz9

(#,v'5a)K<CDT\MIYwT,+GZ3)ivB,^D3)N}5I

Ta_T\#

IT(}Z solid.ini D~PhCN}{/5T4^DdC#}g,*8(~qwDxgX 7,I9CN}{ Listen MJ1D5,}g:

Listen=tcp 192.168.255.1 1315

bm>1~qwl}M'zks1,|&19C TCP/IP -i"xgX7 192.168.255.1 MKZE 1315 4l}M'zks#

n48(m;v$w?<#PX

CDYw53#

D?<Pr* solid.ini

b)N}4UKdCD~PDZ`pxPVi#kND6solidDB \m8O7PD:=

< A,~qwKdCN};M:=< B,M'KdCN};,Tq!XZZ`pMyP ICN}DEv#

?vZ`p<T;vC=(E(p4DZ{*7

[com]

[com] b ; Z P > ( EE" # " b , Z { ; x V s !4# Z { “[COM]”"“[Com]”M“[com]”H,#

BfG~qwK solid.ini dCD~D;vy>Z:

[IndexFile] FileSpec_1=C:\soldb\solid1.db 1000M CacheSize=64M

nX*DM'zKN}

>ZhvnX*D solidDB M'zKN}0d1!hC#

(exg{(Com Z)

M'z&CLr9Cxg{48(k~qwxP(E1*9CD-iT0*,S=D ~qw#

Connect N}

[Com] ZPD Connect N}(eM'zk~qwxP(E1*,S=D1!xg{(, SV{.)#;vyO,IZM'z&Ck~qwyl}Dxg{*5,yTM'zO

D Connect N}5&Ck~qwOD Listen N}5%d#

,}g:

1!5SYw53x(#kNDZ 93

TB connect Pf*M'z9C TCP/IP -iT0~qwKZE“1313”k{*“spiff”D Fcz*5,Sxk~qwxP(E#

[Com] connect = tcpip spiff 1313

1&CLr9C solidDB ODBC }/Lr1,+9C ODBC }]4{F,rK Con- nect ;pwC#

"b,Z [HotStandby] M [Synchronizer] ZP,9CK`FD connect N}Z solidDB ~qw.dtC,S#PXb)N}Dhv,kND6solidDB _ICTC'8O7M

solidDB Advanced Replication Guide#

3D6 B, :\mxg,S;#

,SV{.Dq=

yPl}dCN}T0 ODBC Ma?6M'z&CLrP9CD,SV{.<IC, ;V,SV{.q=#

,SV{.q=gBy>:

protocol_name [options][server_name][port_number]

dP,options ITGNb}?DBP!n:

42 IBM solidDB: \m18O

12.

,SV{.!n

!n ,e

-z TK,StC}]9u&\

-c milliseconds 8(G <,1(1!5fYw53D;,xPyd/)#Z8(D

1d}s,G<ks+'\#":vJCZ TCP -i#

-r milliseconds 8(,S(rA),1(1!5G 60 k)#g{Z8(D1dZ4

U=NNl&,G4xgks+'\#5 0 +,1hC*^^#

":vJCZ TCP -i#

>}:

tcp localhost 1315 tcp 1315 tcp -z -c1000 1315 nmpipe host22 SOLID

Trace N}

g{+ Trace N}D1!hCI No |D* Yes,G4 solidDB a*<+PXQ(" Dxg,SDxg{"zYE"G<=1!zYD~r_ TraceFile N}y8(DD~#

TraceFile N}

g{ Trace N}hC* Yes,G4xg{"zYE"+;4k TraceFile N}y8(D D~#g{48(D~{,G4~qw+9C1!D~ soltrace.out,s_+;4k~q

wrM'zD10$w?<,b!vZZD;Kt/zY#

nX*D~qwKN}

>ZhvnX*D solidDB ~qwKN}0d1!hC#

(exg{(Com Z)

~qwt/1,|+*<9Cxg{4l};Vr`V-i(xg{9~qwZxg PkZ;,)#M'z&CLr9C`FDxg{48(*9CD-iT0*,S=D

~qw#

Listen N}

[Com] ZPD Listen N}(e~qwDxg{;bG solidDB ~qw*<l}xg1 9CD-iM{F#M'zxL9CKxg{k~qwxP(E#1!5SYw53 x(#PXN}q=Dj8E",kNDZ 93 3D6 B, :\mxg,S;#

[Com] Listen = tcpip localhost 1313

\m}]bD~M_Y:f(IndexFile Z)

Z solidDB P,}]Mw}f"Z,;vD~P#uo“w}D~”kuo“}]bD~” G,eJ#Z solid.ini D~P,IndexFile Z|,DN}8(CZf"}]bDD~D{

FM;C#solid.ini D IndexFile Z9XFk_Y:f`XDN}#

3 dC solidDB 43

FileSpec_[1...N] N}

FileSpec N}hvw}D~(}]bD~)D;CMnss!#*(e;CMnss!, FileSpec N}S\Bfb}vTd?:

v }]bD~{

v nsD~s!

v h8E(I!)

[IndexFile]

FileSpec_1=SOLID.DB 2000M

KN}D1!5G:

solid.db 2147483647

(`1ZTVZm>D 2 GB-1)

s!%;G 1 VZ#zIT9C K M M %;{E4Vpm>'VZMWVZ#ns D~s!G (4G-1)*is!#TZ1!D 8KB is!,b+G 32TB - 1#

FileSpec N}9ITCZ+}]bD~.V*`vD~

"f"Z`vELO#*+}]

b.V*`vD~,k8(I}V 2 j6Dm;v FileSpec N}#w}D~Zs!, vZ;v FileSpec N}y8(Dns51,+;4kZ~vD~#

ZTB>}P,N}Z}]bD~s!,v 1GB(1073741824 VZ).s+d

Vn=

EL C:"D: M E:#K>}49CI!Dh8E#

[IndexFile] FileSpec_1=C:\soldb\solid.1 1000M FileSpec_2=D:\soldb\solid.2 1000M FileSpec_3=E:\soldb\solid.3 1000M

dkDw}D~;CZ~qwDYw53PXkGP'D76{#}g,g{~qw KP UNIX Yw53,G476Vt{XkG1\,x;\G41\#

d;}]bD~$tZ;,D?<P,+D~{Xk(;#ZTO>}P,

;,Dh

8E8> C:"D: M E: Vx$tZ;,DELO#

TZIT9CD}]bD~},;P5JD^F#

+}]bD~Vn=`vELPzZa_~qwDT\,bGr*,`vEL7+a )T}]b}]D"PCJ#

"b,g

4(D}]bD~Ds!,G4zI\h*+`vD~f"Z%;ELO#

g{+}]bD~Vn=`vomEL,G4`_L solidDB M\;T?vh88(; v;

`j8E",kNDZ 7 3D:_L`M;PD:(C_L;;B#

ITT?v}]D~8(DI!“h8E”Tc oz~qwa_T\#"b,5Jh8 EvCZT?vomh88(@XD`E;h8E;Pd{C>,}g8>f"h8 D7F"MErXw#

44 IBM solidDB: \m18O

{omELVx*`v_-EL"R;PNN%;_-EL\;]IzZ{

,DEL I/O _L#by,~qwM\;T"P==4P}]bD~ I/O#PX|

g{+;,D~f"Z,;omh8O,G4kTG)D~PD?;v9C,;vh 8E#}g,Y(FczKP Microsoft Windows "RP=vomEL}/w#Z;v

omEL}/wG C:#Z~vomEL}/wVx*=v_-EL}/w,4 D:

E:#g{Z C:"D: M E: Owf";v}]D~,G4 solid.ini D~I\`FZ:

FileSpec_1=C:\soldb\solid.1 1000M 1 FileSpec_2=D:\soldb\solid.2 1000M 2 FileSpec_3=E:\soldb\solid.3 1000M 2

Z>}P,FileSpec_2 M FileSpec_3 9C`,Domh8(!\h8{ D: k E: ; ,),rK|G;8(,;vh8E#CZh8ED5J5(C: 9C 1,D: 9C 2,E:

9C 2)GNbD,|;PNN,e#

g{}]bo= FileSpec N}y8(Dnss!,G4zI

Tvs^F#z;hXU~

qw,vss!VN,;sXBt/~qw#IT(}bV=(4vss!,+;\

"T(}bV=(4u!s!#

"b:

k;*"T9C FileSpec N}4u!}]bDs!;byvP*'$HfZD}]" <B}]bp

5DgU#

CacheSize

CacheSize N}(eCZ,$EL}]bD2m:eXDwZf?#K:eX;F*}

]b_Y:f#v'5!vZ~qwYw53#TZ?Zf}]bYwxT,_Y: fs!;),v 8MB,kG)YwMy>;`X#xTn!s!G 512 'VZ#}

[IndexFile] CacheSize=512

s!%;GVZ#2IT9CWVZ*%;48(Ud?,}g,“10M”m> 10 WV Z#d; solidDB \;Z_Y:fs!O!DivBKP,+OsD_Y:f(#\;

a_~qwYH#yhD_Y:fs!!vZ}]bs!"y,SDC'} qw4PDYwDTJ#

1!_Y:fs!G 32 MB#

T0T~

8(>X8]?<(General Z)

}]b"U>D~MdCD~ solid.ini D8]+;4F=>X8]?<#C?<Xkf

Z"RXkPc;DELUd4f"8]D~,bGr*,;v}]bDyP}]b D~+;4F=,;v?<#zIT+dhC*} solidDB }]bD~?<

?<r$w?<TbDNNVP?<#

BackupDirectory N}

[General] ZPD BackupDirectory N}CZ(e8]?<D{FM;C#"b,1!5 “backup”G`TZ solidDB $w?<D?<#}g,g{KN}*:

[General] BackupDirectory=backup

G48]+;4k solidDB ?<D;vS?<#

"U>D~

3 dC solidDB 45

dkD8]?<XkG~qwDYw53PDP'76{#}g,g{~qwKP UNIX Yw53,G476Vt{XkG1\,x;\G41\#

8(xg8]?<(General Z)

b)N}hCxg8]~qwPCZf"8]D~"U>D~MdCD~D?j? <#g{6L?<;fZ,G4PI\1+4(C?<#

4KN}

4~qwPD

[General] NetBackupDirectory=netbackupdir

N}hC6L?<,Tc9Cxg8]&\#netbackupdir r_GxT?<,r_`T Zxg8]~qwDy?<#

xg8]~qwKN}

xg8]~qwPDN}

[Srv] NetBackupRootDir=netbackup root dir

9C`TZy8( NetBackupDirectory D76mo=TyPxg8]YwhCy?<# netbackup root dir ITGxT?<,2IT`TZ$w?<#

*c:

1!ivB,xg4F&\+|,`vD~D_-}]b4F= NetBackupDirectory P D;v=fD~# zIT(e`v*Zx ~,Tzf+a9=L*;vD~#+4}]bD~3d=`v8]}]bD~b;

Nq(} backup.ini D~jI#

*7#Qd5DBqDMCT,Bqa{+ZBqd51;"44ky8(?<PD

~#zXk9C>XEL{+KD~f"=>X}/w,T\bxg I/O Jb"

;vD

a_T\#1!U>D~?<G solidDB $w?<#

g8]}LP+4}]bD~3d=DD

FileNameTemplate

Logging ZPD FileNameTemplate N}(eBqU>D~DD~{a9#}g,TBh C:

[Logging] FileNameTemplate = d:\logdir\sol#####.log

8> solidDB Z?< d:\logdir P4(U>D~"S sol00001.log *<43rTU>D ~xP|{#

+U>D~k}]bD~EZ;,DomELOITa_T\#

2IT(}+ FileNameTemplate N}k LogDir N}dO9C49lD~{,ZbV ivB,LogDir N}(eD~{D PX8>E",kNDZ 138 3D:Logging Z;#

46 IBM solidDB: \m18O

?<0:,FileNameTemplate N}(e5JD~{#

8(CZb?Erwc(D?<(Sorter Z)

b?Erwc(CZTwZfP0;BDNq4PEr#g{ZdCD~P8(K TmpDir_[1...N] N},G4+tCb?Erwc(#b?ErYw9CDyPY1D~

<+Z8(D?<P4("T/>}#

"b,“b?Er”;vh*ELUd,

P [Sorter] ZD MaxMemPerSort M MaxCacheUsePercent N}4dCy*9CDns ELUd?#

9h*ZfUd#zIT(}hC solid.ini D~

TmpDir_[1...N]

Sorter ZPD TmpDir[1-N] N}(eITIb?Erw9CD?<#;P1!hC#} g:

[Sorter] TmpDir_1=c:\soldb\temp.1 TmpDir_2=d:\soldb\temp.2 TmpDir_3=g:\soldb\temp.3

*Ka_T\,Xk9C>XEL{+b)D~f"=>X}/w,T\b4Pxg I/O#"b,g{4(eY1?<,G4I\a<Bi/T\;Q#

hCCZ4P&mD_L}(Srv Z)

}K(E"I/O MU>\mw_LTb,solidDB 9ITt/(CD$wLr_L,Tc Z~qwDNq53P4PC'Nq#PX|`j8E",kNDZ 7 3D:` _L

&m;#

nED_L}!vZ53P20D&mw}#(#,?v&mw

'Jn_#

KP 2 = 8 v_L1,

zXkxPTiE\7(Zzy9C2~MYw53O\;a)nQT\D5#nC

STB+=kV:

_L} =(2x&mw})+1

Threads

[Srv] ZPD Threads N}(e solidDB y9CD(C$wLr_LD}?#}g:

[Srv] Threads=9

hC SQL zY6p(SQL Z)

“SQL E"”$_JmzT SQL bvwME/w8(zY6p#PX?V6pDj8E ",kND6solidDB SQL 8O7#

Info

(}+dCD~P [SQL] ZD Info N}hC*Gc5,ITtC“SQL E"”$_#d

v+4k solidDB ?<P{* soltrace.out DD~#

KN}+Tx0l~qwT\,rK;&CCZJOoOC>#(#,KN}CZV v;vr`vX(i/DT\#TZ;cD

j<D solidDB `S&\#

&CLr SQL }]bzYxT,nC!q

3 dC solidDB 47

8(xg(EzY(Com Z)

(EzY$_GXhD,}g,1xg2~D$w;}#1,Mh*9CK$_#( }r*zY&\,(EcM\;G<ms(uAG53yXPDms),"IToz

oOxgPD5JJb#PXj8E",kNDZ 105 3D:xgz N}XFxgzYE"Ddv#

Trace

g{+ Trace N}D1!hCI No |D* Yes,G4 solidDB a*<+PXyPQ ("Dxg,SDxg{"zYE"G<=1!zYD~r_ TraceFile N}y8(D

D~#

TraceFile

g{ Trace N}hC* Yes,G4xg{"zYE"+;4k TraceFile N}y8(D D~#g{48(D~{,G4~qw+9C1!D~ soltrace.out,s_+;4k~q

wrM'zD10$w?<,b!vZZD;Kt/zY#

\m~qwKN}

zIT(}BP==4i4M^D solidDB N}T0|GD5:

v Z solidDB SQL `-w(g+rV$_)PdkBP|n:

Y$_;#BP

ADMIN COMMAND ’parameter’

ADMIN COMMAND ’describe parameter’

v 1S`- solidDB ?<PD solid.ini D~#

sxBZ|,PX\m ADMIN COMMAND M solid.ini DN}D8>E"#

": PXvi4MhC~qw(E-iN}D

18O7PD:\mxg,S;;Z#

j8E",kND6IBM solidDB \m

9C ADMIN COMMAND 4i4MhCN}

hz ADMIN COMMAND,IT(} solidDB ~qwT6L==|DN},x^hX Bt/~qw#yPN}<ICJ,49|GZ solid.ini dCD~P;fZ`gK#g

{N};fZ,G4+9Cv'5#

i4N}

IT(}4PTB|nqCm`N}PDdP;vN}DEv:

ADMIN COMMAND 'parameter [-r] [section_name[.parameter_name]]';

dP:

-r !nm>;P105GXhD

48 IBM solidDB: \m18O

section_name GKN}Z solid.ini Pyt`pD{F

*i4yPN},kZ solidDB SQL `-w(g+rV$_)PdkTB|n:

ADMIN COMMAND ’parameter’;

+5XyP_P

105"1!5Mv'5

DN}DPm#IT(}mSZ{+i4D

N}^ZX(Z,}g:

ADMIN COMMAND 'parameter logging';

IT(}8(j{N}{4i4k%vN}`XD5,}g:

admin command 'parameter logging.durabilitylevel';

RC TEXT

-- ---0 Logging DurabilityLevel322

1 rows fetched.

+4TB3rT>Ov}v5:

105

~qwt/19CD

t/5

z7P$HhCD

v'5

g{z8bD0,9IT9C -r !n4^(K|nTcvT>105#}g:

ADMIN COMMAND ’parameter -r’;

i4X(N}Dhv

z9ITi4X(N}D|j8hv,dP|(P'N}`MMCJ==#KE"\ PC,HdG,zI\h*T/,==&mN};;,Dz7"=(r"PfI\_ P;,DN}'V#

*i43vN}Dhv,k9C solidDB SQL `-w(g+r

ADMIN COMMAND 'describe parameter [section_name[.parameter_name]]';

%vN}Da{/gBy>:

admin command 'describe parameter logging.durabilitylevel';

RC TEXT

-- ---0 DurabilityLevel 0 Default transaction durability level 0 LONG 0RW 02 03 02

7 rows fetched.

a{/DwPVpG:

V$_)dkTB|n:

3 dC solidDB 49

N}{

KN}D

GN}D{F,}g CacheSize#

}]`M

CJ==

–

,bITGBPdP;n:

RO:;A,;\/,X|D5

RW:A/4,IT/,X|D5,"R|D+"4z'

RW/t/:IT/,X|D5,+GywD|D1=~qwBNt/sEaz

RW/4(:IT/,X|D5,+GywD|D

t/5

105

v'5

T>N}Dt/5

T>N}D105

T>z7P$HhCD5#

1=z4(B}]b1Eaz

hCN}5

*hCX(N}D5,k9C solidDB SQL `-w(g+rV$_)dkTB|n:

ADMIN COMMAND 'parameter section_name.parameter_name=value [temporary]';

dP:

value GP'N}5#

g{48(NN5,G4K|n+*KN}hCv'5(r_!{hC5)#xR,g {8(xPGE(*)DN}5,G4KN}+hC*|Dv'5#

1hC* temporary 1,;a+Q|DD5f"Z solid.ini D~P#

50 IBM solidDB: \m18O

"b,ITZHE=_mSUq#

>}:

--set communication trace on ADMIN COMMAND 'parameter com.trace = yes';

N}\mYw";GBqD;?V,^(Xv#

|n+5XB5w*a{/#g{KN}DCJ==* RO(;A),r_dkD5^ ',G4 ADMIN COMMAND od+5X;vms#

TN}yw^DDVCT

T_P RW* CJ==DN}ywDyP|D<f"Z solid.ini D~DB;vlic#

b;JCZ9C temporary !nhCD5#

9IT9CTB|n4ks"4f"Q|DD5:

ADMIN COMMAND 'save parameters [ini_file_name]';

48( ini_file_name 1,+XB4k10 solid.ini D~#qr,a+j{DdCD~ 4kB;C#byIT\=cX#fdCD~licT)+49C#

Z solid.ini Pi4MhCN}

r* solidDB xLD$w?<PD solid.ini D~#

i4N}D5#

yT>DN}G10Z~qwP&Zn/4,DN}#g{P4hCN}5,G4 t/1+9Cv'5#v'5I\!vZ solidDB yKPZDYw53#

X*1,kmSZ"N}MN

#f|D#

XkXBt/~qwE\$nywD|D#

#?N}5

dCD~D IndexFile ZPD Blocksize N}DN}CJ==* RO#KN}GZ4( }]b1hCD,Ts;\^D#

}5#

g{z*9Cd{#?5,G4Xk4(BD}]b#Z4(BD}]b.0,(} `- solidDB ?<PD solid.ini D~4hCBDN}#?5#

TB>}+(}r solid.ini D~PmSBPwP*w}D~hCBDis!:

3 dC solidDB 51

[IndexFile] Blocksize = 4096

`- "#f solid.ini D~. s,kF/ r>}I D }]bM U >D~, ; st/ solidDB#

ITZt/~qw1|DU>is!#

52 IBM solidDB: \m18O

4 9C solidDB }]\m$_

>Bhv solidDB }]\m$_,bG;iCZ4PwV}]bNqD5CLr#b) $_|(:

“solidDB 6LXF”(solcon)M“solidDB SQL `-w”(solsql),CZ(}Yw5 3a>{xP|nPa0#

“solidDB lY0kw”(solload),CZ+b? ASCII D~PD}]0k= solidDB }]b#

“solidDB <v”(solexp),CZ+}]S solidDB }]b6X= ASCII D~#

“solidDB }]Vd”(soldd),CZS solidDB }]bPlw}](eod#

solidDB $_;'V8wJO*F(TF)&\#8wJO*FG_ICTdCD;nX w#K&\9~qw|D

'8O7#

TC';IS#PX|`E",kND6solidDB _ICTC

"GyP solidDB $_<Gj<;6z7DXh?~,"R,|GZ3)=(ODIC TI\\^#PX solidDB }]\m$_DE",kk IBM +>z[zmr_ IBM

+> Web >c

http://www.ibm.com/software/data/soliddb

SD~Pdk\k

(#,C'j6E"TwD==dk,}gdk= solidDB t/|nT0 solidDB } ]\m$_#+G,ITSD~Pdk\k#by,M^((}KP UNIX |n ps 4

i4\k#

o(gBy>:

command -x pwdfile:filename

K|nITGBPNN;n:solcon"soldd"solexp"solid"solload r solsql#!n

filename ITGxT?<,2IT`TZ$w?<#

Z;vT;P{a2DV{.+;A!";S*\k#0<UqM;P{+;vT# g{\k|,Uqr;P{,G4|Xk

C41\V{TC\kP|,D}EM41\V{xP*e#

OD IBM +>Z_~q*5:

(Z}EP#+G,9C}Eb6EXk9

|n>}:

solsql -x pwdfile:userpwd "tcp solsrv 1313" dba solid -f -c soldb -x pwdfile:solpwd -U dba

solidDB 6LXF(solcon)

9C“solidDB 6LXF”,zITZ|nP"|na>{r_(}4P|,|nDE>D

~4P\m|n(`1Z solidDB SQL ADMIN COMMAND)#

4P\mYwDC'Xk_P SYS_ADMIN_ROLE r SYS_CONSOLE_ROLE (^,

qr,S+;\x#

t/“solidDB 6LXF”

*t/“solidDB 6LXF”,kZYw53a>{&"v solcon |n#

z9IT8(TBo("|(BPI!|nPTd?:

solcon options servername username password

dP,options ITG:

13. solcon

|n!n

!no( hv

-c dir |D$w?<#

-e command string 4P8(D“6LXF”|n#

-f filename 4PE>D~PD|nV{.#

-x pwdfile: filename SD~ filename PA!\k#

-h M -? T>C(oz#

Servername GzQ,S=D solidDB ~qwDxg{#Kb,9IT+_-}]4{F

k$_dO9C;PX|`E",kNDZ 93 3D6 B, :\mxg,S;#x(Dx g{Xk(Z}EP#

Username Gj6C'yXhD,"RCZ7(C'D(^#g{

|n4P+;\x#

Password GC'CZCJ}]bD\k#

“solidDB 6LXF”+,S= solid.ini D~PD Connect N}P8(DZ;v~qw#

g{z48(NNTd?,G453+a>zdk}]b\m1DC'{M\k#z ITZ|nP

Pa),SE",Tc2G solid.ini PD,S(e#

;PJ1D(^,G4

*Kv“6LXF”,kdk exit |n#

54 IBM solidDB: \m18O

6LXF

9C~qw{FT0\m1DC'{M\k4t/“6LXF”:

solcon "tcp localhost 1313" admin iohi4y

t/“6LXF”,Tc8]X(}]b:

solcon -ebackup 'ShMem SOLID" dbadmin password

Z“solidDB 6LXF”Pdk|n

Z("k~qwD,S.s,+T>|na>{#

IT9C -e !nZ|nPOr_9C -f !nZD>D~P4PyP|n#Kb,2I T9C SQL |n“ADMIN COMMAND”D!n4(}Lr4P\m|n#

Z“solidDB 6LXF”P4P\m|n1,z;ha) command_name

w*|nV{.

Do((;x}E);}g,Z“solidDB 6LXF”P,SQL |n ADMIN COM- MAND ’backup’ vvG:

backup

*q!ITZ“solidDB 6LXF”P9CD\m|nDPm,kND6solidDB SQL 8

O7PD=<:solidDB SQL o(;PPX“ADMIN COMMAND”Dhv#

1|nPPfZms1,“solidDB 6LXF”+a)I\!nDPmw*a{#kqXl izydkD|nP#

14. “

6LXF”yXPD|n

|n u4 5w

exit ex Kv“solidDB 6LXF”#

help ? T>ICD“6LXF”|n#

solidDB SQL `-w(solsql)

hz solidDB SQL `-w,ITZ|nPPr|na>{&"v SQL od(dP|

( SQL ADMIN COMMAND),9IT(}4P|, SQL odDE>D~4"v SQL od#*Kb SQL odD}=(eT0 ADMIN COMMAND Pm,kND 6solidDB SQL 8O7PD=<:Solid

hv#*KbICD ADMIN COMMAND DrLhv,dP|(u4,k4PTB| n:

SQL o(;PPX“ADMIN COMMAND”D

ADMIN COMMAND ’help’

t/ solidDB SQL `-w

*t/ solidDB SQL `-w,kZYw53a>{&"v solsql |n#

z9IT8(TBo("|(BPI!|nPTd?:

solsql options servername username password

4 9C solidDB }]\m$_ 55

dP,options ITG:

15. solsql

!no( hv

-a T/d5?uod#

-c dir |D$w?<#

-e sql-string 4P SQL V{.;g{9CK!n,G4;\(} -a 44Pd

-f filename 4PE>D~PD SQL V{.#

-h M -? T>C(oz#

-m Z{dk_P`VZV{q=#

|n!n

-o filename +a{/4k

-O filename TKD~7Sa{/#

-s schema_name v9CK#=#

-t r!?u|nD4P1d#

-u Z{dk_P UTF-8 q=#

-x pwdfile: filename SD~ filename PA!\k#

-x onlyresults vr!P#

-x outputsql K|nP*X9r!Q4PD SQL |n,x;Gvvr!?nYw

Da{#

-x returnerroronexit K

-x stoponerror K|nP*XCZZlb=mss"4?F#9"Kv solsql#

|nP*XCZT> SQL msMC'}pD}LmsD5X

k#I\D5Xk|(:g{4P SQL od'\,G4+5Xz k 60#g{}LwC5Xms,G4+5Xzk 61#g{4P

SQL E>ZdP`v SQL odM/r}LwC'\,G4+ Z;vJOD5Xk#

KD~#

g{Z|nPP8(KC'{M\k,G49Xk8(~qw{F#"R,g{Z| nPP8(K SQL E>D~D{F(-f !n}b),G49Xk8(~qw{F"C

'{M\k#k;*|GZ SQL E>)2r_ZKv SQL `-w0d5

Servername GzQ,S=D solidDB ~qwDxg{#Kb,9IT+_-}]4{F

k$_dO9C;PX|`E",kNDZ 93 3D6 B, :\mxg,S;#x(Dx g{Xk(Z+}EP#

Username Gj6C'yXhD,"RCZ7(C'D(

|n4P+;\x#

56 IBM solidDB: \m18O

$w#

^#g{;PJ1D(^,G4

Password GC'CZCJ}]bD\k#

solidDB SQL `-w+,S= solid.ini D~PD Connect N}P8(DZ;v~qw#

g{z48(NNTd?,G453+a>zdk}]b\m1DC'{M\k#

1|nPPfZms1,solidDB SQL `-w+a)I\!nDPmw

*a{#kqX

lizydkD|nP#

*Kv SQL `-w,kdk exit |n#

KP SQL E>

ITZ solidDB SQL `-wP1S4P SQL E>#z8(D SQL E>2ITwC d{ SQL E>#SQL `-wPDE>wCo(gBy>:

@filename

}g:

---Execute the SQL script named "insert_rows.sql" in the

-- root ("\") directory of the C: drive. @\c:\insert_rows.sql;

xT76{M`T76{<\'V#g{z8(`T76,G4|&C`TZ SQL `

-wD$w?<#

SQL E>>}

Y(Q("}]b,S,G4K|n>}+4PTVEU9D SQL od:

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

t/ SQL `-w"4P tables.sql E>:

solsql "tcp localhost 1313" admin iohe47 tables.sql

9C solidDB SQL `-w44P SQL od

Z("k~qwD,S.s,+T>|na>{#solidDB SQL `-w4PIVEU9 D SQL od#

>}:

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

insert into testtable (value, name) values (31, 'Duffy Duck'); select value, name from testtable; commit work;

drop table testtable; commit work;

SD~P4P SQL E>

*SD~P4P SQL E>,Xk8(CE>D~D{Fw*|nPN}:

solsql servername username password filename

CE>PDy Pod < X kTV E U9# 4 PCE> D ~ P DyPod j I s ,

solidDB SQL `-w+Kv#

4 9C solidDB }]\m$_ 57

>}:

solsql "tcp localhost 1313" admin iohe4y tables.sql

k;*|GZ SQL E>)2r_ZKv solidDB SQL `-w0d5$w#g{(}

!n -e 44P SQL V{.,G4;\9C -a !n44Pd5#

solidDB lY0kw

solidDB lY0kw$_CZ+b? ASCII D~PD}]0k= solidDB }]b# solidDB lY0kw\;0kwVq=D}],"\;+PX0k}LDj8E"zI

=U>D~#<kD~(4,|,b? ASCII }]DD~)Dq=IXFD~8(#

}]+(} *0kD}];X$tZ~qwFczO#

k"bBPwn:

mXkfZZ}]bP,byE\4P}]0kYw#

solidDB lY0kwa)K?<'V#'VTBo

catalog_name.schema_name.table_name

solidDB lY0kw+liBP<x:

–

N<<x

–

NOT NULL <x

–

solidDB Lr0k=}]b#b+Jm}]bZ0kZdT*z==$w#

solidDB lY0kw;'Vli<x,s_(} CREATE TABLE M ALTER TABLE

od(e,CZ8(PPD}]5^F#

+G,solidDB lY0kw<Uli9C CREATE TABLE od(eD(;<xrb|

<x#PX

(;PD CREATE TABLE o(#

XFD~

XFD~a)PX<kD~a9DE"#KD~|,BPE":

58 IBM solidDB: \m18O

(;<x

<xDj8E",kND6solidDB SQL 8O7D=< :solidDB SQL o

?v<kD~<h*;v;,DXFD~#solidDB lY0kw?N+}]0k=;v

mP#

PXXFD~q=D|`j8E",kNDZ 61 3D:XFD~o(;#

<kD~

<kD~XkG ASCII `MDD~#<kD~IT|,L(q=r(gq=D}]:

<kD~D{F

<kD~Dq=

*0kDmMP

TZL($Hq=xT,}]G<D$HL(,"RG<PD}]VN|,L(D

;CM$H#

TZ(gq=xT,}]G<D$HId#?v} {(}g:E)kB;v}]VNM}]G<Vt*(bMG solidDB Export yzI Dq=)#4|,}]DVN+T/hC* NULL#

G<PD}]VNIT_PNNIXFD~8(D3r#k"bBPwn:

kD~PD}]Xk_PJ1D`M#}g,T!cq=m>D}5;\0k=

< integer r smallint `MDVNP#

Z<kD~P,VARBINARY M LONG VARBINARY `MD}]XkxP.yx F`k#

9CNNL(mHVN1,^[GDV}]`M,Solload <Z{<kD mH,499C NULL 1`gK#

{"U>D~

Z0kZd,solidDB lY0kw+zI|,BPE"DU>D~:

]VNM}]G<<(}(gV

~_P8(D

0kUZM1d

4 9C solidDB }]\m$_ 59

0k3FE",}gI&0kDP}"'\P}T00k1d(g{(}!n8( *zIKZ]D0)

NNI\Dms{"#PX solidDB lY0kwmsDj8E",kNDZ 230 3D :solidDB lY0kw5CLr(solload)ms;#

g{^(4(U

>D~,G40k}L+U9#1!ivB,U>D~D{Fy]<

kD~D{Fz I , " + < k D ~ D D ~ ) 9 { f ; *D~ ) 9 { .log#} g , my_table.ctr +4(U>D~ my_table.log#*8(m;vD~{,k9C!n -l#

dCD~

dCD~;G solidDB lY0kwyXhD#~qwN}DdC5|(Z solidDB d CD~ solid.ini P#

zIT4(KD~DM'z1>,Tca) solidDB lY0kwyhD,SE"#g{

Z|nPP48(~qw{F,G4 solidDB lY0kw+S~qwdCD~ +,S=D~qw{F#}g,*9C NetBIOS -i4,S=~qw"R~qw{F

* solidDB,G4dCD~&C|,BPwP:

[Com] Connect=netbios SOLIDDB

t/ solidDB lY0kw

zIT9CxPwVTd?!nD solload |n4t/ solidDB lY0kw#g{t/ solidDB lY0kw148(NNTd?,G4z+4=Td?**0dC(Dr*h

v#|nPo(gBy>:

solload [options][servername] username [password]control_file

P!q|

dP,options ITG:

16. solload

!no( hv

-b records *Z;vzNPd5DG<}#

-c dir |D$w?<#

-C catalog_name hC1!?<,+TK?<A4}]#

-l filename +U>u?4kKD~#

-L filename TKD~7SU>u?#

-n records ek}is!(xgf>)#

-s schema_name hC1!#=#

-t r!0k1d#

-h T>C(oz#

|n!n

60 IBM solidDB: \m18O

16. solload

!no( hv

-x emptytable v1mP;PNNP1E0k}]#

-x errors: count nsms}#

-x nointegrity 0kZd;4Pj{Tli#

-x pwdfile: filename SD~PA!\k#

-x skip: records *x}DG<}#

-x utf8 WCHAR }]IC UTF-8 q=#

|n!n(x

)

PX control_file Dj8E",kNDB;Z#

Servername GzQ,S=D solidDB ~qwDxg{#Kb,9IT+_-}]4{F

k$_dO9C;PX|`E",kNDZ 93 3D6 B, :\mxg,S;#x(Dx g{Xk(Z}EP#

Username Gj6C'yXh

D,"RCZ7(C'D(^#g{;PJ1D(^,G4

4P+;\x#

Password GC'CZCJ}]bD\k#

1|nPPfZms1,solidDB lY0kw+a)I\!nDPmw*a{#kqX lizydkD|nP#

XFD~o(

XFD~o(_PBPXw:

X|VXkTs4V88(

IT9Cj<D SQL +,V{(--)"Mm>(4|("M

(}+;P{CZNNJ.0,IT9odgP

g{+ solidDB lY0kw#tVCw}]VdTs(4,m{rP d(Z}EP#TBPm|, solidDB lY0kwXFD~DyP#tV:

{),G4Xk+

17.

lY0kw#tV

AND ANSI APPEND BINARY

BLANKS BY CHAR CHARACTERSET

4 9C solidDB }]\m$_

17.

lY0kw#tV(x

DATA DATE DECIMAL DOUBLE

ENCLOSED ERRORS FIELDS FLOAT

IBMPC INFILE INSERT INTEGER

INTO LOAD LONG MSWINDOWS

NOCNV NOCONVERT NULLIF NULLSTR

NUMERIC OPTIONALLY OPTIONS PCOEM

POSITION PRECISION PRESERVE REAL

REPLACE SCAND7BIT SKIP SMALLINT

TABLE TERMINATED TIME TIMESTAMP

TINYINT VARBIN VARCHAR WHITESPACE

)

lY0kw#tV

XFD~Tod LOAD [DATA] *7,sz`vod,CZhvy*0kD}]#Z LOAD [DATA] od0f,;\!q8("Mr OPTIONS od#

18.

XFD~Dj{o(

o(*X (e

control_file

option_part

options

option

load_data_part

characterset_specification

::= [option_part] load_data_part into_table_part fields column_list

::= OPTIONS (options)

::= option [, option]

::= [SKIP = int_literal] [ERRORS = int_literal]

::= LOAD [DATA] [characterset_specification] [DATE date_mask] [TIME time_mask] [TIMESTAMP timestamp_mask] [INFILE filename] [PRESERVE BLANKS]

::= CHARACTERSET { NOCONVERT |

NOCNV |

ANSI |

MSWINDOWS |

PCOEM | IBMPC |

SCAND7BIT }

62 IBM solidDB: \m18O

"b,ZXFD~P,;Jm9C UTF8#

18.

XFD~Dj{o((x

o(*X (e

)

into_table_part

fields

termination

termination_char

enclosure

enclose_char

hex_literal

column_list

column

::= INTO TABLE tablename

::= [FIELDS {termination | enclosure}]

::= TERMINATED BY termination_char [[OPTIONALLY] enclosure]

::= WHITESPACE | 'char' | "char" | hex_literal

::= ENCLOSED BY enclose_char [AND enclose_char]

::='char' | "char" | hex_literal

::= X'hex_byte_string'

::= column [, column]

::= column_name datatype_spec

[POSITION (int_literal {:|-}int_literal)] [DATE date_mask] [TIME time_mask] [TIMESTAMP timestamp_mask] [ NULLIF BLANKS | NULLIF NULLSTR| NULLIF 'string'| NULLIF ((int_literal {:|-}int_literal)='string')]

datatype_spec

::= {BINARY | CHAR [(length)]|DATE| DECIMAL [ (precision [,scale ]) ] | DOUBLE PRECISION | FLOAT [ (precision) ] | INTEGER | LONG VARBINARY | LONG VARCHAR | NUMERIC [ ( precision [,scale ])]| REAL | SMALLINT | TIME | TIMESTAMP [ ( timestamp precisionv )]| TINYINT | VARBINARY | VARCHAR [ (length )]}

BPwNj85wo(*X0dC(#

CHARACTERSET

CHARACTERSET X | V CZ( ed k D ~ P9 C DV { / # g{ 4 9 C CHARACTERSET X|V,r_+KX|VkN} NOCONVERT r NOCNV dO9 C,G 4+;4P*;#9C N} ANSI m> ANSI V{/,MSWINDOWS m> Microsoft Windows V{/,PCOEM m>U( PC V{/,IBMPC m> IBM PC V {/,SCAND7BIT m>|,90

DI,GV{D 7 ;V{/#

ZXFD~P,;Jm9C UTF8#

DATE"TIME M TIMESTAMP

b)X|VITCZ=v;C"_P;,D&\:

4 9C solidDB }]\m$_ 63

+b)X|VDdP;vCw load-data-part *XDiI?V1,|(e<kD~PC Z+}]ek=NNC`MDPDq=#

1X|Vw*P(eDiI?VvV1,|8(+}]ek=CP19CDq=#

w* load-data-part *XiI?V9CDZ

kXk_PTB3r:DATE"TIME M

TIMESTAMP#b)X|VPD?;v<GI!D#

Z<kD~"ZkT0*+}]0k=DmPP,}]D`MXk`,#

19.

}]Zk

}]`M ICD}]Zk

DATE YYYY/YY-MM/M-DD/D

TIME HH/H:NN/N:SS/S

TIMESTAMP YYYY/YY-MM/M-DD/D HH/H:NN/N:SS/S

ZOmP,jZkG YYYY M YY,BZkG MM M M,UZkG DD M D,! 1ZkG HH M H,VSZkG NN M N,kZkG SS M S#UZZkPDZk

IT_PNb3r;}g,UZZkITG“MM-DD-YYYY”#g{<kD~DUZ} ]Dq=* 1995-01-31 13:45:00,

G4k9CZk YYYY-MM-DD HH:NN:SS#

XFD~PDUZ>}

"b,TB>}9C POSITION X|V#PXKX|VDj8E",kNDZ 68 3D :POSITION;#

OPTIONS(SKIP=1)

LOAD DATA RECLEN 12 INTO TABLE SLTEST2 (

)

XFD~PDUZ"1dM1dAG>}

"b,TB>}9C FIELDS TERMINATED BY X|V#PXKX|VDj8E",

kNDZ 67 3D:FIELDS TERMINATED BY;#

LOAD DATE 'MM/DD/YY' TIME 'HH-NN-SS' TIMESTAMP 'HH.NN.SS YY/MM/DD' INTO TABLE SLTEST3 FIELDS TERMINATED BY ',' (

64 IBM solidDB: \m18O

ID POSITION(1:2) NULLIF BLANKS, DT POSITION(3:12) DATE 'DD.MM.YYYY' NULLIF ((4:6) = ' ')

ID, DT, TM,

)

PRESERVE BLANKS

PRESERVE BLANKS X|VCZ#tD>VNPDyPUq#

INTO_TABLE_PART

into_table_part *XCZ(emD{FT0}]*ek=DP#

FIELDS ENCLOSED BY

FIELDS ENCLOSED BY SdCZ(e?vVN=TD(gV{#(g{ITG;vV {,2ITGdkD~P?v}]VN0sD=v;,V{#zIT9C;vV{

(}g+}E)r;TV{(}gsR2(E)TVNxP(g#g{9C+}Ew

g{,"9C:Ew*U9{/Vt{,G4dkI\`FZ:

"field1", "field2"

g{9CsR2(E,G4dkI\`FZ:

(field1),(field2)

"b,g{9CKX|V OPTIONALLY,G4(g{GI!D,"R;h*vVZ? n}]=T#

g{8(V{5,G4Xk+d(Z%}Er+}EP#}g,BP>}D'{`

ENCLOSED BY '(' AND ')' ENCLOSED BY "(" AND ")"

zuAIT9C%}E4(!;vbcV{"9C+}E4(!m;vbcV{,}

ENCLOSED BY '(' AND ")"

+G,bPI\a}pe;,rK(iz;*9CKq=#xG,(iz9C%} E,}G}Z9C%}E>mw*bcV{,}g:

ENCLOSED BY "'" AND "'"

"b,g{z}Z9C%}Ew*bcV{,G4Xk+2EX4,gTOSdy >#}g,*Z}]bPzITBZ]:

Didn't I warn you?

dk+G:

'Didn''t I warn you?'

8uNNIr!V{<ICw“bc”V{#z 2IT9C.yxFq=48(bcV {#}g,g{9C.yxFV{.,G4q=gBy>:

X 'hex_byte_string'

}g:

4 9C solidDB }]\m$_ 65

X'3a' m> 3A .yxF5,|8(0E(“:”)

;TbcV{PDsV{MRV{IT`,#}g,TBSdZXFD~PP':

ENCLOSED BY '"' AND '"'

g{sRV{`,,G4CV{Z ENCLOSED BY SdP;h*vV;N#}g,B

PSdD'{`,:

ENCLOSED BY '"' ENCLOSED BY '"' AND '"'

TBGZXFD~P(eOvSds;)dkT0mP5Jf"D`&5D>}#

"Hello." Hello.

"""Ouch!"", he cried." "Ouch!", he cried.

"""He said her last words were ""I'll never quit!""""" "He said her last words were "I'll never quit!""

"""He said: ""Her last words were ""I'll never quit!""""""" "He said: "Her last words were "I'll never quit!"""

"b,ZP}]>mPI\9CKbcV{(6kDVNVt{)#ZbVivB,I T+ TERMINATED BY Sdk OPTIONALLY ENCLOSED BY SddO9C,T7 #}7X+P}](p4,gZ 67 3D:FIELDS TERMINATED BY;yv#

ENCLOSED BY

dkfrM>}

>Z|,9CbcV{1Dy>frM>}#}GmPyw,qr?v>}<|,B PXFD~P:

FIELDS TERMINATED BY X'3a' OPTIONALLY ENCLOSED BY "(" AND ")"

bm>bcV{G2(E,Vt{(U9{)G0E - .yxF 3A 8(0E(“:”)#

}]+;0k=|,=PDm,Z;PD`M* VARCHAR,Z~PD`M* INTE- GER#

T}]P(p4DV{D&m==

ENCLOSED BY V{>m2ITvVZ}]P#+G,Z}]PvV1,TZbcV{ Z}]bPD?;NvV,CV{<&CvV=N#

g{dkD~|,TBZ]:

(David Bowie ((born David Jones)) released 'space Oddity"):1972

G4+Z}]bPzITBq=:

David Bowie (born David Jones) released 'space Oddity":1972

TZ6Wc}OnD2(ExT,iv`gK#g{dkD~|,TBZ]:

(You((can((safely((try))this))at))home.):2

66 IBM solidDB: \m18O

G4+ZmDZ;PPzITB5#

You(can(safely(try)this)at)home.

Tns;vbcV{D&m==

ns;vbcV{XkZdk)2vVf}N#}g:

*Z}]bPzITBq=:

American Pie (The Day The Music Died)

dkD~Xk|,:

(American Pie ((The Day The Music Died)))

Zns}vR(EP,0=v;S*CV{D%;5},ns;v;S*bcV{#

6k;P{

9CbcV{1,ITZV{.P6k;P{(X5{M/r;P{)#}g:

(This is a long line that can be split across two or more input lines ((and keep the end-of-line characters)) if the enclosing characters are used):1

g{Z}]P49CVNVt{(TO>}PD0E),"R;h*#tdk}]P D;P{,G4Zdk}]P;h*VNVt{(x;h*bcV{)#

g{}]DmHL(,G4H;h*Vt{2;h*bcV{#

FIELDS TERMINATED BY

FIELDS TERMINATED BY Sd(eCZZdkD~PxVVNax;CDVt{#

zXk(}BP}V=(PD;V=(48(KV{:

(Z+}EP,}g ″:″

(Z%}EP,}g ’:’

T.yxFq=8(,}g X’3A’

9C.yxFq=1,Xk9C%}E

"b,FIELDS TERMINATED BY Sd8(Vt{,x;Gf}DU9{;Zns; vVN.s,8(DV{;GXhD#}g,g{Vt{G0E,G4Bfb=V} ]D~q=H,"R<P':

1:2:3:

,x;\9C+}E#

1:2:3

"b,S\ns;vVNsfD2?0E,+C0E;GXhD#

4 9C solidDB }]\m$_ 67

1P}]>m|,CZ(!P}]DV{1,kZ FIELDS TERMINATED BY Sds f9C OPTIONALLY ENCLOSED BY Sd#TBG;vXFD~>}:

FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY "'"

ZTO>}P,Vt{G:E#

K>}+%}E(eICZZ}]D~P(!y6kDVNVt{(:E)D{E# "b,OPTIONALLY ENCLOSED BY SdIT9C%}Er+}ETbcV{xP(

g#TB>}:

OPTIONALLY ENCLOSED BY '('AND")"

]>gNTTBo(PD enclose_char ,19C%}EM+}E:

ENCLOSED BY enclose_char [AND enclose_char]

K>}";U(,+|PI\a}pe;,b9ddCA^[5#

TB>}TVt{T0bcV{DC(xPEv#ZK>}P,+“:”(0E)(e*

Vt{(FIELDS TERMINATED BY),"9C2(E4(!“:”(0E),s_6kZ VNP"R;&;bM*V

t{#K>}9|,=vVN,Z;vVNG VARCHAR V

N,Z~vVNG INTEGER VN#

}]D~>}

(This colon : is enclosed by parentheses and is not a separator):12345

XFD~>}

LOAD DATA CHARACTERSET MSWINDOWS INFILE 'test6.dat' INTO TABLE SLTEST FIELDS TERMINATED BY X'3a' -- X'3a' == ':' OPTIONALLY ENCLOSED BY '(' AND ")" (

TEXT, ID

)

POSITION

POSITION X|VCZ(eVNZ_-G<PD;C#zXk,1(e*<;CMax ;C#

NULLIF

NULLIF X|VCZZ`&DVN_P8(51T3vP8( NULL 5#m;vX| V:p8(CVNXk_PD5#X|V BLANKS ZVN*U1hC NULL 5;X

|V NULL ZVN*V{.“NULL”1hC NULL 5;(e“string”ZVNkV{. “string”%d1hC NULL 5 .“string”%d1hC NULL 5#

+ NULLIF X|Vk BLANKS X|VdO9C

;(e“((start : end) = ’string’)”ZVND8(?VkV{

TB>}5wgN+ NULLIF X|Vk BLANKS X|VdO9C,TcZVN*U1

hC NULL 5#K>}95wgN9C NULL X|VZVN*V{.“NULL”1hC NULL 5#

68 IBM solidDB: \m18O

LOAD INFILE 'test7.dat' INTO TABLE SLTEST FIELDS TERMINATED BY ',' (

)

NAME VARCHAR NULLIF BLANKS, ADDRESS VARCHAR NULLIF NULL, ID INTEGER NULLIF BLANKS

+ NULLIF X|Vk BLANKS X|VdO9C

TB>}TdkD~PDZ}vVN9C(e“((start : end) = ’string’)”#r*Xk8( “string”D<7;C,yTKo(vJCZL(mHDVN#

LOAD INFILE '7b.dat' INTO TABLE t7 (

NAME CHAR(10) POSITION(1:10) NULLIF BLANKS, ADDRESS CHAR(10) POSITION(11:20) NULLIF NULL, ADDR2 CHAR(10) POSITION(21:30) NULLIF((21:30)='MAKEMENULL')

)

"b,ZK>}P,V{.xVs!4# “MAKEMENULL”k“makemenull”";H

0kL(q=DG<

XFD~>} 1

-- EXAMPLE 1 uses multiple columns in fixed-width field

OPTIONS(ARRAYSIZE=3)

LOAD INFILE 'test1.dat' INTO TABLE SLTEST (

)

XFD~>} 2

-- EXAMPLE 2 OPTIONS (SKIP = 10, ERRORS = 5)

-- Skip the first ten records. Stop if

-- errorcount reaches five. LOAD DATA INFILE 'sample.dat'

-- import file is named sample.dat INTO TABLE TEST1 ( ID INTEGER POSITION(1-5), ANOTHER_ID INTEGER POSITION(8-15), DATE1 POSITION(20:29) DATE 'YYYY-MM-DD', DATE2 POSITION(40:49) DATE 'YYYY-MM-DD' NULLIF NULL)

"NAME" POSITION(1-5), ADDRESS POSITION(6:10), ID POSITION(11-15)

0kd$G<

>Z|,SId$H<kD~P0k}]19CDXFD~D>}:

4 9C solidDB }]\m$_ 69

XFD~>} 3

-- EXAMPLE 1 uses multiple columns that have separators rather than

-- fixed length fields.

LOAD INFILE 'test1.dat' INTO TABLE SLTEST FIELDS TERMINATED BY ',' (

)

NAME, ADDRESS, ID

XFD~>} 4

LOAD DATA INFILE 'EXAMP2.DAT' INTO TABLE SUPPLIERS FIELDS TERMINATED BY ',' (NAME VARCHAR, ADDRESS VARCHAR, ID INTEGER)

-- EXAMPLE 2

OPTIONS (SKIP=10, ERRORS=5)

-- Skip the first ten records. Stop if

-- errorcount reaches five.

LOAD DATE 'YYYY-MM-DD HH:NN:SS'

-- The date format in the import file

INFILE 'sample.dat'

-- The import file

INTO TABLE TEST1

-- data is inserted into table named TEST1

FIELDS TERMINATED BY X'2C'

-- Field terminator is HEX ',' == 2C

-- This line could also be:

-- FIELDS TERMINATED BY ','

OPTIONALLY ENCLOSED BY '[' AND ')'

-- Fields may be enclosed

-- with '[' and ')'

( ID INTEGER, ANOTHER_ID DECIMAL(2), DATE1 DATE(20) DATE 'YYYY-MM-DD HH:NN:SS', DATE2 NULLIF NULL )

-- ID is inserted as integer

-- ANOTHER_ID is a decimal number with 2

-- digits.

-- DATE1 is inserted using the datestring

-- given above

-- The default datestring is used for DATE2.

-- If the column for DATE2 is 'NULL' a NULL is

-- inserted.

9C Solload 4KPy>0k

"b,>Zy}CDD~|,Z Samples/DatabaseEngine/samples/importexport/ ?<P#

1. t/ solidDB#

2. (}9C sample.sql E>M solidDB SQL `-w,4(m#

3. (}dkTB|n*<0k:

70 IBM solidDB: \m18O

solload ’shmem solid″ dba dba delim.ctr

Y(C'{M\k*“dba”#*9CL($HDXFD~,kdkTB|n:

solload ’shmem solid″ dba dba fixed.ctr

9C delim.ctr xPDI&0kDdv*:

IBM Solid Speed Loader v.4.10.00xx (C) Copyright Solid Information Technology Ltd 1992-2003 Load completed successfully, 19 rows loaded.

9C fixed.ctr xPDI&0kDdv*:

IBM Solid Speed Loader v.4.10.00xx (C) Copyright Solid Information Technology Ltd 1992-2003 Load completed successfully, 19 rows loaded.

PXa_0kYHDa>

BPa>ITozz7#Tn_T\4P0k:

PI\1,T>X==xP,S;\b(}xg0k}]PzZa_YH#

a_Z%;zNPd5DG<}#1!ivB,+Z?uG<s4Pd5#

solidDB <v

{CBqU>G<&\#

Xk9C LogEnabled N}4{CU>G<&\#solid.ini D~PDBfb=P+{CU >G<&\:

[Logging] LogEnabled=no

0kYwjIs,k;*|GYNtCU>G<&\#solid.ini D~PDBfb=P+ tCU>G<&\:

[Logging] LogEnabled=yes

Zzz73P,?R(iz;*Z{CU>G<&\DivBKP~qw#g{44 U>,G4IZg4JOMmsmsHJb"zms1,+^(4PV4#

“solidDB <v”GCZ+}]S solidDB }]b6X= ASCII D~Dz7#“solidDB < v”+,1zI<kD~(|,y<vD ASCII }])MXFD~(CZ8(<kD~

Dq=)#solidDB lY0kwIT1S9Cb)D~+}]0k= solidDB }]b#

CZ4P<vY

wDC'{XkT<vDm_P!q(^#qr,+;a<vNN}

4 9C solidDB }]\m$_ 71

t/“solidDB <v”

zIT9C solexp |n4t/“solidDB <v”#g{t/“solidDB <v”148(NN Td?,G4z+4=Td?**0dr*hv#|nPo(gBy>:

solexp [options][servername] username[password {tablename |*}

dP,options Td?ITG:

20. solexp

!no( hv

-c dir |D$w?<#

-e sql_string 4P SQL V{.TcxP<v#

-f filename 4PD~PD SQL V{.TcxP<v#

-l filename +U>u?4kKD~#

-L filename TKD~7SU>u?#

-o filename +<vD}]4kKD~#

-s schema_name v9CK#=xP<v#

|n!n

-C catalog_name hC1!?<,+TK?<A4}]#

-p #t#={Mm{Ds!4#

-8 dv 8 ;{F= .crt D~({C UNICODE {F)#

-h M -? T>C(oz#

-x pwdfile: filename SD~PA!\k#

IT9C{E * 4(}%;|n<vyPDm#+G,;\+dCw(d{#

*K#VIE>P',T'V -t tablename(<vm)!n#

Servername GzQ,S=D solidDB Dxg{#Kb,9IT+_-}]4{Fk$_

dO9C;PX|`E

",kNDZ 93 3D6 B, :\mxg,S;#x(Dxg{X

k(Z+}EP#

Username Gj6C'yXhD,"RCZ7(C'D(^#g{;PJ1D(^,G4 4P+;\x#

Password GC'CZCJ}]bD\k#

}g:

72 IBM solidDB: \m18O

solexp -CMyCatalog -sMySchema -ofile.dat "tcp 1315" MyID My_pwd MyTable

1|nPPfZms1,“solidDB <v”+a)I\!nDPmw*a{#kqXliz

ydkD|nP#

g{!T#=D{F,G4zI\aSU=;u{",C{"8vR;=8(Dm# g{ solexp Lr;*@&CZDv#=PxPiR,G

solidDB }]Vd

“solidDB }]Vd”GCZS solidDB }]bPlw}](eodDz7#“solidDB } ]Vd”+zI;v SQL E>,s_|,CZhv}]ba9D}](eod#zID

E>|,PXm"S<"w}"%"w"}L"rP""<MB~D(e#

4|+R;=m#

7#2+,4P>C'MG+(e#

CZ4P<vYwDC'{XkTm_P!q(^#qr,,S+;\x#

t/“solidDB }]Vd”

zIT9C soldd |n4t/“solidDB }]Vd”#g{wC“solidDB }]Vd”14 8(NNTd?,G4z+4=Td?**0dr*hv#|nPo(gBy>:

soldd options servername username password [ tablename]

dP,options ITG:

21. soldd

!no( hv

-c dir |D$w?<#

-m Z{dk_P`VZV{q=#

-o filename +}](e4kKD~#

-O filename TKD~7S}](e#

-C catalog_name hC1!?<,+TK?<A4}](e#

-s schema_name vP>K#=PD(e#

-p #t#={Mm{Ds!4

|n!n

-8 dv 8 ;{F= .crt D~({C UNICODE {F)#

-h M -? T>C(oz#

-x tableonly vP>m(e#

-x indexonly vP>w}(e#

4 9C solidDB }]\m$_

21. soldd

!no( hv

-x viewonly vP>S<(e#

-x sequenceonly vP>rP(e#

-x procedureonly vP>}L(e#

-x publicationonly vP>"<(e#

-x eventonly vP>B~(e#

-x triggeronly vP>%"w(e#

-x schemaonly vP>#=(e#

-x hiddennames vP>Z?<x{F#

-x pwdfile: filename SD~PA!\k#

|n!n(x

)

Servername GzQ,S=D solidDB ~qwDxg{#Kb,9IT+_-}]4{F

k$_dO9C;PX|`E",kNDZ 93 3D6 B, :\mxg,S;#x(Dx g{Xk(Z}EP#

Username Gj6C'yXhD,"RCZ7(C'D(^#g{

;PJ1D(^,G4

4P+;\x#

Password GC'CZCJ}]bD\k#

1|nPPfZms1,“solidDB }]Vd”+a)I\!nDPmw*a{#kqXl izydkD|nP#

“solidDB }]Vd”>}

soldd -odatabase.sql "tcp database_server 1313" dbadmin f1q32j4

dv}L TEST_PROC D(e:

soldd -x procedureonly " " dba dba TEST_PROC

g{48(m{,G4+P>C'P(9CDyP(e#

g{a)K objectname N}"8(KdP;v -x !n,G4+y]C{Fvdv

y8(TsD(e#

74 IBM solidDB: \m18O

*K#VIE>P',T'V -t tablename !n#

$_y>:XB0k}]b

K>}]>gN+ solidDB }]bXB0k=B}]bP#Z]>1,9+(};v> }i\gN9C?v solidDB $_#"b,>}M|BYwI\aZ}]bPtBdt

(49CDUd)#XB0k}LG#PC,K}L+X4;PdtD}] bD~ solid.db Ds!5AnMLH#

XB0k}]b

SI}]bPi!}](e#

SI}]bPi!}]#

+I}]bf;*B}]b#

+}](e0k=B}]b#

b"+}]

+}]0k=B}]b#

XB0k}]b:$@@

Z>>}P,~qw{FG solidDB,"RCZ,SD-iG“2mZf”#rK,xg{ G ’shMem SOLIDDB″#K}]bG9CC'{“dbadmin”M\k“password”4(D#

}](eG9C“solidDB }]Vd”i!D#k9CTB|nP4i!|,yPm" S<"%"w"w}"

D1!{FG soldd.sql#

soldd ’shMem SOLIDDB″ dbadmin password

K|n+ZD~ soldd.sql(1!{F)PP>yP}](e#g0yv,*K7#2 +,4P>C'MG+(e#g{C}]b|,C'rG+,G4Xk+{G

=KD~P#

yP}]<G9C“solidDB <v”i!D#<vYw+zIXFD~()9{* .ctr DD~)M}]D~()9{* .dat DD~)#1!D~{k<vDm{`,#Z 16 ;73P,$H,} 8 vV8DD~{+xP"C#k9 mDXFD~M}]D~#

}L"rPMB~D(eD SQL E>#yi!D SQL D~

CTB|nP4i!yP

solexp ’shMem SOLIDDB″ dbadmin password *

K|n+SyPmP<v}]#?vmD}]<+;4k{* table_name.dat D<k D~#TZ?vm{,+4;v%@DXFD~ table_name.ctr#

4 9C solidDB }]\m$_ 75

(}S`&D?<P>} solid.db T0yP sol#####.log D~,IT4(B}]b Tf;I}]b#ZK.sZ;Nt/ solidDB 1,+4(B}]b#

Z>}I}]b.0,(iz*d4(8]#zIT9C“solidDB 6LXF”4jI KNq#

B|nP,(}“solidDB 6LXF”44(8]:

9CT

solcon -eBACKUP ’shMem SOLIDDB″ dbadmin password

K|n+4(8]#!n -e 8(\m|n#

+}](e0k=B}]b#zIT9C solidDB SQL `-w4jIKNq#k9 CTB|nP44PI“solidDB }]Vd”4(D SQL E>#

solsql -fSOLDD.SQL ’shMem SOLIDDB″ dbadmin password

n+}](e0k=BDU}]b#b)(eG9C!n -f SD~ soldd.sql P

lwD#,SN}kH0>}PD,SN}`,#

(}9CTB|nP4t/ solidDB,IT,14P0=v=h#!n -x +4(B }]b"4PD~PD|n"Kv#

solid -Udbadmin -Ppassword -x execute:soldd.sql

+}]0k=B}]b#KNq(} solidDB lY0kwjI#*+`vm0k= }]bP,(iz*?vm4(;v|,;,|nPDz&mD~#ZyZ Unix D

Yw53P,IT9C(d{ *#k9

solload ’shMem SOLIDDB″ dbadmin password table_name.ctr

K|n0k;vmD}]#~qw&Z*z4,#

IT9CDz&mD~|(:

Unix 73PD Shell E>

Kb,9+(eC'{M\k#

CTB|nP+}]0k=B}]b#

76 IBM solidDB: \m18O

VMS PD .com E>

Windows PD .bat E>

5 T\w{

>BV[ICZa_ solidDB T\D<u#>B|,Dwb|(:

U>G<kBqMCT

!qtk6p

XFZfDC?

w{xg{"

w{ I/O

w{lic

(}d5;ABqu! Bonsai wDs!

TT\;QJbxPoO

PXE/_6

a>:

BPN}ozza_}]bT\r_ZT\k2+T=fxP=b#Z 113 3D=< A, :~qwKd C N } ;Tb) N } w K|j8D V [ # 5 B, : T\w { ; 2 T DurabilityLevel N}wKV[#

IsolationLevel

DurabilityLevel

DefaultStoreIsMemory

4F&\D<I,kND solidDB Advanced Replication Guide#

U>G<kBqMCT

>BSm[GHV[BqMCT#PX!qMhCBqMCT6pD|`E",kN D6solidDB SQL 8O7#

d5Bq1,}]b~qw+}]4k=v;C:}]bD~MBqU>D~#+ G,;X,1+}]4kb=v;C#d5Bq1,~qw(#"4+}]4kBq

U>D~ - 4,~qwd5Bq1"44K}]#~qw;X"4+} D~#~qwITH=HOUP1Y4P4Yw,2ITH[}`n|D,;sY+

}]4k}]bD~#

g{~qwZ+yP}]4k}]bD~0l#XU(}gIZg4JOxl#X

U),G4~qwIT(}A!}]b 5}]#TSON4}]bD~sywDNN|D<#fZBqU>D~P#~qw

ITSU>D~PA!G)|D,;s9CCE"4|B}]bD~#SU>D~P A!|DM|B}]bD~

100% nB#

~qwZl#XUsXBt/1,+<UT/4PV4}L#C'(#;aul=K }L(}G~qwZ<8Cl&Bks0"zSY)#

]4k}]b

D~kBqU>D~DiO4V4 100% DQd

D}LF*“V4”#V4}Laxs,}]bD~ +5V

;vyO,*xP 100% DV4,X

~qwZ~qwd5}]D,1+}]4kU>D~#rK,Qd5DBq+f"Z ELO,49Fczl#XU2;a*'#bF*“OqMCT”#Qd5D}]“IM

C”,49~qwl#

g{MCT*“Oq”,G4C'1=}];I &4kELODBqU>.sEa;f *}]Qd5jO - b7#49~qwl#XU,}]2IV4#OqMCT7#Q

d5D}]8u;I\*',}G2L}/w>

g{MCT*“mI”,G4C'I\aZ}] ;4kELODBqU>.0;f*} ]Qd5jO#~qwIT!qSY4}],}g,HH}vV`v*4}]DB q#g{MCT*“mI”,"R+}]4kE L

*';)Qd5DBq#

solidDB Jm(}wV==4XFMCT6p#TZ~qw6'DhC,[Logging] ZP DN} DurabilityLevel ITIC}v5:3(m>“Oq”)"1(m>“mI”)M 2(m

>“TJ&”)

TJ&MCTCZ“H8C”Yw#g{MCT*“T J&”,G4~qw+q-BP f

XU`gK#

k+ 100% DBq4kU>D~#(#,}]b

m"zJO#

0"zg4JO,G4~qwI\a

g{C~qwG“H8C”53PDw~qw,"R(z~qw&Zn/ 4,,G4 w~qw+ICmIMCT;

ZyPd{ivB

78 IBM solidDB: \m18O

,C~qw<+ICOqMCT#

v1 [HotStandby] N} SafenessLevel D5hC* 2safe(1!5)1,Eaq-T OP*#g{KN}hC*NNd{5,G4~qwZyPivB<+ICmIM CT(DurabilityLevel D5hC*“TJ&”)#

g{4tC“H8C”&\,G4“TJ&”h

1!MCT6p*“TJ&”#

=bT\k2+T

Zz7O,s?V}]b~qwD?j<GnsLHXa_2+T,4,7#}];

aIZg4JOrd{Jbx*'#b)}]b~qwI C“OqMCT”#K=(J CZm``MD}](}gGJ}]),TZb)}],49*';v

3)}]b~qw;hFInsLHXa_T\,x;<G2+T#bZ3)ivB IS\,}gz;h*T}]xPIy,r_~qw\;TnB;i}]4PYw, x;<GCi}]Ds!#w*;v>}, g,D)FczZ?;lDX(1dD$w:XnX#zIT9CK`E"TFcz

OD:XxP=b#KE"fE1dDFFx|D,“I”}];g“B”}]P[5#5 JO,zITj

32T;\;}#KP"Z;vGZZq!;{W+B}](Y(z(#Oz;vG ZT0D}])#ZbVivB,<{*'}]r_*'?V}]<IS\,r*T

|X*#

solidDB Jmz8(G*xP“Oq”U>G<T#$yPQd5D}]ZbbXzs<I V4,9G*xP“mI”U>G<TJm3)nBBqZ3)ivB*'#

C+;S*“Oq”#

Bq2;IS

Y(~qw|,PXT\D3F}] - }

+Oz;vGZT0DNN}]#49*'T\M:Xyb}],5

mIBqMCTgNa_T\

(}f*~qw;XZd5}]D,14U>D~,ITa_T\#bJm~qwF

Y4U>D~,I\FY=~qw;G4&1xP,2I\FY=IT,14`vB q1xP#bF*“mIMCT”#K&\(}5M I/O(dk/d

g{+BqMCT6phC*“mI”,G4f Z*'3)}]DgU;4,g{~q

wZd53)}].s+Z+C}]4kBqU>.0l#XU,G4+*'}]# rK,v1\;P\*'Y?nB}]b

j<;BT

BqMCT";G ANSI D SQL-99 j<DiI?V#

v):X4a_T\#

;iv1,E&C9CmIMCT#

5 T\w{ 79

BqMCTDV^T

"b:

9C“mI”BqMCT1,fZ*'}]DgU#g{}]b~qwl#XU(}g IZg4JOxl#XU),G4C~qw+*'NNP44kBqU>D~DQd 5Bq#g{9CmIMCT,G43)BqI\4;4kU>

Qd5`gK#v1z\;P\<{*'Y?nB}]b;iv1,E&C9CmI MCT#

g{ *hC ~q w4 } ]0 D ns S Y1d ,kZ solid.ini d CD~ Ph C RelaxedMaxDelay N}#PXKN}D|`E",kND6solidDB \m8 < A;#

!qBqtk6p

"PXFyZ&CLrDhs#3)&CLrXkq@<}]b;y4P#d{&C LrIT]LZ3VLHO;d{,1KPD&CLrIE#*Kzc;,&CLr

Dh*,SQL-92 j<(eKDVBqtk6p#4U-r,solidDB ^(A!4d5D }] }V\'VDtk6pxP5w#

D~,49G)Bq

O7PD:=

#d-rZZ,b+<BS<;;B,"R9PI\F5}]bj{T#BfT

Qd5A

Ktk6p;JmBqA!Qd5D}]#+G,ZBq4PZd,}]bDS< I\aIZd{Bqd5

IX4A

Ktk6pG solidDB }]bD1!tk6p#|;JmBqA!Qd5D}]"# $yA!D}]ZCBqU90;a|D#Kb,solidDB 97#CBqfT;BD }]bS<#9CV["PXF1,(}9CBq4 e;#bb6E,~qw;i$4Yw,x;i$AYw#}g,g{;vBqf

0;vAYwM;v|BYw,G4 solidDB +i$,;PZCAYwM|BYw. dGq4;NNK|B#by,MITlb=

xPBq4/i$DivB,I\a"zCq|B,"RBq;IrP/#~qw D1!tk6pG“IX4A”,rK1!i$GBq4/i$#

IrP/

Ktk6p;JmBqA!_P;B 50,;PNNd{Bq\;|DKBqyA!D5,qr+<BwvBqD4P

Z;civB^(rP/#

|DxPyd/#

/i$4lbwvBq.dD

*'D|B,+;aTAYwi$# Z

}]bS<DQd5}]#"R,ZKBqd

solidDB IT(}lbwvBq.dDe;4a)IrP/DBq#|(},19C 4/i$

80 IBM solidDB: \m18O

MA/i$45VK?j#IZ;9CNNx(,rKIT\byP"P

XFl#,dP|(Cq|B# *tCK&\,k9C|n SET TRANSACTION

ISOLATION LEVEL SERIALIZABLE,6solidDB SQL 8O7PD:=< B,solidDB SQL o(;TK|nwKhv#

SERIALIZABLE tk6pvJCZyZELDm#

hCtk6p

*hCtk6p,k9CBPdP;v SQL |n:

SET ISOLATION LEVEL

{READ COMMITTED | REPEATABLE READ | SERIALIZABLE}

SET TRANSACTION ISOLATION LEVEL

{READ COMMITTED | REPEATABLE READ | SERIALIZABLE}

}g:

SET ISOLATION LEVEL REPEATABLE READ; SET TRANSACTION ISOLATION LEVEL REPEATABLE READ;

"b,solidDB 'V“Bq6”M“a06”tk6p|n#PX|`j8E",kND 6SQL 8O7D:=< B,solidDB SQL o(;PDhv#

XFZfDC?

XFxLs!

wZf+y]539CivT0Yw5373T/,==xPVd#Zf\m53D y>*XGs!`,DPkZf:exDX#zITdCZf:exD}?Ms!, Tczc;,&CLr73Dhs#

solidDB t/UUjI1,Microsoft Windows +

!#bGr*,_Y:f3fGZKWNVdD,+ Microsoft Windows 1=|GZ; N;9C1E+d|(ZxLs!P#k Microsoft Windows ;,,yZ UNIX DY

w53+|(_Y:f3f"(fOsDxLs!#

xLs!>mk5J}]bZfDC?"^1SX*,bGr*xLs!9|,G} ]b*X#xLs!|,D*XgBy>:

_Y:fs!#solid.ini PD1!5G 32 WVZ#

zk2Gxs< 3 WVZ,+|u</;,Db"PI\v

(fTx!Z5JVds!DxLs

s= 8 WVZ#

M'z_L#?vM'z<DC8Yv'VZDwZf#

5 T\w{ 81

*&m|nx#tD/,Zf#VdDK?VZfCZ&m4P=8MY1}]H Z]#

od_Y:f#1 solidDB 4P SQL od1,|+HT|GxPbvME/#K} LI\HOD1#~qwIT+-}bvME/Dodf"ZibZfP# od_Y:f”#

BqiRmD"Pm#

BqMEr:ex#

LockHashSize N}+0lZfDC?#KN}(ex("PmPD*X}?#

yCJDm2+ZwZfPxP:f#

Ov*XG0lxLs!Dw**X#

bF*“

9CBPwZ{vD\m|nMN}4XFxLs!#g{%4xL^F,G

zIT

4b)%}iv+G<Z solmsg.out U>D~P#

ADMIN COMMAND ’info processsize’;

ADMIN COMMAND ’info processsize’; |n5XZf}]bxL109CDZf?# 5XD5G;v VARCHAR,|8>KxL9CDZf?(4'VZF)#"b,K| n5Xy9CDibZf?,x;G5Xy9CDomZf?#

ProcessMemoryLimit N}

ProcessMemoryLimit N} 8 ( I TVdx Z f } ]bx L D n sibZf? # ProcessMemoryLimit Dv'5* 1G(4,1 'WVZ)#k+KN}hC*;v\7#

+Zf}]bxL+?EkomZfPD5#1;,zXk<GBPrX:

FczPDomZf?

539CDZf?

Zfm(|(Y1m"2,mM“#f”Zfm)T0XZb)ZfmD w}y9C DZf?#

* solidDB ~qwD_Y:f$tDZf?(solid.ini dCN} CacheSize)

82 IBM solidDB: \m18O

,1Z~qwPKPD,S"BqModyh*DZf?#~qwPD"",SM

n/od=`,~qwh*D$wZfM=`#(#,&1*~qwPD?vM' z,SAYVd 0.5MB Zf#

}ZFczPKPDd{xL(LrM

o=^F(4,Zf}]bxLC! ProcessMemoryLimit y8(DZf?).s,~

q w + ; S \ ADMIN COMMAND( \ m | n )# z I T 9 C ProcessMemoryWarningPercentage N}4a)PXZfDC?;OvSD/f#

}])9CDZf?

ProcessMemoryLowPercentage N}

KN}TxL\s!hC^F#K^FT ProcessMemoryLimit N}5DYVHm>#

Z,vK^F.0,zQ,v9C ProcessMemoryWarningPercentage N}(eD/f^ F"SU=/f{"#,v ProcessMemoryLowPercentage ^F1,+zI53B~#

ProcessMemoryWarningPercentage N}

KN}TxL\s!hC/f^F#K/f^FT ProcessMemoryLimit N}5DYV

Hm>#,v ProcessMemoryWarningPercentage ^F1,+zI53B~#

ProcessMemoryCheckInterval N}

53(ZlixLs!^F#zIT9C ProcessMemoryCheckInterval N}4hCli 1ddt#1ddtTAk*%;8(#

n!DGc5G 1000(Ak)#;Jm5* 0 r_sZHZ 1000(1 k)#g{8(D 5sZ 0 +!Z 1000,G4+zIms{"#

v'5* 0,

w{Yw53

Yw53IT+E"f"ZBP;C:

5Zf(omZf)

ibZf

)9f"w

Yw539IT+E"S;v;CFAm;;C#y]Yw53D;,,KF/;F *“3fwH”r“;;”#m`Yw53(}xP3fwH

IDs?E"#+G,KYwHOD1#}`D3fwHr;;Ywa<BYw53 T\B5,"mw53DZf\?;;s,^(]IyPQ;VdZfDZ]#z&

Ca_Zf\?r_uYyVdD

4,{9lixLs!#

r;;4f"5Zfy^(]

}]b_Y:fZf?#

5 T\w{ 83

}]b_Y:f

solidDB \mDE"r_f"ZZfP,r_f"ZELO#IZZfCJHELCJ

YHl,rKmkivG,(}CJZfzfCJEL4zc}]ks#

(e}]b_Y:fs!

}]b_Y:f9CICDZf4f"S2LPyZELD}]bPA!DE"#| 9CZZ~qw4PlicZdT}]b3xP:f - ZyZELD}]bMZf} ]bPxP`,D:f#1&CLrB;Nksq!KE"1,+SZf

A!C}]#_Y:fs!D1!5!vZy9CD=(,"RIT(} CacheSize N }xP|D#1fZ`v""C'1,(izvsK5#

g{}]bw*yZEL,G4IT4TB==xP@c:

v TZ53D?v""C',V

v }]bs!D 2-5%

9CTOD54@cXhD_Y:fs!1,k9COsD@c5#g{}]b;G Zf}]b,G4v'5Qc;#u!_Y:fs!1,k"b,*KP'X4Pl

icn/,Ks!;&!Z 8MB#

x;G2L

d 0.5 MB

z&Cww ^(j+0B,Sxh*T~qwzk>mxP;;,<BT\;Q#m;=f,g {_Y:f+!,G4_Y:f|PJ+;1\M#_Y:fT\;QD"4G,

]bi/YHmV*MZ$Z,"Ri/ZdDELn/}`#

(}9C|n ADMIN COMMAND 'status' 4li_Y:f|PJ,r_9C ADMIN COM- MAND 'perfmon' 4li{e_Y:fMD~HJ3FE",zITi$~qwGq}Z

SELx;GZflws?V}]#PX 8 DBMS `SMJOoO;MZ 15 3D:li}]b{e4,;#"b,_Y:f|

PJ&C_Z 95%#

Xvs CacheSize D5#g{K5}s,G4+<B~qwxLZZfP

}

b)|nDj8E",kNDZ 17 3D:j

/,X|D}]b_Y:fs!

zIT/,X|D CacheSize 5,gBy>:

admin command ’parameter IndexFile.CacheSize=40mb’

^(u!_Y:fs!#

solidDB 9C"Pm4r/T_Y:fDCJ#"Pms!HZ_Y:fPD3}#b

+7#yxPDCJ8u;a"ze;#g{/,Xvs_Y:fs!,G4"Pm ;aT ReferenceCacheSizeForHash N}4'VvssD_Y:f#ReferenceCacheSizeForHash N}5CZFc_Y:f"Pms!#v1za0*@~qwz|\ZZDns_Y :fs!1,E&C9CKN}#m;

s,I\a"z"Pme;#

/vs#b+<B"ze;DI\Ta_#*K\bbViv,zIT9C

=f,g{48(5,G4vs_Y:fs!

84 IBM solidDB: \m18O

ReferenceCacheSizeForHash N } 5; \! Z CacheSize 5 # qr , ReferenceCacheSizeForHash N}5+;\x,"R+9C1!5#Kb,+Q;u{"

r!= solmsg.out U>D~#

1!ivB,solidDB ZZfP4PyPEr#CZ4PErDZf?I [SQL] ZPD

N} SortArraySize 7(#g{*ErD}]?ZVdDZfP0;B,G4zI\k vs SortArraySize N}D5#

"b,Er}is!D}7hCFuXk]I^(4|5ErDns

$Za{/;+

G,ZvsEr}is!1,*<G;);1[Ds{#

g{vs SortArraySize D5<Bi/KPYHu}xGSl,G4PI\Gf0=E

/wDBPdP;VP*:

SortArraySize N}0lGq9Cw}xPEr#g{ SortArraySize hCOs,G

E/wPI\ 9 C E r}ix P E r,x; G9C I C Dw} x P E r# g{

SortArraySize O!,G4E/wPI\9CICDw}xPEr#Z3)ivB(H dGa{/O!Div),kOsD SortArraySize hC`H,O!D SortArraySize

hCD'{|C#

SortArraySize

N}0lE/w4P GROUP YwD==#E/w+T4Era{/

4PD GROUP YwS*_I>Yw#rK,Z SortArraySize hCO!DivB, E/w+<BHTa{/xPEr,;sY4P GROUP Yw#Z SortArraySize h COsDivB,PI\;Ta{/xP

ErM4P GROUP Yw#Z3)ivB,

bI\<B SortArraySize hCOs1DT\;ghCO!1Div#

"b,TZsMErxT,r_IZZf;cx^(vs SortArraySize D51,z& C$nb?Er&\,4,+PdE"f"=EL#

*$nb?ELE

[sorter] TmpDir_1 = c:\tmp

r&\,kZdCD~ solid.ini PmSBfb;ZMN}:

IT9C`FD(e4mSd{Er?<:

[sorter] TmpDir_1 = c:\tmp TmpDir_2 = d:\tmp TmpDir_3 = e:\tmp

(}Z;,DomELO(e`vErwY1?<,ITZ`vEL.d=b I/O : X,SxT"a_ErT\#

-}E/DEr

3)i/~=X*sxPEr#}g,g{ SQL E/w!q JOIN YwT9C MERGE JOIN c( ,G4* ,SDa {/*sH4PEr,;sE\xP,S#zITS solidDB P9C EXPLAIN PLAN FOR od4i/E/wDv_#PXj8E",k ND6solidDB SQL 8O7PPX EXPLAIN PLAN FOR

|nDhv#

5 T\w{ 85

9CZf}]b

w{xg{"

v144}73rT/5Xa{/1,Ea4PEr#g{9Cw|rw}4CJm }],G4a{/+T/4U9CPDw}y8(D3rEP#rK,(}hFw|

Mw}T'V#CDT\X|i/DErhs,ITTxa_~qw

solidDB }]bz79C=v/I=}]b}f:;vGyZELD+3}f,m;v GwZf}f,s_Jm4(@C$tZwZfPDm#"R,*G)m4(Dw} 2j+f"ZwZfP#Z9CZf}]b&\1,zIT*?vm! w*mDf"w#kvvyZELD~qwxL`H,9CZfmKPD solidDB xL

*sC`#*@@Zfm0dw}yhDZf?,kND6solidDB Zf}]bC'8 O7#

(}8> solidDB ~qwZ;uxg{"P5X`va{/P,ITa_ solidDB A

!sMa{/DT\#*$nK&\,kZ solidDB ~qwD solid.ini dCD~D [Srv] ZP`-BPN}DdP;vr+?:

RowsPerMessage#1!5G 10#

T\#

qELrZf

w{ I/O

PXb=v

m`m~53DT\5JO\EL I/O F<#(#,Z4P I/O n/Zd,CPU n/ Xk]R#

V< I/O

1`vxL"T,1CJ,;vEL1,+"zELyCiv#*K\bbViv, k+D~SCJ?1XDELFAn/?;sDEL,1=wvELD I/O ?sB`,

*9#

kq-BP<r:

ExecRowsPerMessage#1!5G 2#

N}D|`E",kNDZ 113 3D=< A, :~qwKdCN};#

9C%@DEL4f"U>D~#

]b.V*`vD~"+? v}]bD~EZ;,DELO#kNDZ 43 3D

:\m}]bD~M_Y:f(IndexFile Z);#

<G+%@DELCZb?Erw#

86 IBM solidDB: \m18O

IBM solidDB User Manual V6.3

Specifications and Main Features

Frequently Asked Questions

User Manual

ODBC

JDBC

solidDB

CacheSize

FileNameTemplate

TmpDir_[1...N]

Threads

Info

Trace

TraceFile

CHARACTERSET

PRESERVE BLANKS

INTO_TABLE_PART

FIELDS ENCLOSED BY

FIELDS TERMINATED BY

POSITION

NULLIF