There is actually a command to fix the problem
The only issues surrounding its use are
a) You have to know when your tables are broken so you can fix them
b) the manual says, in large friendly letters: Before running this command, back up your entire database, and contact your local support representative.
Really gives one the warm fuzzies...
I can't remember the actual command off the top of my head. This is probably just as well. For what it's worth, I did run it, with no (readily apparent) ill effects. Mind you, I did this well and truly
after we'd migrated everthing to a real (Oracle) Database...
Remind me to never take a job that requires using Red Brick. Ever
Sound advice. I've already turned down a job offer for that very reason.