IBM E02HMLL-I Implementation Guide - Page 116

Configuring, database, properties, using, System, Manager

Page 116 highlights

v The Server version field, which identifies the version of IBM WebSphere Integration Server Express software the server is running. v The Total memory field, which identifies the amount of RAM on the computer running InterChange Server Express. v The Free memory field, which identifies the amount of RAM that is available on the computer running InterChange Server Express. v The Startup time field, which identifies the time at which the server instance started. v The Local Time Zone field, which identifies the time zone in which the computer running System Manager resides. v The Server Time Zone field, which identifies the time zone in which the computer running InterChange Server Express resides. v The Server locale field, which identifies the locale of the computer on which InterChange Server Express is running. Configuring database properties using System Manager The "Database" tab of the configuration file editor allows you to change properties that specify the databases InterChange Server Express uses to store repository, event management, and transaction management data. Do the following to configure the database properties: 1. Click the Database tab. 2. Select the appropriate value in the Database Driver drop-down menu-either IBM DB2 Serveror MQ SQL Server-depending on the database vendor. 3. Type the maximum number of connections you want InterChange Server Express to make with the database server in the Max Connections field, or enable the Unlimited checkbox to allow InterChange Server Express an unlimited number of connections. 4. Type the maximum number of pools InterChange Server Express should establish to contain the database connections it caches in the Max pools field. 5. Type the number of minutes you want a connection object to remain idle before being returned to the database connection pool for reuse in the Idle Timeout field. 6. Type the number of times that the server should attempt to execute a deadlocked database transaction in the Max deadlock retry field. This field is related to the Deadlock retry interval field documented in step 7. For more information on the behavior of the server in the case of a database deadlock, see the System Administration Guide. 7. Type the number of seconds that the server should wait in between attempts to execute a deadlocked database transaction in the Deadlock retry interval field. This field is related to the Max deadlock retry field documented in step 6. For more information on the behavior of the server in the case of a database deadlock, see the System Administration Guide. 8. Do the following in the "Event Management" pane to configure the database connectivity for the event management service: a. If you chose MQ SQL Server(Type 4)in the Database Driver drop-down menu, then type the name of the computer on which the database server resides in the Host name field. b. Type the name of the database in the Database field. 104 IBM WebSphere Business Integration Server Express and Express Plus: System Implementation Guide

  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12
  • 13
  • 14
  • 15
  • 16
  • 17
  • 18
  • 19
  • 20
  • 21
  • 22
  • 23
  • 24
  • 25
  • 26
  • 27
  • 28
  • 29
  • 30
  • 31
  • 32
  • 33
  • 34
  • 35
  • 36
  • 37
  • 38
  • 39
  • 40
  • 41
  • 42
  • 43
  • 44
  • 45
  • 46
  • 47
  • 48
  • 49
  • 50
  • 51
  • 52
  • 53
  • 54
  • 55
  • 56
  • 57
  • 58
  • 59
  • 60
  • 61
  • 62
  • 63
  • 64
  • 65
  • 66
  • 67
  • 68
  • 69
  • 70
  • 71
  • 72
  • 73
  • 74
  • 75
  • 76
  • 77
  • 78
  • 79
  • 80
  • 81
  • 82
  • 83
  • 84
  • 85
  • 86
  • 87
  • 88
  • 89
  • 90
  • 91
  • 92
  • 93
  • 94
  • 95
  • 96
  • 97
  • 98
  • 99
  • 100
  • 101
  • 102
  • 103
  • 104
  • 105
  • 106
  • 107
  • 108
  • 109
  • 110
  • 111
  • 112
  • 113
  • 114
  • 115
  • 116
  • 117
  • 118
  • 119
  • 120
  • 121
  • 122
  • 123
  • 124
  • 125
  • 126
  • 127
  • 128
  • 129
  • 130
  • 131
  • 132
  • 133
  • 134
  • 135
  • 136
  • 137
  • 138
  • 139
  • 140
  • 141
  • 142
  • 143
  • 144
  • 145
  • 146
  • 147
  • 148
  • 149
  • 150
  • 151
  • 152
  • 153
  • 154
  • 155
  • 156
  • 157
  • 158
  • 159
  • 160
  • 161
  • 162
  • 163
  • 164
  • 165
  • 166
  • 167
  • 168
  • 169
  • 170
  • 171
  • 172
  • 173
  • 174
  • 175
  • 176
  • 177
  • 178
  • 179
  • 180
  • 181
  • 182
  • 183
  • 184
  • 185
  • 186
  • 187
  • 188
  • 189
  • 190
  • 191
  • 192
  • 193
  • 194
  • 195
  • 196
  • 197
  • 198
  • 199
  • 200
  • 201
  • 202
  • 203
  • 204
  • 205
  • 206
  • 207
  • 208
  • 209
  • 210
  • 211
  • 212
  • 213
  • 214
  • 215
  • 216
  • 217
  • 218
  • 219
  • 220
  • 221
  • 222
  • 223
  • 224
  • 225
  • 226
  • 227
  • 228
  • 229
  • 230
  • 231
  • 232
  • 233
  • 234
  • 235
  • 236
  • 237
  • 238
  • 239
  • 240
  • 241
  • 242
  • 243
  • 244
  • 245
  • 246
  • 247
  • 248
  • 249
  • 250
  • 251
  • 252
  • 253
  • 254
  • 255
  • 256
  • 257
  • 258
  • 259
  • 260
  • 261
  • 262
  • 263
  • 264
  • 265
  • 266
  • 267
  • 268
  • 269
  • 270
  • 271
  • 272
  • 273
  • 274
  • 275
  • 276
  • 277
  • 278
  • 279
  • 280
  • 281
  • 282
  • 283
  • 284
  • 285
  • 286
  • 287
  • 288
  • 289
  • 290
  • 291
  • 292
  • 293
  • 294
  • 295
  • 296
  • 297
  • 298
  • 299
  • 300
  • 301
  • 302

