ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

Repair fails DSNU671I due to table schema mismatch

book

Article ID: 200448

calendar_today

Updated On:

Products

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

Issue/Introduction

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'           
            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?

Environment

Release : 20.0

Component : RC/Merger Component of CA RC/Migrator for DB2 for z/OS

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.