View previous topic :: View next topic |
Author |
Message |
yadav2005 Intermediate
Joined: 10 Jan 2005 Posts: 348 Topics: 144
|
Posted: Tue Oct 05, 2010 2:19 pm Post subject: Load job failed |
|
|
Members,
I am trying to load data into a DB2 table and the records are very huge in number.My LOAD jobs fails with abend code in UTPRINT :
Code: |
ICE046A 0 SORT CAPACITY EXCEEDED - RECORD COUNT 81641189
|
I am using JCL as below:
Code: |
//UTIL1 EXEC DSNUPROC,SYSTEM=DB2T,UID='TRIAL',UTPROC=''
//DSNUPROC.SORTWK01 DD UNIT=SYSDA,SPACE=(CYL,(500,500))
//DSNUPROC.SORTWK02 DD UNIT=SYSDA,SPACE=(CYL,(500,500))
//DSNUPROC.SORTWK03 DD UNIT=SYSDA,SPACE=(CYL,(500,500))
//DSNUPROC.SORTWK04 DD UNIT=SYSDA,SPACE=(CYL,(500,500))
//DSNUPROC.SYSUT1 DD UNIT=SYSDA,SPACE=(CYL,(900,600))
//DSNUPROC.SORTOUT DD UNIT=SYSDA,SPACE=(CYL,(900,600))
//DSNUPROC.SYSREC00 DD DSN=MY SYSREC DATASET,DISP=SHR
//DSNUPROC.SYSIN DD DSN=MY SYSPUNCH DATASET,DISP=SHR
|
And in the SYSPRINT output at the end I get:
Code: |
DSNU044I DSNUGSOR - ERROR FROM SORT COMPONENT RC=16, UTILITY STOPPED
DSNU016I DSNUGSAT - UTILITY BATCH MEMORY EXECUTION ABENDED, REASON=X'00E40005'
DSNU016I DSNUGBAC - UTILITY BATCH MEMORY EXECUTION ABENDED, REASON=X'00E40345'
|
In my LOAD card I have:LOAD DATA LOG NO NOCOPYPEND INDDN SYSREC00 REPLACE
Can somebody help me how to solve the problem.My tablespace gets into RECP and UTUT mode.Indexes get into RBDP status. |
|
Back to top |
|
|
kolusu Site Admin
Joined: 26 Nov 2002 Posts: 12368 Topics: 75 Location: San Jose
|
Posted: Tue Oct 05, 2010 2:27 pm Post subject: |
|
|
yadav2005,
Are you running DFSORT V1R5? Look at the messages in UTPRINT. It lists the version of DFSORT you are running.
Kolusu |
|
Back to top |
|
|
yadav2005 Intermediate
Joined: 10 Jan 2005 Posts: 348 Topics: 144
|
Posted: Tue Oct 05, 2010 9:18 pm Post subject: |
|
|
Kolusu,
I am using Z/OS DFSORT V1R10. |
|
Back to top |
|
|
warp5 Intermediate
Joined: 02 Dec 2002 Posts: 429 Topics: 18 Location: Germany
|
Posted: Wed Oct 06, 2010 12:39 am Post subject: |
|
|
Try giving it more sort work - sortwk05 - sortwk08. I have not used sort in a long time, so check and see if you have to tell sort to use more work files or just adding them is enough. Look at the options, maybe there is a parameter that says how many work data sets to use. There is probably an entry about this here if you do a search for it. Take a look at this thread:
http://www.mvsforums.com/helpboards/viewtopic.php?t=2091&highlight=sortwk |
|
Back to top |
|
|
kolusu Site Admin
Joined: 26 Nov 2002 Posts: 12368 Topics: 75 Location: San Jose
|
Posted: Wed Oct 06, 2010 10:14 am Post subject: |
|
|
yadav2005,
Send the complete sysout of the failing job to my ibm mail id and we will take a look into it.
Kolusu |
|
Back to top |
|
|
yadav2005 Intermediate
Joined: 10 Jan 2005 Posts: 348 Topics: 144
|
Posted: Wed Oct 06, 2010 11:12 am Post subject: |
|
|
Kolusu,
What I did is I tried to split the file into 3 parts and loaded individually with LOAD REPLACE , LOAD RESUME YES and LOAD RESUME YES and was successful. |
|
Back to top |
|
|
kolusu Site Admin
Joined: 26 Nov 2002 Posts: 12368 Topics: 75 Location: San Jose
|
Posted: Wed Oct 06, 2010 11:19 am Post subject: |
|
|
yadav2005,
Well you don't have to do that. You should be able to load all in one go. We just need to allocate more sort work dataset and your job should run fine.
Kolusu |
|
Back to top |
|
|
papadi Supermod
Joined: 20 Oct 2009 Posts: 594 Topics: 1
|
Posted: Wed Oct 06, 2010 2:01 pm Post subject: |
|
|
Quote: | You should be able to load all in one go |
Provided there is enough work space on the system. . . 8)
di |
|
Back to top |
|
|
|
|