By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,611 Members | 2,296 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,611 IT Pros & Developers. It's quick & easy.

Database inconsistant?

P: n/a
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 ???

Aug 8 '07 #1
Share this Question
Share on Google+
5 Replies


P: n/a
"Arun Srinivasan" <ar*******@gmail.comwrote in message
news:11*********************@57g2000hsv.googlegrou ps.com...
>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 ???
It is not a parameter, it is a status.
Aug 8 '07 #2

P: n/a
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.
Aug 9 '07 #3

P: n/a
Dave Hughes wrote:
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.
I often wonder whether this indicator should simply be removed.
It causes way more anxiety than information.

Cheers
Serge

--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab
Aug 10 '07 #4

P: n/a
On Thu, 09 Aug 2007 20:35:29 -0400, Serge Rielau scribbled:
Dave Hughes wrote:
>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.
I often wonder whether this indicator should simply be removed. It
causes way more anxiety than information.
Might be a good idea. I remember the very first time I noticed "Database
is consistent: NO" in the GET DB CFG output and my immediate thought was
that it was indicating some sort of database corruption! Thankfully I
took a little time to read the reference and discovered it was no big
deal after all. Simply changing the label and reversing the meaning might
avoid several DBA heart attacks in future :-)

Pending transactions: YES

Sounds a lot less frightening than:

Database is consistent: NO
Cheers,

Dave.
Aug 11 '07 #5

P: n/a
Rightly put Dave..
Thanks Dave and Serge..Am happy to get replies from such big names in
db2 world.

Aug 15 '07 #6

This discussion thread is closed

Replies have been disabled for this discussion.