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

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