Physical Log

IDS11.50.FC3 HPUX11.11 this is the error message in the online.log we have been getting WARNING! Physical Log size 300000 is too small. Physical Log overflows may occur during peak activity. Recommended minimum Physical Log size is 160 times maximum concurrent user threads. Onmonitor shows the following.... Press ESC to modify the physical log. Press Interrupt to cancel the option and return to the Parameters menu. Press F2 or CTRL-F for field level help. MODIFY PHYSICAL LOG Physical Log Size [ 300000] Kbytes Dbspace Name [rootdbs ] I thought that we moved the physical log some time back but I guess not. I have a dbspace plogdbs available to use which is 400000Kb in size onstat -d plogdbs - shows the following DBspace Usage Report: plogdbs Owner: informix Created: 07/01/1998 Chunk Pathname Pagesize(k) Size(p) Used(p) Free(p) 4 /dev/vgsg1/rlvol3 2 200000 150053 49947 Description Offset(p) Size(p) ------------------------------------------------------------- -------- -------- RESERVED PAGES 0 2 CHUNK FREELIST PAGE 2 1 plogdbs:'informix'.TBLSpace 3 50 PHYSICAL LOG 53 150000 FREE 150053 49947 Total Used: 150053 Total Free: 49947 Now I am confused here...this seems to show that the Physical Log is 300000Kb in size and is in plogdbs and not rootdbs as stated in onmonitor. Am I missing something here?

Onmonitor shows my physical log is in rootdbs also, but that's not true here either (see below). Looks like Onmonitor is broken, which is probably fine, it is being phased out in favor of OAT, Server Studio, and other modern tools and is only included for historical reasons at this point. What does onstat -l show? the phybegin column in the report will show the chunk#:offset of the physical log. So on mine I have: IBM Informix Dynamic Server Version 11.70.FC3 -- On-Line -- Up 3 days 01:23:57 -- 491696 Kbytes Physical Logging Buffer bufused bufsize numpages numwrits pages/io P-1 0 64 4432 459 9.66 phybegin physize phypos phyused %used 2:53 50500 23101 0 0.00 Where chunk#2 is the first and only chunk in dbspace #2 "plogdbs": Dbspaces address number flags fchunk nchunks pgsize flags owner name 5c553028 1 0x60001 1 1 2048 N BA informix rootdbs 5c553708 2 0x40001 2 1 2048 N BA informix plogdbs ... Chunks address chunk/dbs offset size free bpages flags pathname 5c5531d0 1 1 0 476255 48386 PO-BED /opt/informix/data/rootdb.1.chunk 5c6ad948 2 2 0 56742 6189 PO-BED /opt/informix/data/plogdbs.1.chunk ... Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Mon, Dec 19, 2011 at 9:57 AM, howie.lfc@googlemail.com < howie.lfc@gmail.com> wrote: > IDS11.50.FC3 HPUX11.11 > > this is the error message in the online.log we have been getting > > WARNING! Physical Log size 300000 is too small. > Physical Log overflows may occur during peak activity. > Recommended minimum Physical Log size is 160 times maximum > concurrent user threads. > > Onmonitor shows the following.... > > Press ESC to modify the physical log. > Press Interrupt to cancel the option and return to the Parameters > menu. > Press F2 or CTRL-F for field level help. > > MODIFY PHYSICAL LOG > > Physical Log Size [ 300000] Kbytes > > Dbspace Name [rootdbs ] > I thought that we moved the physical log some time back but I guess > not. > > I have a dbspace plogdbs available to use which is 400000Kb in size > > onstat -d plogdbs - shows the following> > DBspace Usage Report: plogdbs Owner: informix Created: > 07/01/1998 > Chunk Pathname Pagesize(k) Size(p) > Used(p) Free(p) > 4 /dev/vgsg1/rlvol3 2 > 200000 150053 49947 > > Description > Offset(p) Size(p) > ------------------------------------------------------------- > -------- -------- > RESERVED PAGES 0 2 > CHUNK FREELIST PAGE 2 1 > plogdbs:'informix'.TBLSpace > 3 50 > PHYSICAL LOG > 53 150000 > FREE > 150053 49947 > > Total Used: 150053 > Total Free: 49947 > > Now I am confused here...this seems to show that the Physical Log is > 300000Kb in size and is in plogdbs and not rootdbs as stated in > onmonitor. > > Am I missing something here? > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list >