I have a db2 table with 96 parts, index controlled partitions. Some user cancelled a long running load job and terminated the utility ID because of which the index went into RBDP state. When i try to rebuild the index, its throwing error because it can't load the index due to duplicate keys.
In order to fix this, i have an option of doing unload of all 96 parts and then load the data back into each partitions but that would be time consuming.
I wanted to know if there is a way to identify the corrupted partition only. That ways i can just unload and load replace on the corrupted partition w/o having to do on all 96 parts.