IBM m18O User Manual

IBM solidDB
IBM solidDB Universal Cache

V6.5

\m18O



S151-1280-01

yw

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

Z;f,Z;^)f

Kf>&CZIBM solidDB V6R5(z7`E 5724-V17)MIBM solidDB Universal Cache V6R5(z7`E 5724-W91)

0yPsx"PfM^)f,1=ZBf>PmPyw*9#

© Solid Information Technology Ltd. 1993, 2010

?<

< .................vii

m .................ix

|D** ..............xi

XZ>Va .............xiii

!"<( ...............xiii

o(m>(<( .............xiv

1 solidDB y>*X ..........1

solidDB }]\mi~ ...........1

`LSZ(ODBC M JDBC) ........2

xg(Ec ..............3

SQL bvwME/w...........3

solidDB ...............4

53$_M5CLr ...........4

T/\mMV/\m ...........5

solidDB e5a9 .............6

yZELDmD}]f"w.........6

yZZfDmD}]f"w.........7

solidDB SQL E/w ...........7

solidDB xg~q ............8

`_L&m

..............8

2 \m solidDB ...........11

CZxP}]b\mDC'G+ ........11

t/ solidDB ..............11

G< ................12

^D solidDB ~qwM solidDB SQL `-w

(solsql)D Windows l]== .......12

4(B}]b ..............13

C'{"\kM53?<{ ........14

Unicode M?V Unicode }]b== .....15

hC}]b73 ............16

solidDB dCD~(solid.ini) ......17

hC}]bis!(BlockSize)M

(FileSpec) .............17

(e}]bTs ............18

,S= solidDB .............18

XU}]b ..............19

XU solidDB ..............19

+ solidDB w* Windows ~qKP ......20

WN+ solidDB w*~qt/ .......20

t/M#9 solidDB ~q .........22

}% solidDB ~q ...........22

Z;(FczOKP`v~qw ........22

i4ms{"MU>D~ ..........23

XF{"U>dv ...........23

9C

ADMIN COMMAND 'errorcode' 4i4ms{"

hv ................24

;C

9CzYD~ .............25

zY'\DG<"T ..........25

`S solidDB ..............25

li}]b{e4, ..........25

q!10Q,SDC' ..........26

^}Q,SD solidDB C' ........26

i/n|;N8]D4, .........26

zI4,(f .............27

T\F}w (perfmon) ..........27

9C solidDB sFzY(AuditTrailEnabled)...38

tCM{CsFzY ..........38

i/ SYS_AUDIT_TRAIL 53mPDsFzY}

] ................39

4P8]MV4 .............39

4P>X8] .............39

(}xgxP8] ...........40

dCT0T/4P8] ..........41

8]ZdavVDiv ..........42

\mxg8]~qw ..........44

`SMXF8] ............44

|}'\D8] ............45

4P8]1

V48] ..............45

BqU>G< .............46

4(lic ..............47

dk(1|n ..............47

9u}]bD~ .............48

24G}]bXi ...........48

}]bXiD$w== ..........48

}]bXi|nP!n ..........49

T}]bxPS\ ............49

T}]bMU>D~xPS\ .......49

{CS\ ..............50

t/-}S

|DS\\k .............51

T}]bxPb\ ...........51

i/}]bS\6p ..........52

8]-}S\D}]b ..........52

TH8C~qwxPS\ .........52

S\MT\ .............52

DdMJb ..........45

\D}]b ..........51

3 dC solidDB ...........53

\mN} ...............53

dCD~MN}hC ..........54

9C ADMIN COMMAND 4i4MhCN} ..55

(} solid.ini dCD~hCN} ......59

dCN}D{Fq=M5q= .......61

nX*D~qwKN} ..........62

nX*DM'zKN} ..........67

9C solidDB |nP!n ..........69

hCX(Z solidDB D73d? .......69

iii

4 9C solidDB }]\m$_ .....71

solidDB 6LXF(solcon) .........71

t/ solidDB 6LXF(solcon) ......72

Z solidDB 6LXF(solcon)Pdk|n ...73

solidDB SQL `-w(solsql) ........73

t/ solidDB SQL `-w ........73

9C solidDB SQL `-w44P SQL od ..76

SD~P4P SQL E> .........76

solidDB lY0kw(solloado M solload) ....77

D~`M ..............78

t/“solidDB lY0kw”(solloado M

PXa_0kYHDa> .........81

>} ................81

XFD~o( .............83

solidDB <v(solexp) ..........91

t/“solidDB <v”(solexp) ........91

solidDB }]Vd(soldd) .........93

t/“solidDB }]Vd”(soldd) .......93

SD~Pdk\k ............96

dCD~ ...............96

+ solidDB $_k Unicode dO9C ......97

>}:9C solidDB $_XB0k}]b ....98

solloado) 78

5 T\w{.............101

U>G<kBqMCT ..........101

30 ...............101

=bT\k2+T ...........102

mIBqMCTgN\;a_T\......103

j<;BT .............103

BqMCTDV^T ..........103

!qBqtk6p ............103

hCtk6p ............104

XFZfDC?.............104

XFxLs! ............104

w{Yw53 ............106

}]b_Y:f............106

Er ...............108

9CZf}]b............108

w{xg{" .............109

w{ I/O...............109

V< I/O..............109

hC MergeInterval N} .........109

w{lic ..............110

(}d5Bqu! Bonsai wDs! ......111

@9 Bonsai w}Hvs .........111

TT\;QJbxPoO..........113

_-}]4{F............120

(E-i ...............121

TCP/IP -i .............121

UNIX \

|{\@ ..............123

-i** ..............124

@ .............122

7 JOoOM'V ..........125

TJbxPJOoO ...........125

CZxPJOoOD$_.........126

T solidDB Universal Cache xPJOoO ...132

T SMA xPJOoO .........134

Qw*6b ..............136

q!^) ...............136

IBM m~'Vz9(JCZ solidDB M solidDB

Universal Cache) ............137

k IBM 'Vz9*5 .........137

U/oO}] ............138

$)“'V”Md{|B .........143

=< A. ~qwKdCN} ......145

Accelerator Z .............145

Cluster Z...............146

Communication Z ............146

General Z ..............148

HotStandby Z .............156

IndexFile Z ..............159

Logging Z ..............161

LogReader Z .............164

MME Z ...............166

Passthrough Z .............169

SharedMemoryAccess Z ..........171

Sorter Z ...............171

SQL Z ...............173

Srv Z ................176

Synchronizer Z .............187

=< B. M'zKdCN} ......189

Client Z ...............189

Communication Z ............190

Data sources Z .............191

SharedMemoryAccess Z ..........191

=< C. solidDB |nP!n .....193

=< D. 73d? ..........197

6 \mxg,S ...........115

M'zk~qw.dD(E .........115

xgl}{F (Com.Listen) .........115

i4~qwy'VD-i.........117

i4~qwDxg{ ..........117

mSM^D~qwDxg{ ........117

}%~qwDxg{ ..........118

M'zD,SV{. ...........118

1!,SV{. (Com.Connect).......119

iv IBM solidDB: \m18O

=< E. msk ...........199

solidDB 53ms ............201

solidDB }]bms ...........203

solidDB mms .............212

solidDB a0ms ............227

solidDB (Ems ............227

solidDB ~qwms ...........230

solidDB }Lms ............236

solidDB API ms ............239

solidDB Erwms ...........239

solidDB RPC msM{" .........240

solidDB ,=ms ............241

solidDB HotStandby ms .........256

solidDB SSA (SQL API) ms ........257

solidDB COM((E){" .........258

solidDB SRV(~qw)ms ........259

solidDB DBE(}]b}f)msM{" ....260

solidDB CP(lic){" .........262

solidDB BCKP(8]){" ........262

solidDB AT((1|n){" ........263

solidDB LOG(G<){" .........263

solidDB INI(dCD~){" ........264

solidDB HSB (HotStandby) msM{"

solidDB SNC(,=){" .........267

solidDB XS(b?Erw)msM{" .....267

.....264

solidDB FIL(D~53){" ........267

solidDB TAB(m){" ..........268

solidDB SMA(2mZfCJ)ms ......268

solidDB PT(+])ms ..........269

solidDB SQL ms ............269

solidDB I4PD~ms ..........275

solidDB lY0kw(solloado M solload)ms . . 276

=< F. solidDB ADMIN COMMAND

o( ...............279

ADMIN COMMAND ...........279

w} ...............291

yw ...............301

?< v

vi IBM solidDB: \m18O

<

1. solidDB i~ ............2 2. solidDB i~ ............4

vii

viii IBM solidDB: \m18O

m

1. !"<( .............xiii

2. o(m>(<( ...........xiv

3. t/~qw .............12

4. solidDB 1!D~ ..........16

5. ,S= solidDB ...........19

6. Perfmon F}w ...........28

7. backup |nD!n ..........40

8. netbackup |nD!n .........40

9. kCZ4P>X8]D solid.ini D~`T&

DN} ..............42

10. kCZ4Pxg8]D solid.ini D~`T&

DN} ..............42

11. ICD8]Mxg

12. ;,(1|nDTd?M1!5 ......48

13. ,SV{.!n ...........67

14. solidDB 73d? ..........69

15. solcon |n!n ...........72

16. X(Z solcon D|n .........73

17. solsql |n!n ...........74

18. solloado M solload |n!n .......79

19. lY0kw#tV ..........83

20. XFD~Dj{o( ..........84

21. }]Zk .............85

22. solexp |n!n ...........91

23. soldd |n

24. CZ ?V Unicode M Unicode }]bD

solidDB $_D|nP!n .......98

25. 7(|n4, ...........112

26. 7(D),SxPQd5DBq .....112

27. TT\;QJbxPoO ........113

28. xgl}{F!n ..........116

29. ,SV{.!n ...........118

30. xgl}{F (Com.Listen) PD TCP/IP -

i ...............121

31. M'z,

TCP/IP -i ............122

32. xg{PD UNIX \@-i .......123

33. xg{PD|{\@-i ........123

34. solidDB -iMxg{ .........124

35. &CLr-iMxg{ ........124

36. “SQL E"”6p...........128

37. Ping $_6p ...........131

38. SOLSMASTART 1!X7Ud ......135

39. solidsupport ............138

40. solidDB Support Assistant (solidsupport) !n 140

41. Accelerator N} ...........145

42. Cluster N} ............146

43. Communication N} .........146

44. General N} ............148

SV{. (Com.Connect) PD

8]|n .......44

P!n ...........94

45. HotStandby N}

46. IndexFile N} ...........159

47. Logging N}............161

48. U>DAwN} ...........164

49. MME N} ............166

50. SQL +]N} ...........169

51. 2mZfCJN} ..........171

52. Sorter N} ............171

53. SQL N} .............173

54. Srv N} .............176

55. Synchronizer N} ..........187

56. Client N} ............189

57. Communication N} .........190

58. Data source N} ..........191

59. 2mZfCJN}(M'zK) .....191

60. solidDB 73d? ..........197

61. solidDB ms`p ..........199

62. solidDB 53ms ..........201

63. solidDB }

64. solidDB a0ms ..........227

65. solidDB (Ems ..........227

66. solidDB ~qwms .........230

67. solidDB SA API ms .........239

68. solidDB Erwms .........239

69. solidDB RPC msM{" ........240

70. solidDB ,=ms ..........241

71. solidDB HotStandby ms ........256

72. solidDB SSA (SQL API) ms ......257

73. solidDB COM((E){" .......258

74. solidDB SRV ms ..........259

75. solidDB DBE msM{" .......260

76. solidDB CP(lic){" .......262

77. solidDB BCKP(8]){" .......262

78. solidDB AT((1|n){" ......263

79. solidDB LOG(G<){"

80. solidDB INI(dCD~){" ......264

81. solidDB HSB msM{"........264

82. solidDB SNC(,=){" .......267

83. solidDB XS(b?Erw)ms .....267

84. solidDB FIL(D~53){" ......267

85. solidDB TAB(m){" ........268

86. solidDB SMA(2mZfCJ)ms ....268

87. solidDB +]ms ..........269

88. solidDB SQL ms ..........269

89. solidDB I4PD~ms ........275

90. solidDB lY0kw(solloado M solload)m

s ...............276

91. ADMIN COMMAND o(M!n .....280

...........156

]bms .........203

.......263

ix

x IBM solidDB: \m18O

|D**

T^)f 01 D|D

v Z TCP/IP -i;ZPmSKPX TCP/IPv6 -iDE"#

v Z~qwKdCN};ZPvSKBN}:

– MME.MaxTransactionSize

– MME.MemoryPoolScope

– Passthrough.ComplexNumNonindexedConstr

– Passthrough.ComplexNumOrderedRows

– Passthrough.ComplexNumTables

v Z perfmon F}wDj{Pm;ZPvSKBDT\F}w:

Passthrough complex by num non indexed constraints
Passthrough complex by num ordered rows
Passthrough complex by num tables

v Z~qwKdCN};ZPmSKPX IndexFile.DirectIO M Logging.DirectIO N

®

}'VDE":b)N}Z Windows

73P^';Z Windows 73P,}]bD

~<U9C“1S I/O”#

®

v solidDB

lY0kw(solloado M solload);ZPD solidDB lY0kw(solloado

M solload)|B

– QvSBDyZ ODBC D solloado#

– Z DATE"TIME M TIMESTAMP ;ZP* DATE M TIMESTAMP ZkvS

DBB]q= B(T"Dm>D}vV8iIDu4,}g,01-DEC-2010)#

v vSBD;ZJOoOM'V,

dP|(PX^)| 2 P}kD solidDB Support

Assistant Dj8E"#

v Z Srv Z;ZPvSKBN}:

– Srv.StackTraceEnabled

v ZM'zKdCN};ZPvSKBN}:

– SharedMemoryAccess.SignalHandler

– SharedMemoryAccess.Signals

v Z perfmon F}wDj{Pm;ZPvSKBDT\F}w:

Log availq items – Number of records added to available items queue
Time sec – Printout time of this pmon in seconds

v Zmszk;ZPvSKBDmszk

21330,Communication,Error,Failed to accept a new client connection, too many open files
30805,XS,Message,Maximum number of files for external sorting reached

v ZxPxg4F;ZP,vSK1YDCZ ADMIN COMMAND ’netbackup’ D!n -I

M -i#

v Q+,S(A),1Dv'5S 60 000 Ak|}* 0(^^);ZM'zD,SV

{.M Communication Zb8ZPQ|BM'zKN} Com.ClientReadTimeout M
Com.Connect !n -rmilliseconds#

xi

v Q|B SQL Z;Z:Z Unicode }]bP,SQL.CharPadding=yes N}hC;

z';<UOz CHAR 5PDUWV{#

v Zt/{IDEP206A: R;=D~#} SQL `-w;ZP,vSK1YD solidDB SQL

`-w (solsql) t/!n -S <schema name> M -C <catalog name>#

v Z Accelerator ZPvSKBN} Accelerator.ReturnListenErrors#

v Z Passthrough ZPvSKBN} Passthrough.Force32bitODBCHandles#

v Q|B perfmon F}wDj{Pm;Z#

v Z~qwKdCN};ZPvSK1YDN}:

– General.UseEncryption(Y1^) 01)

– SQL.SQLInfo

– MME.MaxBytesCachedInPrivateMemoryPool

v Z General ZP,Q+N} General.LockHashSize Dv'5S 1000 |D*

1000000(Y1^) 01)#

v Q+mszk;Z|B*k ADMIN COMMAND ’errorcode all’ dvT&#ZBPw

ZP,QvSH04G<D{":

– API ms

–AT((1|n){"

– BCKP(8]){"

– COM((E){"

–CP(lic){"

– DBE(}]b}f)msM{"

– FIL(D~53){"

– HSB (HotStandby) msM{"

– INI(dCD~){"

– LOG(G<){"

– RPC msM{"

– SMA(2mZfCJ)ms

– SNC(

– SRV(~qw)ms

– TAB(m){"

–XS(b?Erw)msM{"

v vSKBD;Z:9C ADMIN COMMAND ’errorcode’ 4i4ms{"hv

v Z Unicode M?V Unicode }]b==;ZPvSKPX“T Unicode ==4(}

]b”DE"#

v Z HotStandby Z;ZP,Q|}N} HotStandby.TCConnect Dv'1

fZv'5#

v Z perfmon F}wDj{Pm;ZP|BKT\F}wDPm#

v Q|BT}]bxPS\;Z;vSKPXgN{CS\DE"#

,=){"

!5;;

xii IBM solidDB: \m18O

XZ>Va

!"<(

IBM®solidDB G(CD}]b\m53,S!MD6k=53=sf#53<JC#
zIT9CwV&\T solidDB i~4~qZXbhs#K`i~|(:

v Zf}]b

v _HICDH8CdC

v _6l=4F

v CZ+&CLr1Sk~qwzk4SD

b

OvyPi~<G};D,4,|GITZd{i~fZDivB9C#solidDB D\
m1IT9CwVdC!nM$_TnOJD==hCz7#

>8OhvgNhC"`S"\mME/>z7Dy>}]b~qw&\#`XVa

)KPXdCX( solidDB i~D|`j8E"#

a

>8OY(A_FU;cD}]b\m53(DBMS)*6"l$ SQL#

solidDB D59CBP!"<(:

m1.!"<(

q=JCZ

}]bm KVeCZyPU(D>#

NOT NULL ICKVeDs4V88> SQL X|VMj{F#

solid.ini b)Ve8>D~{M76mo=#

SET SYNC MASTER YES;
COMMIT WORK;

run.sh KVeCZy>|nP#

TRIG_COUNT() KVeCZ/

java.sql.Connection KVeCZSZ{F#

LockHashSize KVeCZN}{"/}Td?M Windows "amu?#

argument K`?wJ8>C'r&CLrXka)DE"#

\m18O

D~76m> }GmPyw,qrD~764 UNIX

