DB2 V9.1 S04E R=00D91044 issue



IBM's flagship relational database management system

Re: DB2 V9.1 S04E R=00D91044 issue

Postby yang li » Tue Apr 12, 2011 2:39 pm

yang li wrote:I called the stored procedures from the batch job and got the error as below:

Error msg form sysout:(DB2 version is V9.1)
CEE3250C The system or user abend S04E R=00D91044 was issued.
From compile unit EH65503 at entry point SSCCOBL at compile unit offset +0000811E at entry offset +00003E04
at address 24E08D5E.


But it works when using IBM Data Studio Tool to call the stored procedure.
The function of stored procedure are insert table A and update table B.

Does anyone know what the error or reason code means? Thanks.


More detail info about the issue:
Process logic: cobol pgm call SP1, SP1 call SP2. (SP means stored procedure)
Both SP are native SP.
SP1( ....
open cursor c1;
fetch cursor c1;
while(found='Y') do
insert table A;
set cnt = cnt + 1;
if (cnt= 100) then--commit count 100
call SP2;
commit;
set cnt = 0;
end-if;
fetch cursor c1; -- end of cursor set found = N
if(found='N') then
call SP2;
commit;
set cnt = 0;
end-if;
end while;
....)

SP2 (...
insert table c; --- no commit in SP2
update table d;
...)

After debug, found :
1. If only call SP2 one or 2 time, it runs successfully .
2. If call SP2 more than 2 times, it will get S04E R=00D91044 error.
Best regards
yang li
 
Posts: 10
Joined: Thu Apr 07, 2011 7:54 am
Has thanked: 0 time
Been thanked: 0 time

Re: DB2 V9.1 S04E R=00D91044 issue

Postby GuyC » Tue Apr 12, 2011 9:09 pm

I think someone needs to open a PMR at IBM.
GuyC
 
Posts: 315
Joined: Tue Aug 11, 2009 3:23 pm
Has thanked: 1 time
Been thanked: 4 times

Re: DB2 V9.1 S04E R=00D91044 issue

Postby yang li » Wed Apr 13, 2011 2:22 pm

GuyC wrote:I think someone needs to open a PMR at IBM.


PMR is opened, waitting response.
Thanks.
Best regards
yang li
 
Posts: 10
Joined: Thu Apr 07, 2011 7:54 am
Has thanked: 0 time
Been thanked: 0 time

Re: DB2 V9.1 S04E R=00D91044 issue

Postby yang li » Thu Jun 30, 2011 1:09 pm

yang li wrote:
GuyC wrote:I think someone needs to open a PMR at IBM.


PMR is opened, waitting response.
Thanks.


Just updated, This DB2 bug has been fixed by IBM.

Thanks
Yang
Best regards
yang li
 
Posts: 10
Joined: Thu Apr 07, 2011 7:54 am
Has thanked: 0 time
Been thanked: 0 time

Re: DB2 V9.1 S04E R=00D91044 issue

Postby dick scherrer » Fri Jul 01, 2011 12:06 am

Good to hear this is working - thank you for letting us know :)

d
User avatar
dick scherrer
Global moderator
 
Posts: 6268
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 93 times

Previous

Return to DB2

 


  • Related topics
    Replies
    Views
    Last post