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