Release Notes

25.1 Support for Java Stored Procedures for z/OS or OS/390

In FixPak 7, the following enhancements were added to the Stored Procedure Builder for building interpreted Java stored procedures for DB2 for z/OS or OS/390, Version 7:

• Actual Cost support
• Enhanced error message handling
• Enablement of LINUX/390 servers
• Support for the @ sign in a stored procedure schema name

Compiled Java stored procedures are not supported in any version of z/OS or OS/390 and cannot be created using the Stored Procedure Builder. This is true for all versions of DB2.

Requirements:

• For prerequisites and setup tasks on DB2 for z/OS or OS/390, see APAR PQ52329.
• The Collection ID must match the one used when binding the JDBC driver on z/OS or OS/390.
• Modify the DB2SPB.ini file to include the following entries:

  SPOPTION_WLM_JAVA_ENVIRONMENT = WLMENVJ  
  SPOPTION_JAVAPROC_BUILDER = SYSPROC.DSNTJSPP 
  SPOPTION_BIND_OPTIONS_JAVA = ACT(REP)
  SPOPTION_COLLIDJ = DSNJDBC
  

To create a Java stored procedure for z/OS or OS/390 using the Stored Procedure Builder:

1. Open the Inserting Java Stored Procedure wizard:
   1. Under a z/OS or OS/390 database connection in the project tree, right-click the stored procedures folder.
   2. Click Insert -> Java Stored Procedure Using Wizard. The wizard opens.
2. Complete the wizard, specifying the z/OS or OS/390 options:
   • The Collection ID must match what was specified on the BIND PACKAGE(collid) when the JDBC drivers were bound on z/OS or OS/390.
   • The default for the Java Package is the procedure name, but you can modify this to any name.
3. Click OK. The stored procedure is created and listed in the project tree.
4. Right-click the stored procedure and click Build.