Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

DB2 SPUFI error

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
vinuk2009

New User


Joined: 30 Apr 2009
Posts: 19
Location: chennai

PostPosted: Fri Nov 11, 2011 12:18 pm    Post subject: DB2 SPUFI error
Reply with quote

Hi,

I am getting follow SPUFI error. Could some one please advise me how to resolve this issue?

DSNE004E PROBABLE SUBSYSTEM ERROR DETECTED IN CSECT DSNECP13, SUBSYSTEM FUNCTIO
N CREATE THREAD, RETCODE X'0000004E', REASON CODE X'00C50104'
IEA995I SYMPTOM DUMP OUTPUT
SYSTEM COMPLETION CODE=04E
TIME=01.40.31 SEQ=00429 CPU=0000 ASID=01D2
PSW AT TIME OF ERROR 078D1000 8014C794 ILC 2 INTC 0D
ACTIVE LOAD MODULE ADDRESS=00118000 OFFSET=00034794
NAME=DSNECP10
DATA AT PSW 0014C78E - 00181610 0A0D9180 C0A4A784
GR 0: 80000000 1: 8004E000
2: 00114C11 3: 00117946
4: 00114B94 5: 00C50104
6: 00114A78 7: 00114B98
8: 00000008 9: 00114D40
A: 0000004E B: 8014C3E0
C: 00100360 D: 00100360
E: 8014C776 F: 00C50104
END OF SYMPTOM DUMP
Abend 04E000 hex occurred processing command 'DSN '.
Back to top
View user's profile Send private message

expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8593
Location: Back in jolly old England

PostPosted: Fri Nov 11, 2011 12:48 pm    Post subject:
Reply with quote

Basic questions .........................

What documentation have you referred to for this error, what did you find, and what problems do you have with following the suggestions made in said documentation.

Tell us what you have researched already for yourself so that others do not waste their time doing the same.
Show us that you have tried something other than just post on the forum.
Back to top
View user's profile Send private message
vinuk2009

New User


Joined: 30 Apr 2009
Posts: 19
Location: chennai

PostPosted: Fri Nov 11, 2011 1:16 pm    Post subject: Reply to: DB2 SPUFI error
Reply with quote

Hi Expat,

I saw the DB2 documentation and it is saying below. It seems this explanation is saying for COBOL/DB2 program. But I am not sure how it relate to SPUFI. Please advise.

Explanation: When the system detects an error in internal IBM DATABASE 2
(DB2¦) processing, it will abnormally end a connected user task (TCB) or
one of its own internal tasks. For information about the reason codes
associated with this abend code, see DB2 Messages and Codes.

System Action: The system abnormally ends the connected user task or the
DB2 internal task.

Application Programmer Response: Check register 15 of the SDWA section
'General Purpose Registers at Time of Error', and locate the accompanying
reason code. In addition, check the information displayed at the user's
terminal, and in the corresponding logrec data set entry.

System Programmer Response: If the error recurs and the program is not in
error, look at the messages in the job log for more information. Search
problem reporting data bases for a fix for the problem. If no fix exists,
contact the IBM Support Center. Provide the SYSOUT output for the job and
the logrec data set error record.
Back to top
View user's profile Send private message
expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8593
Location: Back in jolly old England

PostPosted: Fri Nov 11, 2011 1:29 pm    Post subject:
Reply with quote

Always a good starting point is to post the JCL that was submitted and the output with any messages and codes that were issued
Back to top
View user's profile Send private message
vinuk2009

New User


Joined: 30 Apr 2009
Posts: 19
Location: chennai

PostPosted: Fri Nov 11, 2011 2:01 pm    Post subject: Reply to: DB2 SPUFI error
Reply with quote

Hi Expat,

My issue is related to DB2 SPUFI tool and not related to application program.I am getting this error while executing query in SPUFI and not in DB2 program. So I have only choice to show the error message. If I have any job details I would have pasted in my first post itself. I am sorry about this.
Back to top
View user's profile Send private message
Bill Woodger

DFSORT Moderator


Joined: 09 Mar 2011
Posts: 7307

PostPosted: Fri Nov 11, 2011 2:17 pm    Post subject: Reply to: DB2 SPUFI error
Reply with quote

You should be able to find any additional messages produced, and supply those. Or did you check that already?
Back to top
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10232
Location: italy

PostPosted: Fri Nov 11, 2011 2:36 pm    Post subject: Reply to: DB2 SPUFI error
Reply with quote

googling for 00C50104 , quickest way around, will return quite a few hits ( pointing to the IBM manuals )
here one of them
http://publib.boulder.ibm.com/infocenter/dzichelp/v2r2/index.jsp?topic=%2Fcom.ibm.db2z10.doc.codes%2Fsrc%2Ftpc%2F00c50104.htm
where it tells what to do
fortunately/unfortunately we do not belong to Your organization
so You are on Your own to carry the actions suggested by the manuals

PS.
sadly there might not be too many additional messsages !
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts IDC2902I Error tzeche ABENDS & Debugging 1 Tue Mar 28, 2017 11:39 am
No new posts Need help with below DB2 error ashek15 DB2 3 Sat Mar 18, 2017 5:56 am
No new posts FINDREP Syntax Error seahawk789 DFSORT/ICETOOL 4 Thu Mar 09, 2017 10:11 pm
No new posts INVOKE WEBSERVICE error danik56 CICS 11 Thu Mar 09, 2017 11:52 am
No new posts SPUFI -- Joining 3 tables – data in... Sysaron DB2 2 Wed Mar 08, 2017 4:18 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us