You could join, if you have not done so, the DB2 List for a more focused group discussing DB2. To join, it is free, go to idug.org
Lizette > -----Original Message----- > From: IBM Mainframe Discussion List [mailto:[email protected]] On > Behalf Of Peter Hunkeler > Sent: Wednesday, February 10, 2016 5:18 AM > To: [email protected] > Subject: Active versus archive log data sets in DB2 > > I understand there is a DB2 forum somewhere (IDUG?), but I'd rather not > subscribe for this single question someone might be able to answer here. > > > I understand DB2 keeps its log data first in buffers, then writes it to one of > a set of active log data set. Finally the data will be written to archive data > sets when active log data sets fill up. The active data sets are used round > robin. > > > I found a sentence in a DB2 manual stating that the data is being copied from > the active to the archive data set. > > > I'm guessing that "copy" means the physical part not the logical view of where > the data is. That would be "move". It is not clear whether the data in the > active data set would still be used by DB2 after it has been copied to the > archive data set. > > > > > I doubt DB2 will physically delete the data from the active data set after > writing it to an archive data set. The question is, does DB2 remember that the > data is still also available in the active data set, as long as it has not > started reusing it? I think not. A block of log data will only ever be in one > place, buffer, active *or* archive data set. > > > > > Some insight, anyone? Pointers to the right FM would be nice, too. May need to > be able to point someone to a FM so he can read hinself. > > > > > -- > Peter Hunkeler ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [email protected] with the message: INFO IBM-MAIN
