Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2004
    Posts
    29

    Unanswered: How does "NOT LOGGED" option work???

    Hi,

    I am trying to understand how does the DB2 engines writes the data into the database if one of the columns is defined with a "NOT LOGGED" option. I know that it indicates that this particular column value will not be logged into the transaction logs and by which if we do a restore, we are bound to lose some data. can someone shell some light on how DB2 treats these "NOT LOGGED" columns and writes data into database.

    Thanks

    - Raj

  2. #2
    Join Date
    Oct 2004
    Posts
    29
    Nevermind..I figured out how it works. The columns which are marked as "NOT LOGGED", DB2 will write that information directly into the database by passing writing into transaction logs. The downside of it is if we are doing a restore and rolling forward the database by applying the logs, you those columns pertaining to these transactions will be nullified as DB2 will not have any record of these. Correct me if I am wrong.

    - Raj

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •