Filter
Top Products
Field / Description
Tuning Formula or Default Value
(Default value is provided if there is no
tuning formula)
Buffer Size
Determines the number of additional
connections reserved by the database
connection pool. These additional
connections are released when there is an
unexpected demand for more connections.
The buffer connections are created in
addition to the maximum connections
reserved.
Based on the connection pool, the
parameters are provided in the following
list:
v Local: (jdbcService.dbPool_local.buffersize
= 500)
v Select:
(jdbcService.dbPool_Select.buffersize =
500)
v Non-transactional:
(jdbcService.dbPool_NoTrans.buffersize =
500)
v Default: (jdbcService.dbPool.buffersize =
500)
v Archive:
(jdbcService.dbArchivePool.buffersize =
500)
v UI: (jdbcService.dbUIPool.buffersize = 500)
Depending on the database, replace the db
with the database name. For example, if you
are using Oracle as your database, enter
oracle. Default values are provided in the
following list:
v Local: jdbcService.dbPool_local.buffersize
= 500
v Select: jdbcService.dbPool_Select.buffersize
= 500
v Non-transactional:
jdbcService.dbPool_NoTrans.buffersize =
500
v Default: jdbcService.dbPool.buffersize =
500
v Archive:
jdbcService.dbArchivePool.buffersize = 500
v UI: jdbcService.dbUIPool.buffersize = 500
Click Next.
If you have purchased additional adapters, you may have to increase the
database pools to reduce the chances of a business process or adapter having
to wait for a database connection.
12. In the Queue Settings page that is displayed, decide whether you want to use
the current settings or the suggested settings.
Note: Sterling B2B Integrator restart is not required if you modify settings in
this page.
v If yes, click Fill Suggested.
v If no, enter information in the fields in the following columns:
Field / Description
Tuning Formula or Default Value
(Default value is provided if there is no
tuning formula)
Queue Name
Name of the queue. Nine queues (Queue 1
to Queue 9) enable flexible management of
your workload.
Not applicable
160 Sterling B2B Integrator: Performance Management