Re: corrupt index/bcheck problem

pedrin@cpva.saic.com wrote: : Hello, : Does anyone know a way to fix the following problem? When I run the : bcheck utility on a corrupt index the routine tries to fix the problem : but ends up with the following error: : ERROR: duplicate key value, record 3804 : Is there any other utility to fix this problem? We're running version : 5.00.UC3 on a RS6000. : Our management cancelled support last month because where converting to a : new database next month. Now I'm stuck with the problem. I would : appreciate any help! : Thanks, john I can't think of a utility that will fix your problem in one step but when I've had this problem in the past, I've unloaded the table's data, deleted the record with the duplicate key I chose to drop, and reloaded the table. In your case, you would want to look at the 3804'th line in the unloaded ASCII data file. I don't know if you are looking for a fix without unloading and reloading the table. -- Paul D. Brunner, Software Engineer | Voice: (203) 758-1811 ext. 7507 General DataComm Industries, Inc. | FAX: (203) 598-7173 Middlebury, CT 06762-1299 | E-mail: paul.brunner@corp.gdc.com -- When you come to the end of this message, this signature will cease to . .