An RC/Merger 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'
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
DSNU690I -ssid 269 15:27:52.22 DSNUCBVR - CANNOT UPDATE INFORMATION IN THE
THAT DOES NOT MATCH THE PAGE SET
What is causing this error and how can it be resolved?
Release : 20.0
Component : RC/Merger Component of CA RC/Migrator for DB2 for z/OS
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.