Stored Procedure



IBM's flagship relational database management system

Stored Procedure

Postby p19689 » Wed Mar 16, 2011 9:24 pm

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.
p19689
 
Posts: 65
Joined: Fri Oct 01, 2010 1:13 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Stored Procedure

 

Re: Stored Procedure

Postby stoked » Fri Mar 18, 2011 11:36 pm

It looks like your security mechanism on LPAR2 rejected the request before the stored proc was even invoked.
stoked
 
Posts: 11
Joined: Thu Mar 17, 2011 4:15 am
Location: Vancouver, BC
Has thanked: 0 time
Been thanked: 0 time


Return to DB2

 


  • Related topics
    Replies
    Views
    Last post