RMA199E on "Compare DB2 Objects" Step fails
search cancel

RMA199E on "Compare DB2 Objects" Step fails

book

Article ID: 9284

calendar_today

Updated On:

Products

RC Compare for DB2 for z/OS

Issue/Introduction

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.