InterChange Server is certified for use with IBM DB2 version 8.1
with fix pack 2, Oracle Server 8.1.7.4 or
9.2.0.4 (9i), and Microsoft SQL Server 2000 with service
pack 3.
DB2 Server must be configured to meet the following criteria (see "IBM DB2 Server" for instructions):
- Note:
- Building DB2 stored procedures requires a DB2 supported C compiler.
For information about working with stored procedures, read the DB2 online
documentation on the DB2 product CD.
- Note:
- DB2 Type 2 drivers must be installed on the same host as InterChange Server
before running the ICS installer. These drivers are no longer shipped
with ICS, but are included with the DB2 Server software.
- WebSphere Business Integration administrator user with database and table
creation privileges created.
- 50 MB of disk space for data files available for the ICS repository
database (wicsrepos).
- The maxappls and maxagents parameters configured
with a minimum of 50 user connections each.
- The tablespace for the mapping tables (optional) configured to contain at
least 50 MB of data.
- Maximum application heap size configured to be at least 4096.
Oracle Server must be configured to meet the following criteria (see "Configuring Oracle Server" for instructions):
- Oracle Enterprise Edition Database Server 8.1.7.4
(8i) or 9.2.0.4 (9i) installed.
- 300 to 500 MB of disk space for the temporary data files, and 200 to 300
MB of disk space for the rollback data files available.
- Rollback, temporary, and repository tablespaces created.
- Rollback segments defined. For consistency, use CW_RBS1,
CW_RBS2, CW_RBS3, CW_RBS4, and
CW_RBS5.
- Database and database instance created with unique System IDs.
- Database user with connect, resource, and unlimited tablespace privileges
using the repository tablespace as the default tablespace and the temporary
tablespace as the default temporary tablespace.
SQL Server must be configured to meet the following criteria (see "Configuring SQL Server" for instructions):
- WebSphere Business Integration administrator user with table creation
privileges created.
- 50 MB of disk space for data files available for the repository database
(wicsrepos).
- 40 user connections configured.
- 50 MB of disk space available for the mapping tables (optional).
- Logging configured for Truncate Log on
Checkpoint.
