Filter
Top Products
Technology Scalability Survivability Maintainability Num Disks
RAID-10 Excellent read/write
performance.
Can tolerate up to n disk
failures as long as two
failures do not occur in the
same mirrored set.
Excellent. Low disk
utilization skew.
Possible LUN utilization
skew.
20
Use of Native File Systems
Using file systems for storage can simplify administration tasks, although
potentially at some loss of some performance over using raw disks. It is
recommended that you consult with your storage administrator and storage
vendor.
Operating System Native File System
Windows NTFS
Linux EXT3
Solaris UFS
AIX
®
JFS2
HP-UX VxFS
Database management for Sterling B2B Integrator
Sterling B2B Integrator uses a database server as a repository for transactional,
reference, and history data that it generates and uses.
Refer to the system requirements for a list of supported database configurations.
This topic covers the following concepts:
v JDBC Connection Pool Overview
v Configuring Parameters for a Database Pool
v Schema Objects
JDBC connection pool overview
Sterling B2B Integrator uses internal connection pooling to minimize delays in the
creation of new connections to the database server. When a connection is
requested, an existing connection is used whenever possible. Internal connection
pooling improves performance by removing the need to go to the driver and
creating and delete a new connection each time one is needed.
Internal connection pooling mechanism implements a connection pool in every
JVM started for the product. In a cluster with multiple nodes, the number of
connections the database must establish is the total of all connections for all the
connection pools.
For example, if you have four JVM instances and each connection pool averages
around 30 connections, your database server must establish 120 database
connections.
16 Sterling B2B Integrator: Performance Management