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 -- Peter Hunkeler ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [email protected] with the message: INFO IBM-MAIN
