When running the Create Required DB2 Objects job (ssid0001) after upgrading the Database Management Tools to R20 release the following error was displayed on a Load:
DSNU037I 109 11:12:42.23 DSNUGSDA - RECFM=U FOR DDNAME PTILOAD
DSNU016I 109 11:12:42.24
DSNUGBAC - UTILITY BATCH MEMORY EXECUTION ABENDED, REASON=X'00E40070'
BPA0016E: DB2 UTILITY APPLICATION - INCOMPLETE.
.FREE FI(SYSIN) .FREE FI(SYSPRINT) RETCODE = 16
The task worked for all the other DB2 systems .
The error can occur when the unload step fails with:
DSNU185I -ssid 088 09:21:19.51 DSNUGSRI - THE VSAM DATA SET DOES NOT EXIST FOR
If the tablespace is created with DEFINE NO the underlying VSAM lds is not created until data is inserted. The Load fails because there is no data to Load.
Since there is no data to unload or load there are two ways to get around the problem:
1. Restart the job in step EXECRBP2 at the NEXT Sync point after the IBM Load.
Restart step EXECRBP2 via RESTART SYNC ###
.RESTART SYNC nnnn
2. Edit the Highlvl.CDBASAMP(XXXXDDL) and add:
.ALLOC FI(PTILOAD) +
- If the problem occurred processing a utility (Load, Unload, Reorg etc.), be sure to terminate the UTILID shown in the output prior to restarting.
- If a COPY was being processed, delete the allocated copy dataset prior to restarting (SYSC0000).