S04E ERROR



IBM's flagship relational database management system

S04E ERROR

Postby mukerjr » Thu Dec 04, 2008 5:16 pm

WHENEVER I AM TRYING TO LOAD MY TABLE ITS SHOWING S04E ERROR .IN SPOOL I AM GETTING

UTILITY DATA BASE SERVICES MEMORY EXECUTION ABENDED, RESON=X'00E40305'
I FOUND THAT MY TABLE AND ITS ASSOCIATED INDEX WERE IN RECP AND REBUILD PENDING STATUS.SO I REMOVED THE PENDING STATUS AND SUBMITTED THE JOB AGAIN BUT AGAIN IT IS SHOWING THE SAME S04E ERROR.
ALSO BEFORE SUBMITTING THE JOB AGAIN I ENDED THE EARLIER UTILITY BEFORE SUBMITTING THE JOB .
PLEASE CAN ANYONE HELP ME OUT IN THIS MATTER

IN THE SPOOL I AM GETTING THE FOLLOWING ERROR
DSNUGUTC - OUTPUT START FOR UTILITY, UTILID = LOADKMP
DSNUGUTC - LOAD DATA INDDN SYSREC LOG NO REPLACE NOCOPYPEND REUSE SORTKEYS EBCDIC CCSID(37, 0, 0)
DSNURWI - INTO TABLE "DBDJ"."CAS.DED "
DSNURWI - ("REASON_CD " POSITION(3:4) SMALLINT,
DSNURWI - "REASON_DESC " POSITION(6:57) VARCHAR NULLIF(5)=X'FF'
DSNURWI - "CATEGORY_CD " POSITION(59:60) CHAR(2) NULLIF(58)=X'FF'
DSNURWI - "CONCERN_CD " POSITION(62:63) CHAR(2) NULLIF(61))=X'FF'
DSNURWI - "MAJ_COMPONENT_CD " POSITION(65:66) CHAR(2) NULLIF(64))=X'FF'
DSNURWI - "STATUS_CD " POSITION(68:68) CHAR(1) NULLIF(67))=X'FF'
DSNURWI - "SUB_CATEGORY_CD " POSITION(70:73) INTEGER NULLIF(69))=X'FF'
DSNURWI - "SYMPTOM_CD " POSITION(75:76) CHAR(2) NULLIF(74))=X'FF'
DSNURWI - "CLOSE_FLG " POSITION(78:78) CHAR(1) NULLIF(77))=X'FF'
DSNURWI - "LAST_UPDATE_ID " POSITION(80:87) CHAR(8) NULLIF(79))=X'FF'
DSNURWI - "LAST_UPDATE_DATE " POSITION(89:98) DATE EXTERNAL NULL
DSNUGBAC - UTILITY DATA BASE SERVICES MEMORY EXECUTION ABENDED, REASON=X'00E40305'
mukerjr
 
Posts: 6
Joined: Thu Nov 27, 2008 1:16 pm
Has thanked: 0 time
Been thanked: 0 time

Re: S04E ERROR

Postby dick scherrer » Thu Dec 04, 2008 11:00 pm

Hello and welcome to the forum,

First - TURN OFF YOUR CAPS. . .

If is likely that there is additonal diagnostic info presented - you need to post all of the diagnostic info including any message id's.

It may help if you post the jcl and control statements you submitted also.
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6268
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 93 times


Return to DB2

 


  • Related topics
    Replies
    Views
    Last post