Re: archive level 0 size variation

In article <6gokov$f0t$1@news.xmission.com>, ANTS <sui@naseej.com> writes > >Hi again for the archive size, > >Thanks for those who replied. > >We do the level-0 archive when there are no users/activities. >In normal cases no open transactions. Unless the user started something and >left, but we notice size variation even in other days where there are no >open transactions after working hours. > >We dont have BLOB spaces. >The sizes vary 2097152 bytes between two days readings, another example is >6291456 bytes for .5GB file archive size. > I assume that DBSPACETEMP is set such that temporary tables / sort tables are created in dbspaces with have TEMP='Y' hence they are not archived? Also check www.iiug.org under Special Software there is a tool called archecker which can be used to verify archives... >Any reason for this??? > >Nien > > > > > > -- David Williams Maintainer of the Informix FAQ Primary site (Beta Version) http://www.smooth1.demon.co.uk Official site http://www.iiug.org/techinfo/faq/faq_top.html I see you standin', Standin' on your own, It's such a lonely place for you, For you to be If you need a shoulder, Or if you need a friend, I'll be here standing, Until the bitter end... So don't chastise me Or think I, I mean you harm... All I ever wanted Was for you To know that I care