Database inconsistant?

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Arun Srinivasan
    #1

    Database inconsistant?

    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 ???

    Tags: None
    • Mark A
      #2
      Re: Database inconsistant?

      "Arun Srinivasan" <arunrocks@gmai l.comwrote in message
      news:1186592364 .454847.65510@5 7g2000hsv.googl egroups.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.


        Comment

        • Dave Hughes
          #3
          Re: Database inconsistant?

          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_consi stent" 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.

            Comment

            • Serge Rielau
              #4
              Re: Database inconsistant?

              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_consi stent" 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

                Comment

                • Dave Hughes
                  #5
                  Re: Database inconsistant?

                  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_consi stent" 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.

                    Comment

                    • Arun Srinivasan
                      #6
                      Re: Database inconsistant?

                      Rightly put Dave..
                      Thanks Dave and Serge..Am happy to get replies from such big names in
                      db2 world.

                        Comment

                        Previous template Next
                        Working...