Collecting data for stored procedure problems

If Db2 returns SQLCODE -440, collect data for diagnosing stored procedure not found conditions.

Before you begin

To diagnose performance problems, you must have the appropriate authorization to collect data from different z/OS® components.

Procedure

Collect the following data to diagnose stored procedure problems:
  • A detailed problem description which includes:
    • A description of the stored procedure with a list of source code programming languages
    • A copy of source code of the stored procedure
  • The CREATE PROCEDURE SQL statement
  • The WLM PROC startup JCL
  • For SQLCODE -440 errors, include:
    • The value of CURRENT PATH special register
    • The BIND PACKAGE command for the stored procedure
    • The data types of parameters from the CALL statement to the stored procedure