Re: identify changes for level 1 backup?

davidegrove@gmail.com wrote: > Solaris 10 > Sun V480 > Informix 10 > > Sometimes I observe a huge increase in the size of a level 1 archive > from one day to the next. That tells me there were some big-time > updates going on that day. Is there a way to identify the rows/tables > that have been changed since the level 0? In other words, how can I > determine the contents of a level 1 archive? > > Thank you. > > DG Level 1 will contain all the pages that were changed since the last level 0. You could see which pages were changed by comparing their timestamp with the timestamp when the backup started. This would imply reading all the pages, so it's a resource intensive task... And since you would need to read them, you might as well write them (in other words, make the level 1). This could lead to a nice feature request... writing the checkpoint timestamp in each chunk/dbspace (internal structure) if any page is written to it... For less used (written) chunks/dbspaces, this could lead to much lower level 1/level 2 backup times... Of course, all the problems associated with the "timestamp" would have to be considered... Regards -- Fernando Nunes Portugal http://informix-technology.blogspot.com My email works... but I don't check it frequently...