Page 1 of 1

Stored Procedure

PostPosted: Wed Mar 16, 2011 9:24 pm
by p19689
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.

Re: Stored Procedure

PostPosted: Fri Mar 18, 2011 11:36 pm
by stoked
It looks like your security mechanism on LPAR2 rejected the request before the stored proc was even invoked.