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
 

 

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: 8120
Location: East Dubuque, Illinois, 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 Paasing symbolic parameter to instrea... Anirudh Anand JCL & VSAM 0 Thu Jul 27, 2017 1:22 pm
No new posts Passing data from REXX to C programme... chong.zhou CLIST & REXX 3 Wed Jul 26, 2017 9:11 pm
No new posts Passing data from REXX to C programme... chong.zhou All Other Mainframe Topics 0 Wed Jul 26, 2017 4:55 pm
No new posts copying data without knowing location arunsoods DFSORT/ICETOOL 6 Thu Jul 20, 2017 1:03 pm
This topic is locked: you cannot edit posts or make replies. Fetching data from BAI File arunsoods JCL & VSAM 1 Wed Jul 19, 2017 4:28 pm


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