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