MVSFORUMS.com Forum Index MVSFORUMS.com
A Community of and for MVS Professionals
 
 FAQFAQ   SearchSearch   Quick Manuals   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Run Time Abend when Running DB2 Stored Procedure

 
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> Problem Determination
View previous topic :: View next topic  
Author Message
arvibala
Beginner


Joined: 12 Feb 2008
Posts: 142
Topics: 67

PostPosted: Wed Oct 13, 2010 1:53 am    Post subject: Run Time Abend when Running DB2 Stored Procedure Reply with quote

Hi,

I have a DB2 Stored Procedure, STORPROC. I compiled and did a Bind.
A Program STORPGM1 which called this SP and I have compiled and did a Bind too.

It was working fine. But suddenly when I made change to SP, I am getting below error when I run.

SYSOUT
Code:

IGZ0153S Program STTBD110 was compiled with a level of the compiler that require
         Environment.                                                           
         The traceback information could not be determined.                     


SYSTSPRT
Code:

ACF0C038 ACF2 LOGONID ATTRIBUTES HAVE REPLACED DEFAULT USER ATTRIBUTES     
READY                                                                     
  DSNECP00 SYSTEM(DBB0)                                                   
DSNECP00                                                                   
  RUN  PROGRAM(STTBD110) PLAN(SKPBXFER)                                   
DSNECP00 ENDED DUE TO ERROR+                                               
USER ABEND CODE 4038  REASON CODE 0000001                                 


Can someone guide me here?
_________________
Arvind
"You can make a difference with your smile. Have that with you always"
Back to top
View user's profile Send private message Yahoo Messenger
Anuj Dhawan
Intermediate


Joined: 19 Jul 2007
Posts: 298
Topics: 7
Location: Mumbai,India

PostPosted: Wed Oct 13, 2010 4:11 am    Post subject: Re: Run Time Abend when Running DB2 Stored Procedure Reply with quote

arvibala wrote:
But suddenly when I made change to SP, I am getting below error when I run.
So do you bind it again, then?
_________________
Regards,
Anuj
Back to top
View user's profile Send private message
arvibala
Beginner


Joined: 12 Feb 2008
Posts: 142
Topics: 67

PostPosted: Wed Oct 13, 2010 6:33 am    Post subject: Reply with quote

Yes .. I did ....
_________________
Arvind
"You can make a difference with your smile. Have that with you always"
Back to top
View user's profile Send private message Yahoo Messenger
kolusu
Site Admin
Site Admin


Joined: 26 Nov 2002
Posts: 12354
Topics: 75
Location: San Jose

PostPosted: Wed Oct 13, 2010 10:18 am    Post subject: Reply with quote

arvibala,

Check this APAR

http://www.ibm.com/support/docview.wss?rs=2231&context=SS6SG3&dc=DB550&uid=isg1PK90754&loc=en_US&cs=UTF-8&lang=en&rss=ct2231rational

Kolusu
Back to top
View user's profile Send private message Send e-mail Visit poster's website
Display posts from previous:   
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> Problem Determination All times are GMT - 5 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


MVSFORUMS
Powered by phpBB © 2001, 2005 phpBB Group