Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
SPENCE Dale — — source: Informix-list mailing list archive (1991-1998)
Hi All,
We are running IDS 7.23.UC11 on RS/6000 AIX 4.3.2.
We have been getting messages in the message log:
12:27:13 WARNING! Physical Log size 8000 is too small. Physical Log overflows may occur during peak activity.
Recommended minimum Physical Log size is 20 times
maximum concurrent user threads.
I have recently increased PHYSFILE as per the Admin Guide and
am waiting to see...
Question:
--------------
The top portion of an onstat -l --->
INFORMIX-OnLine Version 7.23.UC11 -- On-Line -- Up 00:57:34 --
109024 Kbytes
Physical Logging
Buffer bufused bufsize numpages numwrits pages/io
P-1 0 16 1 1 1.00
phybegin physize phypos phyused %used
10157d 3000 0 0 0.00
1) My understanding is that the %used is the % of pages currently
being used. Is there anywhere a 'maximum pages ever used' for
physical log? [ I have seen a upf_logspmax in SMI table sysrstcb
being "max % of logspace ever used" for logical logs as indicated
in sysmaster.sql [thanks Art, for pointing that file out] but nothing
for physical log ??? ]
2) What is the threshold percentage full of physical log space that
will trigger a "WARNING! Physical Log size nnn is too small."
message??
Thanks and regards,
Dale Spence.
__________________________________________________________
Dale Spence
ADP Clearing (UK), Camberley, UK
______________________________________________________________________________
This message has been checked for all known viruses by Star Internet delivered
through the MessageLabs Virus Control Centre. For further information visit-
http://www.star.net.uk/stats.asp
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.