IBM Mainframe Forum

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.

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

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.

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.

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.

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.

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

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.

But isn't CEE3250C a generic error message meaning only "a system or user abend occurred"?

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.