Filter
Top Products
Feature Description Value
Inline LOBs Sterling B2B Integrator extensively uses
large objects (LOBs). These LOBs are
usually a few kilobytes in size.
The LOB data access performance can be
improved by placing the LOB data within
the rows on data pages instead of the LOB
storage object.
Typically, LOBs are stored in a separate
storage object that is outside the base table.
LOBs can be stored in the formatted rows
of the base table if they are sufficiently
sized. Depending on the page size, the
maximum length of a LOB that can qualify
for in table in-lining is 32660 bytes. Such
LOBs are commonly known as inline LOBs.
Earlier, the processing of such LOBs created
bottlenecks for application. However, now
LOBs improve the performance of queries
that access the LOB data as there is no
additional I/Os required for fetching,
inserting, or updating the data.
LBO inlining is enabled for all LOB
columns in the new or existing tables for
DB2 9.7 and for all existing LOB columns in
an upgrade.
Enable LOB inlining
through the INLINE
LENGTH option on
the CREATE TABLE
statement or the
ALTER TABLE
statement.
Recommended Settings for DB2 for Linux on System z (5.2.4.0 or
later)
IBM recommends special settings for DB2 when using Sterling B2B Integrator
5.2.4.0 or later on the Linux operating system on System z.
When you are running Sterling B2B Integrator 5.2.4.0 or later using the DB2
database on the Linux operating system on System z (or zLinux), IBM recommends
the following settings:
v SCSI over FCP (fiber channel protocol) disks for data and transaction logs.
v RAID 5 for data logs and RAID 10 or solid state drives (SSDs) for transaction
logs. All volumes should be striped across as many disks as possible. With this
setup, DB2 can be configured to use direct input and output.
An alternative setup is the use of separate extended count key data (ECKD) disks
with PAV (parallel access volumes) or HyperPAV for data and transaction logs. The
PAV and HyperPAV features are available on the IBM DS8000 series of IBM SANs.
This setup tries to overcome the limitations of the typical ECKD disk setup. All
ECKD volumes should be striped.
Storage Subsystem
Prior to production, plan the overall storage strategy. The DDLs to create
temporary tablespaces and data tablespaces are left to the discretion of the
customer. This topic discusses some general recommendations.
The Sterling B2B Integrator installation creates tables and indexes. The tables use
different page sizes: 4K, 8K, and 16K. You should have a tablespace to
44 Sterling B2B Integrator: Performance Management