Preparing your environment to debug Db2 stored procedures

The Db2® administrator must define the address space where the stored procedure runs. This can be a Db2 address space or a workload management (WLM) address space. This address space is assigned a name which is used to define the stored procedure to Db2. In the JCL for the Db2 or WLM address space, verify that the following data sets are defined in the STEPLIB concatenation and have the appropriate RACF® Read authorization for programs to access them:

  • LOADLIB for the stored procedure
  • SEQAMOD1 for z/OS Debugger
  • SCEERUN2 for Language Environment

After updating the JCL, the Db2 administrator must refresh the Db2 or WLM address space so that these updates take effect.

Refer to the following topics for more information related to the material discussed in this topic.

  • Related references
  • DB2® UDB for z/OS Application Programming and SQL Guide
1 Add hlq.SEQAMOD to STEPLIB only if it is not already in the system search path (for example, link list). If you create a custom EQAOPTS (as described in EQAOPTS commands) that is not stored in hlq.SEQAMOD, then place the data set containing it in STEPLIB (ahead of hlq.SEQAMOD if it is in STEPLIB). hlq.SEQAMOD must be placed before any other library in the STEPLIB that contains CEEEVDBG for z/OS® Debugger to get control of a debug session.
2 Add CEE.SCEERUN to STEPLIB only if it is not already in the system search path (for example, link list). If you create a private copy of the z/OS Debugger Language Environment® user exit for Db2 that is linked into CEEPIPI (as described in Specifying the TEST runtime options through the Language Environment user exit), then place the data set containing it in STEPLIB (ahead of CEE.SCEERUN if it is in STEPLIB).