Database support

Optim™ Designer provides support for multiple database management systems.

Optim Designer supports JDBC connections for the following databases:

Optim Designer supports native data source connections for the following databases:

DB2 Prerequisites
To allow Optim to obtain full JDBC metadata from an instance of DB2 z/OS, the DESCSTAT value in ZPARMS must be set to YES. Also, you must run job DSNTIJMS in order to install the stored procedures needed by JDBC, bind the necessary packages, and set security permissions. In addition, workload manager (WLM) definitions are needed to ensure that the WLM can start the stored procedure address space when requested by DB2.