1. Using the IBM DB2 Adapter with Oracle Integration Generation 2
  2. Understand the IBM DB2 Adapter
  3. IBM DB2 Adapter Restrictions

IBM DB2 Adapter Restrictions

Note the following IBM DB2 Adapter restrictions.

  • The IBM DB2 Adapter can only be used with the on-premises connectivity agent.
  • Database schema names with hyphens (-) are not supported.
  • The database password length cannot exceed 20 characters.
  • All integrations that include stored procedure, PureSQL, or operation on table database operations must finish within 240 seconds. Otherwise, the query times out and a Limit Exceeded error occurs.

Note:

There are overall service limits for Oracle Integration. A service limit is the quota or allowance set on a resource. See Service Limits.