Database support

Optim™ Designer provides support for multiple database management systems.

For a complete list of supported databases, see the detailed system requirements.

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 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.


Feedback