DataDirect IDMS Extensions OCA-DB2

DataDirect's IDMS Extension OCA-DB2 enables CA-IDMS programs to directly access IBM DB2 databases using standard SQL requests. Two-phase commit is available if used together with OCA-COMMIT. Access to DB2 is performed using the Call Attachment Facility (CAF) or the Recoverable Resource Manager Services Attachment Facility (RRSAF), if OCA-COMMIT is installed in the system.

Key Features

  • Supports standard SQL requests
  • Two-phase commit available with OCA-COMMIT
  • Fully compatible with other OCA components
  • Easily installed in two hours, less if you already use other OCA components

Using both OCA-DB2 and OCA-COMMIT enables you to perform simultaneous updates in both CA-IDMS and DB2 with 100% integrity between both databases.

Tedious work and maintenance costs eliminated
The traditional way of accessing DB2 from CA-IDMS is to use APPC to trigger a CICS program that performs the DB2 access and returns the requested information. APPC programming can be tedious and maintaining those programs can be expensive. OCA-DB2 makes it very easy to access DB2 data, and you get two-phase commit capabilities.

CV performance maintained
Accessing DB2 databases is as simple as coding the SQL requests in your COBOL program, running the program through the DB2 pre-compiler and then through your usual CA-IDMS procedure. You can use both dynamic and static SQL. When you execute the program within CA-IDMS, OCA-DB2 will allocate a DB2 connection and perform the requests without any impact on the CV performance.

More Information
Enable 2PC with IDMS
Access DB2 Data within IDMS
Integration IDMS with WebSphere MQ Series
Integration between IDMS regions
TCPIP Connectivity for IDMS
SOA enablement of mainframe business logic
SOA enablement of mainframe data
SOA enablement of mainframe screen processes
Shadow Advanced Features
Real Time Events
Web Enablement
Direct SQL Access
Mainframe Consumption of Web Services