This deal turned it a no funner.

I ended up doing a dumpdb and loaddb and auditdb to get this pig back.  The
only good news is it was a relatively small database so that process (once I
figured out that's what I should do) only took about 10 hours total.  There
were 27 million objects in the database.  Interesting and fun to know facts,
I guess.

I'm awaiting word from support as to why it got into this bind in the first
place.  If I learn anything of interest there, I'll post it.  I did get a
bunch of trace information during the crashes and hangs so they should be
able to figure out what happened.  It looked like the activity.log table
somehow got hosed.

So, for now, you can call me the dumbdb guru.  BTW, that isn't that fun a
process I'm here to tell you.  Especially on a weekend when all of you guys
are tucked safely away at home.  I hate not having help!

Thanks,

Kelly J. Lipp
Storage Solutions Specialists, Inc.
PO Box 51313
Colorado Springs CO 80919
(719)531-5926
Fax: (719)260-5991
www.storsol.com
lipp AT storsol DOT com