Re: identify changes for level 1 backup?

On Oct 16, 3:01 pm, Fernando Nunes <domusonl...@gmail.com> wrote: > > 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). > Thank you, Mr. Nunes. I do, in fact, make the Level 1 backups. I just am wondering how to identify the what is in them. When I see a sudden, large increase in the size of a Level 1, I would like to know what caused it. (That is, I'd like to identify the changed tables, sorted by the size of their Level 1 deltas.) DG

davidegrove@gmail.com wrote: > On Oct 16, 3:01 pm, Fernando Nunes <domusonl...@gmail.com> wrote: >> 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). >> > > > Thank you, Mr. Nunes. > > I do, in fact, make the Level 1 backups. Yes, I got that... > > I just am wondering how to identify the what is in them. When I see a > sudden, large increase in the size of a Level 1, I would like to know > what caused it. (That is, I'd like to identify the changed tables, > sorted by the size of their Level 1 deltas.) What I tried to explain is that although it would be possible, You'd have to run a query that would need to read all the pages in the engine. It's the same process the backup uses... The information stored in a level 1 image is useless without the level 0. It's just a bunch of pages that changed since the last level 0. Regards. -- Fernando Nunes Portugal http://informix-technology.blogspot.com My email works... but I don't check it frequently...

On Oct 20, 1:11 pm, Fernando Nunes <domusonl...@gmail.com> wrote: > davidegr...@gmail.com wrote: > >  When I see a > > sudden, large increase in the size of a Level 1, I would like to know > > what caused it. > > What I tried to explain is that although it would be possible, You'd have to > run a query that would need to read all the pages in the engine. It's the same > process the backup uses... > > The information stored in a level 1 image is useless without the level 0. It's > just a bunch of pages that changed since the last level 0. > Thank you. At the risk of beating a dead horse, that kind of info could tell me what tables are being changed. I don't think I really care about what data is actually being changed. For instance, a list of table names, and the number of changed pages foreacht table would, I think, be useful. Regards, DG