DB2 V9.1 S04E R=00D91044 issue



IBM's flagship relational database management system

DB2 V9.1 S04E R=00D91044 issue

Postby yang li » Thu Apr 07, 2011 8:09 am

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.
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

 

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

Postby steve-myers » Thu Apr 07, 2011 8:43 am

You are going to have to learn how to find the manuals on your own. I start with this link. By itself, this link is of little value; it brings up a humongous web page with just about every manual bookshelf you can imagine. At the top is a box with this title: "Find shelves with titles or names containing:" Type something that may be related to your need, like DB2, and click on the Find box at the right. This will bring up a smaller page that just has bookshelves with DB2 in the title. Scroll down this page until you find a bookshelf title that looks promising, say "DB2 Version 9.1 for z/OS Bookshelf" and click on it. This will bring up a page that shows all the manuals. Near the top of the page is a box labeled "Search Documents." Click on this box, and you will get a page where you can enter a search argument. I tried, 00D91044, but that came back with no matches, so I then tried 04e, which came back with 7 manuals had this code. That should get you started.

People that lurk here know I often provide a direct link to a manual in my answers. To get this link, I just do what I described above, varied to the needs of the question. I can often skip the search documents step since I often know the manual title I need, and just select the title directly, though some of the bookshelves are large enough that finding the manual is often difficult
steve-myers
Global moderator
 
Posts: 1885
Joined: Thu Jun 03, 2010 6:21 pm
Has thanked: 4 times
Been thanked: 197 times

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

Postby yang li » Thu Apr 07, 2011 9:07 am

Hi Steve, Thanks for your quick reply. The link is really good and useful for trouble shooting.
Before I posted question here, I researched a lot of DB2 manuals but not found any clue for the reason code 00D91044.
So I hope meet some DB2 experts here to indicate the meaning of the code 00D91044.
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 NicC » Thu Apr 07, 2011 11:29 am

if it is not in the manual - tell IBM so that they can correct the omission (and give you the help required). Each manual tends to have a readers comment form that you can print off, fill in, and mail - but there is probably an online feedback facility. And if you feel unsure about doing this because you think you may have missed a manual: do it anyway as it shows them that they may need to make the info more easily available.
The problem I have is that people can explain things quickly but I can only comprehend slowly.
Regards
Nic
NicC
Global moderator
 
Posts: 2690
Joined: Sun Jul 04, 2010 12:13 am
Location: Pushing up the daisys (almost)
Has thanked: 4 times
Been thanked: 105 times

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

Postby BillyBoyo » Thu Apr 07, 2011 12:17 pm

That doesn't look like a "normal" sort of reason code. If there were that many reasons for a failure, you'd need a warehouse of manuals to look them up.

It looks like an address. May be a clue, I don't know. A quick "google" (but only quick) has only introduced confusion. Maybe you have not enough virtual memory. Maybe something else. Check closely for any other messages.
BillyBoyo
Global moderator
 
Posts: 3804
Joined: Tue Jan 25, 2011 12:02 am
Has thanked: 22 times
Been thanked: 264 times

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

Postby Akatsukami » Thu Apr 07, 2011 3:09 pm

The reason code on a S04E abend is the DB2 reason code, IIRC. However, X'00D91044' does not appear to be a legitimate reason code; I can find no reference to it.
"You have sat too long for any good you have been doing lately ... Depart, I say; and let us have done with you. In the name of God, go!" -- what I say to a junior programmer at least once a day
User avatar
Akatsukami
Global moderator
 
Posts: 1053
Joined: Sat Oct 16, 2010 2:31 am
Location: Bloomington, IL
Has thanked: 6 times
Been thanked: 51 times

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

Postby DFSHDC40 » Fri Apr 08, 2011 4:41 am

No 00D91nnn codes in my manuals - as has been suggested you should call it in to IBM
There are hits to Info APARs II11753 and II10902 but they are quite old [so you would expect the code to be in the current manual ] ...time to talk to the vendor
If the code hasn't been changed, why is the LKED date today?
User avatar
DFSHDC40
 
Posts: 41
Joined: Sat Oct 16, 2010 4:16 pm
Location: IMS.SDFSRESL
Has thanked: 0 time
Been thanked: 0 time

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

Postby NicC » Fri Apr 08, 2011 10:38 am

For everyone's info...
This is a duplicate post - it is also on the 'Experts' forum. There it has been diagnosed as a LE problem. CEE... messages are LE.
OP - do not duplicate post until there has been no conclusion reached on the other post.
The problem I have is that people can explain things quickly but I can only comprehend slowly.
Regards
Nic
NicC
Global moderator
 
Posts: 2690
Joined: Sun Jul 04, 2010 12:13 am
Location: Pushing up the daisys (almost)
Has thanked: 4 times
Been thanked: 105 times

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

Postby Akatsukami » Fri Apr 08, 2011 4:07 pm

But isn't CEE3250C a generic error message meaning only "a system or user abend occurred"?
"You have sat too long for any good you have been doing lately ... Depart, I say; and let us have done with you. In the name of God, go!" -- what I say to a junior programmer at least once a day
User avatar
Akatsukami
Global moderator
 
Posts: 1053
Joined: Sat Oct 16, 2010 2:31 am
Location: Bloomington, IL
Has thanked: 6 times
Been thanked: 51 times

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

Postby NicC » Fri Apr 08, 2011 6:59 pm

Could mean that the relevant LE library is not allocated as the code works under Data Studio so it is probably a difference in setup.
The problem I have is that people can explain things quickly but I can only comprehend slowly.
Regards
Nic
NicC
Global moderator
 
Posts: 2690
Joined: Sun Jul 04, 2010 12:13 am
Location: Pushing up the daisys (almost)
Has thanked: 4 times
Been thanked: 105 times

Next

Return to DB2

 


  • Related topics
    Replies
    Views
    Last post