Post Install Compare fails with SQL-904 Unavailable Resource 00C90084 Resource Type 00000100

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

Problem Description:

After upgrading to DB2 10 NFM, the Post Install ssid0000 Compare job fails with the following RC=16 condition code:

RMA199E PROGRAM RMA@GRT2 RECEIVED THE FOLLOWING SQL ERROR DSNT408I

SQLCODE = -904, ERROR: UNSUCCESSFUL EXECUTION CAUSED BY AN UNAVAILABLE RESOURCE. REASON 00C90084, TYPE OF RESOURCE  00000100

 

Resolution:

IBM has advised to use the default setting of 'NO' for the ZPARM WFDBSEP parameter along with using DB2 managed work database tablespaces with SECQTY=0 and to allocate 4K & 32K TS in a 20/80 ratio.