my os is window xp sp2, the oninit server can not start up. could someone help me?
the log file is as following:
11:22:14 IBM Informix Dynamic Server Started.
Thu Oct 11 11:22:15 2007
11:22:15 Booting Language <c> from module <>
11:22:15 Loading Module <CNULL>
11:22:15 Booting Language <builtin> from module <>
11:22:15 Loading Module <BUILTINNULL>
11:22:19 IBM Informix Dynamic Server Version 9.40.TC2 Software Serial Number AAA#B000000
11:22:28 IBM Informix Dynamic Server Initialized -- Complete Disk Initialized.
11:22:28 Checkpoint Completed: duration was 0 seconds.
11:22:33 Checkpoint loguniq 1, logpos 0xd0, timestamp: 83
11:22:33 Maximum server connections 0
11:22:33 Dataskip is now OFF for all dbspaces
11:22:33 On-Line Mode
11:22:33 Building 'sysmaster' database ...
11:22:47 Logical Log 1 Complete, timestamp:28359.
11:22:47 Booting Language <spl> from module <>
11:22:47 Loading Module <SPLNULL>
11:22:48 Logical Log 2 Complete, timestamp:31477.
11:22:48 Dynamically allocated new virtual shared memory segment (size 8192KB)
11:22:48 Unloading Module <SPLNULL>
11:22:58 Checkpoint Completed: duration was 1 seconds.
11:22:58 Checkpoint loguniq 3, logpos 0x155018, timestamp: 33320
11:22:58 Maximum server connections 1
11:23:00 'sysmaster' database built successfully.
11:23:00 Logical Log 3 Complete, timestamp:43128.
11:23:01 'sysutils' database built successfully.
11:23:07 Init operation complete - Mode Online Initialized
11:23:13 Fuzzy Checkpoint Completed: duration was 0 seconds, 1 buffers not flushed,
timestamp: 43182.
11:23:13 Checkpoint loguniq 4, logpos 0x642f4, timestamp: 43182
11:23:13 Maximum server connections 1
11:23:13 Chunk Number 2 - 'D:\IFMXDATA\ol_ybluo\ol_ybluo_mirr.000' -- Recovery Begins(0CAF9E54)
11:23:14 Fuzzy Checkpoint Completed: duration was 0 seconds, 1 buffers not flushed,
timestamp: 43190.
11:23:14 Checkpoint loguniq 4, logpos 0x65204, timestamp: 43190
11:23:14 Maximum server connections 1
11:23:20 Chunk Number 2 - 'D:\IFMXDATA\ol_ybluo\ol_ybluo_mirr.000' -- Online
11:23:20 Fuzzy Checkpoint Completed: duration was 0 seconds, 1 buffers not flushed,
timestamp: 43197.
11:23:20 Checkpoint loguniq 4, logpos 0x6604c, timestamp: 43197
11:23:20 Maximum server connections 1
11:23:21 Chunk number 2 'D:\IFMXDATA\ol_ybluo\ol_ybluo_mirr.000' -- Recovery Complete(0CAF9E54)
11:23:21 Space 'ol_ybluo' added.
11:23:24 Chunk Number 3 - 'D:\IFMXDATA\ol_ybluo\sbspace_mirr.000' -- Recovery Begins(0CAF9E54)
11:23:30 Chunk Number 3 - 'D:\IFMXDATA\ol_ybluo\sbspace_mirr.000' -- Online
11:23:30 Checkpoint Completed: duration was 0 seconds.
11:23:30 Checkpoint loguniq 4, logpos 0x68528, timestamp: 43221
11:23:30 Maximum server connections 1
11:23:31 Chunk number 3 'D:\IFMXDATA\ol_ybluo\sbspace_mirr.000' -- Recovery Complete(0CAF9E54)
11:23:32 Checkpoint Completed: duration was 0 seconds.
11:23:32 Checkpoint loguniq 4, logpos 0x6acc0, timestamp: 43314
11:23:32 Maximum server connections 1
11:23:32 Space 'sbspace' added.
11:29:00 Checkpoint Completed: duration was 0 seconds.
11:29:00 Checkpoint loguniq 4, logpos 0x6c018, timestamp: 43320
11:29:00 Maximum server connections 1
11:38:40 IBM Informix Dynamic Server Started.
Thu Oct 11 11:38:40 2007
11:38:40 Booting Language <c> from module <>
11:38:40 Loading Module <CNULL>
11:38:40 Booting Language <builtin> from module <>
11:38:40 Loading Module <BUILTINNULL>
11:38:45 IBM Informix Dynamic Server Version 9.40.TC2 Software Serial Number AAA#B000000
11:38:46 IBM Informix Dynamic Server Initialized -- Shared Memory Initialized.
11:38:46 Physical Recovery Started at Page (1:294).
11:38:51 Physical Recovery Complete: 0 Pages Examined, 0 Pages Restored.
11:38:51 Logical Recovery Started.
11:38:51 10 recovery worker threads will be started.
11:38:51 Dynamically allocated new virtual shared memory segment (size 8192KB)
11:38:54 Logical Recovery has reached the transaction cleanup phase.
11:38:54 Logical Recovery Complete.
0 Committed, 0 Rolled Back, 0 Open, 0 Bad Locks
11:38:55 Dataskip is now OFF for all dbspaces
11:38:55 Checkpoint Completed: duration was 0 seconds.
11:38:55 Checkpoint loguniq 4, logpos 0x6d018, timestamp: 43333
11:38:55 Maximum server connections 0
11:38:55 Init operation complete - Mode Online
11:38:55 On-Line Mode
12:50:11 IBM Informix Dynamic Server Started.
Thu Nov 22 12:50:12 2007
12:50:12 Booting Language <c> from module <>
12:50:12 Loading Module <CNULL>
12:50:12 Booting Language <builtin> from module <>
12:50:12 Loading Module <BUILTINNULL>
12:50:16 IBM Informix Dynamic Server Version 9.40.TC2 Software Serial Number AAA#B000000
12:50:17 IBM Informix Dynamic Server Initialized -- Shared Memory Initialized.
12:50:17 Physical Recovery Started at Page (4:15840).
12:50:23 Physical Recovery Complete: 0 Pages Examined, 0 Pages Restored.
12:50:23 Logical Recovery Started.
12:50:23 10 recovery worker threads will be started.
12:50:23 Dynamically allocated new virtual shared memory segment (size 8192KB)
12:50:29 Logical Recovery has reached the transaction cleanup phase.
12:50:29 Logical Recovery Complete.
1835 Committed, 0 Rolled Back, 0 Open, 0 Bad Locks
12:50:30 Onconfig parameter PHYSDBS modified from phydbs to rootdbs.
12:50:30 Onconfig parameter PHYSFILE modified from 102400 to 2000.
12:50:30 Onconfig parameter TAPEDEV modified from NUL to \\.\TAPE0.
12:50:30 Onconfig parameter RESIDENT modified from 1 to 0.
12:50:30 Onconfig parameter LOCKS modified from 100000 to 2000.
12:50:30 Onconfig parameter BUFFERS modified from 24576 to 2000.
12:50:30 Onconfig parameter CLEANERS modified from 2 to 1.
12:50:30 Onconfig parameter LRU_MAX_DIRTY modified from 80.000000 to 60.000000.
12:50:30 Onconfig parameter LRU_MIN_DIRTY modified from 70.000000 to 50.000000.
12:50:30 Onconfig parameter NUMCPUVPS modified from 2 to 1.
12:50:30 Onconfig parameter SHMVIRTSIZE modified from 73728 to 8192.
12:50:30 Onconfig parameter RA_PAGES modified from 128 to 4.
12:50:30 Onconfig parameter RA_THRESHOLD modified from 120 to 2.
12:50:30 Onconfig parameter SHMADD modified from 16384 to 8192.
12:50:30 Onconfig parameter DBSPACETEMP modified from oltempdbs to <blank>.
12:50:30 Onconfig parameter LOG_BACKUP_MODE modified from CONT to MANUAL.
12:50:30 Dataskip is now OFF for all dbspaces
12:50:30 Checkpoint Completed: duration was 0 seconds.
12:50:30 Checkpoint loguniq 26, logpos 0x19d174, timestamp: 6434215
12:50:30 Maximum server connections 0
12:50:30 Init operation complete - Mode Online
12:50:30 On-Line Mode
12:50:59 Checkpoint Completed: duration was 0 seconds.
12:50:59 Checkpoint loguniq 26, logpos 0x19e018, timestamp: 6434248
12:50:59 Maximum server connections 1
10:11:21 IBM Informix Dynamic Server Started.
Fri Nov 23 10:11:25 2007
10:11:25 Booting Language <c> from module <>
10:11:25 Loading Module <CNULL>
10:11:25 Booting Language <builtin> from module <>
10:11:25 Loading Module <BUILTINNULL>
10:11:31 listener-thread: err = 0: oserr = 0: errstr = :
10:11:36 sql_listener: ASF_LISTEN failed
10:11:36 Attempting to bring listener thread down.
10:11:36 Server stopped.
10:13:39 IBM Informix Dynamic Server Started.
Fri Nov 23 10:13:39 2007
10:13:39 Booting Language <c> from module <>
10:13:39 Loading Module <CNULL>
10:13:39 Booting Language <builtin> from module <>
10:13:39 Loading Module <BUILTINNULL>
10:13:43 listener-thread: err = 0: oserr = 0: errstr = :
10:13:43 sql_listener: ASF_LISTEN failed
10:13:43 Attempting to bring listener thread down.
10:13:43 Server stopped.
10:14:36 IBM Informix Dynamic Server Started.
Fri Nov 23 10:14:36 2007
10:14:36 Booting Language <c> from module <>
10:14:36 Loading Module <CNULL>
10:14:36 Booting Language <builtin> from module <>
10:14:36 Loading Module <BUILTINNULL>
10:14:40 listener-thread: err = 0: oserr = 0: errstr = :
10:14:40 sql_listener: ASF_LISTEN failed
10:14:40 Attempting to bring listener thread down.
10:14:40 Server stopped.
10:16:40 IBM Informix Dynamic Server Started.
Fri Nov 23 10:16:40 2007
10:16:40 Booting Language <c> from module <>
10:16:40 Loading Module <CNULL>
10:16:40 Booting Language <builtin> from module <>
10:16:40 Loading Module <BUILTINNULL>
10:16:44 listener-thread: err = 0: oserr = 0: errstr = :
10:16:44 sql_listener: ASF_LISTEN failed
10:16:44 Attempting to bring listener thread down.
10:16:44 Server stopped.
and my Onconfig file is as following:
#**************************************************************************
#
# INFORMIX SOFTWARE, INC.
#
# Title: onconfig.std
# Description: Informix Dynamic Server Configuration Parameters
#
#**************************************************************************
# Root Dbspace Configuration
ROOTNAME rootdbs # Root dbspace name
ROOTPATH C:\IFMXDATA\ol_ybluo\rootdbs_dat.000 # Path for device containing root dbspace
ROOTOFFSET 0 # Offset of root dbspace into device (Kbytes)
ROOTSIZE 51200 # Size of root dbspace (Kbytes)
# Disk Mirroring Configuration Parameters
MIRROR 1 # Mirroring flag (Yes = 1, No = 0)
MIRRORPATH D:\IFMXDATA\ol_ybluo\rootdbs_mirr.000 # Path for device containing mirrored root
MIRROROFFSET 0 # Offset into mirrored device (Kbytes)
# Physical Log Configuration
PHYSDBS phydbs # Location (dbspace) of physical log
PHYSFILE 102400 # Physical log file size (Kbytes)
# Logical Log Configuration
LOGFILES 6 # Number of logical log files
LOGSIZE 2000 # Logical log size (Kbytes)
LOG_BACKUP_MODE CONT # Logical log backup mode (MANUAL, CONT)
# Diagnostics
MSGPATH C:\PROGRA~1\Informix\ol_ybluo.log # System message log file path
CONSOLE C:\PROGRA~1\Informix\conol_ybluo.log # System console message path
# To automatically backup logical logs, edit alarmprogram.bat and set
# BACKUPLOGS=Y
ALARMPROGRAM C:\PROGRA~1\Informix\etc\alarmprogram.bat # Alarm program path
TBLSPACE_STATS 1 # Maintain tblspace statistics
# System Diagnostic Script.
# SYSALARMPROGRAM - Full path of the system diagnostic script (e.g.
# c:\informix\etc\evidence.bat.) Set this parameter
# if you want a different Diagnostic Script than
# {INFORMIXDIR}\etc\evidence.bat, which is default.
# System Archive Tape Device
TAPEDEV NULL # Tape device path
TAPEBLK 16 # Tape block size (Kbytes)
TAPESIZE 10240 # Maximum amount of data to put on tape (Kbytes)
# Log Archive Tape Device
LTAPEDEV NUL # Log tape device path
LTAPEBLK 16 # Log tape block size (Kbytes)
LTAPESIZE 10240 # Max amount of data to put on log tape (Kbytes)
# Optical
STAGEBLOB # Informix Dynamic Server/Optical staging area
OPTICAL_LIB_PATH # Location of Optical Subsystem driver DLL
# System Configuration
SERVERNUM 0 # Unique id corresponding to a server instance
DBSERVERNAME ol_ybluo # Name of default Dynamic Server
DBSERVERALIASES # List of alternate dbservernames
NETTYPE onsoctcp,1,,NET # Override sqlhosts nettype parameters
DEADLOCK_TIMEOUT 60 # Max time to wait of lock in distributed env.
RESIDENT 1 # Forced residency flag (Yes = 1, No = 0)
MULTIPROCESSOR 0 # 0 for single-processor, 1 for multi-processor
NUMCPUVPS 1 # Number of user (cpu) vps
SINGLE_CPU_VP 0 # If non-zero, limit number of cpu vps to one
NOAGE 0 # Process aging
AFF_SPROC 0 # Affinity start processor
AFF_NPROCS 0 # Affinity number of processors
# Shared Memory Parameters
LOCKS 100000 # Maximum number of locks
BUFFERS 24576 # Maximum number of shared buffers
NUMAIOVPS 2 # Number of IO vps
PHYSBUFF 32 # Physical log buffer size (Kbytes)
LOGBUFF 32 # Logical log buffer size (Kbytes)
CLEANERS 2 # Number of buffer cleaner processes
SHMBASE 0xC000000L # Shared memory base address
SHMVIRTSIZE 73728 # initial virtual shared memory segment size
SHMADD 16384 # Size of new shared memory segments (Kbytes)
SHMTOTAL 0 # Total shared memory (Kbytes). 0=>unlimited
CKPTINTVL 300 # Check point interval (in sec)
LRUS 8 # Number of LRU queues
LRU_MAX_DIRTY 80 # LRU percent dirty begin cleaning limit
LRU_MIN_DIRTY 70 # LRU percent dirty end cleaning limit
TXTIMEOUT 300 # Transaction timeout (in sec)
STACKSIZE 64 # Stack size (Kbytes)
# Dynamic Logging
# DYNAMIC_LOGS:
# 2 : server automatically add a new logical log when necessary. (ON)
# 1 : notify DBA to add new logical logs when necessary. (ON)
# 0 : cannot add logical log on the fly. (OFF)
#
# When dynamic logging is on, we can have higher values for LTXHWM/LTXEHWM,
# because the server can add new logical logs during long transaction rollback.
# However, to limit the number of new logical logs being added, LTXHWM/LTXEHWM
# can be set to smaller values.
#
# If dynamic logging is off, LTXHWM/LTXEHWM need to be set to smaller values
# to avoid long transaction rollback hanging the server due to lack of logical
# log space, i.e. 50/60 or lower.
DYNAMIC_LOGS 2
LTXHWM 70
LTXEHWM 80
# System Page Size
# BUFFSIZE - Dynamic Server no longer supports this configuration parameter.
# To determine the page size used by Dynamic Server on your platform
# see the last line of output from the command, 'onstat -b'.
# Recovery Variables
# OFF_RECVRY_THREADS:
# Number of parallel worker threads during fast recovery or an offline restore.
# ON_RECVRY_THREADS:
# Number of parallel worker threads during an online restore.
OFF_RECVRY_THREADS 10 # Default number of offline worker threads
ON_RECVRY_THREADS 1 # Default number of online worker threads
# Data Replication Variables
DRINTERVAL 30 # DR max time between DR buffer flushes (in sec)
DRTIMEOUT 30 # DR network timeout (in sec)
DRLOSTFOUND \tmp # DR lost+found file path
# CDR Variables
CDR_EVALTHREADS 1,2 # evaluator threads (per-cpu-vp,additional)
CDR_DSLOCKWAIT 5 # DS lockwait timeout (seconds)
CDR_QUEUEMEM 4096 # Maximum memory for any CDR queue (Kbytes)
CDR_QHDR_DBSPACE # CDR queue dbspace (default same as catalog)
CDR_QDATA_SBSPACE # CDR queue smart blob space
CDR_QDATA_SBFLAGS 2 # Log/no-log (default no log)
CDR_NIFCOMPRESS 0 # Link level compression (-1 never, 0 none, 9 max)
# Backup/Restore variables
BAR_ACT_LOG C:\PROGRA~1\Informix\bar_ol_ybluo.log #Path of log file for onbar.exe
BAR_MAX_BACKUP 0
BAR_RETRY 1
BAR_NB_XPORT_COUNT 10
BAR_XFER_BUF_SIZE 15
BAR_BSALIB_PATH C:\ISM\2.20\bin\libbsa.dll # Location of ISM XBSA DLL
RESTARTABLE_RESTORE ON #To support restartable restore..values on/off
# Informix Storage Manager variables
ISM_DATA_POOL ISMData
ISM_LOG_POOL ISMLogs
# Read Ahead Variables
RA_PAGES 128 # Number of pages to attempt to read ahead
RA_THRESHOLD 120 # Number of pages left before next group
# DBSPACETEMP:
# Dynamic Server equivalent of DBTEMP for SE. This is the list of dbspaces
# that the Dynamic Server SQL Engine will use to create temp tables etc.
# If specified it must be a colon separated list of dbspaces that exist
# when the Dynamic Server system is brought online. If not specified, or if
# all dbspaces specified are invalid, various ad hoc queries will create
# temporary files in /tmp instead.
DBSPACETEMP oltempdbs # Default temp dbspaces
# DUMP*:
# The following parameters control the type of diagnostics information which
# is preserved when an unanticipated error condition (assertion failure) occurs
# during Dynamic Server operations.
# For DUMPSHMEM, DUMPGCORE and DUMPCORE 1 means Yes, 0 means No.
DUMPDIR C:\tmp # Preserve diagnostics in this directory
DUMPSHMEM 1 # Dump a copy of shared memory
DUMPGCORE 0 # Dump a core image using 'gcore'
DUMPCORE 0 # Dump a core image (Warning:this aborts Dynamic
Server)
DUMPCNT 1 # Number of shared memory or gcore dumps for
# a single user's session
FILLFACTOR 90 # Fill factor for building indexes
# method for Dynamic Server to use when determining current time
USEOSTIME 0 # 0: use internal time(fast), 1: get time from OS(slow)
# Parallel Database Queries (pdq)
MAX_PDQPRIORITY 100 # Maximum allowed pdqpriority
DS_MAX_QUERIES 32 # Maximum number of decision support queries
DS_TOTAL_MEMORY 4096 # Decision support memory (Kbytes)
DS_MAX_SCANS 1048576 # Maximum number of decision support scans
DATASKIP # List of dbspaces to skip
# OPTCOMPIND
# 0 => Nested loop joins will be preferred (where
# possible) over sortmerge joins and hash joins.
# 1 => If the transaction isolation mode is not
# "repeatable read", optimizer behaves as in (2)
# below. Otherwise it behaves as in (0) above.
# 2 => Use costs regardless of the transaction isolation
# mode. Nested loop joins are not necessarily
# preferred. Optimizer bases its decision purely
# on costs.
OPTCOMPIND 2 # To hint the optimizer
DIRECTIVES 1 # Optimizer DIRECTIVES ON (1/Default) or OFF (0)
ONDBSPACEDOWN 2 # Dbspace down option: 0 = CONTINUE, 1 = ABORT, 2 = WAIT
OPCACHEMAX 0 # Maximum optical cache size (Kbytes)
# HETERO_COMMIT (Gateway participation in distributed transactions)
# 1 => Heterogeneous Commit is enabled
# 0 (or any other value) => Heterogeneous Commit is disabled
HETERO_COMMIT 0
SBSPACENAME sbspace # Default sbspace
BLOCKTIMEOUT 3600 # Default timeout for system block
# Optimization goal: -1 = ALL_ROWS(Default), 0 = FIRST_ROWS
OPT_GOAL -1
ALLOW_NEWLINE 0 # embedded newlines(Yes = 1, No = 0 or anything but 1)
SYSSBSPACENAME sbspace # Default System sbspace
#
# The following are default settings for enabling Java in the database.
#
#VPCLASS jvp,num=1 # Number of JVPs to start with
JVPJAVAHOME C:\PROGRA~1\Informix\extend\krakatoa\jre # JDK installation root directory
JVPHOME C:\PROGRA~1\Informix\extend\krakatoa # Krakatoa installation directory
JVPLOGFILE C:\PROGRA~1\Informix\extend\krakatoa\ol_ybluo_jvp.log # VP log file
JVPPROPFILE C:\PROGRA~1\Informix\extend\krakatoa\.jvpprops_ol_ybluo # JVP property file
JDKVERSION 1.3 # JDK version supported by this server
# The path to the JRE libraries relative to JVPJAVAHOME
JVPJAVALIB \bin\
JVPJAVAVM hpi;server;verify;java;net;zip;jpeg
# Classpath to use upon Java VM start-up (use _g version for debugging)
JVPCLASSPATH C:\PROGRA~1\Informix\extend\krakatoa\krakatoa.jar;C:\PROGRA~1\Informix\extend\krakatoa\jdbc.jar
