DB2 requirements

To use Subzero as an interface between a queue-sharing group (QSG) for IBM MQ and IBM DB2, between DB2 and CICS, or between IBM IMS and DB2, you must have a license for the BMC Subsystem Optimizer for DB2 product.

Subzero supports DB2 Version 10.1 and later . For the latest information about the compatibility of Subzero with a specific release of DB2, use the BMC Solution and Product Availability and Compatibility Utility on the BMC Support Central website (http://www.bmc.com/support).

Subzero supports the following types of application program calls to DB2 databases:

  • Structured Query Language (SQL)

    Subzero supports all SQL calls that are normally available within the application execution environment (such as CICS).

  • Instrumentation Facility Interface (IFI)

    Subzero supports most IFI calls—including COMMAND, WRITE, and READS (synchronous read)—that are normally available within the application execution environment (such as CICS).

    Subzero does not support READA (asynchronous read) because this call requires the application to issue a z/OS WAIT request. CICS application programs must avoid WAIT requests.

Note

If you are using the DB2 group attach facility to define the connection between CICS and DB2, you can specify the defined DB2 group ID in a Subzero option set. The group ID is valid for the original (source) subsystem, the target (remote) subsystem, or both.

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*