On Wed, 08 Aug 2007 09:59:24 -0700, Arun Srinivasan scribbled:
I recently noticed the
'Database is consistant' parameter of the db cfg changed from Yes to No,
when I did a
'set integrity immediate unchecked' command. the integrity of the table
was compromised, many rows didnt have parent rows.. But what is this
parameter ???
The "database_consistent" parameter (which is shown as the "Database is
consistent" parameter in DB CFG) indicates whether there are any pending
transactions that have modified anything. Basically, if all transactions
have been rolled back or committed, it's "Yes", otherwise it's "No".
The purpose, according to the docs, is to determine whether you need to
take any special action if the system crashes. If the value was "Yes"
prior to the crash, no special action is required, otherwise a RESTART
DATABASE command is required.
Cheers,
Dave.