Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
Error 00E40045 in Loading data

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

New User


Joined: 11 Mar 2010
Posts: 59
Location: China,Shanghai

PostPosted: Thu Jun 09, 2011 10:45 am    Post subject: Error 00E40045 in Loading data
Reply with quote

My load job shows this error:

DSNU348I -DSTA DSNURBXA - BUILD PHASE STATISTICS - NUMBER OF KEYS=68809 FOR IN DSTA.SIBATCH1 PART 6
DSNU348I -DSTA DSNURBXA - BUILD PHASE STATISTICS - NUMBER OF KEYS=69300 FOR IN DSTA.SIBATCH2 PART 6
DSNU348I -DSTA DSNURBXA - BUILD PHASE STATISTICS - NUMBER OF KEYS=69300 FOR IN DSTA.SIBATCH3 PART 6
DSNU348I -DSTA DSNURBXA - BUILD PHASE STATISTICS - NUMBER OF KEYS=69300 FOR IN DSTA.SIBATCH4 PART 6
DSNU348I -DSTA DSNURBXA - BUILD PHASE STATISTICS - NUMBER OF KEYS=69300 FOR IN DSTA.SIBATCH5 PART 6
DSNU258I DSNURBXD - BUILD PHASE STATISTICS - NUMBER OF INDEXES=5
DSNU343I DSNURBXD - BUILD PHASE STATISTICS - 491 DUPLICATE KEY ERRORS ENCOUN
DSNU259I DSNURBXD - BUILD PHASE COMPLETE, ELAPSED TIME=00:00:10
DSNU355I DSNURVIX - INDEXVAL PHASE STATISTICS - 491 DUPLICATE KEY ERRORS OR
491 DATA ROWS
DSNU356I DSNURVIX - INDEXVAL PHASE COMPLETE, ELAPSED TIME=00:00:01
DSNU016I DSNUGBAC - UTILITY BATCH MEMORY EXECUTION ABENDED, REASON=X'00E40045'

The load jcl is:

//LDBATCH EXEC DSNUPROC,PARM='DSTA,LDBATCHP',COND=(4,LT)
//STEPLIB DD DSN=DSN810.SDSNLOAD,DISP=SHR
//LOCK DD DSN=TBSM03.LOCK,DISP=OLD
//DSNTRACE DD SYSOUT=*
//SORTLIB DD DSN=SYS1.SORTLIB,DISP=SHR
//SORTOUT DD UNIT=3390,SPACE=(CYL,(50,20),,,ROUND)
//SYSMAP DD UNIT=3390,SPACE=(CYL,(50,20),,,ROUND)
//SORTWK01 DD UNIT=3390,SPACE=(CYL,(50,20),,,ROUND)
//SORTWK02 DD UNIT=3390,SPACE=(CYL,(50,20),,,ROUND)
//SORTWK03 DD UNIT=3390,SPACE=(CYL,(50,20),,,ROUND)
//SORTWK04 DD UNIT=3390,SPACE=(CYL,(50,20),,,ROUND)
//SYSUT1 DD UNIT=3390,SPACE=(CYL,(50,20),,,ROUND)
//DISCARD DD DSN=DSTAAPPL.PLEXP1.LOAD.DISCARD,DISP=SHR
//SYSERR DD DSN=DSTAAPPL.PLEXP1.LOAD.SYSERR,DISP=SHR
//SYSREC00 DD DSN=DSTAAPPL.PLEXP1.RMF.BATCH.DATA,DISP=SHR
//SYSIN DD *
LOAD DATA RESUME YES LOG NO INDDN SYSREC00 NOCOPYPEND
DISCARDDN(DISCARD) INTO TABLE
DSTA.STBATCH(
FLAG POSITION(1) CHAR(3) ,
JOBNAME POSITION(5) CHAR(8) ,
JOBNUMBER POSITION(14) CHAR(8) ,
SYSID POSITION(23) CHAR(4) ,
JOBSTP POSITION(28) CHAR(8) ,
PRGMNAME POSITION(37) CHAR(8) ,
STTIMESTAMP POSITION(46) TIMESTAMP EXTERNAL(19) ,
EDTIMESTAMP POSITION(66) TIMESTAMP EXTERNAL(19) ,
STDATE POSITION(86) DATE EXTERNAL(10),
STTIME POSITION(97) TIME EXTERNAL(8),
EDDATE POSITION(106) DATE EXTERNAL(10),
EDTIME POSITION(117) TIME EXTERNAL(8),
ELAPSEDTIME POSITION(126) DECIMAL EXTERNAL(8,2),
RCCODE POSITION(135) CHAR(5) ,
USERID POSITION(141) CHAR(8) ,
EXCPSS POSITION(150) DECIMAL EXTERNAL(12,0),
CPUPE POSITION(163) DECIMAL EXTERNAL(3,0),
SERUNIT POSITION(167) DECIMAL EXTERNAL(12,0))
/*

It seems that a failure has occurred during an attempt to free SORT storage after load.Can someone say the reason about this problem?
Back to top
View user's profile Send private message

dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Thu Jun 09, 2011 7:34 pm    Post subject:
Reply with quote

Hello,

Fix the duplicates and try again. . . ?
Back to top
View user's profile Send private message
Victor Niu

New User


Joined: 11 Mar 2010
Posts: 59
Location: China,Shanghai

PostPosted: Thu Jun 09, 2011 7:37 pm    Post subject:
Reply with quote

load again,the result is fine.

Hope to know the reason,the similar error occurs several times...
Back to top
View user's profile Send private message
Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 8281
Location: Dubuque, Iowa, USA

PostPosted: Thu Jun 09, 2011 7:49 pm    Post subject:
Reply with quote

APAR PK58910?
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Thu Jun 09, 2011 8:51 pm    Post subject:
Reply with quote

Hello,

Has the error ever happened when there were NO duplicates?
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 Error executing Java program in OSGI ... danik56 CICS 0 Thu Apr 26, 2018 12:16 am
No new posts 3270 Data stream error Benchwarmer CICS 6 Tue Apr 17, 2018 12:06 am
No new posts How to list data set names with diffe... murali.andaluri CLIST & REXX 8 Thu Apr 12, 2018 11:33 pm
No new posts VSAM file NOT Found error while proce... SumaReva CICS 5 Wed Apr 11, 2018 9:54 pm
No new posts Invalid XML character while producing... nikhil.bhole IBM Tools 4 Tue Mar 20, 2018 1:24 am

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us