v
The
Server
version
field,
which
identifies
the
version
of
IBM
WebSphere
Integration
Server
Express
software
the
server
is
running.
v
The
Total
memory
field,
which
identifies
the
amount
of
RAM
on
the
computer
running
InterChange
Server
Express.
v
The
Free
memory
field,
which
identifies
the
amount
of
RAM
that
is
available
on
the
computer
running
InterChange
Server
Express.
v
The
Startup
time
field,
which
identifies
the
time
at
which
the
server
instance
started.
v
The
Local
Time
Zone
field,
which
identifies
the
time
zone
in
which
the
computer
running
System
Manager
resides.
v
The
Server
Time
Zone
field,
which
identifies
the
time
zone
in
which
the
computer
running
InterChange
Server
Express
resides.
v
The
Server
locale
field,
which
identifies
the
locale
of
the
computer
on
which
InterChange
Server
Express
is
running.
Configuring
database
properties
using
System
Manager
The
“Database”
tab
of
the
configuration
file
editor
allows
you
to
change
properties
that
specify
the
databases
InterChange
Server
Express
uses
to
store
repository,
event
management,
and
transaction
management
data.
Do
the
following
to
configure
the
database
properties:
1.
Click
the
Database
tab.
2.
Select
the
appropriate
value
in
the
Database
Driver
drop-down
menu—either
IBM
DB2
Server
or
MQ
SQL
Server
—depending
on
the
database
vendor.
3.
Type
the
maximum
number
of
connections
you
want
InterChange
Server
Express
to
make
with
the
database
server
in
the
Max
Connections
field,
or
enable
the
Unlimited
checkbox
to
allow
InterChange
Server
Express
an
unlimited
number
of
connections.
4.
Type
the
maximum
number
of
pools
InterChange
Server
Express
should
establish
to
contain
the
database
connections
it
caches
in
the
Max
pools
field.
5.
Type
the
number
of
minutes
you
want
a
connection
object
to
remain
idle
before
being
returned
to
the
database
connection
pool
for
reuse
in
the
Idle
Timeout
field.
6.
Type
the
number
of
times
that
the
server
should
attempt
to
execute
a
deadlocked
database
transaction
in
the
Max
deadlock
retry
field.
This
field
is
related
to
the
Deadlock
retry
interval
field
documented
in
step
7.
For
more
information
on
the
behavior
of
the
server
in
the
case
of
a
database
deadlock,
see
the
System
Administration
Guide
.
7.
Type
the
number
of
seconds
that
the
server
should
wait
in
between
attempts
to
execute
a
deadlocked
database
transaction
in
the
Deadlock
retry
interval
field.
This
field
is
related
to
the
Max
deadlock
retry
field
documented
in
step
6.
For
more
information
on
the
behavior
of
the
server
in
the
case
of
a
database
deadlock,
see
the
System
Administration
Guide
.
8.
Do
the
following
in
the
“Event
Management”
pane
to
configure
the
database
connectivity
for
the
event
management
service:
a.
If
you
chose
MQ
SQL
Server(Type
4)
in
the
Database
Driver
drop-down
menu,
then
type
the
name
of
the
computer
on
which
the
database
server
resides
in
the
Host
name
field.
b.
Type
the
name
of
the
database
in
the
Database
field.
104
IBM
WebSphere
Business
Integration
Server
Express
and
Express
Plus:
System
Implementation
Guide