Prerequisites for developing routines that target DB2 for z/OS

You must install and configure the necessary prerequisites before you can develop routines that target DB2® for z/OS®. In addition to the server-specific prerequisites described in this section, you must also complete general routine prerequisites.

About this task

For detailed information about setup requirements for developing DB2 for z/OS routines, see the Redbook DB2 9 for z/OS Stored Procedures: Through the CALL and Beyond at http://www.redbooks.ibm.com/abstracts/sg247604.html?Open

For tips on using the workbench to develop DB2 for z/OS stored procedures, refer to the IBM® developerWorks® article Get your DB2 for z/OS system ready for Developer Workbench V9.2 at http://www.ibm.com/developerworks/db2/library/techarticle/dm-0705scanlon/

To build external SQL stored procedures for DB2 for z/OS, you must install and configure a C compiler on the server. For more information, see the IBM DB2 Application Development Guide.

Running DB2 for z/OS Java™ stored procedures using JDK 1.4.2

The default native HEAP size for JVM 1.42 is not sufficient for debugging Java stored procedures. If you are using JDK 1.4.2, you must increase to HEAP(8M,2M,ANYWHERE,KEEP). For example:

MSGFILE(JSPDEBUG,,,,ENQ), 
XPLINK(ON), 
HEAP(8M,2M,ANYWHERE,KEEP),
ENVAR("_CEE_ENVFILE=/u/oeusr05/CEEOPTIONS.txt")

Do not put the HEAP setting in the CEEOPTIONS.txt file. This step is not required if you are using JDK 1.5.

What to do next

You can perform a check of the stored procedures, packages, and Java version that are required for routine development. From a data development project for a DB2 z/OS data server, right-click the project and click Data Server Configuration. The Data Server Configuration window displays data server configuration information for routine development.

Feedback