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#ffset 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 (AT) googlemail (DOT) com <
howie.lfc (AT) gmail (DOT) com> wrote: