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.
Dear Here,
Today,I found following warning in online.log .
My database OS is AIX and DB is Informix Database server 7.3.
09:05:45 WARNING! Physical Log size 50000 is too small. Physical Log overflows may occur during peak activity.
Recommended minimum Physical Log size is 20 times maximum
concurrent user threads.
I had config Physical and Logical :
# Physical Log Configuration
PHYSDBS rootdbs # Location (dbspace) of physical log
PHYSFILE 50000 # Physical log file size (Kbytes)
# Logical Log Configuration
LOGFILES 120 # Number of logical log files
LOGSIZE 2000 # Logical log size (Kbytes)
Actually , My dbspace in used is 27% and 73% is avaiabled .
and concurrent user between 500-600 and each user session size is 7k .
So , Physical Log size should be enough .
Why this warning happen ? and How to fix it ?
PLS Help me !! Thanks.
Regards
Jerry
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.