SYSCOLDIST table is marked as invalid. Rebuild index getting error - 901 due to duplicate values
Biswarup(Bis)Mukherjee 120000HKTY Visits (10540)
Some older DB2 levels experienced this problem.
If the database cannot be restored using an earlier good backup then following way might help,
The SYSCOLDIST table contains the distribution statistics.
In that case, if it's o.k. to get rid of all the current distribution statistics then following could be done,
Above command will ask for,
Table ID or name, tablespace ID, first page, num of pages
Following could be entered,
The table id for SYSCOLDIST table could be obtained from system catalog.
For the service-password IBM support needs to be involved.
After making the SYSCOLDIST table blank, the index rebuild should work normally.
Later a full runstats for all the tables will help to populate the table back.
If this way of fixing the issue don't help then the IBM DB2 support needs to be involved.
If it's not possible to forget all the existing statistics and only the specific records complaining with duplicate values is to be cleaned up then a more involved steps needed and for that IBM DB2 Support needs to be involved.