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