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