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.