How to fix error - X469 rebuild pending bit set on <tablename> when trying to edit a table in XDB Wizard

Problem

How to fix error - X469 rebuild pending bit set on <tablename> when trying to edit a table in XDB Wizard

Resolution

Solution is to run attached JCL (X469Fix.jcl) sample using the CHECK DATA utility via DNSUTILB in MFE.

To use the JCL

- Unzip the attached file X469Fix.zip into a directory of your choice.

- Open Mainframe Express

- Add the file X469Fix.jcl to your DB2/XDB project

- Edit the JCL

       - change the following to match your database and tablespace names

         CHECK DATA TABLESPACE databasename.tablespacename

       - You can change the JOBCARD if you would like to, but this is not essential.

- Run the JCL 

When completed, the tables will be accessible again.

X469Fix.zip

Incident#2883666