If you encounter problems setting up, calling, or running stored procedures, several
troubleshooting techniques and tools are available in Db2 and z/OS®.
Procedure
To troubleshoot Db2 stored
procedures, perform one or more of the following actions:
-
For general information about the available debugging tools and techniques, see Debugging stored procedures.
- See
Db2 for z/OS Stored Procedures:
Through the CALL and Beyond (IBM Redbooks) if you are troubleshooting one of the following problems:
- For problems with implementing RRS, see
RRS error samples.
- For problems with calling a particular stored procedure, you might not have the required
authorizations. See
Privileges to execute a stored procedure called statically.
- For troubleshootingJava™ stored procedures, see
Common
problems.
- For invoking programs that receive SQLCODE -430, see
Classical debugging of stored
procedures.