KVeCZLrzkMLrdv#>} SQL od29CKV
e#

}{#

bVy=CZ}Cd{D5r_,;D5PDBZ#BuoM
?wDJb24Ky=i4#

®

q=m>#1\(/)

V{m>20y?<#

xiii

m1.!"<((x

q=JCZ

)

o(m>(<(

Yw53 g{D5|,PXYw53.dDnpDZ],G4WHa=

DG UNIX q=#Microsoft

.s"(Z(EP#d{Yw53+%@Pv#TZ;,DY
w539I\P;,DBZxPhv#

®

Windows q=;Z UNIX q=

solidDB D59CBPo(m>(<(:

m2.o(m>(<(

q=JCZ

INSERT INTO table_name

solid.ini KVe8>D~{M76mo=#

[] =(E8>I!n;g{GVeD>,G4Xk+=(E|,

| z_,CZ+o(PPD=v%b!nVt*#

{} s(ECZTo(PPD;i%b!nxP(g;g{GVe

o(hvICKVe#If;?VIC

Zo(P#

>,G4Xk+s(E|(Zo(P#

D

K

Ve#

... !TE8>IT`NX49CTd?#

.
.
.

I}vciID;Pm>bGH0zkPDSx#

xiv IBM solidDB: \m18O

1 solidDB y>*X

solidDB DKDGX5}]b~qw#K}]b~qwS\T SQL oT`4Di/#
(#,b) SQL i/I

~qw5XDa{/#

"R,solidDB 9a)K,=&\,TJm+;v solidDB PQ|BD}]"M=;v
r`vd{ solidDB#

solidDB 9JmICH8CdCKP;T solidDB,"Jm+M'z&CLr1S4S=

}]b~qw}LTca_T\T 0|t\XXF~qw#b)&\F*“H8C”M
2mZfCJ(SMA)r4SbCJ(LLA)#

TBwZhvKWci~MxL,|G9 solidDB I*1q4SV<=5373Pmk
DV<=}]\mbv
D30E"#

solidDB }]\mi~

B<T>K solidDB }]\mi~,fsDBZT|GxPhv#

M'z

&CLra;,s_+ SQL od"M=~qw"SU

=8#b)BZa)KZxg73P\mM,$ solidDB yXh

1

1. SA API G solidDB T:D API,k2mZfCJ(SMA)r4SbCJ(LLA)bdO9C#PXj8E",kN
D6IBM solidDB 2mZfCJM4SbCJC'8O7#

<

1. solidDB

i~

`LSZ(ODBC M JDBC)

*r}]b~qwa;i/(4 SQL od),M'zXk\;kK}]b~qwxP

(E#km`d{}]b~qw`,,solidDB 29C“}/Lr”4'VK(E#M'z
&CLrwC}/LrPD/},;sI}/Lr&mk~qwxP(E

Bq#}g,zIT`4+wC ODBC }/LrPD/}D C oTLr,2IT`4
+wC JDBC }/LrPD/}D Java

2 IBM solidDB: \m18O

™

Lr#

Md{_e

ODBC

solidDB ODBC }/Lr{O Microsoft ODBC 3.51 API j<#solidDB ODBC }/
Lr'VD/}I(} solidDB ODBC API xPCJ,C API G solidDB }]bD

wC6SZ(CLI)"k ANSI X3H2 SQL CLI ;B#

PX solidDB ODBC }/LrD|`j8E",kND IBM solidDB Programmer

Guide#

JDBC

solidDB JDBC }/LrJm Java &CLr9C JDBC 4CJ}]b#solidDB JDBC
}/Lr5VK JDBC 2.0 f6PDs?VZ]#

PX solidDB JDBC }/LrD|`j8E",kND IBM solidDB Programmer
Guide#

(PSZ

solidDB 9a)K=v(PSZ solidDB &CLr`LSZ(SA API)M solidDB ~
qwXF API(SSC API)#}g,b)SZJm C Lr1SwC}]b~qwPD

/}#b)(PSZd8K solidDB 2mZfCJ(SMA)M4SbCJ(LLA)b#

PX solidDB (P`LSZD|

4SbCJC'8O7

xg(Ec

solidDB \;ZyPw w`MDxgPKP"'VyPww(E-i(}g TCP/
IP)# *"_IT4(CZ;,V`Fc73DV<=&CLr#PXxg(ED|`
j8E",kNDZ 115 3D6 B, :\mxg,S;#

SQL bvwME/w

solidDB 9CyZ SQL j< ANSI X3H2 M IEC/ISO 9075 D SQL o(#|+f'

V SQL-89 ~6j<T0 SQL-92 kE6j<#Kb,9'Vj{ SQL-92 M SQL-99
j<Dm`XT#solidDB a)K;vyZ*zD_6E/w,s_7#|*4SDi

/2\;_'XKP#KE/wT/,$PX

53FV<ivDE"#

PX solidDB SQL E/wD|`j8E",kNDZ 7 3D:solidDB SQL E/w;
;Z#

E/wa>

E/wa>(bGT SQL D)9)G(}i/odP6kD1"M8(D18n#E
/w+lbb)18nra>,"`&X9|Di/4P=8TK*y!#E/wa

>Jmy]}]"i/`MM}]bDwVivT&CLrxPE
K<;"zDi/T\JbDbv=8,9+l&1dXF(S53F;xC'#

`j8E",kND6IBM solidDB

M IBM solidDB Programmer Guide#

ms!"mPP}"ICw}T0w}

2mZfCJM

/#|G;va)

PXE/wa>D|`j8E",kND6IBM solidDB SQL 8O7#

1 solidDB y>*X 3

solidDB

solidDB +&m(} solidDB SQL a;D}]ks#< 2 y>D solidDB ~qw+}
]f"Z}]bP"SC}]bPlw}]#

1. SA API G solidDB T:D API,k2mZfCJ(SMA)r4SbCJ(LLA)bdO9C#PXj8E",kN
D6IBM solidDB 2mZfCJM4SbCJC'8O7#

<

2. solidDB

i~

53$_M5CLr

solidDB |(;WCZxP}]\mD$_#

4 IBM solidDB: \m18O

XF($_:solidDB SQL `-w(solsql)M solidDB 6LXF
(solcon)

v “solidDB SQL `-w”(solsql) G;vXF($_,CZZ|na>{&r(}4P

|, SQL odDE>D~4"v SQL odM solidDB ADMIN COMMAND#

v “solidDB 6LXF”(solcon) G;vCZ\mDXF($_;_P\m1(^DC'I

TZ|na>{&r(}4P|,|nDE>D~4
C solcon,ADMIN COMMAND Iw* solcon t/|nPD;?V"v#

CZ<vM0k}]D$_

solidDB a)KTBCZ<vM0k}]D$_:

v “solidDB lY0kw”(solloado r solload)+}]Sb?D~0k= solidDB }]

bP#

v “solidDB <v”(solexp) +}]S solidDB }]b<v=D~P#|9a4(“solidDB

lY0kw”(solloado r solload)CZ4P}]0kYwDXFD~#

v “solidDB

>|,hv}]ba9D}](eod#

}]Vd”(soldd) <v}]bD}]Vd#|azI;v SQL E>,CE

T/\mMV/\m

solidDB hFIT^KU4==VxYw,"R?prc#|;*sz4PnY?D,

$$w#\mYw(dP|(8])IT(} SQL )9T`L==4P,b))9I
TT/KP,2ITZ\m1DksBKP#

"v ADMIN COMMAND#{

X*1,z2ITV/\

solidDB a)KBPCZ4PV/\mD$_M=(:

v ADMIN COMMAND

*4P\mNq,zITZ solidDB SQL `-w(solsql)P"v solidDB SQL T
:D ADMIN COMMAND#*q!j{D|nPm,kND Z 279 3D=< F,

:solidDB ADMIN COMMAND o(;#

v solidDB ~qwXF API(SSC API)

g{z}Z9C_P4SbC

API)+9C'&CLr\;(}LrXFNqD4P#SSC API /}ICZT}]
b8]"}]blicM Bonsai wO".`DNq8(EH6#y8(DEH67

(Nq4PsDKP3r#PXj8E",k

SbCJC'8O7#

v solidDB 6LXF(solcon)

“solidDB 6LXF”(solcon)JmzZ;9C ADMIN COMMAND o(DivB
dk\m|n#PXj8E",kNDZ 71 3D:solidDB 6LXF(solcon);#

m solidDB#

J&\D solidDB,G4 solidDB ~qwXF API(SSC

ND6IBM solidDB 2mZfCJM4

1 solidDB y>*X 5

solidDB e5a9

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

v }]f"w

v /, SQL E/

v xg~q

v `_L&m

yZELDmD}]f"w

CZf"yZELDm(D m)Dw}]a9G;V B wde#~qw9Cb)a9
PD=V;“wf"w”fE@C}],F*“Bonsai w”Dnpw}wY1f"“B”}],
1=C}]ITFAwf"w*9#

– wf"w

– Bonsai w`f>XFM"PXF

:pf" D mD~qwZ??~F*“y

ZELD}f”(DBE)#

wf"w

wf"w|,~qwPDyP}],dP|(mMw}#ZZ?,~qw+yP}]
<f"Z“w}”P - ;P%@Dm#?vw}<|,j{Dw|(4,;PPDyP
}])r(|(SQL +KF*“w}”- vvG|,Z SQL w}PDP
FsTs(BLOB)Md{$P5Tb,}]P;P%@Df"=(#

yPw}<f"Z%;DwP,CwF*wf"w#ZCwP,w}(}53(eD
w}j6`%Vt,Kj6+ek=?v|50f#bVzF+w}wV*
w}Sw,dP,;vw}D|5`%/:=;p#PX}]/:Mw|w}Dj8

E",kND6IBM solidDB SQL 8O7PPXw|w}DV[#

5)#}~x

`v_-

solidDB Bonsai w`f>XFM"PXF

Bonsai wG!MDn/“w}”(}]f"w),|ZPkZfP_'Xf"B}](>

}"ekM|B),,1,$`f>E"#Z Bonsai wP,,;PD`vf>(If
>MBf>)IT2f#I}]MB}]<CZ"PXFT07#yPBqDA6

;B,x;alINNx(*z#hz Bonsai w,ITTxuYxP"PXFyhD
K$#

Bqt/1,|;3h,xDBqt/E(TSN)#TSN CwBqD“A6p”;yPZ

K.sSd{,Sek=}]bD|5TZ10BqP4P
+a);BDw}A6p,MqAYwZCBqt/1T-S==4P;y#by,

MIT7#AYwfr;BD}]S<xP,x;h*4P*zO_Dx(Yw#

DQwxT<;IS#b

p

If>DP(T0G)PDBf>)+f"Z
f>DBq,M;1#VbV4,#ZyP}CIf>DBqjIs,+S Bonsai w

POz“I”f>D}],"RBd5D}]+S Bonsai wFAwf"w#$HErD|
5+(}k#f}]bYw"PDs
b#ZO"Zd,+Tom==}%Q>}D|5#

6 IBM solidDB: \m18O

Bonsai wP,;*fZh*i4G)I

(YwxPO"#b+TxE/ I/O "5V:Xy

w}9u

Z Bonsai wMf"wP,9C=V=(4f"|5#WH,v#f<B;v|5kH
0|5PyxpDE"#4,T| 5xP“0:9u”#dN,Zw}wDO_c,S

)2*<XO|5_g;4,T|GxPs:9u#

yZZfDmD}]f"w

solidDB Jm4($tZZfPDm,4 M m# M mDEcZZT\#M mZMC
TMIV4T=fDtTkyZELD+3m(D m)`,# (;DxpZZ,wf

"wD;C;,#M mw*f"Zwf"wP,bm>Zf}]b=s,|
P<CDUd=s#}5J}]Tb,M mDw}2Zwf"wP9(#solidDB 9C

F*“T=”Dwf"wE/w}<u45Vw}# *@@f" M m0dw}yhDZ
f?,kND6IBM solidDB Zf}]bC'8O7#

Zwf"w

:pf" M mD~qwZ

solidDB SQL E/w

solidDB SQL E/wGyZ*zDE/w,CZ7# SQL od_'X4P#KE/w
kyZfrDE/w9C`,D<u,4,@?;i$H`EDfr47((ya{

DnL76#}g,SQL E/w+<Gw}GqfZ"w}Gq(;T0w}GyZ
;mP9G;imP#+G,kyZfrDE/w;,,KE/wPyZ*zD&\
\;y]}]bD5JZ](}g,P}T0wvPD5V<iv)xPwZ#

solidDB T/,$PX5J}]D3FE",Sx7#T\nQ#49}]
]Pyd/,KE/w2T\;7((y}]DnP'76#

i/&m

i/&mV*`v!MD=h4P,T7#;nD1DYw;ah{m;&CLrD
ks#i/(};v|,BPWNDrPxP&m:

v o(Vv

v 4(4P<

v &m4P<

o(Vv

+T SQL i/xPVv,"R~qw+zIo(ro(msDbvw#bvod1,
+Q4PCodyXhDE"0k=od_Y:f#;*od_Y:f|,;vod

D4PE",CodMIT444P,x;XxPXBE/#

??~F*wf"w}f(MME)#

%

D}?MZ

4(4P<

+y]i/bvw4(_PBPXTD4P<#

v 4Sod;`4I3;"R|r%Dq=#

v g{\;a_T\,G4+Q OR u~*;* UNION Sd#(PX OR k UNION

D | ` j8E " , k N D 6 IBM solidDB SQL 8 O 7 P P X
CONVERTORSTOUNIONS DV[#)

v 4PG\,S<

PX4P=8P?vYwr%*Dj8E",kND6IBM solidDB SQL 8O7PPX
EXPLAIN PLAN FOR odDV[#

x+],TczI\;uL,S}L4P1dDPd,Sa{#

1 solidDB y>*X 7

&m4P<

T4P<xPD&mV*}v,xDWN4P:

v `M@@WN

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

v @c@@WN

@@lw08PT0lw{va{/D*z,"y]kCods(DN}54/,

X!qJ1DQw_

SQL E/w9*z@cyZPX|5V<iv"ms!Md{/,3F}]DT/,
$E"#z;h*TV/==|Bw}1=<rNNd{@cE"#

v PlwWN

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

solidDB xg~q

solidDB xg~qyZ6L}LwC(RPC)6},s_9(ESZr%WC# 1M'
zr~qw"Mks1,|MqGwC>X/};yYw#xg~qT;IS==+

Cks0dN}+]=~qw,ZC~qwO,RPC ~qw+wC5JD~q
~q/}jIs,5XN}+;"MX=wC&CLr#

T#

/}#C

ZV<=53P,I\aP`v&CLr,1ks~qw4P`nYw#*Ko=n
s"PT,solidDB xg~q+9CICDYw53_L4a)^lD`C''V#Z

%_LYw5

(Ea0c

solidDB (E-i DLL(r2,b)a)K?V-iDj<Z?SZ#(Ea0cDn
Mc?~w*|0w$w,|:p!qkx(X7E"`XD}7-i DLL rb#Z
K.s,a0D5J-iE"&Z~X4,#

solidDB IT,1l}`V-i#

`_L&m

solidDB D`_Le5a9'VZ&CLrP_'X2m&mw# _LGIVIDzk
i,|vv5PQ;"Dfw(Z_L4PZd)0dEH6#|kxLPDyPd

{n/_L2myPd{Z]#k4(xL`H,4(_LD53*z*MC
LIzk"}]T0r*DD~Mr*DSP.`Dd{J4iI)#

_Lw*wCLrDiI?V0k=ZfP;rK,wC_L1;XCJEL#_L

IT9C+Vd?"B~MEExP(E#

g{Yw53'V;,&

mw#

3O,xg~q(}c:9Cl=Yw4nsLHXa_T\#

`(x

mw.dDTF`_L<u,G4 solidDB aT/{C`v&

_L`M

solidDB _L<u53I(C_LM(C_LiI#

(C_L

8 IBM solidDB: \m18O

(C_L4P~qwDNq53PDNq#|G4PDNq|(*C'ksa)~
q"4(8]"4P(1|n"O"w}T04(lic(+;BD}]f"=E

L)#

(C_LSNq53Pq!Nq,4PNq=h1AjI,;sP;=N

q53PD

m;vNq#Nq53T-7==$w,SxZ;,_L.dyHXV"M'zY
w#

zITZ solid.ini dCD~PhC(C_LD}?#

(C_L

(C_L)X(Yw(C#Z~qwP,I\fZBP(C_L:

v I/O \mw_L

K_LCZxPG\EL I/O E/T0:Xyb#yP I/O ks<(} I/O \mw,
s_7(G+?v I/O ks+]=_Y:f9GZd{ I/O ks.dTdxP2E#

I/O ks

4|GD_-D~X7Er#xPErPzZE/D~ I/O,bGr*,Z

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

v (EA_L

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

'z4((CDA_L#

M

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

(#,?V-iP;v(E!qw_L#?vKPPD!qw_L<++kks4

k+2{"SP#

v (E~qw_L(2F* RPC ~qww_L)

K_LS+2{"SPP

q#

A!ks"(}wCyksD~q/}*&CLra)~

1 solidDB y>*X 9

10 IBM solidDB: \m18O

2 \m solidDB

>ZhvgN,$y20D solidDB#>Z{vD\mNq|(:

v 4Py>D solidDB Yw,}gt/M#9~qw

v 8]~qw

v T}]bxPS\

*c: g{z} Z9C_P2mZfCJ(SMA) r4Sb CJ(LLA)&\D
solidDB,G4kj< solidDB

6

IBM solidDB

6
DE"#

CZxP}]b\mDC'G+

solidDB |,BPCZxP\mM,$$wDG+:

v SYS_ADMIN_ROLE

bG}]b\m1G+,KG+TyPm"w}MC'5PX(,"RP(9C
“solidDB 6LXF”(solcon)#b2G}]b4(_DG+#

v SYS_CONSOLE_ROLE

2mZfCJM4SbCJC'8O7

`H,Z\m=fP;)np#X*1,> B+}C

7Ta)X(Z SMA r LLA

t/ solidDB

KG+P(9C“solidDB 6LXF”,+;_Pd{\mX

v SYS_SYNC_ADMIN_ROLE

bGCZ4Pk,=&\`XD\mYw(}g>}{")D\mG+#( “{"”
CZZw}]bkd1>.d4X+]E"#}g,}G9C,="B==,qr

*"Bw}]b"<PD}],1>}]bh"M REFRESH {"#)NN

J ( D K 1 < + T / ; Z h y P Z ( G + # K G + T / | (

SYS_SYNC_REGISTER_ROLE#

v SYS_SYNC_REGISTER_ROLE

KG+vCZrw}]b"ar"z1>}]b#

zIT9C GRANT ROLE od4(eb)G+#PX j8E ", k N D

SQL

8O7

PD:

\mC'X(MG+

(}Z|na>{&"v|n solid [options],rZ Windows 73P,(}9C*

< → Lr → IBM solidDB K%76,It/ solidDB#

CZt/ solidDB Do(gB:

solid [options]

;#

(#

_PKC

6

IBM solidDB

TZ options,kND Z 193 3D=< C, :solidDB |nP!n;#

11

*t/ solidDB,P'mI$D~Xk;Z$w?<Pr;Z9C SOLIDDIR 73d?
8(D;CP#

m3.t/~qw

Yw53 *t/~qw...

®

M UNIX Z$w?<P,Z|na>{&dk|n solid [options]#

Linux

Z;Nt/~qw1,k9C|nP!n -f T?F~qwZ0(KP:

solid -f

Windows

v (}*< → Lr → IBM solidDBK%76%wjPt/ IBM solidDB ~qwD<j#

v Z$w?<P,Z|na>{&dk|

v *t/~qwT9dZs(KP,kdk|n start solid#

n solid [options]#

1 solidDB t/1,|+li}]bGqQfZ#~qw+HiR solid.ini dCD
~"A! FileSpec N}D5#;s,~qw+liGqfZ_P FileSpec N}y8

({FM76D}]bD~#g{R=}]bD~,G4 solidDB +T/r*C}]
b#g{R;=

}]b,G4~qwa4(B}]b#

":

>ZDZ]vJCZj< solidDB#g{z}Z9C_P2mZfCJ(SMA)r4S

bCJ(LLA)&\D solidDB,kND6

C'8O7

7TKbPXgNt/ solidDB SMA r LLA ~qwD8>E"#

IBM solidDB

2mZfCJM4SbCJ

6

`XN<

Z 193 3D=< C, :solidDB |nP!n;

`XE"

Z 63 3D:FileSpec_[1...n] N};

G<

solidDB }]b*sC'9C{GDC'{M\k4G<=}]b#

g{z"T9C;}7DC'{M/r\kG< 4 N,G453+h{zD IP X7"
R1dn$Io 60 k#K&\^(xPdCrXU#

^D solidDB ~qwM solidDB SQL `-w(solsql)D
Windows l]==

1!ivB,*< → Lr → IBM solidDBK%76PDt/ IBM solidDB ~qwM
solsql SQL `-w<jITt/ eval_kit\standalone ?<PDLr#*|D1!h

C,k^Dl]==DtT#

^Dt/ IBM solidDB ~qwl]==

(}^Dt/ IBM solidDB ~qwl]==DtT,zIT8(t/ solidDB 19C
D$w?<"G<}]M53?<{FT0d{|nP!n#

1. R|%wt/ IBM solidDB ~qw<j#

2. !qtT,;s!ql]==!n(#

12 IBM solidDB: \m18O

3. *|DG<}]M?<{F(rd{t/!n),k^D?j VNPa)D|nP

!n:

v -C - 53?<{F

v -P - \k

v -U - C'{

}g:

″C:\Program Files\IBM\solidDB\solidDB6.5\bin\solid.exe″ -C mycatalog -P mypassword

-U myname

*qCICD solidDB t/!nPm,kND Z 193 3D=< C, :solidDB |n

P!n;;Z#

4. *|D$w?<,k^Dp<;CVNPD?<76#

}g:

″C:\Program Files\IBM\solidDB\solidDB6.5\eval_kit\mytest\″

^D solsql SQL `-wl]==

(}^D solsql SQL `-wl]==DtT,zIT8( solidDB SQL `-w
(solsql),SAD solidDB ~qwD,SE"MG<}]#

1. R|%w solsql SQL `-w<j#

2. !qtT,;s!ql]==!n(#

3. *|D,SE"MG<}],k^D?jVNPa)D

k#

~qw{F"C'{M\

4(B}]b

}g:

″C:\Program Files\IBM\solidDB\solidDB6.5\bin\solsql.exe″″tcp 2315″ myname mypassword

Kb,z9ITZ?jVNP8(t/!n#*qCICD solsql t/!nPm,

kNDZ 73 3D:t/ solidDB SQL `-w;;Z#

solidDB }]bGZ solidDB ~qwt/14(D#

1 solidDB t/1,|+li}]bGqQfZ#g{}]b;fZ,G4 solidDB +

a>z4(BD}]b#

v Z Windows 73P,;vT00Zaa>zdk}]b\m1DC'{"\kM1

!(53)?<D

v Z Linux M UNIX 73P,+T>TB{":

}]b;fZ#*4(B}]bp(y/n)?

g{Xp“Yes”,G4 solidDB aa>zdk}]b\m1DC'{"\kM1!(5

3)?<D{F#

S\}]b\m1DC'{M\k.s,solidDB +4(B}]b#

{F#

2 \m solidDB 13

1!ivB,}]b+;4(I solidDB $w?<PD;vD~(solid.db)#

;|,53mMS<DU}]bs<<C 4 WVZDELUd# 4(}]byhD1

