Well, don't forget DATA CAPTURE. In SQL Reference, under CREAT TABLE statement: ... if the table is being specified as "Data Capture", then - DATA CAPTURE CHANGES : log record for this table should contain the full before image or - DATA CAPTURE NONE : the partial before image for UPDATE operations
Good luck. ...Roland --- Graves Nora E <[EMAIL PROTECTED]> wrote: > 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] > With best regards, ...Roland Chung Senior Technical Specialist (S/390,VM/VSE,DB2/VSE&VM) MAXC Consultants Inc. Voice/Fax: 416-469-3280 (If busy, call: 416-469-2268) 197 Hastings Ave., Toronto, Ontario, Canada. M4L 2L6 ** Life is short. Stop once in a while and smell the roses. **
