According to the 7.3 Performance Tuning Handbook:
"Keeping Together Frequently Updated Columns: Keep frequently updated columns close together in the same row. This helps to reduce the amount of data that has to be logged because only the portion of the row from the first column updated to the last column updated is recorded in the log."
Nora Graves
[EMAIL PROTECTED]
(202) 622-6735
-----Original Message-----
From: VM/ESA and z/VM Discussions [mailto:[email protected]] On Behalf Of Janice Rank
Sent: Wednesday, November 09, 2005 3:26 PM
To: [email protected]
Subject: DB2 logging
Hi Listers,
Can anyone tell me how DB2 records are logged in the VM version 7.3.0 of DB2? In MVS it only logs the changed field to the end of the record. I am trying to set up some tables for the most efficient logging and if this version does the logging the same as MVS, I need to make sure that the most often updated columns are placed at the end of the table. Thanks, Jan Rank
DBA
Mutual Protective Insurance Company [EMAIL PROTECTED]
