top posting - yes I know - 1. yes, there are buffers for log activity - see DSNZPARM values - not the size of database buffers but not small either 2. Archive logs are recorded in BSDS with start and end logrba 3. If an active log has not been reused, DB2 will search it first not the archive log 4. Large DB2 subsystem may have many more than the base 3 active logs. A usual requirement is to keep an hours worth of updates in active logs so DB2 doesn't have to access the archive log in normal processing.
Mike On Wed, Feb 10, 2016 at 6:28 AM, R.S. <[email protected]> wrote: > Peter, > You are right, active log is copied to archlog, but after that the actlog > is "in scratch status", that mean it can be reused. > It is very similar to SMF SYS1.MANx datasets. > > And yes, after succesful copy actlog -> archlog the data will be searched > in archlog. Actlog is logically empty (until reuse). > > 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. > > > -- ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [email protected] with the message: INFO IBM-MAIN
