Hi , Online application process abend due to an error in stored procedure and the application get freeze based on one of our developers. The application program access subysstem1 (LAPR1) and call the stored procedure to run some SQL in subsystem2(LPAR2). I need to identify the failing Stored procedure/s . I can see error messages in Master address space on subsystem1(Error -ABNORMAL EOT IN PROGRESS FOR USER=user1) and Distributed address space on Subsystem2 ( Error - USER=user1 LOGON/JOB INITIATION - INACTIVE USER HAS BEEN REVOKED ).
Can you give me a generic direction to indetify this stored procedure which I guess may or may not be the cause. I would expect if Stored procedure failed there is some error message in the Stored procedure address space. Is my assumption correct ? I need to establish this within DB2 and no access to the source code.
I have access to DB2 admin tool and OMegamon. Thanks for the help.