When running the Create Required DB2 Objects job (ssid0001) after upgrading the CA DB2 Tools to r20 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 -D2TA 088 09:21:19.51 DSNUGSRI - THE VSAM DATA SET DOES NOT EXIST FOR
If the TS is created with Define NO the underlying VSAM 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 ###
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).