d!vZzy9CD2~=(#g{zP;vG#!D}]b(!Z 4 WVZ),
#{7 # 9 CD E LU d ? !Z 4 W V Z ,G 4 k+ solid.ini dC D ~ P

IndexFile.ExtendIncrement N}D5hC*!Z 500(1!5)#Z 145 3D=< A,
:~qwKdCN};TKN}Md{N}wKV[#

"R

4(}]bjIs,solidDB +*<ZxgPl}M'z,
P,+T> solidDB <j,+Zs`}73P,solidDB w*X$xLT;IS==Z

s(KP#

C'{"\kM53?<{

4( solidDB }]b1,+a4 (}]b5 3\m1J ';}]b D4(__P
SYS_ADMIN_ROLE C'G+#4(}]b1,9a4(53?<{,"RTs;\|

D53?<{#

*c:zXkG!C'{M\k,Tc\;,S= solidDB#;P1!C'{;z
}]b1dkD\m1C'{G(;ICZ,S=B}]bDC'{#

*c:C'{"\kM53?<{PD!4V{+a*;*s4#

C'{

v n!$H:2 vV{#

v ns$H:80 vV{#

v C'{XkTV8rB._*7#IT9C!4V8 a = z"s4V8 A = Z"B

._V{“_”T0}V 0 = 9#

\k

v n!$H:3 vV{#

v ns$H:80 vV{#

v \kIT9CNNV8"B._r}V*7#IT9C!4V8 a = z"s4V8 A

= Z"B._V{“_”T0}V 0 = 9#

v ;\Z\kP9C+}E(″ )V{#?R(iz;*

Uq(“”),bGr*3)$_Z\kP;S\b)V{#

v g{zF.9C solcon,G4k;*4(|,G ASCII V{D\k,bGr* solcon

;aTNNdk4P UTF-8 *;#

v Kb,z9ITSD~dk\k#P

\k;#

Sks#Z Windows 73

4(

9C2E(’)"VE(;)r

X|`E",kNDZ 96 3D:SD~Pdk

53?<

v n!$H:1 vV{#

v ns$H:39 vV{#

v 53?<{;\|,Uq#

CZ}]bTscNa9D solidDB o(gBy>:

catalog_name.schema_name.database_object

14 IBM solidDB: \m18O

1!#={kC'{`,#

1Z solidDB P4(Ts1,g{;8(?<M#={,G4~qw+9CTs4(_
D53?<MC'{47(*9CDTs#

PX solidDB ?<M#=Dj8E",kND

}]bTs

;;Z#

Unicode M?V Unicode }]b==

S V6.5 *<,I(}TB=V==4( solidDB }]b:Unicode ==r?V Uni-
code ==(1!5)#K}]b==yZ solidDB ~qwPV{}]`M(CHAR M
VARCHAR H)D`k#m;V{}]`M(WCHAR M WVARCHAR H)G(}b
=V==xP Unicode `kD#

v Unicode ==

6

IBM solidDB SQL

8O7

PD:

\m

Z Unicode

m;V{}]`MDZ?m>(* UTF-16#

v ?V Unicode ==

Z?V Unicode ==B,V{}]`MDZ?m>(;a9CNNX(D`k;xG

+}]f"ZVZV{.P,,1Y(C'&CLr*@Ki
*;#

m;V{}]`MDZ?m>(* UTF-16#

(} solidDB V6.3 r|Mf>4(D}]b*?V Unicode `M#

*c:6.5 PD1!}]b==*?V Unicode#

==B,V{}]`MDZ?m>(* UTF-8#

v"ZX*1&mC

4( Unicode }]b

solidDB }]b==G(}N} General.InternalCharEncoding XFD#

v Unicode ==:General.InternalCharEncoding=UTF8

1 InternalCharEncoding hC*“UTF8”1,V{}]`MDZ?m>(* UTF-8#
aZ solidDB ~qwk&CLr.d*;V{}]`MMm;V{}]`M#

v ?V Unicode ==:General.InternalCharEncoding=Raw

1 InternalCharEncoding hC*“Raw”1,V{}]`MDZ?m>(

NX(D`k;xG+}]f"ZVZV{.P,,1Y(C'&CLr*@Ki

v"ZX*1Q&mC*;#aZ solidDB ~qwk&CLr.d*;m;V{}]
`M#

(} solidDB V6.3 r|Mf>4(D}]b*?V Unicode `M#

*c:4(}

g{}]bQZdP;V==BfZ,"RC}]b==kN}D5`,\,G4~

qwt/'\,"RTBms{"avVZ solerr.out P:

N} General.InternalCharEncoding kVP}]b==`,\

]b1,Xk(e}]b==,"RTs;\T}]b==xP|D#

;a9CN

2 \m solidDB 15

hC}]b73

1!ivB,solidDB }]bD~"U>"{"MzYD~GZ solidDB $w?<P4
(D#TZzz73,}g,zI\khC}]bD~"8]D~MU>D~;Z;

,DELOD73#

1!$w?<hC

$w?<

GbyD;v?<:|,kKPX( solidDB 5}`XDD~#

BmT>Kn#CD solidDB D~"CD~Dv'5;CT0^D;CD==#

m

4. solidDB

D~ v'5;C ^D==

mI $ D ~(solid.lic"
soliduc.lic r
solideval.lic)

solid.ini dCD~ $w?< Z SOLIDDIR 73d?P(e76

}]bD~(solid.db) $w?< 9CIndexFile.FileSpec N}(e

B q U > D ~

(sol#####.log)

{"D~(solmsg.out) $w?< ;\|D;CM{F;<UZ$w?<Pdv

msD~ (solerror.out) $w?< ;\|D;CM

zYD~(soltrace.out) $w?< 9C Com.TraceFile N}(e

8]D~s<$ w ? <

1!D~

$w?< Z SOLIDDIR 73d?P(e76

$w?< 9C Logging.LogDir N}(e;C

r_

9

C Logging.FileNameTemplate N}(e;

CMD~{

":g{8(CZU>D~D?<,G4Zt
/ solidDB .0,C?<XkfZ:solidDB ;

\4(?<#

solmsg.out D~#

{F;<UZ$w?<Pdv

solerror.out D~#

9C General.BackupDirectory N}(e

>/backup

":8] solidDB .0,CZ8]D~D?<X
kfZ:solidDB ;\4(?<#

XZzz73D(i

v g{;kZzz73ZcOKP20Lr,G4Z@"DZcO20 solidDB,;s

+I4PD~"bM}/LrV/4F=zzZc(g{JCZzD20D0)#

v *K@9Z"zELJO1*'}],k+}]bD~MBqU>D~

Dom}/wO#b9+a)nQT\,XpGZ4P}]blicZd,1T}
]bD~MBqU>D~xP4Yw1#

v +>XEL(x;GxgEL)CZf"}]bD~MU>D~#

TZ solidDB HotStandby hC,bXpX*#TZxP

D73,a+ HotStandby dCw*?j,"RbnC(}9w}]bk(z}]b
;Z;,Zc(?v<9C>XEL)O4jI#xgEL_Pw*53P_-/ o

m%JOcDgU#

16 IBM solidDB: \m18O

f"Z;,

;2mNNZ]De5a9

`XEn

Z 23 3D:i4ms{"MU>D~;
1!ivB,solidDB aZ solidDB $w?<ZD solmsg.out M solerror.out U

>D~PdvmsM{"#*i4%uryPms{"Dhv,k9C ADMIN
COMMAND ’errorcode’#

`XE"

Z 54 3D:dCD~MN}hC;
fZ=v;,D solid.ini dC
z#b=vdCD~<;GXhD#g{;PdCD~,G4+9Cv'5#

Z 62 3D:\m}]bD~M_Y:f(IndexFile Z);

Z 39 3D:4P8]MV4;

Z 22 3D:Z;(FczOKP`v

D~,;vCZ~qw,m;vCZ ODBC M'

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!+
s!#B;Z+T FileSpec M BlockSize N}xPhv#

~qw;

0lT\,"R9+^FnsG<

zITZZ 145 3D=< A, :~qwKdCN};PR=yPN}Dj{hv"PX

solid.ini D~D}7q=Dj8E"T0PX8( solid.ini dCN}D8>E"#
PXhC

N}D|`j8E",kNDZ 53 3D3 B, :dC solidDB;#

hC}]bis!(BlockSize)M;C(FileSpec)

solidDB }]bD~D1!is!* 16 KB#is!(e* 2KBD6}#n!is
!G 2KB,ns5G 64 KB#}]bDnss!G 64 TB#

is!(}N} Indexfile.BlockSize xPhC#g{*C solidDB 4(_Pm;is
!D}]b,G4XkHhCBD#?5,;sY4(B

]b,G4qX+I}] b(.db)MU>D~(.log)FAm;v ? <;BNt/
solidDB 1,+4(B}]b#

*^DB}]bD#?5,kZ solid.ini D~PmSBPwP(a)TVZFDs
!):

[Indexfile]
BlockSize=size_in_bytes

}gyPks!`XDN};y,s!%;G 1 VZ#9IT9C%;{E K M M
(Vpzm KB M MB)#

Z#fD~"t/ solidDB .s,|+4(_P solid.ini D~PDB#?5D}]

b#

}]b#g{fZVPD}

,y,z2IT(}^D FileSpec N}4(eBPwn:

]bD~D;C(1!;CG solidDB ?<PD solid.db)

v }

2 \m solidDB 17

v }]bD~ITo=Dnss!(TVZF,1!5G 2147483647,4 2G-1v

VZ)#nsD~s!G (4 G - 1)*is!#9C1!is! 16 KB 1,nsD~

s!* 64 TB – 1#

z9IT9C FileSpec N}+}]bD~.V*`vD~"f"Z`vELO#g{
zk4(s

PX9C FileSpec N}dC}]bD~;CMs!Dj8E",kNDZ 62 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",kND6
m}]bTs;;Z#

5JO,solidDB y'VDm"PMw}D}?;\^F#V{.M~xF}]TId

$Hq=f"#K&\ITZ!ELUd#b99C*"_D`L$w|*r%,-
rGV{.r~xFVND$H;

(}dC MaxBlobExpressionSize N},IThCV{./}P9CD LONG
VARCHAR(r CLOB)PDnss!#(Ks!ITIC'VZ(K)rWVZ(M)

*%;8(#)1!ivB,Ks!* 1MB(1 WVZ)#

MDom}]b,G4I\Xkbyv#

6

IBM solidDB SQL

XL(#%;P5Dnss!G 2G-1 VZ#

8O7

}#={T

7PD:\

,S= solidDB

*Ka_'J,

r}V/yt.`D BLOB(~xFsTs)sZX(s!1,solidDB +T/lb=

bViv"+G)Tsf"=;vXbD~xr,CxrDis!QkTsMD~x
PE/#z;h

O7

7D:=<:}]`M;PD BLOBMCLOB ;Z#

t/ solidDB .s,zIT9C solidDB g+rV$_"solidDB SQL `-w(solsql)
r solidDB 6LXF(solcon)S$w>,S=~qw,SxbTdC#

":>ZDZ]vJCZj< solidDB#g{z}Z9C_P2mZfCJr4SbC
J&\D solidDB,kND6

TKbPXgN,S= SMA r LLA ~qwD8>E"#

*,S= solidDB,k4PBPYw:

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

BP{"+8>IT9CD{F#

Listening of ’tcp hobbes 1313’ started.

2. t/BPdP;v&CLr,"8(~qwDxg{w*|nPN}:

solidDB IT+ BLOB }]f"Zmb?#1Ts"<q"S5"<N

*4P\mYw#PX|`E",kND66IBM solidDB SQL

6

IBM solidDB

2mZfCJM4SbCJC'8O7

8

7

18 IBM solidDB: \m18O

m5.,S=

$_ |n

solidDB

solidDB 6LXF(solcon)

solidDB SQL `-w(solsql)

XU}]b

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,

G4 solsql +a>zdkb)Z]#

;C.s,z+4=;u{"8>Q-k~qw(",S#

PX solidDB SQL `-w(solsql)r solidDB 6LXF(solcon)D|`j8E",
kND Z 71 3D4 B, :9C solidDB }]\m$_;#

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

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

ADMIN COMMAND ’close’;

XU solidDB

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

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

D}L,kND: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)#

z close |nD'{,k9CTB|n:

*7

ADMIN COMMAND ’open’;

":

>ZDZ]vJCZj< solidDB#g{z}Z9C_P2mZfCJ(SMA)r4S

bCJ(LLA)&\D solidDB,kND6

C'8O7

7TKbPXgN#9 solidDB SMA r LLA ~qwD8>E"#

IBM solidDB

2mZfCJM4SbCJ

6

zIT(}BP=(4XU solidDB:

v S solidDB 6LXF(solcon)r solidDB SQL `-w(solsql).`D&CLrP

T`L==jIYw#*K,k4PBP=h#

1. *K@9k solidDB ("B,S,k(}dkTB

|n4XU}]b:

2 \m solidDB 19

close

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

open

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

throwout all

"b,K|n;aH}Qr*DBqjI;|+P9"XvyPQr*DBq#

3. (}dkTB|n,#9 solidDB:

shutdown

":9C solidDB SQL `-w44POfD=h 1-3 1,kdkj{D SQL o(,

ADMIN COMMAND ’<command_name>’

}g:

ADMIN COMMAND ’close’

v 9C|,OvyPnD ADMIN COMMAND ’shutdown force″ |n#

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

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

9C“net start”|nT6L==t/ solidDB#

b)XUzFPD?V

bD~,ME_Y:fZf"nUU9~qwLr#XU~qwD}LI\h*;!

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

zF<+t/,;v}L,C}L+:fDyP}]4k}]

+ solidDB w* Windows ~qKP

IT+ solidDB w* Windows PD~qKP#WN*+ solidDB w*~qKP1,X
k20C~q,4Jm Windows + solidDB w*~qKP#.s,zIT(} Win-
dows D“~q”T0r|na>{t/M#9~q,2IT9C solidDB |nP!n}

%~q#

WN+ solidDB w*~qt/

WN*+ solidDB w*~qKP1,XkH20C~q,;s9C Windows D“~q
”T0r|na>{t/C~q#

*<.0

v g{z.0944(}]b,G4Xk(}WN+C~qww*0(xLt/44

(}]b#bGr*1 solidDB w*~qKP1,|;akA;;%"R^(4(B
}]b#zITS|nP9C|n solid +C~qww*0(xLt/,

LrK%PDt/ IBM solidDB <j#

v *w*~qKPD solidDB ;\;Zxg}/wP#

2IT9C

20 IBM solidDB: \m18O

}L

1. Jm(20)Windows + solidDB w*~qKP#

