 |
IDS Forum
Re: oninit fail to start up
Posted By: Keith Simmons
Date: Friday, 23 November 2007, at 4:32 a.m.
In Response To: oninit fail to start up (YUEBIN LUO)
With all these changes to the parameteres recorded in the log I would
say your environment is incorrect, you are pointing at the default
onconfig file and not the one that should be starting this engine.
Check the bat file for starting the engine.
Keith
On 23/11/2007, YUEBIN LUO <luoyuebin@yahoo.com.cn> wrote:
> 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
>
>
> *******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
Messages In This Thread
IDS Forum is maintained by Administrator with WebBBS 5.12.
|
|
