BPA0016E: DB2 UTILITY APPLICATION - INCOMPLETE
search cancel

BPA0016E: DB2 UTILITY APPLICATION - INCOMPLETE

book

Article ID: 93024

calendar_today

Updated On:

Products

RC Compare for DB2 for z/OS Fast Unload for DB2 for z/OS DATABASE MANAGEMENT SOLUTIONS FOR DB2 FOR Z/OS RC/Migrator for DB2 for z/OS

Issue/Introduction

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 .

Environment

Release: R20
Component: COMDB2

Resolution

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
            TABLESPACE PTDB.TSNAME


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 
.CONNECT ssid

2. Edit the Highlvl.CDBASAMP(XXXXDDL)  and add: 

.ALLOC FI(PTILOAD) + 
DUMMY

Additional Information

- 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).

See also RC/Migrator : Restart of a Utility Execution during an execution of Batch Processor code.