Physical Log

[howi...@gmail.com]

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?

[Art Kagel]

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.

_______________________________________________
Informix-list mailing list
Inform...@iiug.org
http://www.iiug.org/mailman/listinfo/informix-list