Optim™ Designer provides
support for multiple database management systems.
Optim Designer
supports JDBC connections for the following databases:
- DB2® for z/OS® V8.1, V9.1, V10.1
- DB2 for Linux, UNIX,
and Windows V8.2, V9.1, V9.5,
V9.7
- DB2 for i V5.4
- Informix® V10
- Microsoft SQL Server
2005, 2008
- Oracle V10.2, V11, V11.2
- Sybase V12.5, V15
- Teradata V2.6, V12, V13
Optim Designer supports
native data source connections for the following databases:
- DB2 for Linux, UNIX,
and Windows V9.1, V9.5
- IBM® DB2 for z/OS V9.1
- IBM Informix V11.5
- Oracle V10.2
- 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.