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.

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.

Related concepts
Creating stored procedures
Creating user-defined functions (UDFs)
Preparing to develop routines
Related tasks
Developing database routines
Prerequisites for developing Java stored procedures
Prerequisites for developing routines on Linux

Feedback