Debugging stored procedures on mainframe

[aaadb2]

Hello,

Are there tools for debugging stored procedures
running on mainframe? I am getting an SQL code -430
on EXEC SQL CALL, but manuals refer to it in a very
vague description.

Thanks

 

[sathyarams]

I suppose, you can use SQL Stored Procedure Builder if you have access to db2 via db2 connect

Thanks

Sathyaram

For db2 resoruces visit

http://www.db2click.com

More DB2 questions answered at

http://www.dbforums.com/f8

 

[aaadb2]

Thank you Sathyarams. Is SQL SP Builder available for OS/390
(mainframe)?

 

[pkganapathi]

aaadb2,

Have you checked the logs or the WLM/SPAS started tasks for any type of entries?

-PK.Ganapathy
DB2 DBA
TCS

 

[aaadb2]

Thank you PK. I am working with DBAs on setting up
the MSGFILE log

 

[KLVIS11]

One tool for debugging DB2 stored procedures on the mainframe is XPEDITER which is a product of COMPUWARE.

Stephan