Thank you, Radoslav. >Regarding buffers I think you ar wrong. Buffers are heavily used for tables, but not for log. Due to transaction integrity active log is immediately written to DASD.
I've read this in the DB2 V11 for z/OS Administeaion Guide where is says (page 327): How DB2 creates log records Log records typically go through a standard life cycle. 1. DB2 registers changes to data and significant events in recovery log records. 2. DB2 processes recovery log records and breaks them into segments if necessary. 3. Log records are placed sequentially in output log buffers, which are formatted as VSAM control intervals (CIs).... [snip] 4. The CIs are written to a set of predefined disk active log data sets, which are used sequentially and recycled. 5. As each active log data set becomes full, its contents are automatically offloaded to a new archive log data set. -- Peter Hunkeler ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [email protected] with the message: INFO IBM-MAIN
