What tool should I be using to scan a db for issues? I've got a little dev db that I want to see what's going on under its covers.
There's dbrpr and DBTOOL - is one better than the other?
Hi Tim,
What do you think might be "going on"?
For a good overview of tools and their uses, check out Rich's talk from PUG Challenge 2013 on DB corruption:
http://pugchallenge.org/downloads2013/251_DBCorruption.pptx
http://pugchallenge.org/downloads2013/audio/251_DBCorruption.mp3
I've got a audit enabled db, and I think I've come up with a situation where I cannot delete a record from an audited table due to a "system error". What I want to check for is if there's corruption in the db.
How about DataDigger, if what you want to see is what is in the records ... although corruption sounds like you need the utilities to check the integrity of the database.
There's only one record.
The specific scenario is I have a bunch of legacy data I want to convert to OE Auditing format so everything's the same going forward. I was testing how it behaved when the source record approached the 32K record size limit, particularly when an array was involved when I ran into this issue.