Re: why archive vary in size

ANTS wrote: > Hi, > > We are doing archive level 0 to disk daily. We noticed that the size of the > file goes up and down greatly, more than the activities of the database > itself. > > We have asked Informix, they dont have explanation. One guy said that it's > because of logical logs that being backed up. So sometimes that logs are big > and sometime they are small. But the Informix consultant said that archive > level 0 does not save the logs in the level-0 only the log id. > Your consultant is wrong, a level 0 archive will include as many logical logsas it needs to rollback any open transactions that exists at the time the 1st "archive" checkpoint happens. (The archive checkpoint is the checkpoint that the archvie process requests and it is used to determine the timestamp to compare all the pages timestamps to, to determine if they indeed need to be backed up or not). We don't force you to rollforward logs so the archive has to backup as many as it needs to roll those open transactions back. You don't mention how much of a difference you are seeing in size. Also do you have blobspaces, with tables that reference them? > What's really going on??? We are using Informix 5.05 online. > > Nien > =========================================== > Mails are checked daily and processed right away. > If you don't get my replies within 3 days please send your mail again. -- ******************************************************************** * Jacques P. Renaut "I'd dazzle you with brilliance * * Informix Advanced Support if I only had the knack..." * * email: jrenaut@informix.com #include <disclamier.h> * ********************************************************************