Re: Physical log status

---- you wrote: > I did a onstat -d, which showed all the chunks. I am a bit perplexed as > my physical log dbspace(chunk phylogdbs) shows a free of 0 pages. > > address chk/dbs offset size free bpages flags pathname > 2070482a8 1 1 0 25000 3897 PO- > /user1/informix/chunks/online_root > 207048768 2 2 0 300000 299947 PO- > /user1/informix/chunks/tempdbs > 207048858 3 3 0 50000 1197 PO- > /user1/informix/chunks/llogdbs > 2076a78e8 4 5 0 500000 491189 PO- > /user1/informix/chunks/datachunk2 > 207048948 5 5 0 500000 0 PO- > /user1/informix/chunks/datadbs > 207048a38 6 6 0 500000 120128 PO- > /user1/informix/chunks/idxdbs > 207048b28 7 7 0 300000 0 PO- > /user1/informix/chunks/phylogdbs > > But when I do a onstat -l, my physical logging shows : > > Physical Logging > Buffer bufused bufsize numpages numwrits pages/io > P-2 8 16 0 0 0.00 > phybegin physize phypos phyused %used > 700035 299947 74436 184 0.06 ^^^^^^ > > > Is this how Informix allocates physical log or am I missing something ? You are missing something Dude. The physical log is created with the size you specified in your onconfig file. If that dbspace holds the physical log then it will fit exactly because you spcified a size of 299947. How much of that 299947 is used is reported as 0.06% by onstat -l. AB ---------------------------------------------------------------- Get your free email from AltaVista at http://altavista.iname.com