Informix Dynamic Server Configuration 问题

Mysap-gwg 2009-09-15 12:26:15

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

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

...全文