Corrupt partitions due to duplicate records

baljinders · New User Joined: 21 Aug 2006 Posts: 72

Hi

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.

Thanks

sushanth bobby · Posted: Wed Jul 21, 2010 5:08 pm

Baljinders,

Check the SYSCOPY table for that particular time period and tablespace.
You will get the partition number.

Thanks,
Sushanth