IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Error 00E40045 in Loading data


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
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
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

Moderator Emeritus


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

PostPosted: Thu Jun 09, 2011 7:34 pm
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
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: 8697
Location: Dubuque, Iowa, USA

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

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

Moderator Emeritus


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

PostPosted: Thu Jun 09, 2011 8:51 pm
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 View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts How to save SYSLOG as text data via P... All Other Mainframe Topics 4
No new posts Store the data for fixed length COBOL Programming 1
No new posts Error to read log with rexx CLIST & REXX 11
No new posts Error when install DB2 DB2 2
No new posts Data set Rec-Cnt and Byte-Cnt Testing & Performance 2
Search our Forums:

Back to Top