ademy
Beginner
Joined: 24 Sep 2004
Posts: 2
Topics: 2
|
 Posted: Mon Sep 27, 2004 6:08 pm Post subject: How to restart DB2 LOAD JCL |
 |
|
Hi
My load jcl failed with error message
| Code: |
DSNU320I <D71S DSNURWI - RESUME(YES) WAS SPECIFIED FOR EMPTY TABLESPACE
DSNU335I <D71S DSNURWBG - INPUT FIELD 'TRPDREG' NOT ENTIRELY WITHIN INPUT
RECORD
DSNU302I <D71S DSNURWBF - (RE)LOAD PHASE STATISTICS - NUMBER OF INPUT RECORDS
PROCESSED=1
|
After I made a fix to this error
DSNU335I <D71S DSNURWBG - INPUT FIELD 'TRPDREG' NOT ENTIRELY WITHIN INPUT
RECORD
I rerun the same JCL I am getting the following error message.
| Code: |
DSNU000I DSNUGUTC - OUTPUT START FOR UTILITY, UTILID = AYASSIN
DSNU013I <D71S DSNUGASU - JOB WITH DUPLICATE UTILID FOUND IN SYSUTIL
DSNU016I DSNUGBAC - UTILITY BATCH MEMORY EXECUTION ABENDED, REASON=X'00E4001
|
Do you know what I need to do to start all over again.
Here is my load jcl
| Code: |
//AYDB2LD JOB 620,AYASSIN,CLASS=Z,MSGCLASS=X
//DB2LOAD EXEC PGM=DSNUTILB,REGION=0M,
// PARM='D71S,AYASSIN'
//STEPLIB DD DSN=DSN710.SDSNLOAD,DISP=SHR
//SYSPRINT DD SYSOUT=*
//SYSREC00 DD DSN=ODEM.DL2.V230.CIRCLE.TRPDBD,DISP=SHR
//*SYSERR DD SYSOUT=* ERROR DATA SET
//SYSERR DD DSN=ODEM.DL2.V230.CIRCLE.SYSERR,DISP=(MOD,DELETE,CATLG),
// UNIT=SYSDA,SPACE=(2000,(20,20),,,ROUND)
// DCB=(RECFM=FB,LRECL=80,BLKSIZE=2400)
//UTPRINT DD SYSOUT=* MESSAGES FROM DFSORT
//SYSDISC DD SYSOUT=* DISCARD DATA SET
//SYSUT1 DD DSN=&&SYSUT1, SORT INPUT
// UNIT=SYSDA,SPACE=(CYL,(5,1))
//SORTOUT DD DSN=&&SORTOUT, SORT OUTPUT
// UNIT=SYSDA,SPACE=(CYL,(5,1))
//SYSMAP DD DSN=&&SYSMAP, MAPPING DATA SET
// UNIT=SYSDA,SPACE=(CYL,(5,1))
//SYSIN DD *
LOAD DATA LOG YES RESUME YES INDDN SYSREC00 INTO TABLE
DL2.TRP_DBD
(
TRPDNAME POSITION(1) CHAR(8),
TRPDDFEX POSITION(9) CHAR(8),
TRPDDIEX POSITION(17) CHAR(8),
TRPDREG POSITION(25) CHAR(1),
TRPDREDY POSITION(26) CHAR(1),
TRPDIRDO POSITION(27) CHAR(1))
/*
|
Thank
Adem
_________________
Thanks
Adem |
|
kolusu
Site Admin
Joined: 26 Nov 2002
Posts: 12378
Topics: 75
Location: San Jose
|
| Posted: Mon Sep 27, 2004 6:20 pm Post subject: |
|
|
ademy,
what is the lrecl of the ODEM.DL2.V230.CIRCLE.TRPDBD dataset? And what is the column definition of 'TRPDREG' ?
I guess there is a mismatch in the definition of 'TRPDREG'.
The LOAD utility can be restarted with either RESTART or RESTART(PHASE). However, the utility can be re-executed From the last internal checkpoint. This is dependent on the Data sets used and whether any input data sets have been rewritten.
LOAD RESUME YES cannot be restarted in the BUILD or SORTBLD phase.If report is required and this is a load without discard processing, SYSMAP is required to complete the report phase.
Check this link which explains in detail about restarting a load utility by terminating the utility
http://www.mvsforums.com/helpboards/viewtopic.php?t=630&highlight=display
Hope this helps...
Cheers
Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu |
|
FAQ
Search
Quick Manuals
Register
Profile
Log in to check your private messages
Log in
