RMA199E on "Compare DB2 Objects" Step fails

Document ID : KB000009284
Last Modified Date : 14/02/2018
Show Technical Document Details
Issue:

RMA199E on "Compare DB2 Objects" Step fails 

Environment:
Release R18, R19 and R20 Db2 V11 and V12.
Cause:

While running the "Compare DB2 Objects" step of the customization process, the job may encountered the following error:  

RMA199E PROGRAM RMA@TGET RECEIVED THE FOLLOWING SQL ERROR: DSNT408I SQLCODE = -904.  

ERROR: UNSUCCESSFUL EXECUTION CAUSED BY AN UNAVAILABLE RESOURCE. REASON 00C90084, TYPE OF RESOURCE 00000100, AND RESOURCE NAME DSNDB07  

Resolution:

Dropping the 32K workfile tablespaces and then recreating them using the 32K BP resolves the problem in most cases.