Informix Dynamic Server Configuration 问题

[Mysap-gwg]

#**************************************************************************
#
# 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.

日志中有错误，查下原因，怎么改啊，改后对数据库有哪些影响。

[zhuzhengs]

Logical Log 配置太小 物理日志初始化的时候太小了，起码也得有个100兆，而且最终要把逻辑日志和物理日志从rootdbs中分离出来