Repair fails DSNU671I due to table schema mismatch using RC/Merger

Products

• RC/Migrator for DB2 for z/OS
• RC/Merger for DB2 for z/OS

Issue/Introduction

An RC/Merger for Db2 for z/OS (RMM) copy is failing with a schema mismatch during the Repair for a tablespace:

 DSNU671I  -ssid 269 15:27:52.22 DSNUCBVR - DBID=X'dbid' PSID=X'psid'           
            OBID=X'obid'                                                       
                       TABLE SCHEMA IN THE CATALOG DOES NOT MATCH THE PAGE SET.
DSNU667I  -ssid 269 15:27:52.22 DSNUCBVR -    NUMBER OF COLUMNS IS 18 IN THE   
            CATALOG, BUT 15 IN THE PAGE SET.                                   
DSNU667I  -ssid 269 15:27:52.22 DSNUCBVR - TABLE DEFINITION ERROR CANNOT BE    
            FIXED.                                                             
DSNU690I  -ssid 269 15:27:52.22 DSNUCBVR - CANNOT UPDATE INFORMATION IN THE    
            CATALOG                                                            
                       THAT DOES NOT MATCH THE PAGE SET                                                           

What is causing this error and how can it be resolved?

Resolution

This type of table schema mismatch, where the number of columns differs between the Db2 catalog and the pageset, could be the result of an outstanding
advisory reorg pending on the table after the number of columns in the table have been altered. Check the status of the tablespace with a
-DIS DATABASE (dbname) command. If the tablespace is in reorg pending (AREO*) advisory status, then this needs to be resolved before the
Merger Copy can be completed successfully.