Z|na>{P,"vTB|n:

solid -s"install,<name>,<fullexepath> -c<working directory>[,autostart]"

dP:

<name> G~q{F

<fullexepath> G solid.exe Dj{76

<working directory> G solidDB $w?<(solid.ini MmI$D~yZD;C)

Dj{76

T/

[autostart] GI!N},CZ+~qDt/`MhC*
/1,solidDB +T/w*~qKP#

":

^[ [autostart] N}D5gN,201;aT/t/C~q#WNt/1,Xk

Z Windows D“~q”T0r|na>{PV/t/C~q#(kNDBfD=h
2#)

>} 1

,4,1 Windows t

1 solidDB Q20=?< C:\soliddb "
20{* SOLID D~q(t/`M*

solid -s"install,SOLID,C:\soliddb\bin\solid.exe -cC:\soliddb"

R$w?<G C:\soliddb 1,TB|n

V/

)#

>} 2

1 solidDB Q20=?< C:\soliddb "R$w?<G C:\soliddb 1,TB|n

T/

20{* SOLID D~q(t/`M*

)#BN Windows t/1,solidDB +

T/w*~qKP#

solid -s"install,SOLID,C:\soliddb\bin\solid.exe -cC:\soliddb,autostart"

a>:

r_,z2IT9C Windows D|nP5CLr sc.exe 4(C~q#ZGViv

B,*T~q==t/ solidDB,zXkZ|nP|( solidDB -sstart |nP!
n#}g:

sc create SOLID binPath= "c:\soliddb\bin\solid.exe -cC:\soliddb -sstart"

h* -sstart |nP!n4}% solidDB ~qwkC'.dyZ GUI D;%#w
* Windows ~qKPDLr^(9CG);%#

2. Z Windows D“~q”T0r|na>{PV/t/~q#

v IT(}XFfeCJ Windows D“~q”T0:XFfe → \m$_ → ~q#

v Z|na>{P,"vTB|n:

sc start <name>

2 \m solidDB 21

a{

w* Windows ~qKP1,solidDB a+/fMms{"G<= Windows B~U>#

ITZ Windows P9CB~i4wi4b){"(IT(}XFfeCJB~i4
w):XFfe → \m$_ → B~i4w#{"9+G<= solmsg.out D~#

t/M#9 solidDB ~q

IT9C Windows D“~q”T0r|na>{t/M#9 solidDB ~q#

}L

v IT(}XFfeCJ“~q”T0:XFfe → \m$_ → ~q#

v Z|na>{P,

– "vTB|nTt/C~q:

sc start <name>

– "vTB|nT#9C~q:

sc stop <name>

dP <name> Gz*t/r#9D~qD{F#

}% solidDB ~q

IT9C solidDB |nP!n}% solidDB ~q#

}L

1. Z Windows D“~q”T0r|na>{P#9~q#

v IT(}XFfeCJ Windows D“~q”T0:XFfe → \m$_ → ~q#

v Z|na>{P,"vTB|n:

sc stop <name>

dP <{F> Gz*#9D~qD{F#

2. }% solidDB ~q#

Z|na>{P,"vTB|n:

solid -s"remove,<{F>"

>}

TB|n}%{* SOLID D~q#

solid -s"remove,SOLID"

Z;(FczOKP`v~qw

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

solidDB 9C$w?<DEn#$w?<(#|,kKPX( solidDB 5}`XDD~:

v mI$D
v solid.ini dCD~

v }]bD~

22 IBM solidDB: \m18O

~

v BqU>D~

v {"MzYD~

g{z*Z;(FczO,1KP`v~qw,G4Xk*?v solidDB 5}hC%@
D$w?<#

*Z;(FczOKP`v~qw:

v ZwTD$w?<Pt/?v solidDB ~qwxL,

r_

v 9C|nP!

n -c directory_name 4xk$w?<#

*\b"zxge;,kZ solid.ini dCD~PT?v~qw9C;,Dx gl}
{#

>}:

*t/=v solidDB ~qw5}:

1. 4(=v$w?<#}g:

v C:\solid1
v C:\solid2

2. +mI$D~4F==v?<#

3. Z?v$w?<

P,4( solid.ini dCD~"8(;,Dl}{#

}g:

solid1:

[Com]
Listen=tcpip 2315

solid2:

[Com]
Listen=tcpip 2316

4. Z solidDB 20y?<P:

a. 9CTB|nt/Z;v solidDB ~qw5}:

bin\solid -c C:\solid1

b. 9CTB|nt/Z~v solidDB ~qw5}:

bin\solid -c C:\solid2

i4ms{"MU>D~

1!ivB,solidDB aZ solidDB $w?<ZD solmsg.out M solerror.out U>

D~PdvmsM{"#*i4%uryPms{"Dhv,k9C ADMIN COMMAND
’errorcode’#

XF{"U>dv

g{*(}`L&m{"D~,9xI 8 vV{iID(;zkD{"\;dv#9I

{C“zI{"U>D~”#

2 \m solidDB 23

solidDB +,$BP{"U>D~:

v solmsg.out – ng,S"O*,S"lic"8]T0'\DG<H#fN<B~D

U>D~

v solerror.out – kTB|ms((#<B~qw@#)DU>D~

Kb,solidDB 9IzIzYD~ (soltrace.out) TcxPJOoO#

I(}D

{"U>D~s!G(} Srv.MessageLogSize N}XFD#1o={"U>D~D

nss!1,a+10D solxxx.out D~X|{* solxxx.bak,"Rt/BD
solxxx.out D~#*\bBNo={"U>D~Dnss!12G8] solxxx.bak {

"U>DZ],k9C Srv.KeepAllOutFiles N}4t

~#

>`-wi4{"U>D~#

C*(}v?==|{DU>D

tC{"U>PD{"zk

?umsM4,{"<(}I 8 vV{iID(;zkj6#g{(}Lr4&m{"
D~,"R{"D~|,{"k, G4IT|=cXbv{"#*tC{"zkd
v,k+ Srv.PrintMsgCode hC*“yes”(1!5*“no”)#

{C{"U>zI

*{C solmsg.out T0 solerror.out U>D~DzI,k+ Srv.DisableOutput N

}hC*“yes”(1!5*“no”)#

*c:{CU>D~zIa9TJbxPoO\'Q#XU{"U>G<&\+a_
T\"5MELUd9C?;+G,Zs`}ivB,T\DFyH"vd
nvZ1{DivBPC,}g I/O I>“_:”(3)9CAfD53PDiv),r

_53D}]f"Ud+*P^"R{"U>D~g;>}+;1[}#

"#K!

9C ADMIN COMMAND 'errorcode' 4i4ms{"hv

?umsM4,{"<G(}(;`E4j6D,I+C(;`Ek ADMIN COMMAND
’errorcode’ dO9CTi4mshv#

|n ADMIN COMMAND ’errorcode <error_number>’ T>x(ms{"Dhv#

}g:

ADMIN COMMAND ’errorcode 14706’;

CfK 4 P#

|n ADMIN COMMAND ’errorcode all’ IC“:EVt5”(CSV) q=T>yPms{"

Dhv#

ZZ 199 3D=< E, :msk;P,2a)Kmszk0dhv#

24 IBM solidDB: \m18O

RC TEXT

-- ---­0 zk:SRV_ERR_HSBINVALIDREADTHREADMODE (14706)
0 `:~qw
0 `M:ms
0 D>:CZ HotStandby DA!_L==^',v'V== 2#

9CzYD~

zYD~ (soltrace.out) w*CZTl#B~xPJOoO#

Z~qwU#YwZd,"GXk4P`SzYD~b;Yw#PXzYD~T0g
N9C|GD|`j8E",kNDZ 129 3D:xgzY$_;#

zY'\DG<"T

G<'\1,+G<PXC"TDE"T7#2+#

'\D"T+<U:

v }p SYS_EVENT_ILL_LOGIN B~,"R
v +{",1r!= solmsg.out M solerror.out#

}g,{"|,xPC"TD IP X7MC'{#{"Do(gBy>:

timestamp [message code] User username tried to
connect from {hostname | unnamed host} with an
illegal username or password. [SOLAPPINFO is solappinfo value.]

>}:

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.

`S solidDB

li}]b{e4,

": v1Z solid.ini PtCK{"zkr! (Srv.PrintMsgCode=yes) 1,Ea

|(

{"zk

#

":;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 IBM solidDB started at 2009-08-13 12:48:24
0 Current directory is C:\solidsw\solid64\eval_kit\standalone
0 Using configuration file C:\solidsw\solid64\eval_kit\standalone\solid.ini
0 Memory statistics:
0 39269 kilobytes
0 Process size statistics:
0 Resident set size: 16312 kilobytes
0 Virtual size: 43040 kilobytes
0 Transaction count statistics:
0 Commit Abort Rollback Total Read-only Trxbuf Active Validate
0 114 0 1 115 237 0 1 0
0 Cache count statistics:
0 Hit rate Find Read Write
0 100.0 28809 0 56
0 Database statistics:
0 Index writes 3623 After last merge 0
0 Log writes 2277 After last cp 0

2 \m solidDB 25

0 Active searches 0 Average 1
0 Database size 8064 kilobytes
0 Log size 16 kilobytes
0 User count statistics:
0 Current Maximum Total
0111

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

#,_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

KPDn/Bq#"b,}sD Bonsai w+<BT\B5#PXu! Bonsai ws
!Dj8E",kNDZ 111 3D:(}d5Bqu! Bonsai wDs!;#

v C'F}3FE"T>

”)Ds!#K5=!,~qwT\=C#OsD5mw}fPfZ$1d

q!10Q,SDC'

z9IT(}Z solidDB SQL `-w(solsql)PdkTB|n4q!Q,SC'DP
m:

0_Y:fYw}#(

""C'D10}?Mns}?#

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:

ADMIN COMMAND ’status netbackup″

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

26 IBM solidDB: \m18O

RC TEXT

-- ---­0 SUCCESS

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

C8]10}ZKP#

zI4,(f

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

B|n:

ADMIN COMMAND ’report report_filename’

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

T\F}w (perfmon)

IT(} ADMIN COMMAND ’perfmon’ q!PXwV}]bYwMT\DE"#

ADMIN COMMAND ’perfmon’ |n5XyP solidDB T\F}w(F* perfmons r

pmons)Da{/#ZZ 28 3D:perfmon F}wDj{Pm;PP>"hvKyPb

)F}w#

ADMIN COMMAND ’perfmon’;

RC TEXT

-- ---­0 Performance statistics:
0 Time (sec) 3 Total
0 File open : 0.0 0.1
0 File read : 0.0 1.2
0 File write : 0.0 0.0
0 File append : 0.0 0.6
0 File flush : 0.0 0.0
0 File lock : 0.0 0.0
0 Cache find : 0.0 78.5
0 Cache read : 0.0 1.0
0 Cache write : 0.0 0.0
0 Cache prefetch : 0.0 0.0
0 Cache prefetch wait : 0.0 0.0
0 Cache preflush : 0.0 0.0
0 Cache LRU write : 0.0 0.0
...

?P<zmT\E"D;vlU,ClU43Kn|8VSDT\iv#Z;PT>
8kSZD=yT\E"#Total PT>TS solidDB t/sD=yE"#

s?V}5<G?kB~}#G)^(m>*?kB~}D}5(}g}]bs!)

xT5m>#

T

K|nDo(9Jmz8(dv!n#PXb)!nDj8E",kNDZ 279 3D

=< F, :solidDB ADMIN COMMAND o(;PD perfmon !n#

(}a)F}w{FD0:Pm,ITTdvxP^F#}g,ADMIN COMMAND ’perfmon
db’ 5XT“db”*7DyP pmon F}w:

ADMIN COMMAND ’perfmon db’;

RC TEXT

-- ---­0 Performance statistics:

2 \m solidDB 27

0 Time (sec) 19 Total
0 DBE insert : 0.0 0.0
0 DBE delete : 0.0 0.0
0 DBE update : 0.0 0.0
0 DBE fetch : 0.0 41.2
0 DBE dd operation : 0 0
0 Db size : 8064 8064
0 Db free size : 7440 7440
0 DB actiongate lock time, latest: 0 0
0 DB actiongate lock time, sum : 0 0

CfK 12 P#

0 DB actiongate lock count : 0 0

zI,xDT\`S(f

|n ADMIN COMMAND ’perfmon diff’ Jmz*<M#9+,xDT\F}w(fzI
=D~#

*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(CSV)D~,CD~T;PF }w{F

*7,"R?vIy1d<P;P}]#

*#9`S:

ADMIN COMMAND ’pmon diff stop’

perfmon F}wDj{Pm

F}w4U|GZ ADMIN COMMAND ’pmon’ dvPDvV3rP>#

m

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

File write D~4wCN}

File append D~7SwCN}/k#

File flush D~eVwCN}/k#

F}w

ZmDR`#

DZ;P#

/k#

File lock D~x(wCN}/k#

Cache find _Y:fCfN}/k#

28 IBM solidDB: \m18O

m

6. Perfmon

Perfmon d? hv

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 4P LRU f;1,+4_Y:fPDZ]#bb6E,IZ

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

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

Cache slot wait KF}wmwfZT,;viD""CJ,"R;v_

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

B1e;#

Cache slot replace }]b_Y:f[Q;f;,I[Q;}%#

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

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&

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

\&ZtC4,1,bG?k49uVZ}#

D6S34kEL#

LXkH}

;PI

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

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

SQL prepare SQL <8od}/k#

SQL execute SQL 4Pod}/k#

SQL fetch SQL Cfod}/k#

DBE insert m

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

DBE update m}fP|BN}/k#

DBE fetch m}fPCfN}/k#

}fPekN}/k#

2 \m solidDB

29

m

6. Perfmon

Perfmon d? hv

DBE dd operation ~qwQ4P SQL }]VdYw#

Proc compile }L`k}

Proc exec }L4PN}/k#

Proc SQL prepare 4T}LzkD SQL <8wCN}

Proc SQL execute 4T}LzkD SQL 4PwCN}

Proc SQL fetch 4T}LzkD SQL CfwCN}

Trig compile %"w`k}

Trig exec %"w4PN}/k#

Trig SQL prepare 4

Trig SQL execute 4T%"wzkD SQL 4PwCN}

Trig SQL fetch 4T%"wzkD SQL CfwCN}

SA insert SA 6PekN}/k#

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

SA update SA 6P|BN}/k#

F}w(x

)

T%"wzkD SQL <8wCN}

SA fetch SA 6PCfN}/k#

Trans commit d5DBq}/k#

Trans abort P9DBq}

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/Dd51i$YwD10}?

Trans active n/BqD10}?

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

F}wD5G 32 ;d?,rKIT_P:}5,+Z_-O,5T
;GZ]v#Z104Bq4PZd,g{K5$1d;d,G4
mwA6p;;v$Bqh{,b

vs#

/k#

I\<BO"h{T0 Bonsai w

Ind write w}4N}/k#

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

30 IBM solidDB: \m18O

m

6. Perfmon

Perfmon d? hv

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

Log file write U>i4N}/k#

Log nocp write O;vlic.sD]RU>G<}#

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

Search active m}f6n/Qw}#

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

F}w(x

)

Db free size }]bPD3f6ICUd?(

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

Merge quickstep lYO"=h}/k#

Merge step j+O"=h}/k#

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

Merge active G/q(1/0)#

Merge nomrg write }ZH}O"Dw}u?D10}?

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

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

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

}wCN}/k(g{QtCVne}&\)#

T KB F)#

Backup step }]b8]=h}

Backup active G/q(1/0)#

Checkpoint active lic4,

5 0 b6Elic&Z;n/4,#5 1 M|s5b6Elic&
Zn/4,;sZ 1 D58>4PlicDxH#

