Filter
Top Products
Variable Description
C Any additional connections that are opened by customized code or
user exits that do not go through the NoApp Server connection
pools. This connection requirement is specific to your
implementation.
D Number of connections required by the containers.
Benchmarking
Benchmarking your system to validate assumptions and estimates prior to a
production implementation is strongly recommended. During the test, monitor the
connection pool usage levels in each of the application server instances, the
number of agents to run to meet your processing and service levels, and the actual
DB2 database connections established.
Mandatory settings for DB CFG parameters
For optimal performance, certain parameters and values are mandatory for DB2
9.x.
Parameter Mandatory value
Database Code Set UTF-8
Recommended settings for DB CFG parameters
For optimal performance, follow the recommended settings for DB2 9.x.
The parameters and values described in the following table are recommended:
Parameter Recommended value
SELF_TUNING_MEM Enables the DB2 self-tuning memory manager (STMM) to automatically and
dynamically set memory allocations to memory consumers such as buffer
pools, lock lists, package cache, and sort heap.
Recommended value: ON
DATABASE_MEMORY Allows DB2 to adjust the amount of database memory depending on load,
memory pressures, and other factors.
Recommended values:
AUTOMATIC (for Windows and AIX)
COMPUTED (for Linux, HP-UX, and Solaris)
LOCKLIST Allows STMM to dynamically manage memory allocations.
Recommended value: AUTOMATIC
MAXLOCKS Allows STMM to dynamically manage memory allocations.
Recommended values:
AUTOMATIC
If AUTOMATIC is not supported: 100
PCKCACHESZ Allows STMM to dynamically manage memory allocations.
Recommended value: AUTOMATIC
SHEAPTHRES_SHR
SORTHEAP
40 Sterling B2B Integrator: Performance Management