#**************************************************************************
#
# INFORMIX SOFTWARE, INC.
#
# Title: onconfig.std
# Description: Informix Dynamic Server Configuration Parameters
#
#**************************************************************************
# Root Dbspace Configuration
ROOTNAME rootdbs # Root dbspace name
ROOTPATH d:\IFMXDATA\server_china\rootdbs_dat.000 # Path for device containing root dbspace
ROOTOFFSET 0 # Offset of root dbspace into device (Kbytes)
ROOTSIZE 102400 # Size of root dbspace (Kbytes)
# Disk Mirroring Configuration Parameters
MIRROR 0 # Mirroring flag (Yes = 1, No = 0)
MIRRORPATH # Path for device containing mirrored root
MIRROROFFSET 0 # Offset into mirrored device (Kbytes)
# Physical Log Configuration
PHYSDBS rootdbs # Location (dbspace) of physical log
PHYSFILE 2000 # Physical log file size (Kbytes)
# Logical Log Configuration
LOGFILES 21 # Number of logical log files
LOGSIZE 30000 # Logical log size (Kbytes)
LOG_BACKUP_MODE CONT # Logical log backup mode (MANUAL, CONT)
# Diagnostics
MSGPATH C:\Informix\server_china.log # System message log file path
CONSOLE C:\Informix\conserver_china.log # System console message path
......
......
---------------------------------------------------------------------------------------------
conserver_china.log 中如下：
<<IBM Informix Dynamic Server>>> Logical Log 2 Complete, timestamp:29766.
<<IBM Informix Dynamic Server>>> Logical Log 3 Complete, timestamp:43262.
<<IBM Informix Dynamic Server>>> WARNING! Physical Log size 2000 is too small.
Physical Log overflows may occur during peak activity.
Recommended minimum Physical Log size is 20 times maximum
concurrent user threads.
日志中有错误，查下原因，怎么改啊，改后对数据库有哪些影响。
------解决方案--------------------------------------------------------
Logical Log 配置太小 物理日志初始化的时候太小了，起码也得有个100兆，而且最终要把逻辑日志和物理日志从rootdbs中分离出来