Checkpoint count TSt/*<DlicrE

Checkpoint file write lic

Checkpoint file read licD~AN}/k#

D~4N}/k#

/k(Zxg8]Mxg4F&\P2fZ)#

2 \m solidDB

31

m

6. Perfmon

Perfmon d? hv

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

Sorter start sort b?Ert/DN}

Sorter add row mSAb?ErwDP}

Sorter fetch row Sb?ErwA!DP}

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

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

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

F}w(x

)

Sync mast msg read

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>3fzeV

Log wait flush }ZH}U>YwDC'_LD10}?

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 availq items mSAICnSP

Log writeq add QmS=U>4LrSPDG<}#

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

w}]b:{"AN}/k#

N}/k#

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~

HSB flush count w~qw/(z~qw:{"eVN}/k#

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

qw:{"}/k#

F)#

32 IBM solidDB: \m18O

m

6. Perfmon

Perfmon d? hv

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

HSB flusher bytes T(z~qw*?jD"MSPPD HSB U>VZ}#

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

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~qwD lic &

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

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

F}w(x

)

}(U>G<})F)#

(z~q

p#

wDVZ}#

HSB log waitct HSB U>H}4

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

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

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

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

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

}#

Tabcur create Z?mNjwCN}

Tabcur reset full mNjPj+<xXCwCN}

Tabcur reset smpl mNjPr%<xXCwCN}

Tabcur estimate mNjP*z@cwCN}

Thread count 10_L}

Trans wait readlvl d51A6pDH}N}/k#

Trans wait readlvl G;vF}w,?NBqh*H}+VA6pd
*c;_Tc

}w<aS;#Z#f:XivB, bG 21 D, "R ;h *H

}#Z_:XivB,I\h*\LDH}-7#

ks}/k#

CBq|DZd51IS(TZd{Z])1,CF

DVZ

KF}wD5S;uY#30 k pmon 1ddtZO!Dv?(%v
}V)vG~

Lock ok I&x(ks}/k#

Lock timeout x(,1N}/k#

Lock deadlock @x}/k#

qwPLZvV_:XivD8>#

2 \m solidDB

33

m

6. Perfmon

F}w(x

)

Perfmon d? hv

Lock deadlock check 4Px\mw@xliDN}#

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

Lock wait x(H}}/k#

Lock count x\mwPDx(}#

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

}#

Number of search buffers yZELDmy9CDQw:exD10}

?

NOCHECK operations Q4PD NOCHECK YwDZ?}?#

MME cur num of locks 10 MME x(}

MME max num of locks TSt/sD MME x(}e5#

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

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

MME longest lock chain path MME:n$"Pgv76

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

MME mem used by indexes Vdxw}D MME Zf?(T

'VZF)

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

MME unnec mutexed searches CfD MME P},xZ%b==B;XCf

MME nonmatched (RO) 4k2m==BCfDQwu~`%dD MME P}

MME nonmatched (EXCL) 4k%b==BCfDQwu~`%dD MME P}

MME inserts with x gate T%b==4PDekYwD}

?#}g,1ek}pw}ZcV

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

MME deletes with x gate %b==B4PD MME >}YwD}?

MME hotspot protection MME Qwxk%b==TCJHcDN}

ek= MME w}PD|(|(}]bV4ZdekD|)}(;

1

MME index key inserts

MME index key deletes S MME w}P>}D|}#(;<7

<7

)

1

)

MME bnode resizes Qw{ MME bnode Ds!DN}

1

MME vtrie mutex collisions vtrie PV[%bQe;DN}(;<7

MME vtrie version colls vtrie Pf>liQe;DN}(;<7

,5{2)

1

,5{2)

MME vtrie vertical splits vtrie PQw76QI|ek91VnDN}(;<7

1

BV'QmSA vtrie ZcDN}(;<7

)

I4TB+=Fc vtrie D|FV'rS:

(MME vtrie BV'} - MME vtrie V'>}N})/(MME vtrie

91VnN} - MME vtrie 91,SN})+2#

1

)

KV'rSvJCZw}D vtrie ?V,^(@c bnode 6S6p

MME vtrie new branches

MME vtrie vertical joins vtrie P|>}Q<BQw76OZc;>}DN}(

V'rS#

;<71)

MME vtrie branch deletes vtrie P|>}Q<BV';S vtrie ZcP}%DN}(;<7

34 IBM solidDB: \m18O

1

)

m

6. Perfmon

F}w(x

)

Perfmon d? hv

1

1

1

,5{2)

1

,5{2)

,5{2)

,5{2)

MME vtrie insert retries IZe;,QXT vtrie ekYwDN}(;<7

MME vtrie delete retries IZe;,QXT vtrie >}YwDN}(;<7

MME bnode mutex collisions bnode CJQ<B%be;DN}(;<7

MME bnode version colls IZf>e;,bnode CJQ'\DN}(;<7

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}

G;VQwa9,+Z B wZcPDC;C9(;%

dw};CD

}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_Y:f

P4E/Qw#

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

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

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

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

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

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

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

bViv#(#,K5tzZlic.s#

z

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

q#

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_H(T

c}F)#

B-tree lock node B wZcx(wCN}#

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

2 \m solidDB

35

m

6. Perfmon

Perfmon d? hv

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

Pessimistic gate wait H}yZELD/[mEDN}#

Merge gate wait H}O"EDN}#

Storage gate wait H}f"wEDN}#

Bonsai Gate wait H} Bonsai wEDN}

Action gate wait YwEH}N}

MME pages gate wait CJ MME f"wPD3f1EH}N}

MME index gate wait CJ MME w}1EH}N}

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

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

Logreader spm waitct U>DAwU>UdH}N}/k#

F}w(x

)

#

Logreader spm freespc U>DAwUd\

c,G4axPBqwY(u})#

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

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

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

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

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

U>DAw:T SYS_LOG r*DNj}#

Aw:CZr*NjD=Q{"}/k#

mwICUd(I:eDYw})# g{ 5*

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

Logreader memcache queue len U>DAw:Zf_Y:fSPD$H(TYw}F)#

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

Logreader flush batch full

U>DAw:QSU>DAwPeUj{DBqzN#

36 IBM solidDB: \m18O

m

6. Perfmon

Perfmon d? hv

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

TS applied transactions

Passthrough open connections ksKD SQL +],S}

Passthrough open statements +]AsKD$`kod}

Passthrough reads 5XPDQ4PA!`Mod}(}g,SELECT od)

Passthrough non reads 5XPDQ4P4k`Mod}(}g,INSERT od)

Passthrough commits Qd5od}

Passthrough rollbacks Xvod}

Passthrough result cnv QCf(A!)

Passthrough param cnv Q4PodN}.dD*;Dod}

Passthrough failures ^(ZsKP$`kDod}

Passthrough reprepared QXB$`kDo d } , X

Passthrough complex by num non indexed constraints y] Passthrough.ComplexNumNonindexedConstr N}+]D

Passthrough complex by num ordered rows y] Passthrough.ComplexNumOrderedRows N}+]Dod

Passthrough complex by num tables y] Passthrough.ComplexNumTables N}+]Dod}

XA trans start

XA trans end QaxD XA Bq}

XA trans resume QLxD XA Bq}

XA trans prepare Q$`kD XA Bq}

XA trans commit Qd5D XA Bq}

XA trans rollback QXvD XA Bq}

XA trans forget Q|GD XA Bq}

XA trans recover QV4D XA Bq}

XA trans active 4Pi/1&Zn/4,D XA Bq}

SMA connection count SMA ,S}

SMA shared memory used 9CD2mZf

DB actiongate lock time, latest n|;Nx(VxD1d?(TAkF)

DB actiongate lock time, sum TS~qwt/syPx(QVxD1d?(TAkF)

DB actiongate lock count TS~qwt/sDx(}

Time sec K pmon Dr!dv1d(TkF)

F}w(x

)

™

1 solidDB w*?j}]f"w1 ,InfoSphere
solidDB &CDBq}#

DP},QTb)P4PsKk solidDB }]`M

.dD*;#}g,g{sKD}]`MG CHAR(5) "R solidDB

D}]`MG VARCHAR,G4Mh**;#

B$ ` k D - r G Z s K P4P K

INSERT"UPDATE M DELETE TbD4k`Mod#ZK`iv

B,h*4PXB$`kT7#m(e4|D,m(e|Da<B
$`kodms#

od}

}

Qt/D XA Bq}

?

CDC 5}T

1

jG*

2

ZjG*

;<7

DF}w;<7,r*IZT\-r,4T|GxP%b#$#

5{

DF}wP,syv$b6E,1tI_L}Z,1T}]bD`,?

VxP|B1,"PCJPfZ5{iv#

2 \m solidDB 37

9C solidDB sFzY(AuditTrailEnabled)

solidDB sFzY&\JmVCzY solidDB }]bPDC'M#=|D#sFzY(
} Sql.AuditTrailEnabled N}xPXF#tCsFzY1,a+PX}]bn/DE

"4k SYS_AUDIT_TRAIL 53m#_P\m1(^DC'IT9C#f SQL o(
4i/ SYS_AUDIT_TRAIL 53m#

tCsFzY1

v C'MG<E"PD|D

v #=M?<PD|D

v sFzYD4,(QtC/Q{C/>})

+Z~qw?Nt/14ksFzYD4,#IT9CK4,{"4liN1U/K
sFzY}]T0N1Z{

&\,G4BNt/1,53+4k;u4,{"48>Q{CsFzY#

,53+G<BP}]bn/:

CsFzYDivBt/K~qw#g{Ts{CKsF

C'CJ

v\m1(SYS_ADMIN_ROLE)ITi/ SYS_AUDIT_TRAIL 53m#\m19I
TSCm>}}];}G DELETE od40lNNP,qr+sF DELETE od#

sFzYM_ICT

Z_ICThCP,vw~qwE\4ksFzY#;x,XkZ=v~qwP,1
tCsFzY#bGr*?v~qw<G4UT:D solid.ini D~PDdChC4G
<}]bn/#g{"z*;(IDw~qw_P SQL.AuditTrailEnabled=yes),G

4BDw~q

E aL xG <|D# B D w ~q wD 4, + w * 4, {"(AUDIT TRAIL
ENABLED(HSB)r AUDIT TRAIL DISABLED(HSB))f"Z53mP#

wvZd Sql.AuditTrailEnabled N}ZONt/1hC*“yes”DivB

tCM{CsFzY

sFzY(} Sql.AuditTrailEnabled N}xPXF#Sql.AuditTrailEnabled N}D

CJ==G RO(;A)#

}L

v tCsFzY

1. Z solid.ini dCD~P+ Sql.AuditTrailEnabled N}hC*“yes”#

2. XBt/ solidDB#

a{t/1,53+;u4,{"4k SYS_AUDIT_TRAIL 53mT8>tCKs

FzY#}]bn/PD|D+G<Z SYS_AUDIT_TRAIL 53mP,1={Cs
FzY*9#

v {CsFzY

1. Z solid.ini dCD~P+ Sql.AuditTrailEnabled N}hC*“no”#

2. XBt/ solidDB#

38 IBM solidDB: \m18O

[SQL]
AuditTrailEnabled=yes

a{t/1,53+;u4,{"4k SYS_AUDIT_TRAIL 53mT8>{CKs

FzY#}]bn/PD|D;aG<Z SYS_AUDIT_TRAIL 53mP,1=YN
tCsFzY*9#

i/ SYS_AUDIT_TRAIL 53mPDsFzY}]

_P\m1(^DC'IT9C#f SQL o(4i/ SYS_AUDIT_TRAIL m#

}L

v >}:i4 SYS_AUDIT_TRAIL 53m

SELECT CREATIME, LOGIN_USER, SQLSTR FROM sys_audit_trail

CREATIME LOGIN_USER SQLSTR

2009-03-05 13:21:31 _SYSTEM AUDIT TRAIL ENABLED
2009-03-05 13:21:42 DBA CREATE USER DBUSER IDENTIFIED BY
2009-03-05 13:23:13 DBA CREATE SCHEMA DBA2
2009-03-05 13:23:23 DBA DROP SCHEMA DBA2
2009-03-05 13:23:24 DBA CREATE USER DBA2 IDENTIFIED BY
2009-03-05 13:32:22 DBUSER CREATE TABLE TEST (ID INTEGER)
2009-03-05 13:49:37 DBA CREATE CATALOG DBUSER
2009-03-05 13:49:59 DBUSER CREATE TABLE TEST_TAB (ID INTEGER PRIMARY KEY NOT NULL)

v >}:i/ CREATE USER Yw

SELECT CREATIME, LOGIN_USER, SQLSTR FROM sys_audit_trail WHERE type=’CREATE USER’"

2009-03-05 13:21:42 DBA CREATE USER DBUSER IDENTIFIED BY
2009-03-05 13:23:24 DBA CREATE USER DBA2 IDENTIFIED BY

-------- ---------- ------

CREATIME LOGIN_USER SQLSTR

-------- ---------- ------

4P8]MV4

4P>X8]

8]CZ#$}]bD~Pf"DE"#g{}]bD~p5r_IZ53JOx*
',G4ITy]8]D~4V4}]b#*7#}]49Z53"zJO1`2+
^G,z&C(Z8]w}]b,PI\19&8]1>}]b#

solidDB wf"

w}f'V>X8]T0(}xgxP8](4xg8])#

v >X8]+zI10_-}]b(I\I`vD~iI)D1>,4;v}]bD

~#

v xg8]4P`,>X8],+;,.&ZZ,|(}xg+8]}]b"M

=x

g8]~qw#

BfwZhvgN8] solidDB Zf}]bT0S53JOV4#Kb,9a)KCZ

dC"\mM`S8]YwD=(#

*KbPX8]MV4w}]bT01>}]bD<r,kND IBM solidDB Advanced
Replication User Guide#

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

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

backup |nDIC!n|(:

2 \m solidDB 39

m

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

IT(}ZdCD~D [General] ZPhCN} BackupDirectory 4a0hC8]?<#
*q!ICdCN}Dj{Pm,kNDZ 145 3D=< A, :~qwKdCN};#

"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,{F`,D}

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

(}xgxP8]

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

4Pxg8]

(}TB|nt/xg8] (netbackup):

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

g{ 8(D8] ?<; fZ, G4+ "z solidDB }
10030#PXKmsD|`E",kNDZ 199 3D=< E, :ms

k;

]b ms

;Pns8]

dP:

v options ITG:

m

!n hv

-s ,=4P#

-I 4Pj+D}]bj{Tli

-i 4P}]bw}j{Tli

v DELETE_LOGS | KEEP_LOGS (eG>}8]U>9G+d#tZ4~qwP#1!5

* DELETE_LOGS#

":

– DELETE_LOGS F*

40 IBM solidDB: \m18O

8. netbackup

|nD!n

wCaZxg8]jI1r_"zms15X#

j+8]

– KEEP_LOGS F *

General.NetbackupDeleteLog N}hC*“no”#

v connect connect str 8(kxg8]~qwD,S#g{!T connect str,G4X

kZ solid.ini dCD~P8(KV{.#*Kbj{D,SV{.o(,kNDZ

67 3D:,SV{.Dq=;#

v dir backup dir (exg8]~qwPD8]

`TZ netbackup y?<#

*c:g{+=v}]b4F=,;v?<,G40;v}]b+;s;v}]b2
G#}g,backup dir @6;&C8rxg8]~qwDy?<#

":

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

HT>X8]2Txg8]xP(f#

v ADMIN COMMAND ’netbackuplist’ k ADMIN COMMAND ’backuplist’ H,;|HT>

X8]2Txg8]xP(f#

1 >8]

# 9 C KEEP_LOGS ` 1 Z +

?<#K76ITGxT76,2IT

|n#

U(DM4SDxg8]?<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~#x
g8]dCD~q- solidDB dCD~P [IndexFile] ZDo(#rK,}|,Z{

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

T

[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,

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

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

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

N}

2 \m solidDB 41

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

m

10.

kCZ4Pxg8]D

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

connect connect str NetBackupConnect = connect str

dir backup dir NetBackupDirectory = backup dir

netbackup DELETE_LOGS NetbackupDeleteLog = yes

solid.ini

D~`T&DN}

1!5:;P1!5

1!5:;P1!5

1!5:Yes

netbackup KEEP_LOGS NetbackupDeleteLog = no

1!5:Yes

*q!dCN}M ADMIN COMMAND !nDj{Pm,kVpNDZ 145 3D=<
A, :~qwKdCN};M Z 279 3D=< F, :solidDB ADMIN COMMAND o

(;#

":Z ADMIN COMMAND |nPdkD!n+2G solid.ini }]bdCD~P
8(D`&N}#

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

PXj8E",kNDZ 47 3D:dk(1

|n;#

8]ZdavVDiv

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

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

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

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

v U>D~;b)D~|,4(8]1&Zn/4,DBqywD|D
v solmsg.out }]b{"D~

XhD)

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

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

42 IBM solidDB: \m18O

v solid.ini dCD~;1!ivB9+4FKD~,bGr*,"zEL@#1,-

<1>I\a;F5(ZV4Zd,dCD~;GXhD)

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

": }]bD~D{F0dnss!I solid.ini dCD~P [IndexFile] ZD

FileSpec[1...N] N}

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

+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] Z
4|, CheckpointDeleteLog=yes b;P#

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

j+8]

#

F*

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

s#

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

2 \m solidDB 43

\mxg8]~qw

S V4.5 *<,?v solidDB }]b~qw9d1xg8]~qw#+G,zXkZ

solid.ini dCD~D [Srv] ZPhC;vdCN}:

NetBackupRootDir=netbackup root path

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

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

1. ADMIN COMMAND ’close’

;S\BDxg8]ks#

2. ADMIN COMMAND ’throwout all’

P9xPPD8]Yw#

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

m

11.

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]0dI&4,DPm,k9CTB|n:

ADMIN COMMAND ’backuplist’

44 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 !! nG backup# ; )j I8] ,K | nM +5 X
“OK”r“FAILED”#

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

4P8]1DdMJb

8]i JDELUd;c

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

8]? <D76^'

}g,g{~qwKP UNIX Y w53,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"#

<8xg8]D~TxPV4

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

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

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

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

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

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

xg8]~qwZ8(D;C;fZ

s!#

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

#Z4}7hC solidDB xg8]~qw

}b)=hTb,V4xg8]k

V4>X8]`F#

V4*ON8]D4,

1. g{ solidDB }ZKP,G4+dXU#

2 \m solidDB 45

2. >}U> D~?<P DyPU> D~#1! U>D~{ G sol00001.log M

sol00002.log,HH#

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

4. t/ solidDB#

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

+}]bS8]4,"B=104,

1. g{ solidDB }ZKP,G4+dXU#

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

3. +U>D~S8]?<4F=U>?<#g{b=v ?<PfZ`,DU>D~,

G4k;*CI8]U>D~42GBU>D~#

4. t/ solidDB#

solidDB +

Sl#XUPV4

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

v

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

2G=(

v

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

T/9CU>D~44P0vV4#

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 101 3D5 B, :T\w{;PD“U>G<kBqMC

T”SZ#

46 IBM solidDB: \m18O

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

KNq,k+

4(lic

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

]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,
",kND:dk(1|n;#

solidDB P;vT/lic4(X$Lr,s_+ZU>D~;4X(N}s4(li
c#PXXFlic5JD|`E",kNDZ 110 3D:w{l

lic2JCZ@CZfm,x;vvJCZyZELDm#

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

g{~qw"zJO,G4z

;

ic;#

dk(1|n

":

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

icI\*s4Ps?D I/O Yw,rKZlic"zZd,~qwDitHI\a

l

\0l#PX|`j8E",kNDZ 110 3D:w{lic;#

solidDB |,JmzT/4P\mNqDZCF1w#IT9C(1|n44PYw5

3|n,IT4(8]"licM}]b4,(f,"ITr*MXU}]bT0O
*C'D,S"XU~qw#

*dk(1|n,k`- solid.ini D~D [Srv]

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#

ZP At N}#o(*:

2 \m solidDB 47

>}:

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

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

Bm|,P'D|n0dTd?DPm#

m

12.

;,(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 Yw53|n

}g,Z Linux 73P

cp solmsg.out solmsg2.out

open ;PTd? ;P1!5

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#

}]bXiD$w==

105VJmTQz==Z3f6 4P}]bD~9u#“Qz”b6Ey9uD}]
bD~;\)~qw9C#“3f6”b6EvSD~P"V"}%U3f#;4P3

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

fI\avV

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

(}]b8]#

48 IBM solidDB: \m18O

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

}]bXi|nP!n

P=v|nP!nICZ}]bXi:

ICrS(f

solid -x infodbfreefactor

infodbfreefactor !ndv;v(f,T(f}]bPDIC3f}"ICUd?(T
'VZF)T0ICUdy<YVH5#+(fr!= ssdebug.log MXF(.s,

solidDB xL+5XI&5X5#

Xi

solid -x reorganize

reorganize !nw C}]bXiYw#KYw+3fFA}]bD~PNN49CD

[#3fX(;jIs,49CDUd+;MEX=D~53;4,D~;XO,4
(Blic,solidDB xLU9"5XI&5Xk#yKPDXiD(f+;4

ssdebug.log D~#

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

T}]bxPS\

1!ivB,solidDB <U9C DES c(T\kxPS\#g{9*T}]bD~M
U>D~xPS\,G4h*9C solidDB |nP!n44(-}S\D}]b#9I

T{9T\kxPS\#

ICrS(fMXi

#

k

solidDB =x;6D DES c(yZ9C 56 ;\?DTF\?
\?,Z4("t/rb\-}S\D}]b1Xk8(t/\k#

solidDB DES c(G;Vu DES c(,(i;*+|CZh*?2+TD&CLr#

T}]bMU>D~xPS\

9C|nP!n -E M -x keypwdfile:<filename> T{v}]b(}]bMU>D~)

xPS\#

XZKNq

v -E !n+wC}]bS\&\#IZ4(B}]brt/VP}]b1T}]bxP

S\#

v -x keypwdfile:<filename> !nSD~Pa)S\\k#

S\\kG#$TFS\\?(f"Z}]bD~D4-S\D73P)yXh

D#

g{8(K -E,G4S\\k
(U\k,G4S\\?&Z4\#$4,#

":Kb,!n -S ICwt/|nD;?Va)\k#+Zs`}53O,byv
";2+#}g,Z UNIX 53P,IZ ps |ndvP4

ZwTr@@#

c(#*#$TFS\

GXhD#\kDn!$H*}vV{#g{z!q8

=\k#-S !nvJC

2 \m solidDB 49

}L

v 4(-}S\DB}]b

v TVP}]bxPS\

{CS\

I(}~qwKrM'zKN}4{C\kD1!S\,2IZ,S19C“ODBC ,S

E"”hCrGj< JDBC ,StT4{C\kD1!S\#

1!ivB,solidDB <U9C DES c(T\kxPS\#1!ivB,;T}]b
MU>D~xPS\

* 4 ( - } S \ D } ] b , k Z solidDB t / | n P | ( -E M -x
keypwdfile:<filename> !n#

}g:

solid -C mycatalog -U admin -P admin -E -x keypwdfile:pwd.txt

* T V P } ] b x P S \ , k Z solidDB t / | n P | ( -E M -x
keypwdfile:<filename> !n#

}g:

solid -U admin -P admin -E -x keypwdfile:pwd.txt

#

g{*Z;xPNNS\DivB4(}]b,k(}9CBfyvDN}hCr,
StT4{C\kDS\#

{C\kDS\9a{C}]bMU>D~DS\(g{Q9C)#

~qwKN}hC

*Z solidDB ~qwP{CS\,k+~qwKN} General.UseEncryption hC*
“No”#

[General]
UseEncryption=No

1!hC*“Yes”#

M'zKN}hC

*{CkTX( ODBC M'z,SDS\,k+M'zKN} Client.UseEncryption

hC*“No”#

[Client]
UseEncryption=No

1!hC*“Yes”#

r_,9C,SV{.!n USE_ENCRYPTION=NO 4{CS\#

ODBC ,SE"!n

Z ODBC 73P,I(}+!n USE_ENCRYPTION=NO |(Z ODBC ,SE"V

{.P4{CS\#

50 IBM solidDB: \m18O

XkZ~qw,SV{.0fa)C!n,}g:

USE_ENCRYPTION=NO tcp 1964

1!5* USE_ENCRYPTION=YES#

JDBC ,StT

Z JDBC 73P,I(}+Gj< JDBC ,StT“solid_use_encryption”hC*“NO”

4{CS\#

t/-}S\D}]b

*t/-}S\D}]b,XkZt/1a)S\\k#g{;Zt/|nP|(\
k,G4~qwaa>zdk\k#

}L

9CTB|nt/ solidDB:

solid -x keypwdfile:<filename>

}g:

solid -x keypwdfile:pwd.txt

Kb,IT9C -S |nP!na)\k:

solid -S <password>

|DS\\k

*|DS\\?D\k,Xk9C!n -E T08(I\kMB\kD!n4t/

solidDB#

}L

|DS\\k

*|DS\\k,k9CTB|no(4t/ solidDB:

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

}g:

solid -E -x keypwdfile:pwd.txt -x keypwdfile:newpdw.txt

Kb,z9IT9C -S !nZ|nPP8(B\kMI\k

solid -E -S <old_password> -S <new_password>

T}]bxPb\

IT9C!n -x decrypt 4T}]bxPb\#9h*a)S\\k#

}L

T}]bxPb\

*T}]bxPb\,k9CTB|no(t/ solidDB:

solid -x decrypt -x keypwdfile:< filename>

2 \m solidDB 51

}g:

solid -x decrypt -x keypwdfile:pwd.txt

i/}]bS\6p

IT9C DATABASE_ENCRYPTION_LEVEL() /}4li}]bS\6p#K&\I
\\PC;}g,g{zD53;JmZ4-S\DD~Pf"}],G4zh*"

aBD1>#

}L

9C DATABASE_ENCRYPTION_LEVEL() /}# C/}_PTB5X5:

v 0 - 4S\

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

v 2 - QS\,\?\m;vt/\k#$

8]-}S\D}]b

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

TH8C~qwxPS\

Z_ICT(H8C)dCP,w~qwM(z~qwXk9C`,DS\=(MS
\\?#

WHTw}]bxPS\,;sTd4P4Frxg4F#

H8Cw?"G(}}]bD~S\&\xPS\#*#$ HSB w?,h*9Cd{
2+T=(
\bTb)D~xP_`DS\/b\#

S\MT\

9C-}S\D}]ba0l4PA4Yw1D}]b~qwT\#

1. TZA!`MYw,T\0lw*I_Y:f|PJ 7(,g{_Y:f|PJO

_,G4mw0l";Tx#

2. TZekM|BYw,~qwaTU>D~(g

Mb\,ZbVivB,T\0lI\HOwT#

#4P HSB 4Frxg4F1,aTS\N=+d}]bD~MU>,T

{9CKU>D~D0)xPS\

52 IBM solidDB: \m18O

3 dC solidDB

wV solidDB dC!nozzzc73"T\MYwh*#

s`} solidDB dChCG9CdCN}(eD#fZ=v solid.ini dCD~,;
vCZ~qw,m;vCZ ODBC M'z#b=vdCD~<;GXhD#g{;P

dCD~,G4+9Cv'5#Kb,"

g{3vN}4vVZ solid.ini D~P,rg{4hCX(N}D5,G4a9Cv
'5#

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

(}V/`- solid.ini dCD~,rZs`}ivB(}9C ADMIN COM-
MAND,IhCdCN}5#

(}9C SQL |n SET r SET TRANSACTION,r_(}9C ODBC ,StT (at-
tribute) r JDBC ,StT (property) (e?v,SDhC,9IT?va0r?vB

q

v SET TRANSACTION:Bq6phC

v SET:a06phC

v ODBC ,StT (attribute) M JDBC ,StT (property)
v I solid.ini dCD~PD58(DN}hC

v N}Dv'5

GyPN}<h*vVZ solid.ini D~P;

CN}TtCr{C3v&\#

2G3)N}hC#EH3rcNa9gB(S_EH3r=MEH3r):

\mN}

Kb,I(}BP!n4XF3) solidDB ~

v solidDB |nP!n(Z solidDB t/1)

v 73d?

v ODBC M'z,SV{.Td?

`XN<

Z 193 3D=< C, :solidDB |nP!n;

`XE"

Z 145 3D=< A, :~qwKdCN};

Z 189 3D=< B, :M'zKdCN};

M'zKdCN}f"Z

I9C ADMIN COMMAND r(}`- solid.ini dCD~4i4M^D~qwK

dCN}#;\(}9C solid.ini D~4i4M^DM'zKdCN}#

solid.ini dCD~P,ZM'zt/1A!#

qwYw:

53

dCD~MN}hC

fZ=v;,D solid.ini dCD~,;vCZ~qw,m;vCZ ODBC M'z#

b=vdCD~<;GXhD#g{;PdCD~,G4+9Cv'5#

v ~qwK solid.ini Cw~qwDwdCD~#
v M'zK solid.ini D~k solidDB ODBC M'z(}/Lr)dO9C#M'z

K solid.ini D~9Ik solidDB }]\m$_dO9C,}g,CZ(e_-}
]4{F#

": Z solidDB D5P,solid.ini (#8DG~qwK solid.ini D~#

1 solidDB(r ODBC M'z)t/1,|a"TWHSI SOLIDDIR 73d?hC
D?<Pr* solid.ini#g{ZKd?8(D76P
'zK+"TS10$w?<Pr*KD~#10$w?<(#MGzSdPt/

solidDB ~qwr_M'z&CLrD?<#9I(}Z solidDB t/19C -c |n
P!n48(m;v$w?<#

R;=KD~,G4~qwrM

g{Z solid.ini D~P4hC
v'5I\!vZz9CDYw53#

dCN}G4

p<T;vC=(E(p4DZ{*7,}g:

[Com]

[Com] b;ZP>(EE"#Z{F;xVs!4#Z{F [COM]"[Com] M [com] H

[#

a > : Z D 5 P , N } ( # G I C q = section.parameter( } g ,
Logging.LogEnabled)}CD#

N}{F/5

X(N}D5,G4 solidDB +9CKN}Dv'5#

TDN=(eD#b)N}4UZ`pxPVi#?vZ`

>}

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

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

y> solid.ini D~

solidDB 20?<PD samples ?<|,CZ;,C}Dy>#TZ?vC},?vy
><|,xP`XhCD solid.ini D~;1dC731,I9Cy> solid.ini D

~w*N<#

a>:g{ solidDB ~qwMM'zZ,;zwOKP,"R9C,;$w?<,G4

v solid.ini d C D~I ,1 w*~ qw KMM 'zKd CD ~ #} g,

%
solidDB_installation_directory\eval_kit\standalone ?<PD solid.ini dCD

~|,~qwK Com.Listen MM'zK Com.Data Sources N}hC#

54 IBM solidDB: \m18O

`XEn

Z 120 3D:_-}]4{F;
solidDB $_MM'zb'V_-}]4{F#_-}]4{FICZT}]ba)

hvT{F#

`XE"

Z 145 3D=< A, :~qwKdCN};

Z 189 3D=< B, :M'zKdCN};

M'zKdCN}f"Z

solid.ini dCD~P,ZM'zt/1A!#

9C ADMIN COMMAND 4i4MhCN}

I(} ADMIN COMMAND |Ds`}~qwKN},x;h*XBt/ solidDB ~
qw#yPN}<I(} ADMIN COMMAND CJ,49|G;Z solid.ini dC
D~P#

i4N}

I4yPN}"3ZPDyPN}r;N%vN}4i4N}hC#

XZKNq

CZi4N}Do(gB:

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

dP:

v -r 8(vT>105
v section_name GKN}Z solid.ini Pyt`pD{F

}L

v *i4yPN},k9CTB|n:

ADMIN COMMAND ’parameter’;
RC TEXT

CfK 192 P#

v *i4%vN},k+Z{FT0N}{F|(Z|nP#}g:

admin command ’parameter logging.durabilitylevel’;

CfK 1 P#

v *i43ZPDyPN},k+Z{F|(Z|nP#}g:

-- ---­0 Accelerator ImplicitStart Yes Yes Yes
0 Accelerator ReturnListenErrors No No No
0 Com Listen tcpip 2315, tcpip 2315, tcpip 1964
0 Com MaxPhysMsgLen 8192 8192 8192
0 Com RConnectLifetime 60 60 60
0 Com RConnectPoolSize 10 10 10
0 Com RConnectRPCTimeout000
0 Com ReadBufSize 2048 2048 2048
0 Com SocketLinger Yes Yes Yes
0 Com SocketLingerTime000
.
.
.

RC TEXT

-- ---­0 Logging DurabilityLevel322

3 dC solidDB 55

admin command ’parameter logging’;

CfK 11 P#

RC TEXT

-- ---­0 Logging BlockSize 16384 16384 16384
0 Logging DigitTemplateChar###
0 Logging DurabilityLevel111
0 Logging FileFlush Yes Yes Yes
0 Logging FileNameTemplate sol#####.log sol#####.log sol#####.log
0 Logging LogDir logs logs
0 Logging LogEnabled Yes Yes Yes
0 Logging LogWriteMode222
0 Logging MinSplitSize 10485760 10485760 10485760
0 Logging RelaxedMaxDelay 5000 5000 5000
0 Logging SyncWrite No No No

a{

dv4TB3rT>}v5:

v

105

v ~qwt/19CD

v z7P$HhCD

t/5

v'5

*vT>

admin command ’parameter -r logging’;

CfK 11 P#

105

,k9C -r !n#}g:

RC TEXT

-- ---­0 Logging BlockSize 16384
0 Logging DigitTemplateChar #
0 Logging DurabilityLevel 1
0 Logging FileFlush Yes
0 Logging FileNameTemplate sol#####.log
0 Logging LogDir logs
0 Logging LogEnabled Yes
0 Logging LogWriteMode 2
0 Logging MinSplitSize 10485760
0 Logging RelaxedMaxDelay 5000
0 Logging SyncWrite No

i4X(N}Dhv

zITi4X(N}Dj8hv,dP|(P'N}`MMCJ==#

":N}'VI\Z;,=(.dPyd/#

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

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.

56 IBM solidDB: \m18O

a{/DwPVpG:

N}{

v

v KN}D

v

}]`M

v

CJ==

GN}D{F,}g CacheSize#

hv

,ITGBPdP;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|D1=z4(B

v

v

v'5

v

t/5

105

T>N}Dt/5

T>N}D105

T>z7P$HhCD5

}]b1Eaz'

hCN}5

IT(} ADMIN COMMAND ’parameter’ 4|Ds?VN}#y]N}DCJ==,|D
I\a2I\;a"4&C#

|nDo(gB:

ADMIN COMMAND ’parameter param_name = value [temporary]’

v param_name M value q-Z 61 3D:dCN}D{Fq=M5q=;P8(Df

r#

– param_name Xk|,IdcV{VtDZ{MN}{#

}g,*+ [Logging] ZP DurabilityLevel N}D5hC*“1”,k"vTB|

n:

ADMIN COMMAND ’parameter Logging.DurabilityLevel=1’;

– value Xk*P'5,r:

g{48(NN5,G4a+KN}hC*v'5(r_!{hC5)#

g{8(xPGE(*)DN}5,G4KN}+hC*|Dv'5#

v ITZHE=_mSUq#}g:

ADMIN COMMAND ’parameter com.trace = yes’

v 1hCK temporary 1,;a+Q|D5f"Z solid.ini D~P#

v 9C ADMIN |n4|DN}D51,C|DI\a2I\;a"4;&C,"RI

\a2I\;aZ~qwBNt/1;&C#

– g{+N}54k solid.ini D~,G4|+Z~qwBNt/sz'#

g{9CK temporary !n,G4C5+0l~qwD10P*,+;aZ~q

–

wXBt/sTdzz0l#

– Z3)ivB,TN}ywD|DI\"4z',"a+CN}4k solid.ini D

~,TcZ~qwBNt/s2&CCN}#b!vZCN}

CJ==

#

D

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

3 dC solidDB 57

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

`XE"

:TN}yw^DDCJ==MVCT;
N}DCJ==(eGqI(} ADMIN COMMAND /,|DCN}T0K|DN

1z'#

TN}yw^DDCJ==MVCT

N}DCJ==(eGqI(} ADMIN COMMAND /,|DCN}T0K|DN1

z'#

I\DCJ==gB:

v RO(;A):;\|D5;105<Ukt/5`,#

v RW:IT(} ADMIN COMMAND |D5,"RK|Da"4z'#

v RW/t/:IT(} ADMIN COMMAND |D5,"RK|Da

sz'#

v RW/4(:IT(} ADMIN COMMAND |D5,"RK|DaZ4(B}]b1

&C#

T_P RW* CJ==DN}ywDyP|D<f"Z solid.ini D~DB;vli
c#b;JCZ(} temporary !nhCD5#

Z~qwBNt/

#fN}

9I9CTB|n4ks"4f"Q|D5:

ADMIN COMMAND ’save parameters [ini_file_name]’;

g{ 4 8( ini_file_name, G 4aXB4k10 solid.ini D~#g{8(K
ini_file_name,a+j{DdCD~4kB;C#byIT\=cX#fdCD~li

cT)+49C#

>}:;A (RO) N} IndexFile.BlockSize

IndexFile.BlockSize N}DCJ==G RO#KN}GZ4(}]b1hCD,Ts

;\^D#

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

TB>}+(}r solid.ini D~PmSBP

[IndexFile]
Blocksize = 4096

`-"#f solid.ini D~.s,kF/r>}ID}]bMU>D~,;st/

solidDB#

wP*w}D~hCBDis!:

a>:ITZt/~qw1|DU>is!#

58 IBM solidDB: \m18O

(} solid.ini dCD~hCN}

1 solidDB ~qw(r ODBC M'z)t/1,|a"Tr*dCD~ solid.ini#

g{CD~;fZ,G4a9CN}Dv'5#g{CD~fZ,+Z solid.ini D~
P4hCX(N}D5,G4a9CCN}Dv'5#v'5!vZz9CDYw5

3#

1!iv

B,~qwZ10$w?<PiR solid.ini D~,C?<(#GzSPt/

~qwD?<#

I(}BP=(48(m;v?<Cw10$w?<:

v 9C -c solidDB |nP!n#
v hC SOLIDDIR 73d?,T8( solid.ini D~D;C#

1Qw solid.ini D~1,solidDB 9CT

BEH3r(S_=M):

v SOLIDDIR 73d?8(D;C(g{QhC)

v 10$w?<

`XN<

Z 193 3D=< C, :solidDB |nP!n;

solid.ini D~Dq=/fr

dCD~ solid.ini G|,;P{D ASCII D~#

solid.ini dCD~V*`vZ#?;Z<|,;vr`vX5;\PDN}#?;Z

<_P{F,"RC{FI=(E(g,}g:

[SQL]

?;Z<|,N}#N}4TBq=8(:

param_name=param_value

}g:

Listen=tcp 127.123.45.156 1313
DurabilityLevel=2

JmHE=TfZUq,+b)Uq;GXhD#Bfb=PH,:

DurabilityLevel=2
DurabilityLevel = 2

g{!TN}5,G4~qw+9Cv'5#}g:

; Use the factory value
DurabilityLevel=

g{!TN}5MHE,G4z+SU=ms{"#

?vN}<Xk;ZZ7sf#g{+;vN}EZNNZ7.0,G4z+SU=

ms{",C{"8v{*“<no section>”DZ|,^(6pDu?#

Z{ITX4#}g:

3 dC solidDB 59

[Index] BlockSize=2048
[Com]
...
[Index]
CacheSize=8m

+G,X4Z{+9C'|QT7#D~nB"R;B,rK(iz\bZ{X4#

N}{2ITX4(z;aSU=/f{"),+?R(iz\bbViv#N}Z

D~PDns;NvV_PEH(#

solid.ini D~IT|,XkTVE*7

; This is a valid comment.

D"M#

"MkN}ITZ,;P#

DurabilityLevel=2 ; This is also a valid comment.

TBG solid.ini D~P?VZ]Dr%>},K?VZ]|,Zjb"N}M"M:

[Logging]
; Use "relaxed logging", which improves performance but may
; risk losing the last few transactions during a failure.
DurabilityLevel=1

[Com]
...

Z3)ivB,=vr`vZ|,,{DN}#rK,zXkP8X+?vN}CZ

}7DZP#

s`}ZMN}GI!D#z;h*T?vZPD?vN}8(5,5JO,IT+

{vZ!T#g{!T3vN},G4~qw+9

Cv'5#Z>=<Dfs?V,

RG+P>?vZ"?vN}{"CN}Dv'5T0CN}DC>hvMP'56
'#

~qw+li solid.ini D~PD?vu?#g{Cu?;G"M,G4~qw+li
Z{kN}{DiOGqP'#g

{D~|,^'Du?,G4~qw+Z solmsg.out

D~Pdvms{";g{~qww*0(xLKP,G4C{"9+T>ZXF(

O#C{"+`FZBPdP;n:

1. /f:INI D~|,^(6pDu?:“<section>.<parameter>”#

2. /f:INI D~|,;O(Du?:<whole illegal line>

60 IBM solidDB: \m18O

g{u?Dq=}7

,+|G;P$(eDZ{MN}{,G4z+4=K{"#

}g,g{ solid.ini D~|,`FZTBDZ],G4z+SU=K{":

; This has a valid section name, but an invalid parameter name.
[Logging]
NoSuchParam=NoSuchValue

This has an invalid section name.
[NoSuchSectionName]

Z;vmsD{"+`FZ:

/f:INI D~|,^(6pDu?“Logging.NoSuchParam”#

g{4\+3;P6p*Z7"N}{""MrUP,G4~qw+T>K{"#
g{u?Dq=;}7,G4z+4=K{"#}g,g{ solid.ini D~|,`
FZTBDZ],G4z+4=K{":

; This text was intended to be a comment
but we forgot to precede part of it with a semicolon.

3. /f:“<inifilename>”|, 1 v^(6pr;O(Du?

r_

/f:“<inifilename>”|, <number> v^(6pr;O(Du?#

Z~qw&m solid.ini D~jIs,|+P>ylb=Dms\}#

4. /f:9CK4"aDN} <section>.<parameter>#

g{"zKms,G4mw~qw>mI\

fZJb#g{z4=Kms,kr IBM

+>(f#

"b,1z9C^'DN}51,~qw;;(aT>ms{"#~qwI\vvG
9Cv'5,x;"vms{"#

v1~qwt/1,Eali solid.ini N}D~#g{zZ~qwt/s`-KD

,G4~qw1=BNt/sEalb=zywD|D#

~

"b:

g{zT solid.ini D~xP|D,"R9C ADMIN COMMAND T~qwPDN
}xP|D,G4P * ; I $b# 1 ~ q w &ZKP 4 , 1 ,zIT 2 + X |D

solid.ini D~r_9C ADMIN COMMAND 4|D~qw5,+;&

CZ~qwD

;NKPZd,1xPb=V|D#

frD**gB:

v Z{Dq=*

[section-name]

v ,;vZ{IT9C`N(+G,(iz\bbViv)#

v ?vN}<%@<C;P#

v D~PDu?ITxP0<Uq#

v g{Z;vGUqV{G"MV{, G4{;P<+;vT(4,|;S*"M

P)#

v "MV{G

VE(;)#

v "MITzZ,;PPDd{u?.s#

v 4|,NNV{r_;|,UWV{DP+;vT#

dCN}D{Fq=M5q=

^[G(} solid.ini D~9G ADMIN COMMAND 4hCdCN},b)N}D

{FfrM5fr<`,:

v Z{MN}{;xVs!4#

v V{.5;xVs!4#

3 dC solidDB 61

v Zs`}ivB,%;;xVs!4#}g,*8(%;TWVZF,IT9CB

PNN;n:m"M"MB"mb"Mb r mB#3)%;(}g1d%;“s”(k)M
“ms”(Ak))xVs!4,b)ivQG<ZD5P#

v ;cN}5hCD

param_name [space characters] = [space characters] value_literal

5Do(*:

value_literal [space characters] unit_of_measure

dP:

param_name GN}{#Z ADMIN COMMAND P9CKo(1,{F&CGj{
N}{,4|,Z{,}g Logging.DurabilityLevel#Z solid.ini D~P9CK

o(1,|;&|,Z{,bGr*N}&CQP>Z`&DZ7.s#

o(gBy>:

value_literal G*3hN}D5#b(#GVf5,}g}
MyServer2 1315”#g{48(5,G4CN}+;hC*|Dt/5#g{8(xP

GE(*)DN}5,G4KN}+hC*|Dv'5#"b,g{Z ADMIN COM-
MAND P9CV{.Vf5,G4(#&C+|G(Z+}EP#

unit_of_measure GF?

[space characters] m>Uq(g{Jm9CUq+"GXk9CUqD0)#HE=

TDUqGI!D#5kF?%;.dDUqGI!D#

}g,JmDq=|(:

CacheSize=32M
cachesize=32m
CacheSize = 32 m

HH

nX*D~qwKN}

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

(exg{(Com Z)

~qwt/1,|*<9Cxg{4l};Vr`V-i(xg{CZxVC~qw
kxgPDd{?V)#M'z&CLr9C`FDxg{(,SV{.)48(*
9CD-iT0*,SD~qw#

V 12 r_V{.“tcp

%;,}g MB m>WVZ,ms m>Ak#

xg{G9C [Com] ZP Listen N}(eD,}g:

[Com]
Listen = tcpip localhost 1313

1!5SYw53x(#kNDZ 115 3D6 B, :\mxg,S;,Tq!PXN}

q=Dj8E"#

\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}#

62 IBM solidDB: \m18O

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!#9C1!is! 8KB1,nsD~s!* 32 TB - 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+dVn=

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

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

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

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

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

v;

`j8E",kNDZ 8 3D:_L`M;PD:(C_L;;Z#

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

3 dC solidDB 63

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:

M

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!;baP*'VP}]"p5}]
bDgU#

:

CacheSize

CacheSize N}(eCZ,$EL}]bD2m:eXDwf"w?#

K:eX;F*}]b_Y:f#v'5!vZ~qwYw53#TZ?Zf}]b

YwxT,_Y:fs!;),v 8MB,kG)YwMy>;`X#xTn!s!G
512 'VZ#}g:

[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'}

T0T~

qw4PDYwDTJ#

1!_Y:fs!G 32 MB#

8(>X8]?<(General Z)

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

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

~?<r$w?<TbDNNVP?<#

"U>D

8]?<D{FM;CG9C [General] ZPD BackupDirectory N}(eD#

1!;CG`TZ solidDB $w?<D?<#

}g:

[General]
BackupDirectory=backup

Z9CTO5“backup”DivB,a+8]4kw* solidDB ?<DS?<D?<#

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

64 IBM solidDB: \m18O

8(xg8]?<(General Z)

x g8 ]~q w P CZf"8] D ~ " U> D ~ M dC D ~ D ?j ? < ( }

NetBackupDirectory N}Z4~qwMxg~qwKxPhC#g{6L?<;fZ,
G4a4(C?<(h*4(^)#

4KN}:

[General]
NetBackupDirectory=netbackupdir

4~qwPDN}

hC6L?<,Tc9Cxg8]&\#netbackupdir r_GxT?<,r_`TZx
g8]~qwDy?<#

xg8]~qwKN}:

[Srv]
NetBackupRootDir=

xg8]y?<

4~qwPDN}

9C`T76mo=TyPxg8]Yw4Ud NetBackupDirectory f64hCy?<#

xg8]y?<

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

*c:

1!ivB,xg4F&\+|,`vD~D_-}]b4F= NetBackupDirectory P
D;v=fD~# zIT(e`v*Zxg8]}LP+4}]bD~3d=DD

~,Tzf+a9=L*;vD~#

+4}]bD~3d=`v8]}]bD~b;

Nq(} backup.ini D~jI#

*7#Qd5DBqDMCT,Bqa{+ZBqd51;"44ky8(?<PD
;vD~#zXk9C>XEL{+KD~f"=>X}/w,T\bxg I/O J

b"

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

:

FileNameTemplate

Logging ZPD FileNameTemplate N}(eBqU>D~DD

~{a9#}g,TBhC:

[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

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

PX8>E",kND Z 161 3D:Logging Z;#

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

[Sorter] ZPD TmpDir[1-N] N}(eITIb?Erw9CD?<#b?Erwc

(CZTwf"wP0;BDNq4PEr#g{ZdCD~P8(K TmpDir[1-
N],G4atCb?Erwc(#b?ErYw9CDyPY1D~<+Z8(D?

<P4("T

/>}#

3 dC solidDB 65

TmpDir[1-N] N};P1!hC#

[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#k"b,14(eY1?<1,bI<Bi/T\\n#

":“b?Er”;vh*ELUd,9h*ZfUd#IT(}hC solid.ini D~P
[Sorter] ZD

sELUd?#

MaxMemPerSort M MaxCacheUsePercent N}4dC*9CDn

hCCZ4P&mD_L}(Srv Z)

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

&m;#

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

[Srv]
Threads=9

nED_L}!vZ53P20D&mw}#(#,?v&mwKP 2 = 8 v_L1,
'Jn_#

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

STB+=kV:

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

hC SQL zY6p(SQL Z)

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

6

",kND

(}+dCD~P [SQL] ZD Info N}hC*Gc5,ITtC“SQL E"”$_#
dv+4k solidDB ?<P{* soltrace.out DD~#

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

j<D solidDB `S&\#

IBM solidDB SQL

8O7

#

D&CLr SQL }]bzYxT,nC!q

8(xg(EzY(Com Z)

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

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

Y$_;#BP

Trace

PXyPQ("xg,SDxg{"DzYE"G<=1!zYD~r_Z TraceFile

N}P8(DD~#

66 IBM solidDB: \m18O

:

g{+ Trace N}D1!hCI No |D* Yes,G4 solidDB a*<+

TraceFile

:

g{ Trace N}hC* Yes,G4a+PXxg{"DzYE"4k

TraceFile N }8 (DD ~ #g {4 8( D~ {, G4 ~ q w+9 C 1! D~

soltrace.out,s_+;4k~qwrM'zD10$w?<,b!vZZD;Kt
/zY#

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'zOD Connect N}5&Ck~qwOD Listen N}5%d#

1!5SYw53x(#kNDZ 115

3D6 B, :\mxg,S;#

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 N};pwC#

"b,Z [HotStandby] M [Synchronizer] ZP,9CK`FD connect N}Z solidDB

~qw.dtC,S#PXb)N}Dhv,kND6

7MIBM solidDB Advanced Replication User Guide#

O7

,SV{.Dq=:

I9CM'zK Com.Connect dCN}4(e1!,SV{

IBM solidDB

_ICTC'8

6

.#9Ia)C,SV{.,}g,Z,S1rZ9C ODBC }/Lr\mw4dC
}]41#

,;,SV{.q=JCZ Com.Connect N}T0JCZ solidDB $_r ODBC M

a?6M'z&CLr9CD,SV{.#

SV{.Dq=gBy>:

,

protocol_name [options][host_computer_name] server_name

dP:

v options ITGBPwnDNNiO:

m

13.

,SV{.!n

!n hv -i

-z TK,StC}]9u&\

-c milliseconds 8(G<,1(1!5X(ZYw53)#Z8(D1d}s,G<ks+'\# TCP/IP

-r milliseconds

8(,S(rA! ), 1# g{Z8(D1dZ4SU= NN l&,G4xgks+'
\#5

0(1!5)+,1hC*^^(Yw53D1!,1JC)#

yP

TCP/IP

3 dC solidDB

67

m

13.

,SV{.!n(x

!n hv -i

-ofilename r*xgzY$_"(ezYdvD~D{F

-plevel Zx(6p (0-5) OT~qw4P Ping Yw#

-t r*xgzY$_

)

6

kND

M'z<UITZ6p 1(0 *^Yw/1!5)O9C solidDB Ping $_#v1Q+~q

whC*AYZ`,D6pO9C Ping $_1,E\9C6p 2"3"4 r 5#

kND

kND

IBM solidDB

6

IBM solidDB

6

IBM solidDB

\m18O7

\m18O7

\m18O7

PD Network trace facility Tq!j8E"#

PD Ping facility Tq!j8E"#

PD Network trace facility Tq!j8E"#

yP

yP

yP

v g{M'zk~qwZ;,zwOKP,G4 TCP/IP -iM|{\@-ih*

host_computer_name#

v server_name !vZ(E-i:

– Z TCP/IP -iP,server_name G~qKZE(}g“2315”)#
– Zd{-iP,server_name G{F(}g“soliddb”r“chicago_office”)#

PX;,(E-iPo(Dj8E",kND

IBM solidDB

\m18O7

6

Communication protocols#

PD

":

v protocol_name M server_name Xkk~qwZdxgl}{FP}Z9CDG)5

`%d#

v g{Z,S1a),SV{.,G4XkC}E+d}p4#

v ,SV{.DyPi~<;xVs!4#

>}

[Com]
Connect=tcp -z -c1000 1315

[Com]
Connect=nmpipe host22 SOLID

solsql "tcp localhost 1315"

solsql "tcp 192.168.255.1 1315"

rc = SQLConnect(hdbc, "upipe SOLID", (SWORD)SQL_NTS, "dba", 3, "dba", 3);

Trace

N}:

g{+ Trace N}D1!hCI No |D* Yes,G4 solidDB a

*<+PXQ("xg,SDxg{"DzYE"G<=1!zYD~r_Z TraceFile

N}P8(DD~#

TraceFile

N}:

g{ Trace N}hC* Yes,G4a+PXxg{"DzYE"

4k TraceFile N}8(DD~#g{48(D~{,G4~qw+9C1!D~

soltrace.out,s_+;4k~qwrM'zD10$w?<,b!vZZD;Kt
/zY#

68 IBM solidDB: \m18O

9C solidDB |nP!n

}g,1t/ solidDB 1,I9C|nP!n42G3)N}hCrwCng}]b*
;.`D}]bYw#

XZKNq

v Z Z 193 3D=< C, :solidDB |nP!n;;ZP,a)KIC|nP!nDj

{Pm#9Ii4xP|nP!n -h r -? D!n,}g:

solid -h

v g{|nDo(;}7,G4aT>C(E"#

v |nP!nxVs!4#

}L

ZYw53|na>{&,9CTBo(:

solid [option] [option] [...]

>}

solid -Udba -Pdba -x listen:"tcp 2315" -E -Sadmin

TO|nat/ solidDB ~qw"TVP}]bxPS\,dP:

v -U = C'{:admin
v -P = \k:admin123
v -x listen = xgl}{F:tcp 2315
v -E = T}]bxPS\
v -S = S\\k:admin

hCX(Z solidDB D73d?

X(Z solidDB D73d?9z\;(e1!hC(}g,solid.ini D~"mI$D~

MzYD~D;C)#

XZKNq

BmPP>KX(Z solidDB D73d?#

m

14. solidDB

73d? C> >}

SOLIDDIR (eCZ solid.ini MmI$D~D1!?< export SOLIDDIR=/home/

SOLSMASTART ?F+ SMA ~qwDp<X7Udw* solidDB 1!p<X7Ud

SOLTRACE r*xgzY$_,Sx2G solid.ini D~PD Com.Trace hC export SOLTRACE=yes

73d?

5!vZYw53;kND

JC'8O7

j8E"#

PD SOLSMASTART default address spaces Tq!|`

6

IBM solidDB

soliddb/settings/

export
SOLSMASTART=0x2c0000000000

2mZfCJM4SbC

3 dC solidDB 69

m

14. solidDB

73d? C> >}

SOLTRACEFILE (e+zYE"dv=dPDD~D{FM;C,Sx2G solid.ini

73d?(x

D~PD Com.TraceFile hC

(e SOLTRACEFILE 73d?aT/r*xgzY$_#

)

export SOLTRACEFILE=/home/
soliddb/settings/trace.out

}L

v Z Linux M UNIX 73P,9CTB|n:

export <environment_variable>=<value>

v Z Windows 73P,9CTB|n:

set <environment_variable>=<value>

70 IBM solidDB: \m18O

4 9C solidDB }]\m$_

solidDB }]\m$_G;iCZ4PwV}]bNqD5CLr#

XF($_:solidDB SQL `-w(solsql)M solidDB 6LXF
(solcon)

v “solidDB SQL `-w”(solsql) G;vXF($_,CZZ|na>{&r(}4P

|, SQL odDE>D~4"v SQL odM solidDB ADMIN COMMAND#

v “solidDB 6LXF”(solcon) G;vCZ\mDXF($_;_P\m1(^DC'I

TZ|na>{&r(}4P|,|nDE>D~4
C solcon,ADMIN COMMAND Iw* solcon t/|nPD;?V"v#

CZ<vM0k}]D$_

solidDB a)KTBCZ<vM0k}]D$_:

v “solidDB lY0kw”(solloado r solload)+}]Sb?D~0k= solidDB }]

bP#

v “solidDB <v”(solexp) +}]S solidDB }]b<v=D~P#|9a4(“solidDB

lY0kw”(solloado r solload)CZ4P}]0kYwDXFD~#

v “solidDB

>|,hv}]ba9D}](eod#

}]Vd”(soldd) <v}]bD}]Vd#|azI;v SQL E>,CE

"v ADMIN COMMAND#{

":solidDB }]\m$_;'VZ_ICTdCP9CD“8wJO*F”(TF)&\#
“8wJO*F”9~qw|DTC';IS#

ICTC'8O7

solidDB 6LXF(solcon)

“solidDB 6LXF”(solcon)G;vCZ\mDXF($_;_P\m1(^DC'I
TZ|na>{&r(}4P|,|nDE>D~4"v ADMIN COMMAND#ADMIN

COMMAND Iw* solcon t/|nPD;?V"v#

1k“solidDB 6LXF”(solcon)dO9C1,ADMIN COMMAND o(;,Zk

“solidDB SQL
COMMAND !n,;,}E#

}g:

solcon:

backup

solsql:

ADMIN COMMAND "backup"

`-w”(solsql)dO9C1Do(#Z solcon P,|n;|( ADMIN

#

PX|`E",kND6IBM solidDB

_

71

t/ solidDB 6LXF(solcon)

(}|n solcon (szTd?!n)t/“solidDB 6LXF”(solcon)#

CZt/ solcon Do(gBy>:

solcon [options][network_name][username][password]

dP:

v options ITG:

m

15. solcon

!no( hv

-c dir |D$w?<#

-e command string 4P8(D ADMIN COMMAND#

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

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

-h M -? T>C(oz#

|n!n

v network_name GzQ,S=D solidDB ~qwDxg{#

x(Dxg{Xk(Z}EP#

":9IT+_-}]4{Fk$_dO9C;kNDZ 115 3D6 B, :\mxg

,S;,Tq!x;=DE"#

v username Gj6C'T07(C'D(^yXhD

#g{;PJ1D(^,G4|n

4P+;\x#

v password GC'CZCJ}]bD\k#

solcon CZ,S= solid.ini D~D Com.Connect N}P8(DZ;v~qw#g
{z48(NNTd?,G453+a>zdk}]b\m1DC'{M\k#zI

TZ|nPPa)

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

CJ(

*9C solcon,zXk_P SYS_ADMIN_ROLE r SYS_CONSOLE_ROLE (^,q

r,S+;\x#

ms{"

1|nPPfZms1,solcon aa)I\o(!nDPmw*a{#klizydk
D|nP#

Kv solcon

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

72 IBM solidDB: \m18O

>}:solidDB 6LXF(solcon)

9C~qw{F“tcp localhost 1313”"\m1C'{“admin”M\k“iohi4y”t/ solcon:

solcon "tcp localhost 1313" admin iohi4y

t/ solcon,Tc8]X(}]b:

solcon -ebackup ’tcpip 1313" dbadmin iohi4y

Z solidDB 6LXF(solcon)Pdk|n

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

IT9C -e !nZ|nPOr_9C -f !nZD>D~P4PyP|n#

Z“solidDB 6LXF” P4P\m|n1,z;ha) ADMIN COMMAND !n

(command_name)w*|nV{.Do((;x}E);}g,Z“solidDB 6
”P,SQL |n ADMIN COMMAND ’backup’ G:

backup

PX\m|nPm,kND Z 279 3D:ADMIN COMMAND; ;Z#

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

LXF

m

16.

X(Z

|n u4 5w

exit ex Kv“solidDB 6LXF”

help ? T>ICD“6LXF”|n

solcon

D|n

solidDB SQL `-w(solsql)

“solidDB SQL `-w”(solsql) G;vXF($_,CZ"v SQL odM ADMIN COM-
MAND#ITZ|na>{&r(}4P|, SQL odDE>D~4"v|nMod#

6

PX SQL odD}=(e,kND

;;Z#

(

IBM solidDB SQL

PX ADMIN COMMANDs M ADMIN COMMAND o(Pm,kND Z 279 3D

:ADMIN COMMAND;#

a>:*KbICD ADMIN COMMAND DrLhv0du4,k4PTB|n:

ADMIN COMMAND ’help’

8O7

PD:solidDB SQL

o

t/ solidDB SQL `-w

(}|n solsql (szTd?!n)t/ solidDB SQL `-w (solsql)#

CZt/ solsql Do(gBy>:

solsql [options][network_name] username [password]

4 9C solidDB }]\m$_ 73

dP:

v options ITG:

m

17. solsql

!no( hv

-a T/d5?vod

-c dir |D$w?<#

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

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

-o filename +a{/4kKD~

-O filename TKD~7Sa{/

-S schema_name v9CK#=

-C catalog_name v9CK

-t r!?u|nD4P1d

-2 k}]b4(=u,S

|n!n

?<

-u

-m

I9C|n switch 4Zb=u,S.dxPP;#

v Z Unicode } ] b P

(General.InternalCharEncoding=UTF8),$ZC UTF-8 T

V{Mm;V{}]`MPPD}]xP`k#

v Z ? V Unicode } ]b P

(General.InternalCharEncoding=Raw),$ZC UTF-8 Tm

;

V{}]`MPPD}]xP`k#;a*;V{}]`MP

PD}]#

PX|`E",kNDZ 97 3D:+ solidDB $_k Unicode d
O9C;;Z#

v Z Unicode }]b(General.InternalCharEncoding=UTF8)

P,$ZCXF(DoT73/zk3TV{Mm;V{}]`

PD}]xP`k,x;<G~qwKMM'zKV{}]

MP

s(N}DhC#

v Z ? V Unicode } ]b P

(General.InternalCharEncoding=Raw),$ZCXF(Do

T73/zk 3Tm;V{}]`MPPD}]`k,x;<G
~qwKMM'zKV{}]s(N}DhC#

]`MPPD}]#

PX|`E",kNDZ 97 3D:+ solidDB $_k Unicode d

O9C;;Z#

;a*;V{}

74 IBM solidDB: \m18O

m

17. solsql

!no( hv

-M locale_name

-h M -? oz = C(

|n!n(x

)

v Z Unicode } ] b P

(General.InternalCharEncoding=UTF8),$ZC8(Do

T7 3 /zk3 T V{Mm ; V{}] ` MPPD } ]xP`
k#

v Z ? V Unicode } ]b P

(General.InternalCharEncoding=Raw),$ZC8(DoT

73/zk3Tm;V{}]` MPPD}]xP`k#;a
;V{}]`MPPD}]#

locale_name Dq=!vZYw53#

}g,Z Linux 73P,PD/PzDzk3 GB18030 DoT7
3* zh_CN.gb18030#

Z Windows 73P,R<o/R<D Latin1 zk3DoT73*

fin_fin.1252#

PX|`E",kNDZ 97 3D:+ solidDB $_k Unicode d

9C;;Z#

O

*

-x onlyresults vr!P

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

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

-x returnerroronexit K|nP*XCZT> SQL msMC'}pD}LmsD5X

k#5XkI\G:

v zk 60:4P SQL od

v zk 61:}LwC5Xms#

g{4P SQL E>ZdP`v SQL odM/r}LwC'\,G4
+5XZ;vJOD5Xk#

-x outputsql K|nP*Xr!Q4PD SQL |n,x;Gvvr!?nYwD
a{#

'\#

v network_name GzQ,S=D solidDB ~qwDxg{#

x(Dxg{Xk(Z}EP#PX|`E",kNDZ 115 3D6 B, :\mxg

,S;#

a>:9IT+_-}]4{Fk solidDB $_dO9C#

v username Gj6C'yXhD,"RCZ7(C'D(^

#g{;PJ1D(^,G

4|n4P+;\x#

v password GC'CZCJ}]bD\k#password G

D~{

– XhD(g{4SD~A!C\k,CD~(}!n -x pwdfile:

xP(e)

– I!D(g{SD~PA!C\k)

4 9C solidDB }]\m$_ 75

":

v g{Z|nPP8(K username M password,G49Xk8( network_name#
v g{Z|nPP8(K SQL E>D~D{F(-f !n}b),G49Xk8(

network_name"username M password#

kG!Z SQL E>)2r_ZKv solsql 0d5$w#

solidDB $_,SA solid.ini D~Z Com.Connect N}P8(DZ;

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

ms{"

1|nPPfZms1,solsql aa)I\o(!nDPmw*a{#klizydk
D|nP#

Kv solsql

*Kv solsql,kdk exit |n#

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;

v~qw#

drop table testtable;
commit work;

SD~P4P SQL E>

IT1SZ solidDB SQL `-wPr_(}Z solidDB SQL `-wt/|nPP8(
E>D~{4SD~4P SQL E>#

Z solidDB SQL `-wP4P SQL E>

solsql PCZE>wCDo(G:

@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 solsql $

w?<#

76 IBM solidDB: \m18O

Z“solidDB SQL `-w”t/1SD~P4P SQL E>

*Z solsql t/1SD~P4P SQL E>,Xk8(CE>D~D{Fw*|nPN
}:

solsql network_name username password filename

CE>PDyPod<XkTVEU9#4PCE>D~PDyPods,solsql +K

v#

>}:

solsql "tcp localhost 1313" admin iohe4y tables.sql

":

k;*|GZ SQL E>)2r_ZKv solsql 0d5$w#g{(}!n -e 44P
SQL V{.,G4;\9C -a !n44Pd5#

solidDB lY0kw(solloado M solload)

“solidDB lY0kw”(solload) G;v$_,CZ+}]Sb?D~0k= solidDB }
]b#

S solidDB 6.5 FP2 *<,fZ“solidDB lY0kw”D=Vde:

v solloado T Unicode M?V Unicode }]ba)'V#|9'V(}`v_L0k

}]#solloado yZ solidDB ODBC API;CM'zKdCN}IC4XF solloado

P*#

D

v solload vT?V Unicode }]ba)'V#solload yZ solidDB SA API#

“solidDB lY0kw”\;0kwVq=D}],"\;+PX0k}LDj8E"zI

=U>D~#

}]+(} solidDB Lr0k=}]b#b+Jm}]bZ0kZdT*z==$w#
*0kD}];X$tZ~qwFczO#

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

v (}TBo('V?<:

catalog_name.schema_name.table_name

v aTBP<xxPli:

– N<<x

– NOT NULL <x

– (;<x

v “solidDB lY0kw”;'V9C CREATE TABLE M ALTER TABLE od(e"

RZPP8(}]5^FDli<x#

+G,solidDB lY0kw<Uli9C CREATE TABLE od(eD(;<xrb
|<x#PX<xD|`j8

solidDB SQL

<kD~

(4|,b?}]DD~)Dq=GZ

E",kND6IBM solidDB SQL

o(

;PD CREATE TABLE o(#

XFD~

8O7

P8(D#

D:

=<:

4 9C solidDB }]\m$_ 77

D~`M

XFD~

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

v <kD~D{F

v <kD~Dq=

v *0kDmMP

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

PXXFD~q=D

|`j8E",kND Z 83 3D:XFD~o(;#

<kD~(}]D~)

<kD~G|,*0k= solidDB }]bPD}]DD~#“solidDB <v”(solexp) z
Ib)`MD}]D~#

<kD~IT|,L(q=r(gq=D}]:

v TZL($Hq=xT,}]G<D$HL(,"RG<PD}]VN_PL(D

;CM$

v TZ(gq=xT,}]G<D$HId#?v}]VNM}]G<<(}(gV

{(}g:E)kB;v}]VNM}]G<Vt*(bMG solidDB Export yzI

Dq=)#4|,}]DVN+T/hC* NULL#

G<PD}]VNIT

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

INTEGER r SMALLINT `MDVNP#

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

F`k#

v 9CNNL(mHVN1,

~_P8(DmH,499C NULL 1`gK#

H#

_PNNIXFD~8(D3r#

^[GDV}]`M,solloado r solload <Z{<kD

{"U>D~

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

v 0kUZM1d

v 0k3FE",}gI&0kDP}"'\P}T00k1d(g{(}!n8(*

zIKZ]D0)

v NNI\Dms{"#PX solidDB lY0kwmsD

D:solidDB lY0kw(solloado M solload)ms;#

g{^(4(U>D~,G40k}L+U9#1!ivB,U>D~D{Fy]<
kD~D { F z I , " + < k D ~ D D ~)9{f;*D~)9{ .log# } g ,
my_table.ctr +4(U>

t/“solidDB lY0kw”(solloado M solloado)

9C|n solloado r solload(szTd?!n)4t/“solidDB lY0kw”#

78 IBM solidDB: \m18O

j8E",kND Z 276 3

D~ my_table.log#*8(m;vD~{,k9C!n -l#

g{t/ solidDB lY0kw148(NNTd?,G4z+4=Td?**0dC(
Dr*hv#

v CZt/ solloado Do(gBy>:

solloado [options][network_name] username [password]control_file

v CZt/ solload Do(gBy>:

solload [options][network_name] username [password]control_file

dP,options ITG:

m

18. solloadoMsolload

!no( solloado solload hv

XX *Z;vz&mPd5D insert od}(4Pd5.0Dod})

-b statements

-B records X *Z;vodPekDG<}

XX

-c dir

XX

-C catalog_name

XX

-l filename

XX

-L filename

-m X

|n!n

}g,g{8( -b 10,G4aZ 10 v insert od.s4Pd5#

}g,g{8( -B 3,G4?v insert odaek}P#

|D$w?<#

hC1!?<,aTK?<A4}]

+U>u?4kKD~

TKD~7SU>u?

v Z Unicode }]b(General.InternalCharEncoding=UTF8)P,$ZCXF(Do

T73/zk3TV{Mm;V{}]`MPPD}]xP`k,x
M'zKV{}]s(N}DhC#

v Z ?V Unicode }]bP(General.InternalCharEncoding=Raw),$ZCXF(

DoT73/zk3Tm;V{}]`MPPD}]`k,x;<G~qwKMM'z
KV{}]s(N}DhC#;a*;V{}]`M

;<G~qwKM

PPD}]#

-M locale_name X

-u X

PX|`E",kNDZ 97 3D:+ solidDB $_k Unicode dO9C;;Z#

v Z Unicode }]bP(General.InternalCharEncoding=UTF8),$ZC8(DoT

73/zk3TV{Mm;V{}]`MPPD}]xP`k#

v Z ?V Unicode }]bP(General.InternalCharEncoding=Raw),$ZC8(

oT73/zk3Tm;V{}]`MPPD}]xP`k#;a*;V{}]`MP

PD}]#

locale_name Dq=!vZYw53#

}g,Z Linux 73P,PD/PzDzk3 GB18030 DoT73* zh_CN.gb18030#

Z Windows 73P,R<o/R<D Latin1 zk3D

PX|`E",kNDZ 97 3D:+ solidDB $_k Unicode dO9C;;Z#

v Z Unicode }]bP(General.InternalCharEncoding=UTF8),$ZC UTF-8 T

V{Mm;V{}]`MPPD}]xP`k#

v Z ?V Unicode }]bP(General.InternalCharEncoding=Raw),$ZC UTF-8

Tm;V{}]`MPPD

PX|`E",kNDZ 97 3D:+ solidDB $_k Unicode dO9C;;Z#

}]xP`k#;a*;V{}]`MPPD}]#

oT73* fin_fin.1252#

4 9C solidDB }]\m$_

79

D

m

18. solloadoMsolload

!no( solloado solload hv

XX

-n records

XX

-s schema_name

XX

-t

-w threads X hCek}]D_L}#C5;\,}&mw}

XX

-h

XX

-x emptytable

XX

-x errors: count

XX

-x nointegrity

XX

-x pwdfile: file-

name

XX

-x skip: records

-x utf8

|n!n(x

X

)

ek}is!(xgf>)

hC1!#=

r!0k1d

1!5* 4#

oz = C(

v1mP;PNNP1E0k}]

nsms}

0kZd;4Pj{Tli

SD~PA!\k

*x}DG<}

WCHAR }]IC UTF-8 q=

v network_name GzQ,S=D solidDB ~qwDxg{#

x(Dxg{Xk(Z}EP#PX|`E",kNDZ 115 3D6 B, :\mxg

,S;#

a>:9IT+_-}]4{Fk solidDB $_dO9C#

v username Gj6C'yXhD,"RCZ7(C'D(^

#g{;PJ1D(^,G

4|n4P+;\x#

v password GC'CZCJ}]bD\k#password G

D~{

– XhD(g{4SD~A!C\k,CD~(}!n -x pwdfile:

xP(e)

– I!D(g{SD~PA!C\k)

PX control_file Dj8E",kNDZ 83 3D:XFD~o(;;Z#

>}

TB solloado >}SI{* DBA_TBL.ctr DXFD~8(DD~P0k}],SxT
UTF-8 V{N=A!}]"9C 8 v_L4+_P 30 vG<D}]ek=;vod

P:

solloado -w 8 -B 30 -u "tcpip 1964" dba dba DBA_TBL.ctr

TB solload >}SI{* delim.ctr DXFD~8(DD~P0k}]:

solload "tcpip 1964" dba dba delim.ctr

80 IBM solidDB: \m18O

ms{"

1|nPPfZms1,solload aa)I\o(!nDPmw*a{#kli|nPd

k#

PXa_0kYHDa>

BPa>ITozz7#Tn_T\4P0k:

v PI\1,T>X==xP,S;r*;h*(}xg0k}],yTYHa|l

;)#

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

v {CB

qG<&\#

*{CG<&\,k+ Logging.LogEnabled N}hC*“no”#

a>:Z0kYwjIs,kG!YNtCG<&\ (Logging.LogEnabled=yes)#
Zzz73P,?R(iz;*Z{CU>G<&\DivBKP~qw#g{4

4U>,G4"zms(}g,IZ

>}

>}:0kL(q=DG<

g4JOrELms)1,^(4PV4#

ZL($Hq=<kD~P,}]G<D$HL(,"Rb)G<PD}]VN|,

L(D;CM$H#

>}:XFD~ 1

>} 1 ZL(mHVNP9C`P:

OPTIONS(ARRAYSIZE=3)

LOAD
INFILE ’test1.dat’
INTO TABLE SLTEST
(

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

)

>}:XFD~ 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 (
IDINTEGER 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)

>}:0kd$G<

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

4 9C solidDB }]\m$_ 81

>}:XFD~ 3

>} 1 9C_PVt{D`Px;GL($HVN#

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 date string

-- given above

-- The default date string is used for DATE2.

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

-- inserted.

9C solidDB lY0kw(solload)KPy>0k

solidDB Lr|_P]>gN9C solload 40kD~Dy>#Z solidDB D samples/
importexport/solload ?<Pa)KCy>#

1. t/ solidDB#

2. (}9C load.sql E>M solidDB SQL `-w (solsql) 44(m#

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

82 IBM solidDB: \m18O

solload "tcpip 1964" dba dba delim.ctr

Y(C'{M\k*“dba”#

*9CL($HDXFD~,kdkTB|n:

solload "tcpip 1964" dba dba fixed.ctr

4. 9C delim.ctr r fixed.ctr xPDI&0kDdv*:

IBM solidDB lY0kw v.06.50.0015
(c) Solid Information Technology Ltd. 1993, 2009
Load completed successfully, 19 rows loaded.

XFD~o(

XFD~o(_PBPXw:

v X|VXkTs4V88(

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

v (}+;P{CZNNJ.0,IT9odgP

g{+ solidDB lY0kw#tVCw}]VdTs(4,m{rP

{),G4Xk+

d(Z}EP#TBPm|, solidDB lY0kwXFD~DyP#tV:

m

19.

lY0kw#tV

lY0kw#tV

AND ANSI APPEND BINARY

BLANKS BY CHAR CHARACTERSET

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

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

4 9C solidDB }]\m$_ 83

m

20.

XFD~Dj{o(

o(*X (e

control_file

option_part

options

option

load_data_part

characterset_specification

into_table_part

::= [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 }

::= INTO TABLE tablename

fields

termination

termination_char

enclosure

enclose_char

hex_literal

column_list

column

::= [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

’)]

84 IBM solidDB: \m18O

m

20.

XFD~Dj{o((x

o(*X (e

)

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

CHARACTERSET

CHARACTERSET X | V CZ( ed k D ~ P9 C D V {/ # g { 49 C
CHARACTERSET X|V,r_+KX|VkN} NOCONVERT r NOCNV dO9

C,G4+;4P*;#

4gBy>9CN}:

v TZ ANSI V{/,9C ANSI

v TZ Windows V{/,9C MSWINDOWS

v TZU( PC V{/,9C PCOEM

TZ IBM PC V{/,9C IBMPC

v

v TZ|,90DI,GV{D 7 ;V{/,9C SCAND7BIT

DATE"TIME M TIMESTAMP

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

v +b)X|VDdP;vCw load-data-part *XDiI?V1,|(e<kD~PC

Z+}]ek=NNC`MDPDq=#

v 1X|Vw*P(eD;?VvV1,|8(+}]ek=CP19

CDq=#

":

1. Cw load-data-part *XD;?VDZkXkICTB3r:DATE"TIME M TIME-

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

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

m

21.

}]Zk

}]`M ICD}]Zk

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

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

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

v Zk?V:

– j]Zk:YYYY M YY

– B]Zk:MM"M M B(B 8DG"oPT}vV8m>DB]u4,;xV

s!4)

4 9C solidDB }]\m$_ 85

– UZZk:DD M D

– !1Zk:HH M H

– VSZk:NN M N

– kSZk:SS M S

v UZZkPDZkIICNN3r;}g,UZZkITG“MM-DD-YYYY”(12-18-

2010) r“DD-B-YYYY”(18-DEC-2010)#

v g{<kD~DUZ}]Dq=* 1995-01-31 13:45:00,G4k9CZk YYYY-

MM-DD HH:NN:SS#

v XkVt

b)Zk

XFD~PDUZ>}

TB>}9C POSITION X|V#PXKX|VDj8E",kND Z 90 3D:POSI-
TION;#

OPTIONS(SKIP=1)

LOAD DATA
RECLEN 12
INTO TABLE SLTEST2
(

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

)

XFD~PDUZ"1dM1dAG>}

TB>}9C FIELDS TERMINATED BY X|V#PXKX|VDj8E",kND
Z 89 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 ’,’
(

)

ID,
DT,
TM,
TS

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"

86 IBM solidDB: \m18O