oninit use 95+%cpu

(If you already saw this email many times, I have to say sorry. I keep sending but could not retrieve my email and response in IIUG.) Hi, Thanks for all the responses. You guys are so great!! We research more and found at that time there is one sql statement is running: select count(*) from tableA where col1=a andcol2=b and col3=c and col4=d; This sql usually returns 2 to 3, or even 0. At the mean time, another session is trying to delete around 200 rows, including the first guy's rows: delete from tableA where col1=a and col2=b;Both statement isolation level were committed read. I don't know if this is the reason. message log ============ 10:02:32 Checkpoint Completed: duration was 0 seconds. 10:07:40 Checkpoint Completed: duration was 3 seconds. 10:12:48 Checkpoint Completed: duration was 5 seconds. 10:17:56 Checkpoint Completed: duration was 5 seconds. 10:23:04 Checkpoint Completed: duration was 5 seconds. 10:26:11 Logical Log 886 Complete. 10:28:16 Checkpoint Completed: duration was 8 seconds. 10:33:27 Checkpoint Completed: duration was 7 seconds. 10:38:36 Checkpoint Completed: duration was 5 seconds. 12:43:51 The Master Daemon Died 12:43:51 PANIC: Attempting to bring system down ...... then recycle database ONCONFIG =========== Informix Dynamic Server Version 7.31.UC2A -- On-Line -- Up 1 days 03:19:09 -- 1 18704 Kbytes Configuration File: /opt/informix/etc/onconfig.fmdsgm #************************************************* ************************* # # INFORMIX SOFTWARE, INC. # # Title: onconfig.std # Description: INFORMIX-OnLine Configuration Parameters # #************************************************* ************************* # Root Dbspace Configuration ROOTNAME fmd_rootdbs # Root dbspacename ROOTPATH /dev/informix/fmd_rootdbs # Path for root dbspace ROOTOFFSET 0 # Offset of rootdbspace into device (Kbytes) ROOTSIZE 10000 # Size of root dbspace (Kbytes) # Disk Mirroring Configuration Parameters MIRROR 0 # Mirroring flag (Yes = 1, No = 0) MIRRORPATH # Path for devicecontaining mirrored root MIRROROFFSET 0 # Offset intomirrored device (Kbytes) # Physical Log Configuration PHYSDBS fmd_phys # Location (dbspace) of physical log PHYSFILE 20000 # Physical log file size (Kbytes) # Logical Log Configuration LOGFILES 22 LOGSIZE 1000 # Logical log size (Kbytes) # Diagnostics MSGPATH /opt/informix/online.log # System message log file path CONSOLE /dev/console # System consolemessage path ALARMPROGRAM /opt/informix/etc/no_log.sh # Alarm program path # System Archive Tape Device TAPEDEV /sgm/DBbackups/backupdb # Tape device path TAPEBLK 16 # Tape block size (Kbytes) TAPESIZE 2000000 # Maximum amountof data to put on tape (Kbytes) # Log Archive Tape Device LTAPEDEV /sgm/DBbackups/backuplog # Log tape device path LTAPEBLK 16 # Log tape block size (Kbytes) LTAPESIZE 1000000 # Max amount ofdata to put on log tape (Kbytes) # Optical STAGEBLOB # INFORMIX-OnLine/Optical staging area # System Configuration SERVERNUM 1 # Unique idcorresponding to a OnLine instance #SERVERNUM 101 # Unique id corresponding to a OnLine instance DBSERVERNAME fmdsgm # Name of defaultdatabase server DBSERVERALIASES fmdsgm_tcp # List ofalternate dbservernames DEADLOCK_TIMEOUT 60 # Max time towait of lock in distributed env. RESIDENT 1 # Forced residency flag (Yes = 1, No = 0) MULTIPROCESSOR 0 # 0 forsingle-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 startprocessor AFF_NPROCS 0 # Affinity numberof processors # Shared Memory Parameters LOCKS 300000 # Maximum numberof locks BUFFERS 40000 # Maximum numberof shared buffers NUMAIOVPS 6 # Number of IO vps PHYSBUFF 32 # Physical log buffer size (Kbytes) LOGBUFF 32 # Logical log buffer size (Kbytes) LOGSMAX 50 # Maximum numberof logical log files CLEANERS 3 # Number of buffercleaner processes SHMBASE 0x0 # Shared memorybase address SHMVIRTSIZE 16000 # initial virtualshared memory segment size SHMADD 8192 # Size of newshared memory segments (Kbytes) SHMTOTAL 0 # Total shared memory (Kbytes). 0=>unlimited CKPTINTVL 300 # Check point interval (in sec) LRUS 8 # Number of LRUqueues LRU_MAX_DIRTY 60 # LRU percentdirty begin cleaning limit LRU_MIN_DIRTY 50 # LRU percentdirty end cleaning limit LTXHWM 50 # Long transactionhigh water mark percentage LTXEHWM 60 # Long transactionhigh water mark (exclusive) TXTIMEOUT 0x12c # Transaction timeout (in sec) STACKSIZE 32 # Stack size (Kbytes) # System Page Size # BUFFSIZE - OnLine no longer supports this configuration parameter. # To determine the page size used by OnLine 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 # Defaultnumber of offline worker threads ON_RECVRY_THREADS 1 # Default numberof online worker threads # Data Replication Variables # DRAUTO: 0 manual, 1 retain type, 2 reverse type DRAUTO 0 # DR automaticswitchover DRINTERVAL 30 # DR max timebetween DR buffer flushes (in sec) DRTIMEOUT 30 # DR network timeout (in sec) DRLOSTFOUND /dev/null # DR lost+foundfile path # Read Ahead Variables RA_PAGES # Number of pagesto attempt to read ahead RA_THRESHOLD # Number of pagesleft before next group # DBSPACETEMP: # OnLine equivalent of DBTEMP for SE. This is the list of dbspaces # that the OnLine SQL Engine wi