View previous topic :: View next topic
|
Author |
Message |
vinuk2009
New User
Joined: 30 Apr 2009 Posts: 19 Location: chennai
|
|
|
|
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 |
|
|
expat
Global Moderator
Joined: 14 Mar 2007 Posts: 8797 Location: Welsh Wales
|
|
|
|
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 |
|
|
vinuk2009
New User
Joined: 30 Apr 2009 Posts: 19 Location: chennai
|
|
|
|
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 |
|
|
expat
Global Moderator
Joined: 14 Mar 2007 Posts: 8797 Location: Welsh Wales
|
|
|
|
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 |
|
|
vinuk2009
New User
Joined: 30 Apr 2009 Posts: 19 Location: chennai
|
|
|
|
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 |
|
|
Bill Woodger
Moderator Emeritus
Joined: 09 Mar 2011 Posts: 7309 Location: Inside the Matrix
|
|
|
|
You should be able to find any additional messages produced, and supply those. Or did you check that already? |
|
Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007 Posts: 10872 Location: italy
|
|
Back to top |
|
|
|