Thanks Nora and Roland, Sounds like DB2/VM logs identically to the way that DB2/zOS & MVS does it's logging. Once we decide on the necessity of using data capture for recovery purposes, I will be able to finalize my table layouts. I appreciate the help.
Jan Rank DBA Mutual Protective Insurance Company [EMAIL PROTECTED] -----Original Message----- From: VM/ESA and z/VM Discussions [mailto:[EMAIL PROTECTED] On Behalf Of Roland P. Chung Sent: Thursday, November 10, 2005 9:58 AM To: [email protected] Subject: Re: DB2 logging 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. **
