HELP: Informix doesn't come up anymore
Tim
your help is greatly appreciated on this matter !!
Yesterady somebody rebooted the NT server in the middle of an import.
When starting oninit, we get following error:
the af.xxxx file
12:26:32
12:26:32 Informix Dynamic Server Version 7.31.TC2 Software Serial Number
AAC#J726137
12:26:32 Assert Failed: No Exception Handler
12:26:32 Who: Session(2, informix@, 0, 0)
Thread(7, soctcppoll, 0, 7)
Exception at Addr: 0x77f64ab3, TOS: 0x25561ca8, FP:0x25561d60, Exc: c0000005
12:26:32 Results: Exception Caught. Type: MT_EX_OS, Context: mem
12:26:32 Action: Please notify Informix Technical Support.
---------------------------------
Begin System Alarm Program Output
---------------------------------
+-+-+-+-+-+-+-+-+-+-+-+-+-+
SYSALARMPROG Debug Info ON
+-+-+-+-+-+-+-+-+-+-+-+-+-+
Arguments:
AF_CLASS = 3
AF_ID =
AF_FILE = \tmp\af.3ef9958
SES_ID = 2
RSTCB = 0x0
THREAD_ID = 7
TCB = 0x254f2d00
BITMASK = 513
AF_DIR = \tmp
Bits on:
Global settings:
BLOCK_SYSTEM = off
DIAG_AFWARN = off
WRITE_TO_CONSOLE = off
DBA = informix
SEND_DBA_MAIL = off
RAS = rasn...@informix.com
SEND_RAS_MAIL = off
COMPRESS = "None"
COMPRESS_SUFFIX =
DO_ONSTAT_G_ALL = off
DO_ONSTAT_A = off
PRINT_POOL = off
SHORT_BLOCK_TIME = 600
LONG_BLOCK_TIME = 3600
CONSOLE =
DUMPDIR = \tmp
IBIN = E:\INFORMIX\bin
ONSTAT = E:\INFORMIX\bin\onstat
ONCHECK = E:\INFORMIX\bin\oncheck
ONMODE = E:\INFORMIX\bin\onmode
Host Name: BAAN
Database Server Name: ol_baan
Date and Time of failure:
The current date is: Sat 05/03/2003
The current time is: 12:26:33.50
Shared memory file: "None"
===========------------- - - - - - -
onstat -m:
Informix Dynamic Server Version 7.31.TC2 -- Fast Recovery -- Up 00:00:16 --
347584 Kbytes
Message Log File: E:\informix\online.log
12:14:35 Checkpoint Completed: duration was 0 seconds.
12:14:44 See Also: af.3ef9683, shmem.3ef9683.0
12:16:49 , line -1, thread 7, proc id 185, No Exception Handler.
12:16:49 PANIC: Attempting to bring system down
Sat May 03 12:26:26 2003
12:26:26 DR: DRAUTO is 0 (Off)
12:26:32 Informix Dynamic Server Version 7.31.TC2 Software Serial Number
AAC#J726137
12:26:32 Assert Failed: No Exception Handler
12:26:32 Informix Dynamic Server Version 7.31.TC2
12:26:32 Who: Session(2, informix@, 0, 0)
Thread(7, soctcppoll, 0, 7)
Exception at Addr: 0x77f64ab3, TOS: 0x25561ca8, FP:0x25561d60, Exc: c0000005
12:26:32 Results: Exception Caught. Type: MT_EX_OS, Context: mem
12:26:32 Action: Please notify Informix Technical Support.
12:26:33 Informix Dynamic Server Initialized -- Shared Memory Initialized.
12:26:33 Physical Recovery Started.
12:26:33 Physical Recovery Complete: 0 Pages Restored.
12:26:33 Logical Recovery Started.
===========------------- - - - - - -
E:\INFORMIX\bin\onstat -g ath: 7
Informix Dynamic Server Version 7.31.TC2 -- Fast Recovery -- Up 00:00:17 --
347584 Kbytes
Threads:
tid tcb rstcb prty status vp-class name
2 2549ebe8 0 2 sleeping forever 3lio lio vp 0
3 2549ee58 0 2 sleeping forever 4pio pio vp 0
4 2549f0c8 0 2 sleeping forever 5aio aio vp 0
5 2549f338 0 2 sleeping forever 6msc msc vp 0
6 254f2230 253ba018 4 sleeping secs: 1 1cpu main_loop()
7 254f2d00 0 2 running 7soc soctcppoll
8 254f3548 0 2 running 8soc soctcpio
9 254f3d40 0 3 sleeping forever 1cpu soctcplst
10 2552a458 253ba500 2 sleeping forever 1cpu flush_sub(0)
11 2552a678 253ba9e8 2 sleeping forever 1cpu flush_sub(1)
12 2552a8c0 253baed0 2 sleeping forever 1cpu flush_sub(2)
13 2552ab08 253bb3b8 2 sleeping forever 1cpu flush_sub(3)
14 2552ad50 0 4 sleeping forever 5aio kaio
15 2552b300 0 4 sleeping forever 1cpu kaio
16 2552e278 253bb8a0 3 sleeping forever 1cpu aslogflush
17 2552e588 253bbd88 2 sleeping secs: 59 1cpu btclean
18 2552e910 253bc270 2 ready 1cpu fast_rec
18 2552e910 253bc270 2 running 1cpu fast_rec
19 2552ee88 253bc758 2 sleeping secs: 1 1cpu bld_logrecs
20 2552f0d0 253bcc40 2 cond wait packet_con 1cpu logredo
21 2552f870 253bd128 2 cond wait packet_con 1cpu xchg_1.0
22 2552fab8 253bd610 2 cond wait packet_con 1cpu xchg_1.1
23 2552fd00 253bdaf8 2 cond wait packet_con 1cpu xchg_1.2
24 2549f5a8 253bdfe0 2 cond wait packet_con 1cpu xchg_1.3
25 2549f750 253be4c8 2 cond wait packet_con 1cpu xchg_1.4
26 2549f970 253be9b0 2 cond wait packet_con 1cpu xchg_1.5
27 2549fbb8 253bee98 2 cond wait packet_con 1cpu xchg_1.6
28 2549fe00 253bf380 2 cond wait packet_con 1cpu xchg_1.7
29 254ba2a0 253bf868 2 cond wait packet_con 1cpu xchg_1.8
30 254ba4c0 253bfd50 2 cond wait packet_con 1cpu xchg_1.9
31 254bae98 253c0238 2 sleeping secs: 1 1cpu xchg_2.0
===========------------- - - - - - -
E:\INFORMIX\bin\onstat -g stk 7 light:
Informix Dynamic Server Version 7.31.TC2 -- Fast Recovery -- Up 00:00:17 --
347584 Kbytes
Stack for thread: 7 soctcppoll
base: 0x2555e018
len: 16896
pc: 0x00697f60
tos: 0x2556200c
state: running
vp: 7
0xfffffff0 (***nosymtab***)0xfffffff0
===========------------- - - - - - -
E:\INFORMIX\bin\onstat -u: 2
Informix Dynamic Server Version 7.31.TC2 -- Fast Recovery -- Up 00:00:18 --
347584 Kbytes
Userthreads
address flags sessid user tty wait tout locks nreads nwrites
253ba018 ---P-RD 1 informix - 0 0 0 23 0
253ba500 ---P--F 0 informix - 0 0 0 0 0
253ba9e8 ---P--F 0 informix - 0 0 0 0 0
253baed0 ---P--F 0 informix - 0 0 0 0 0
253bb3b8 ---P--F 0 informix - 0 0 0 0 0
253bb8a0 ---P--- 6 informix - 0 0 0 0 0
253bbd88 ---P--B 7 informix - 0 0 0 0 0
253bc270 ---P-RD 8 informix - 0 0 0 19 0
253bcc40 Y----RD 8 informix - 2552f400 0 0 0 0
253bd128 Y----RD 8 informix - 254baa28 0 0 0 0
253bd610 Y----RD 8 informix - 254ba9e0 0 0 0 0
253bdaf8 Y----RD 8 informix - 254ba998 0 0 0 0
253bdfe0 Y----RD 8 informix - 254ba950 0 0 0 0
253be4c8 Y----RD 8 informix - 254ba908 0 0 0 0
253be9b0 Y----RD 8 informix - 254ba8c0 0 0 0 0
253bee98 Y----RD 8 informix - 254ba878 0 0 0 0
253bf380 Y----RD 8 informix - 254ba830 0 0 0 0
253bf868 Y----RD 8 informix - 254ba7e8 0 0 0 0
253bfd50 Y----RD 8 informix - 254ba7a0 0 0 0 0
253c0238 -----RD 8 informix - 0 0 0 0 0
20 active, 128 total, 0 maximum concurrent
===========------------- - - - - - -
E:\INFORMIX\bin\onstat -g ses 2:
Informix Dynamic Server Version 7.31.TC2 -- Fast Recovery -- Up 00:00:18 --
347584 Kbytes
session #RSAM total used
id user tty pid hostname threads memory memory
2 informix - 0 - 0 8192 5560
Memory pools count 1
name class addr totalsize freesize #allocfrag #freefrag
2 V 25546018 8192 2632 9 1
name free used name free used
overhead 0 120 scb 0 96
gentcb 0 544 ostcb 0 40
sqscb 0 4712 fragman 0 48
===========------------- - - - - - -
E:\INFORMIX\bin\onstat -g sql 2:
Informix Dynamic Server Version 7.31.TC2 -- Fast Recovery -- Up 00:00:19 --
347584 Kbytes
===========------------- - - - - - -
E:\INFORMIX\bin\onstat -c:
Informix Dynamic Server Version 7.31.TC2 -- Fast Recovery -- Up 00:00:19 --
347584 Kbytes
Configuration File: E:\INFORMIX/etc/ONCONFIG.ol_baan
#**************************************************************************
#
# INFORMIX SOFTWARE, INC.
#
# Title: onconfig.std
# Description: INFORMIX-OnLine Configuration Parameters
#
#**************************************************************************
# Root Dbspace Configuration
ROOTNAME rootdbs # Root dbspace name
ROOTPATH E:\IFMXDATA\ol_baan\rootdbs_dat.000 # Path for device containing
root dbspace
# Path for device containing root dbspace
ROOTOFFSET 0 # Offset of root dbspace into device (Kbytes)
ROOTSIZE 20480 # 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 baandb_plog # Location (dbspace) of physical log
PHYSFILE 204800 # Physical log file size (Kbytes)
# Logical Log Configuration
LOGFILES 80 # Number of logical log files
LOGSIZE 5000 # Logical log size (Kbytes)
# Diagnostics
MSGPATH E:\informix\online.log # System message log file path
CONSOLE E:\informix\console.log # System console message path
ALARMPROGRAM # Alarm program path
# System Archive Tape Device
#TAPEDEV F:\backup\alldb.tap # Tape device path
TAPEDEV NUL # Tape device path
TAPEBLK 16 # Tape block size (Kbytes)
TAPESIZE 4190140 # Maximum amount of data to put on tape (Kbytes)
# Log Archive Tape Device
#LTAPEDEV F:\backupl\allarch.tap # Log tape device path
LTAPEDEV NUL # Log Tape device path
LTAPEBLK 16 # Log tape block size (Kbytes)
LTAPESIZE 4190140 # Max amount of data to put on log tape (Kbytes)
# Optical
STAGEBLOB ,1 # INFORMIX-OnLine/Optical staging area
# System Configuration
SERVERNUM 0 # Unique id corresponding to a OnLine instance
DBSERVERNAME ol_baan # Name of default Dynamic Server
DBSERVERALIASES # List of alternate dbservernames
NETTYPE soctcp,1,100,NET # Override sqlhosts nettype parameters
DEADLOCK_TIMEOUT 60 # Max time to wait of lock in distributed env.
RESIDENT 0 # Forced residency flag (Yes = 1, No = 0)
MULTIPROCESSOR 1 # 0 for single-processor, 1 for multi-processor
NUMCPUVPS 1 # 2 ; Number of user (cpu) vps
SINGLE_CPU_VP 1 # 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 50000 # Maximum number of locks
BUFFERS 20000 # old 13086; Maximum number of shared buffers
NUMAIOVPS 1 # Number of IO vps
PHYSBUFF 32 # Physical log buffer size (Kbytes)
LOGBUFF 32 # Logical log buffer size (Kbytes)
LOGSMAX 115 # Maximum number of logical log files
CLEANERS 4 # old 1 ; Number of buffer cleaner processes
SHMBASE 0x20000000 # Shared memory base address
# SHMBASE 0xC000000L # Shared memory base address
SHMVIRTSIZE 262144 # initial virtual shared memory segment size
SHMADD 32768 # Size of new shared memory segments (Kbytes)
SHMTOTAL 0 # Total shared memory (Kbytes). 0=>unlimited
CKPTINTVL 300 # Check point interval (in sec)
LRUS 30 # old 8 ; Number of LRU queues
LRU_MAX_DIRTY 3 # old 2 ; LRU percent dirty begin cleaning limit
LRU_MIN_DIRTY 1 # LRU percent dirty end cleaning limit
LTXHWM 50 # Long transaction high water mark percentage
LTXEHWM 60 # Long transaction high 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 # Default number of offline worker threads
ON_RECVRY_THREADS 1 # Default number of online worker threads
# Data Replication Variables
# DRAUTO: 0 manual, 1 retain type, 2 reverse type
DRAUTO 0 # DR automatic switchover
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_LOGBUFFERS 2048 # size of log reading buffer pool (Kbytes)
CDR_EVALTHREADS 1,2 # evaluator threads (per-cpu-vp,additional)
CDR_DSLOCKWAIT 5 # DS lockwait timeout (seconds)
CDR_QUEUEMEM 4096 # Maximum amount of memory for any CDR queue (Kbytes)
# Backup/Restore variables
BAR_ACT_LOG E:\informix\bar_act.log #Path of log file for onbar.exe
BAR_MAX_BACKUP 1
BAR_RETRY 1
BAR_NB_XPORT_COUNT 10
BAR_XFER_BUF_SIZE 15
# Read Ahead Variables
RA_PAGES 1 # Number of pages to attempt to read ahead
RA_THRESHOLD # Number of pages left before next group
# DBSPACETEMP:
# OnLine equivalent of DBTEMP for SE. This is the list of dbspaces
# that the OnLine SQL Engine will use to create temp tables etc.
# If specified it must be a colon separated list of dbspaces that exist
# when the OnLine 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 baandb_tmp # 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 OnLine operations.
# For DUMPSHMEM, DUMPGCORE and DUMPCORE 1 means Yes, 0 means No.
DUMPDIR \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 OnLine)
DUMPCNT 1 # Number of shared memory or gcore dumps for
# a single user's session
# ADT*
# ADT* parameters moved to adtcfg file
FILLFACTOR 60 # Fill factor for building indexes
# method for OnLine to use when determining current time
USEOSTIME 0 # 0: use internal time(fast), 1: get time from OS(slow)
# Parallel Database Queries (pdq)
# OFF => 0, LOW => 1, HIGH => 100
MAX_PDQPRIORITY 100 # Maximum allowed pdqpriority
DS_MAX_QUERIES 1 # Maximum number of decision support queries
DS_TOTAL_MEMORY 2048 # Decision support memory (Kbytes)
DS_MAX_SCANS 10 # Maximum number of decision support scans
DATASKIP off # 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 0 # To hint the optimizer
ONDBSPACEDOWN 0 # Dbspace down option: 0 = CONTINUE, 1 = ABORT, 2 = WAIT
LBU_PRESERVE 0 # Preserve last log for log backup
DD_HASHSIZE 83
DD_HASHMAX 511
BAR_BSALIB_PATH E:\ISM\2.20\bin\libbsa.dll # Location of ISM XBSA DLL
===========------------- - - - - - -
*:
E:\INFORMIX\bin\onstat -s:
Informix Dynamic Server Version 7.31.TC2 -- Fast Recovery -- Up 00:00:19 --
347584 Kbytes
Latches with lock or userthread set
name address lock wait userthread
===========------------- - - - - - -
E:\INFORMIX\bin\onstat -k:
Informix Dynamic Server Version 7.31.TC2 -- Fast Recovery -- Up 00:00:19 --
347584 Kbytes
Locks
address wtlist owner lklist type tblsnum rowid key#/bsiz
0 active, 50000 total, 32768 hash buckets
===========------------- - - - - - -
E:\INFORMIX\bin\onstat -b:
Informix Dynamic Server Version 7.31.TC2 -- Fast Recovery -- Up 00:00:20 --
347584 Kbytes
Buffers
address userthread flgs pagenum memaddr nslots pgflgs xflgs owner waitlist
5 modified, 0 resident, 20000 total, 32768 hash buckets, 4096 buffer size
===========------------- - - - - - -
E:\INFORMIX\bin\onstat -t:
Informix Dynamic Server Version 7.31.TC2 -- Fast Recovery -- Up 00:00:20 --
347584 Kbytes
Tblspaces
n address flgs ucnt tblnum physaddr npages nused npdata nrows nextns
resident
1 253b99f8 0 1 100001 10000e 150 150 0 0 3 0
2 253b9d40 0 1 200001 200004 50 2 0 0 1 0
3 253e1430 0 1 300001 300004 120800 120800 0 0 115 0
4 253e1ab8 0 1 400001 400004 50 2 0 0 1 0
5 253e1dc8 0 1 500001 500004 50 2 0 0 1 0
6 253ec950 0 1 600001 600004 50 2 0 0 1 0
7 253ed2a0 0 1 700001 e00004 450 411 0 0 9 0
8 253ed538 0 1 800001 f00004 1000 1000 0 0 18 0
8 active, 8 total
===========------------- - - - - - -
E:\INFORMIX\bin\onstat -d:
Informix Dynamic Server Version 7.31.TC2 -- Fast Recovery (CKPT REQ) -- Up
00:00:20 -- 347584 Kbytes
Blocked:CKPT
Dbspaces
address number flags fchunk nchunks flags owner name
253b8150 1 1 1 1 N informix rootdbs
253b9248 2 1 2 1 N informix ol_baan
253b9308 3 1 3 8 N informix baandb_dbs
253b93c8 4 1 4 1 N informix baandb_plog
253b9488 5 1 5 1 N informix baandb_llog
253b9548 6 2001 6 1 N T informix baandb_tmp
253b9608 7 1 14 1 N informix baandb_000
253b96c8 8 1 15 3 N informix baandb_100
8 active, 2047 maximum
Chunks
address chk/dbs offset size free bpages flags pathname
253b8210 1 1 0 5120 3761 PO- E:\IFMXDATA\ol_baan\rootdbs_dat.000
253b84c8 2 2 0 12800 12747 PO- E:\IFMXDATA\ol_baan\ol_baan_dat.000
253b85a0 3 3 0 512000 333588 PO- F:\informix\Dbspaces\baandb.dbs
253b8678 4 4 0 52480 1227 PO- E:\informix\Dbspaces\baandbplog
253b8750 5 5 0 104960 2507 PO- C:\informix\Dbspaces\baandbllog
253b8828 6 6 0 51200 51147 PO- C:\informix\Dbspaces\baandbtmp
253b8900 7 3 0 512000 313603 PO- F:\IFMXDATA\ol_baan\baandb_dbs_dat.001
253b89d8 8 3 0 524032 175780 PO- F:\IFMXDATA\ol_baan\baandb_dbs_dat.000
253b8ab0 9 3 0 500000 48433 PO- f:\ifmxdata\ol_baan\baandb_dbs_dat.002
253b8b88 10 3 0 128000 181 PO- f:\ifmxdata\ol_baan\baandb_dbs_dat.003
253b8c60 11 3 0 512000 121061 PO- f:\ifmxdata\ol_baan\baandb_dbs_dat.004
253b8d38 12 3 0 512000 471275 PO- f:\ifmxdata\ol_baan\baandb_dbs_dat.005
253b8e10 13 3 0 500000 498793 PO- f:\ifmxdata\ol_baan\baandb_dbs_dat.006
253b8ee8 14 7 0 512000 89891 PO- f:\ifmxdata\ol_baan\baandb_000_dat.000
253b8fc0 15 8 0 512000 229829 PO- f:\ifmxdata\ol_baan\baandb_100_dat.000
253b9098 16 8 0 512000 511997 PO- f:\ifmxdata\ol_baan\baandb_100_dat.001
253b9170 17 8 0 512000 511997 PO- f:\ifmxdata\ol_baan\baandb_100_dat.002
17 active, 2047 maximum
===========------------- - - - - - -
E:\INFORMIX\bin\onstat -l:
Informix Dynamic Server Version 7.31.TC2 -- Fast Recovery (CKPT REQ) -- Up
00:00:20 -- 347584 Kbytes
Blocked:CKPT
Physical Logging
Buffer bufused bufsize numpages numwrits pages/io
P-1 0 8 0 0 0.00
phybegin physize phypos phyused %used
400035 51200 8614 0 0.00
Logical Logging
Buffer bufused bufsize numrecs numpages numwrits recs/pages pages/io
L-1 0 8 0 0 0 0.0 0.0
Subsystem numrecs Log Space used
address number flags uniqid begin size used %used
20313388 16 U-B---- 62496 500035 1280 1280 100.00
203133a4 17 U-B---- 62497 500535 1280 1280 100.00
203133c0 18 U-B---- 62498 500a35 1280 1280 100.00
203133dc 19 U-B---- 62499 500f35 1280 1280 100.00
203133f8 20 U-B---- 62500 501435 1280 1280 100.00
20313414 21 U-B---- 62501 501935 1280 1280 100.00
20313430 22 U-B---- 62502 501e35 1280 1280 100.00
2031344c 23 U-B---- 62503 502335 1280 1280 100.00
20313468 24 U-B---- 62504 502835 1280 1280 100.00
20313484 25 U-B---- 62505 502d35 1280 1280 100.00
203134a0 26 U-B---- 62506 503235 1280 1280 100.00
203134bc 27 U-B---- 62507 503735 1280 1280 100.00
203134d8 28 U-B---- 62508 503c35 1280 1280 100.00
203134f4 29 U-B---- 62509 504135 1280 1280 100.00
20313510 30 U-B---- 62510 504635 1280 1280 100.00
2031352c 31 U-B---- 62511 504b35 1280 1280 100.00
20313548 32 U-B---- 62512 505035 1280 1280 100.00
20313564 33 U-B---- 62513 505535 1280 1280 100.00
20313580 34 U-B---- 62514 505a35 1280 1280 100.00
2031359c 35 U-B---- 62515 505f35 1280 1280 100.00
203135b8 36 U-B---- 62516 506435 1280 1280 100.00
203135d4 37 U-B---- 62517 506935 1280 1280 100.00
203135f0 38 U-B---- 62518 506e35 1280 1280 100.00
2031360c 39 U-B---- 62519 507335 1280 1280 100.00
20313628 40 U-B---- 62520 507835 1280 1280 100.00
20313644 41 U-B---- 62521 507d35 1280 1280 100.00
20313660 42 U-B---- 62522 508235 1280 1280 100.00
2031367c 43 U-B---- 62523 508735 1280 1280 100.00
20313698 44 U-B---- 62524 508c35 1280 1280 100.00
203136b4 45 U-B---- 62525 509135 1280 1280 100.00
203136d0 46 U-B---- 62526 509635 1280 1280 100.00
203136ec 47 U-B---- 62527 509b35 1280 1280 100.00
20313708 48 U-B---- 62528 50a035 1280 1280 100.00
20313724 49 U-B---- 62529 50a535 1280 1280 100.00
20313740 50 U-B---- 62530 50aa35 1280 1280 100.00
2031375c 51 U-B---- 62531 50af35 1280 1280 100.00
20313778 52 U-B---- 62532 50b435 1280 1280 100.00
20313794 53 U-B---- 62533 50b935 1280 1280 100.00
203137b0 54 U-B---- 62534 50be35 1280 1280 100.00
203137cc 55 U-B---- 62535 50c335 1280 1280 100.00
203137e8 56 U-B---- 62536 50c835 1280 1280 100.00
20313804 57 U-B---- 62537 50cd35 1280 1280 100.00
20313820 58 U-B---- 62538 50d235 1280 1280 100.00
2031383c 59 U-B---- 62539 50d735 1280 1280 100.00
20313858 60 U-B---- 62540 50dc35 1280 1280 100.00
20313874 61 U-B---- 62541 50e135 1280 1280 100.00
20313890 62 U-B---- 62542 50e635 1280 1280 100.00
203138ac 63 U-B---- 62543 50eb35 1280 1280 100.00
203138c8 64 U-B---- 62544 50f035 1280 1280 100.00
203138e4 65 U-B---- 62545 50f535 1280 1280 100.00
20313900 66 U-B---- 62546 50fa35 1280 1280 100.00
2031391c 67 U-B---- 62547 50ff35 1280 1280 100.00
20313938 68 U-B---- 62548 510435 1280 1280 100.00
20313954 69 U-B---- 62549 510935 1280 1280 100.00
20313970 70 U-B---- 62550 510e35 1280 1280 100.00
2031398c 71 U-B---- 62551 511335 1280 1280 100.00
203139a8 72 U-B---- 62552 511835 1280 1280 100.00
203139c4 73 U-B---- 62553 511d35 1280 1280 100.00
203139e0 74 U-B---- 62554 512235 1280 1280 100.00
203139fc 75 U-B---- 62555 512735 1280 1280 100.00
20313a18 76 U-B---- 62556 512c35 1280 1280 100.00
20313a34 77 U---C-L 62557 513135 1280 1079 84.30
20313a50 78 U-B---- 62478 513635 1280 1280 100.00
20313a6c 79 U-B---- 62479 513b35 1280 1280 100.00
20313a88 80 U-B---- 62480 514035 1280 1280 100.00
20313aa4 81 U-B---- 62481 514535 1280 1280 100.00
20313ac0 82 U-B---- 62482 514a35 1280 1280 100.00
20313adc 83 U-B---- 62483 514f35 1280 1280 100.00
20313af8 84 U-B---- 62484 515435 1280 1280 100.00
20313b14 85 U-B---- 62485 515935 1280 1280 100.00
20313b30 86 U-B---- 62486 515e35 1280 1280 100.00
20313b4c 87 U-B---- 62487 516335 1280 1280 100.00
20313b68 88 U-B---- 62488 516835 1280 1280 100.00
20313b84 89 U-B---- 62489 516d35 1280 1280 100.00
20313ba0 90 U-B---- 62490 517235 1280 1280 100.00
20313bbc 91 U-B---- 62491 517735 1280 1280 100.00
20313bd8 92 U-B---- 62492 517c35 1280 1280 100.00
20313bf4 93 U-B---- 62493 518135 1280 1280 100.00
20313c10 94 U-B---- 62494 518635 1280 1280 100.00
20313c2c 95 U-B---- 62495 518b35 1280 1280 100.00
===========------------- - - - - - -
E:\INFORMIX\bin\onstat -p:
Informix Dynamic Server Version 7.31.TC2 -- Fast Recovery (CKPT REQ) -- Up
00:00:20 -- 347584 Kbytes
Blocked:CKPT
Profile
dskreads pagreads bufreads %cached dskwrits pagwrits bufwrits %cached
0 0 0 0.00 0 0 0 0.00
isamtot open start read write rewrite delete commit rollbk
0 0 0 0 0 0 0 0 0
gp_read gp_write gp_rewrt gp_del gp_alloc gp_free gp_curs
0 0 0 0 0 0 0
ovlock ovuserthread ovbuff usercpu syscpu numckpts flushes
0 0 0 0.00 0.00 0 0
bufwaits lokwaits lockreqs deadlks dltouts ckpwaits compress seqscans
0 0 0 0 0 0 0 0
ixda-RA idx-RA da-RA RA-pgsused lchwaits
0 0 0 0 0
===========------------- - - - - - -
E:\INFORMIX\bin\onstat -x:
Informix Dynamic Server Version 7.31.TC2 -- Fast Recovery (CKPT REQ) -- Up
00:00:21 -- 347584 Kbytes
Blocked:CKPT
Transactions
address flags userthread locks log begin isolation retrys coordinator
253e2018 A---- 253ba018 0 0 COMMIT 0
253e2168 A---- 253ba500 0 0 COMMIT 0
253e22b8 A---- 253ba9e8 0 0 COMMIT 0
253e2408 A---- 253baed0 0 0 COMMIT 0
253e2558 A---- 253bb3b8 0 0 COMMIT 0
253e26a8 A---- 253bb8a0 0 0 COMMIT 0
253e27f8 A---- 253bbd88 0 0 COMMIT 0
7 active, 128 total, 0 maximum concurrent
===========------------- - - - - - -
E:\INFORMIX\bin\onstat -f:
Informix Dynamic Server Version 7.31.TC2 -- Quiescent (CKPT REQ) -- Up
00:00:21 -- 347584 Kbytes
Blocked:CKPT
dataskip is OFF for all dbspaces
===========------------- - - - - - -
E:\INFORMIX\bin\onstat -h:
Informix Dynamic Server Version 7.31.TC2 -- Quiescent (CKPT REQ) -- Up
00:00:21 -- 347584 Kbytes
Blocked:CKPT
buffer hash chain length histogram
# of chains of len
32752 0
13 1
1 2
1 3
1 7
32768 total chains
16 hashed buffs
20000 total buffs
===========------------- - - - - - -
E:\INFORMIX\bin\onstat -C:
Informix Dynamic Server Version 7.31.TC2 -- Quiescent (CKPT REQ) -- Up
00:00:21 -- 347584 Kbytes
Blocked:CKPT
Btree Cleaner Info
btcleanr pool flags pools npend busypnum head tail free
253bbd88 255a9080 1 1 0 0 0 0 255a9080
nreqs dups success dfrmv unnec ditems ditlks cmprs palcs
0 0 0 0 0 0 0 0 1
outstanding requests
address next partnum pagenum keynum
0 pending, 1024 total, 1024 hash buckets, 1 pools
===========------------- - - - - - -
E:\INFORMIX\bin\onstat -F:
Informix Dynamic Server Version 7.31.TC2 -- On-Line (CKPT REQ) -- Up
00:00:22 -- 347584 Kbytes
Blocked:CKPT
Fg Writes LRU Writes Chunk Writes
0 0 0
address flusher state data
253ba500 0 I 0 = 0X0
253ba9e8 1 I 0 = 0X0
253baed0 2 I 0 = 0X0
253bb3b8 3 I 0 = 0X0
states: Exit Idle Chunk Lru
===========------------- - - - - - -
E:\INFORMIX\bin\onstat -R:
Informix Dynamic Server Version 7.31.TC2 -- On-Line (CKPT REQ) -- Up
00:00:22 -- 347584 Kbytes
Blocked:CKPT
30 buffer LRU queue pairs priority levels
# f/m pair total % of length LOW MED_LOW MED_HIGH HIGH
0 F 668 100.0% 668 667 1 0 0
1 m 0.0% 0 0 0 0 0
2 f 668 99.9% 667 666 1 0 0
3 m 0.1% 1 0 1 0 0
4 f 668 99.9% 667 666 1 0 0
5 m 0.1% 1 0 1 0 0
6 f 668 100.0% 668 666 2 0 0
7 m 0.0% 0 0 0 0 0
8 f 668 100.0% 668 666 2 0 0
9 m 0.0% 0 0 0 0 0
10 f 668 100.0% 668 666 2 0 0
11 m 0.0% 0 0 0 0 0
12 f 668 100.0% 668 666 2 0 0
13 m 0.0% 0 0 0 0 0
14 f 668 100.0% 668 666 2 0 0
15 m 0.0% 0 0 0 0 0
16 f 668 100.0% 668 667 1 0 0
17 m 0.0% 0 0 0 0 0
18 f 668 100.0% 668 667 1 0 0
19 m 0.0% 0 0 0 0 0
20 f 666 100.0% 666 665 1 0 0
21 m 0.0% 0 0 0 0 0
22 f 666 100.0% 666 665 1 0 0
23 m 0.0% 0 0 0 0 0
24 f 666 100.0% 666 665 1 0 0
25 m 0.0% 0 0 0 0 0
26 f 666 100.0% 666 665 1 0 0
27 m 0.0% 0 0 0 0 0
28 f 666 99.8% 665 665 0 0 0
29 m 0.2% 1 0 1 0 0
30 f 666 99.8% 665 665 0 0 0
31 m 0.2% 1 0 1 0 0
32 f 666 99.8% 665 665 0 0 0
33 m 0.2% 1 0 1 0 0
34 f 666 100.0% 666 665 1 0 0
35 m 0.0% 0 0 0 0 0
36 f 666 100.0% 666 665 1 0 0
37 m 0.0% 0 0 0 0 0
38 f 666 100.0% 666 665 1 0 0
39 m 0.0% 0 0 0 0 0
40 f 666 100.0% 666 665 1 0 0
41 m 0.0% 0 0 0 0 0
42 f 666 100.0% 666 665 1 0 0
43 m 0.0% 0 0 0 0 0
44 f 666 100.0% 666 665 1 0 0
45 m 0.0% 0 0 0 0 0
46 f 666 100.0% 666 665 1 0 0
47 m 0.0% 0 0 0 0 0
48 f 666 100.0% 666 665 1 0 0
49 m 0.0% 0 0 0 0 0
50 f 666 100.0% 666 665 1 0 0
51 m 0.0% 0 0 0 0 0
52 f 666 100.0% 666 665 1 0 0
53 m 0.0% 0 0 0 0 0
54 f 666 100.0% 666 665 1 0 0
55 m 0.0% 0 0 0 0 0
56 f 666 100.0% 666 665 1 0 0
57 m 0.0% 0 0 0 0 0
58 f 666 100.0% 666 665 1 0 0
59 m 0.0% 0 0 0 0 0
5 dirty, 20000 queued, 20000 total, 32768 hash buckets, 4096 buffer size
start clean at 3% (of pair total) dirty, or 20 buffs dirty, stop at 1%
0 priority downgrades, 0 priority upgrades
===========------------- - - - - - -
E:\INFORMIX\bin\onstat -g glo:
Informix Dynamic Server Version 7.31.TC2 -- On-Line (CKPT REQ) -- Up
00:00:22 -- 347584 Kbytes
Blocked:CKPT
MT global info:
sessions threads vps lngspins
0 18 8 0
sched calls thread switches yield 0 yield n yield forever
total: 10 10 3 4 1
per sec: 0 0 0 0 0
Virtual processor summary:
class vps usercpu syscpu total
cpu 1 0.00 0.00 0.00
aio 1 0.00 0.00 0.00
lio 1 0.00 0.00 0.00
pio 1 0.00 0.00 0.00
adm 1 0.00 0.00 0.00
soc 2 0.00 0.00 0.00
msc 1 0.00 0.00 0.00
total 8 0.00 0.00 0.00
Individual virtual processors:
vp pid class usercpu syscpu total
1 280 cpu 0.00 0.00 0.00
2 50 adm 0.00 0.00 0.00
3 106 lio 0.00 0.00 0.00
4 310 pio 0.00 0.00 0.00
5 311 aio 0.00 0.00 0.00
6 104 msc 0.00 0.00 0.00
7 295 soc 0.00 0.00 0.00
8 117 soc 0.00 0.00 0.00
tot 0.00 0.00 0.00
===========------------- - - - - - -
E:\INFORMIX\bin\onstat -g qst:
Informix Dynamic Server Version 7.31.TC2 -- On-Line (CKPT REQ) -- Up
00:00:22 -- 347584 Kbytes
Blocked:CKPT
Queue statistics not enabled
===========------------- - - - - - -
E:\INFORMIX\bin\onstat -g wst:
Informix Dynamic Server Version 7.31.TC2 -- On-Line (CKPT REQ) -- Up
00:00:23 -- 347584 Kbytes
Blocked:CKPT
Wait statistics not enabled
===========------------- - - - - - -
E:\INFORMIX\bin\onstat -g spi:
Informix Dynamic Server Version 7.31.TC2 -- On-Line (CKPT REQ) -- Up
00:00:23 -- 347584 Kbytes
Blocked:CKPT
Spin locks with waits:
Num Waits Num Loops Avg Loop/Wait Name
2 2 1.00 vproc vp_lock, id = 1
1 10 10.00 pool po_lock, name = global
===========------------- - - - - - -
E:\INFORMIX\bin\onstat -g lmx:
Informix Dynamic Server Version 7.31.TC2 -- On-Line (CKPT REQ) -- Up
00:00:24 -- 347584 Kbytes
Blocked:CKPT
Locked mutexes:
mid addr name holder lkcnt waiter waittime
===========------------- - - - - - -
E:\INFORMIX\bin\onstat -g wmx:
Informix Dynamic Server Version 7.31.TC2 -- On-Line (CKPT REQ) -- Up
00:00:24 -- 347584 Kbytes
Blocked:CKPT
Mutexes with waiters:
mid addr name holder lkcnt waiter waittime
===========------------- - - - - - -
E:\INFORMIX\bin\onstat -g con:
Informix Dynamic Server Version 7.31.TC2 -- On-Line (CKPT REQ) -- Up
00:00:25 -- 347584 Kbytes
Blocked:CKPT
Conditions with waiters:
cid addr name waiter waittime
===========------------- - - - - - -
E:\INFORMIX\bin\onstat -g stk all:
Informix Dynamic Server Version 7.31.TC2 -- On-Line (CKPT REQ) -- Up
00:00:25 -- 347584 Kbytes
Blocked:CKPT
Stack for thread: 33 onmode_mon
base: 0x258c8018
len: 33280
pc: 0x006b1fb0
tos: 0x258d0214
state: ready
vp: 1
Stack for thread: 32 CDRStart
base: 0x258d4018
len: 33280
pc: 0x006b1fb0
tos: 0x258dc214
state: ready
vp: 1
Stack for thread: 17 btclean
base: 0x2572c018
len: 33280
pc: 0x00697f60
tos: 0x2573416c
state: sleeping
vp: 1
0x0069ac46 (oninit)_mt_yield(0x1, 0x0, 0x4, 0x2552e594)
0x005f27ee (oninit)_btclean_loop(0x253760f8, 0x420, 0x2552e588, 0x0)
0x006b2064 (oninit)_startup(0x0, 0x0, 0x0, 0x0)
0x00000000 (***nosymtab***)0x0
Stack for thread: 16 aslogflush
base: 0x2571e018
len: 33280
pc: 0x00697f60
tos: 0x25726134
state: sleeping
vp: 1
0x0069ac46 (oninit)_mt_yield(0x257180c0, 0x133430, 0x25718090, 0x2552e284)
0x00658a5d (oninit)_wait_4_Qbuf(0xffffffff, 0x420, 0x25718090, 0x0)
0x00658394 (oninit)_get_full_Qbuf(0x25718090, 0x2, 0xffffffff, 0x420)
0x0058d21e (oninit)_aslogflush(0x25718090, 0xffffffff, 0x257261d4,
0x257261d0)
0x006b2064 (oninit)_startup(0x0, 0x0, 0x0, 0x0)
0x00000000 (***nosymtab***)0x0
Stack for thread: 15 kaio
base: 0x25712018
len: 16896
pc: 0x00697f60
tos: 0x25716180
state: sleeping
vp: 1
0x0069ac46 (oninit)_mt_yield(0x25435530, 0x254354f8, 0x133020, 0x2552b30c)
0x006a63aa (oninit)_kaiothread(0xffffffff, 0x0, 0x2552b300, 0x0)
0x006b2064 (oninit)_startup(0x25435688, 0x0, 0x0, 0x0)
0x00000000 (***nosymtab***)0x0
Stack for thread: 14 kaio
base: 0x255da018
len: 16896
pc: 0x00698773
tos: 0x255de174
state: sleeping
vp: 5
0x0069ac52 (oninit)_mt_yield(0x254314c8, 0x25431490, 0x158a68, 0x2552ad5c)
0x006a63aa (oninit)_kaiothread(0xffffffff, 0x0, 0x2552ad50, 0x0)
0x006b2064 (oninit)_startup(0x25431620, 0x0, 0x0, 0x0)
0x00000000 (***nosymtab***)0x0
Stack for thread: 13 flush_sub(3)
base: 0x255d4018
len: 16896
pc: 0x00697f60
tos: 0x255d8178
state: sleeping
vp: 1
0x0069ac46 (oninit)_mt_yield(0x20005000, 0x253b8450, 0x20012858, 0x2552ab14)
0x005891fd (oninit)_flush_sub(0xffffffff, 0x420, 0x2552ab08, 0x0)
0x006b2064 (oninit)_startup(0x3, 0x0, 0x0, 0x0)
0x00000000 (***nosymtab***)0x0
Stack for thread: 12 flush_sub(2)
base: 0x255ca018
len: 16896
pc: 0x00697f60
tos: 0x255ce178
state: sleeping
vp: 1
0x0069ac46 (oninit)_mt_yield(0x20005000, 0x253b83d8, 0x20012858, 0x2552a8cc)
0x005891fd (oninit)_flush_sub(0xffffffff, 0x420, 0x2552a8c0, 0x0)
0x006b2064 (oninit)_startup(0x2, 0x0, 0x0, 0x0)
0x00000000 (***nosymtab***)0x0
Stack for thread: 11 flush_sub(1)
base: 0x255c0018
len: 16896
pc: 0x00697f60
tos: 0x255c4178
state: sleeping
vp: 1
0x0069ac46 (oninit)_mt_yield(0x20005000, 0x253b8360, 0x20012858, 0x2552a684)
0x005891fd (oninit)_flush_sub(0xffffffff, 0x420, 0x2552a678, 0x0)
0x006b2064 (oninit)_startup(0x1, 0x0, 0x0, 0x0)
0x00000000 (***nosymtab***)0x0
Stack for thread: 10 flush_sub(0)
base: 0x255b6018
len: 16896
pc: 0x00697f60
tos: 0x255ba178
state: sleeping
vp: 1
0x0069ac46 (oninit)_mt_yield(0x20005000, 0x253b82e8, 0x20012858, 0x2552a464)
0x005891fd (oninit)_flush_sub(0xffffffff, 0x420, 0x2552a458, 0x0)
0x006b2064 (oninit)_startup(0x0, 0x0, 0x0, 0x0)
0x00000000 (***nosymtab***)0x0
Stack for thread: 9 soctcplst
base: 0x255a2018
len: 16896
pc: 0x00697f60
tos: 0x255a5610
state: sleeping
vp: 1
0x0069ac46 (oninit)_mt_yield(0x2554b640, 0x2554b79c, 0x25553030, 0x254f3d4c)
0x006e5bd3 (oninit)_accpsocket(0xffffffff, 0x2554f030, 0x25553ad8,
0x25553030)
0x006c9ad0 (oninit)_tlAccept(0x2554b79c, 0x25553030, 0x255a5954, 0x2554d31c)
0x006d1dd3 (oninit)_slSQIind(0x2554d31c, 0x25553030, 0x255a5954, 0xffffffff)
0x006ccef3 (oninit)_pfConInd(0x2554fb5c, 0x25553030, 0x255a5958, 0x255a5954)
0x006c4a98 (oninit)_cmConInd(0x2554d31c, 0x25553030, 0x255a5da4, 0x25553114)
0x006c0bea (oninit)_ascInd (0x2554d31c, 0x25553030, 0x255a5da4, 0x255a5c07)
0x006be9cf (oninit)_ASF_Call(0x2554d31c, 0x2554d0a8, 0x255a5da0, 0x255a5c07)
0x006da583 (oninit)_sql_listener(0x255a5df4, 0x255a5da0, 0x70f8, 0x254f3d40)
0x006b2064 (oninit)_startup(0x0, 0x0, 0x0, 0x0)
0x00000000 (***nosymtab***)0x0
Stack for thread: 8 soctcpio
base: 0x25580018
len: 16896
pc: 0x00697f60
tos: 0x2558414c
state: running
vp: 8
0x255841c0 (***nosymtab***)0x255841c0
Changing data structure forced command termination.
===========------------- - - - - - -
E:\INFORMIX\bin\onstat -g mem:
Informix Dynamic Server Version 7.31.TC2 -- On-Line (CKPT REQ) -- Up
00:00:25 -- 347584 Kbytes
Blocked:CKPT
Pool Summary:
name class addr totalsize freesize #allocfrag #freefrag
resident R 20002018 5488640 16240 2 2
res-buff R 2053e018 81936384 12144 2 2
global V 25372018 434176 145296 541 47
mt V 25376018 1523712 660392 721 37
rsam V 253b8018 712704 5448 70 3
aio V 253f8018 1769472 165008 246 63
gls V 253fc018 49152 2240 709 6
dictpool V 25400018 8192 6368 2 1
procpool V 25404018 8192 7112 4 1
XTF_mem V 25438018 409600 17464 4 3
main_loop() V 2553a018 49152 9776 125 6
2 V 25546018 8192 2632 9 1
3 V 25568018 8192 3176 8 1
4 V 2558a018 16384 2888 207 1
5 V 25710018 8192 3176 8 1
lgflushpool V 25718018 8192 7912 3 1
aslogflush V 2571a018 16384 4128 108 1
btclean V 25728018 16384 4128 108 1
CDRStart V 25736018 16384 4128 108 1
onmode_mon V 257c4018 16384 4128 108 1
Blkpool Summary:
name class addr size #blks
global V 25374350 0 0
===========------------- - - - - - -
E:\INFORMIX\bin\onstat -g seg:
Informix Dynamic Server Version 7.31.TC2 -- On-Line (CKPT REQ) -- Up
00:00:25 -- 347584 Kbytes
Blocked:CKPT
Segment Summary:
id key addr size ovhd class blkused blkfree
1381386241 1381386241 20000000 87490560 2204 R 10673 7
1381386242 1381386242 25370000 268435456 4692 V 621 32147
Total: - - 355926016 - - 11294 32154
(* segment locked in memory)
===========------------- - - - - - -
E:\INFORMIX\bin\onstat -g rbm:
Informix Dynamic Server Version 7.31.TC2 -- On-Line (CKPT REQ) -- Up
00:00:25 -- 347584 Kbytes
Blocked:CKPT
Block bitmap for resident segment address 20000000:
(bitmap address = 20000250, bitmap size = 1336)
20000250:ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff
ffffffff
20000270:ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff
ffffffff
20000290:ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff
ffffffff
200002b0:ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff
ffffffff
200002d0:ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff
ffffffff
200002f0:ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff
ffffffff
20000310:ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff
ffffffff
20000330:ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff
ffffffff
20000350:ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff
ffffffff
20000370:ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff
ffffffff
20000390:ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff
ffffffff
200003b0:ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff
ffffffff
200003d0:ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff
ffffffff
200003f0:ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff
ffffffff
20000410:ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff
ffffffff
20000430:ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff
ffffffff
20000450:ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff
ffffffff
20000470:ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff
ffffffff
20000490:ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff
ffffffff
200004b0:ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff
ffffffff
200004d0:ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff
ffffffff
200004f0:ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff
ffffffff
20000510:ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff
ffffffff
20000530:ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff
ffffffff
20000550:ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff
ffffffff
20000570:ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff
ffffffff
20000590:ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff
ffffffff
200005b0:ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff
ffffffff
200005d0:ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff
ffffffff
200005f0:ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff
ffffffff
20000610:ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff
ffffffff
20000630:ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff
ffffffff
20000650:ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff
ffffffff
20000670:ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff
ffffffff
20000690:ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff
ffffffff
200006b0:ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff
ffffffff
200006d0:ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff
ffffffff
200006f0:ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff
ffffffff
20000710:ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff
ffffffff
20000730:ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff
ffffffff
20000750:ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff
ffffffff
20000770:ffffffff ffffffff ffffffff ffffffff ffffffff 0080ffff
===========------------- - - - - - -
E:\INFORMIX\bin\onstat -g nbm:
Informix Dynamic Server Version 7.31.TC2 -- On-Line (CKPT REQ) -- Up
00:00:26 -- 347584 Kbytes
Blocked:CKPT
Block bitmap for virtual segment address 25370000:
(bitmap address = 25370250, bitmap size = 4096)
25370250:ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff
ffffffff
25370270:ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff
ffffffff
25370290:ffffffff 0000f0ff 00000000 eff37d00 beeffbbe 00beeffb 00000000
00000000
253702b0:00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000
253702d0:00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000
253702f0:00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000
25370310:00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000
25370330:00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000
25370350:00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000
25370370:00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000
25370390:00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000
253703b0:00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000
253703d0:00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000
253703f0:00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000
25370410:00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000
25370430:00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000
25370450:00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000
25370470:00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000
25370490:00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000
253704b0:00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000
253704d0:00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000
253704f0:00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000
25370510:00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000
25370530:00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000
25370550:00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000
25370570:00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000
25370590:00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000
253705b0:00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000
253705d0:00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000
253705f0:00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000
25370610:00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000
25370630:00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000
25370650:00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000
25370670:00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000
25370690:00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000
253706b0:00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000
253706d0:00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000
253706f0:00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000
25370710:00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000
25370730:00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000
25370750:00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000
25370770:00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000
25370790:00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000
253707b0:00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000
253707d0:00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000
253707f0:00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000
25370810:00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000
25370830:00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000
25370850:00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000
25370870:00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000
25370890:00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000
253708b0:00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000
253708d0:00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000
253708f0:00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000
25370910:00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000
25370930:00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000
25370950:00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000
25370970:00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000
25370990:00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000
253709b0:00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000
253709d0:00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000
253709f0:00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000
25370a10:00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000
25370a30:00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000
25370a50:00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000
25370a70:00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000
25370a90:00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000
25370ab0:00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000
25370ad0:00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000
25370af0:00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000
25370b10:00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000
25370b30:00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000
25370b50:00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000
25370b70:00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000
25370b90:00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000
25370bb0:00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000
25370bd0:00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000
25370bf0:00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000
25370c10:00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000
25370c30:00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000
25370c50:00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000
25370c70:00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000
25370c90:00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000
25370cb0:00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000
25370cd0:00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000
25370cf0:00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000
25370d10:00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000
25370d30:00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000
25370d50:00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000
25370d70:00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000
25370d90:00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000
25370db0:00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000
25370dd0:00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000
25370df0:00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000
25370e10:00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000
25370e30:00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000
25370e50:00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000
25370e70:00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000
25370e90:00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000
25370eb0:00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000
25370ed0:00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000
25370ef0:00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000
25370f10:00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000
25370f30:00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000
25370f50:00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000
25370f70:00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000
25370f90:00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000
25370fb0:00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000
25370fd0:00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000
25370ff0:00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000
25371010:00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000
25371030:00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000
25371050:00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000
25371070:00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000
25371090:00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000
253710b0:00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000
253710d0:00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000
253710f0:00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000
25371110:00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000
25371130:00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000
25371150:00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000
25371170:00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000
25371190:00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000
253711b0:00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000
253711d0:00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000
253711f0:00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000
25371210:00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000
25371230:00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000
===========------------- - - - - - -
E:\INFORMIX\bin\onstat -g dic:
Informix Dynamic Server Version 7.31.TC2 -- On-Line (CKPT REQ) -- Up
00:00:26 -- 347584 Kbytes
Blocked:CKPT
Dictionary Cache: Number of lists: 83, Maximum list size: 511
list# size refcnt dirty? heapptr table name
--------------------------------------------------------
Dictionary cache is empty
===========------------- - - - - - -
E:\INFORMIX\bin\onstat -g dsc:
Informix Dynamic Server Version 7.31.TC2 -- On-Line (CKPT REQ) -- Up
00:00:26 -- 347584 Kbytes
Blocked:CKPT
Distribution Cache:
Number of lists : 31
DS_POOLSIZE : 127
Number of entries : 0
Number of entries in use : 0
Distribution Cache Entries:
list# id ref_cnt dropped? heap_ptr distribution name
-----------------------------------------------------------------
Distribution Cache is empty.
===========------------- - - - - - -
E:\INFORMIX\bin\onstat -g prc:
Informix Dynamic Server Version 7.31.TC2 -- On-Line (CKPT REQ) -- Up
00:00:26 -- 347584 Kbytes
Blocked:CKPT
Stored Procedure Cache:
Number of lists : 31
PC_POOLSIZE : 127
Number of entries : 0
Number of entries in use : 0
Stored Procedure Cache Entries:
list# id ref_cnt dropped? heap_ptr procedure name
--------------------------------------------------------------
Stored Procedure Cache is empty.
===========------------- - - - - - -
E:\INFORMIX\bin\onstat -g cac:
Informix Dynamic Server Version 7.31.TC2 -- On-Line (CKPT REQ) -- Up
00:00:27 -- 347584 Kbytes
Blocked:CKPT
===========------------- - - - - - -
E:\INFORMIX\bin\onstat -g sch:
Informix Dynamic Server Version 7.31.TC2 -- On-Line (CKPT REQ) -- Up
00:00:27 -- 347584 Kbytes
Blocked:CKPT
VP Scheduler Statistics:
vp pid class semops busy waits spins/wait
1 280 cpu 70 25189 1
2 50 adm 0 0 0
3 106 lio 1 1 1
4 310 pio 2 2 1
5 311 aio 50 50 1
6 104 msc 4 4 1
7 295 soc 0 0 0
8 117 soc 0 0 0
===========------------- - - - - - -
E:\INFORMIX\bin\onstat -g pos:
Informix Dynamic Server Version 7.31.TC2 -- On-Line (CKPT REQ) -- Up
00:00:27 -- 347584 Kbytes
Blocked:CKPT
1 7 0 infos ver/size 2 136
2 1 0 snum 0 52564801 20000000 ol_baan
3 4 0 onconfig path E:\INFORMIX/etc/ONCONFIG.ol_baan
4 5 0 host baan.soenen.com
5 6 0 oninit ver Informix Dynamic Server Version 7.31.TC2
6 8 0 del
===========------------- - - - - - -
E:\INFORMIX\bin\onstat -g ioa:
Informix Dynamic Server Version 7.31.TC2 -- On-Line (CKPT REQ) -- Up
00:00:27 -- 347584 Kbytes
Blocked:CKPT
AIO global info:
6 aio classes
20 open files
64 max global files
AIO I/O queues:
q name/id len maxlen totalops dskread dskwrite dskcopy
kio 0 0 0 0 0 0 0
kio 1 0 1 53 52 1 0
adt 0 0 0 0 0 0 0
msc 0 0 1 2 0 0 0
aio 0 0 1 60 14 0 0
pio 0 0 0 0 0 0 0
lio 0 0 0 0 0 0 0
gfd 3 0 0 0 0 0 0
gfd 4 0 0 0 0 0 0
gfd 5 0 0 0 0 0 0
gfd 6 0 0 0 0 0 0
gfd 7 0 0 0 0 0 0
gfd 8 0 0 0 0 0 0
gfd 9 0 0 0 0 0 0
gfd 10 0 0 0 0 0 0
gfd 11 0 0 0 0 0 0
gfd 12 0 0 0 0 0 0
gfd 13 0 0 0 0 0 0
gfd 14 0 0 0 0 0 0
gfd 15 0 0 0 0 0 0
gfd 16 0 0 0 0 0 0
gfd 17 0 0 0 0 0 0
gfd 18 0 0 0 0 0 0
gfd 19 0 0 0 0 0 0
AIO I/O vps:
class/vp s io/s totalops dskread dskwrite dskcopy wakeups io/wup errors
kio 0 i 0.0 0 0 0 0 0 0.0 0
kio 1 i 4.4 53 52 1 0 25172 0.0 0
msc 0 i 0.2 2 0 0 0 3 0.7 0
aio 0 i 5.0 60 14 0 0 49 1.2 0
pio 0 i 0.0 0 0 0 0 1 0.0 0
lio 0 i 0.0 0 0 0 0 1 0.0 0
AIO global files:
gfd pathname totalops dskread dskwrite io/s
3 **E:\IFMXDATA\ol_baan\rootdbs_dat.000 12 11 1 1.0
4 **E:\IFMXDATA\ol_baan\ol_baan_dat.000 2 2 0 0.2
5 **F:\informix\Dbspaces\baandb.dbs 7 7 0 0.6
6 **E:\informix\Dbspaces\baandbplog 3 3 0 0.3
7 **C:\informix\Dbspaces\baandbllog 3 3 0 0.3
8 **C:\informix\Dbspaces\baandbtmp 1 1 0 0.1
9 **F:\IFMXDATA\ol_baan\baandb_dbs_dat.001 5 5 0 0.4
10 **F:\IFMXDATA\ol_baan\baandb_dbs_dat.000 3 3 0 0.3
11 **f:\ifmxdata\ol_baan\baandb_dbs_dat.002 1 1 0 0.1
12 **f:\ifmxdata\ol_baan\baandb_dbs_dat.003 4 4 0 0.3
13 **f:\ifmxdata\ol_baan\baandb_dbs_dat.004 2 2 0 0.2
14 **f:\ifmxdata\ol_baan\baandb_dbs_dat.005 1 1 0 0.1
15 **f:\ifmxdata\ol_baan\baandb_dbs_dat.006 1 1 0 0.1
16 **f:\ifmxdata\ol_baan\baandb_000_dat.000 3 3 0 0.3
17 **f:\ifmxdata\ol_baan\baandb_100_dat.000 3 3 0 0.3
18 **f:\ifmxdata\ol_baan\baandb_100_dat.001 1 1 0 0.1
19 **f:\ifmxdata\ol_baan\baandb_100_dat.002 1 1 0 0.1
AIO big buffer usage summary:
class reads writes
pages ops pgs/op holes hl-ops hls/op pages ops pgs/op
kio 62 52 1.19 0 0 0.00 1 1 1.00
adt 0 0 0.00 0 0 0.00 0 0 0.00
msc 0 0 0.00 0 0 0.00 0 0 0.00
aio 0 0 0.00 0 0 0.00 0 0 0.00
pio 0 0 0.00 0 0 0.00 0 0 0.00
lio 0 0 0.00 0 0 0.00 0 0 0.00
===========------------- - - - - - -
E:\INFORMIX\bin\onstat -g nta:
Informix Dynamic Server Version 7.31.TC2 -- On-Line (CKPT REQ) -- Up
00:00:27 -- 347584 Kbytes
Blocked:CKPT
global network information:
#netscb connects read write q-limits q-exceed
3/ 3 0 0 0 150/ 10 0/ 0
Individual thread network information (basic):
netscb type thread name sid fd poll reads writes q-nrm q-exp
2554b640 soctcp soctcplst 4 248 5 0 0 10 1
25549c10 soctcp soctcpio 3 0 0 0 0 10 1
253ffc40 soctcp soctcppoll 2 0 5 0 0 10 1
Individual thread network information (times):
netscb thread name sid open read write address
2554b640 soctcplst 4 12:26:32 baan.soenen.com|1526|soctcp
25549c10 soctcpio 3 12:26:32
253ffc40 soctcppoll 2 12:26:31
Network mailbox information:
box netscb thread name max received in box max in box full signal
5 253ffc40 soctcppoll 10 1 0 1 0 yes
6 2554b640 soctcplst 10 0 0 0 0 no
Client Type Calls Accepted Rejected Read Write
sqlexec no 0 0 0 0
srvinfx no 0 0 0 0
onspace yes 0 0 0 0
onlog yes 0 0 0 0
onparam yes 0 0 0 0
oncheck yes 0 0 0 0
onload yes 0 0 0 0
onunload yes 0 0 0 0
onmonitor yes 0 0 0 0
dr_accept yes 0 0 0 0
cdraccept no 0 0 0 0
ontape yes 0 0 0 0
srvstat yes 0 0 0 0
asfecho yes 0 0 0 0
listener yes 0 0 0 0
crsamexec yes 0 0 0 0
safe yes 0 0 0 0
Totals 0 0 0 0
===========------------- - - - - - -
E:\INFORMIX\bin\onstat -g nsd:
Informix Dynamic Server Version 7.31.TC2 -- On-Line (CKPT REQ) -- Up
00:00:28 -- 347584 Kbytes
Blocked:CKPT
===========------------- - - - - - -
E:\INFORMIX\bin\onstat -g nsc:
Informix Dynamic Server Version 7.31.TC2 -- On-Line (CKPT REQ) -- Up
00:00:28 -- 347584 Kbytes
Blocked:CKPT
clientid clientPID state #serverbufs #clientbufs #rdwrts
===========------------- - - - - - -
E:\INFORMIX\bin\onstat -g nss:
Informix Dynamic Server Version 7.31.TC2 -- On-Line (CKPT REQ) -- Up
00:00:28 -- 347584 Kbytes
Blocked:CKPT
clientid clientPID state #serverbufs #clientbufs #rdwrts
===========------------- - - - - - -
E:\INFORMIX\bin\onstat -g sts:
Informix Dynamic Server Version 7.31.TC2 -- On-Line (CKPT REQ) -- Up
00:00:28 -- 347584 Kbytes
Blocked:CKPT
Stack usage:
TID Total Max Current Thread Name
bytes % bytes %
2 16384 1351 8 208 1 lio vp 0
3 16384 1351 8 208 1 pio vp 0
4 16384 1723 10 208 1 aio vp 0
5 131072 4639 3 208 0 msc vp 0
6 32768 9199 28 2544 7 main_loop()
7 16384 7147 43 524 3 soctcppoll
8 16384 1379 8 204 1 soctcpio
9 16384 9015 55 3080 18 soctcplst
10 16384 549 3 160 0 flush_sub(0)
11 16384 550 3 160 0 flush_sub(1)
12 16384 550 3 160 0 flush_sub(2)
13 16384 550 3 160 0 flush_sub(3)
14 16384 279 1 164 1 kaio
15 16384 343 2 152 0 kaio
16 32768 243 0 228 0 aslogflush
17 32768 183 0 172 0 btclean
32 32768 3 0 4 0 CDRStart
33 32768 3 0 4 0 onmode_mon
===========------------- - - - - - -
E:\INFORMIX\bin\onstat -g ses:
Informix Dynamic Server Version 7.31.TC2 -- On-Line (CKPT REQ) -- Up
00:00:28 -- 347584 Kbytes
Blocked:CKPT
session #RSAM total used
id user tty pid hostname threads memory memory
5 informix - 0 - 0 8192 5016
4 informix - 0 - 0 16384 13496
3 informix - 0 - 0 8192 5016
2 informix - 0 - 0 8192 5560
===========------------- - - - - - -
E:\INFORMIX\bin\onstat -g sql:
Informix Dynamic Server Version 7.31.TC2 -- On-Line (CKPT REQ) -- Up
00:00:29 -- 347584 Kbytes
Blocked:CKPT
===========------------- - - - - - -
E:\INFORMIX\bin\onstat -g stq:
Informix Dynamic Server Version 7.31.TC2 -- On-Line (CKPT REQ) -- Up
00:00:29 -- 347584 Kbytes
Blocked:CKPT
===========------------- - - - - - -
E:\INFORMIX\bin\onstat -g opn:
Informix Dynamic Server Version 7.31.TC2 -- On-Line (CKPT REQ) -- Up
00:00:29 -- 347584 Kbytes
Blocked:CKPT
tid rstcb isfd op_mode op_flags partnum ucount ocount lockmode
===========------------- - - - - - -
E:\INFORMIX\bin\onstat -g dri:
Informix Dynamic Server Version 7.31.TC2 -- On-Line (CKPT REQ) -- Up
00:00:29 -- 347584 Kbytes
Blocked:CKPT
Data Replication:
Type State Paired server Last DR CKPT (id/pg)
standard off -1 / -1
DRINTERVAL 30
DRTIMEOUT 30
DRAUTO 0
DRLOSTFOUND \tmp
===========------------- - - - - - -
E:\INFORMIX\bin\onstat -g ppf:
Informix Dynamic Server Version 7.31.TC2 -- On-Line (CKPT REQ) -- Up
00:00:29 -- 347584 Kbytes
Blocked:CKPT
Partition profiles
partnum lkrqs lkwts dlks touts isrd iswrt isrwt isdel bfrd bfwrt seqsc
rhitratio
0x100001 0 0 0 0 0 0 0 0 0 0 0 0
0x100002 0 0 0 0 0 0 0 0 1 0 0 0
0x200001 0 0 0 0 0 0 0 0 0 0 0 0
0x300001 0 0 0 0 0 0 0 0 0 0 0 0
0x400001 0 0 0 0 0 0 0 0 0 0 0 0
0x500001 0 0 0 0 0 0 0 0 0 0 0 0
0x600001 0 0 0 0 0 0 0 0 0 0 0 0
0x700001 0 0 0 0 0 0 0 0 0 0 0 0
0x800001 0 0 0 0 0 0 0 0 0 0 0 0
===========------------- - - - - - -
E:\INFORMIX\bin\onstat -g tpf:
Informix Dynamic Server Version 7.31.TC2 -- On-Line (CKPT REQ) -- Up
00:00:30 -- 347584 Kbytes
Blocked:CKPT
Thread profiles
tid lkreqs lkw dl to lgrs isrd iswr isrw isdl isct isrb lx bfr bfw lsus lsmx
seq
0 0 0 0 0 0 0 0 0 0 0 0 0 122367 2 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
20 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
===========------------- - - - - - -
E:\INFORMIX\bin\onstat -g tgp:
Informix Dynamic Server Version 7.31.TC2 -- On-Line (CKPT REQ) -- Up
00:00:30 -- 347584 Kbytes
Blocked:CKPT
Generic Page Thread profiles
tid read write rewrite delete alloc free cursor opens
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
20 0 0 0 0 0 0 0
===========------------- - - - - - -
E:\INFORMIX\bin\onstat -g pgp:
Informix Dynamic Server Version 7.31.TC2 -- On-Line (CKPT REQ) -- Up
00:00:30 -- 347584 Kbytes
Blocked:CKPT
Generic Page Partition profiles
partnum read write rewrite delete alloc free cursor opens
===========------------- - - - - - -
E:\INFORMIX\bin\onstat -g mgm:
Informix Dynamic Server Version 7.31.TC2 -- On-Line (CKPT REQ) -- Up
00:00:30 -- 347584 Kbytes
Blocked:CKPT
Memory Grant Manager (MGM)
--------------------------
MAX_PDQPRIORITY: 100
DS_MAX_QUERIES: 1
DS_MAX_SCANS: 10
DS_TOTAL_MEMORY: 2048 KB
Queries: Active Ready Maximum
0 0 1
Memory: Total Free Quantum
(KB) 2048 2048 2048
Scans: Total Free Quantum
10 10 1
Load Control: (Memory) (Scans) (Priority) (Max Queries) (Reinit)
Gate 1 Gate 2 Gate 3 Gate 4 Gate 5
(Queue Length) 0 0 0 0 0
Active Queries: None
Ready Queries: None
Free Resource Average # Minimum #
-------------- --------------- ---------
Memory 0.0 +- 0.0 256
Scans 0.0 +- 0.0 10
Queries Average # Maximum # Total #
-------------- --------------- --------- -------
Active 0.0 +- 0.0 0 0
Ready 0.0 +- 0.0 0 0
Resource/Lock Cycle Prevention count: 0
===========------------- - - - - - -
E:\INFORMIX\bin\onstat -g smb:
Informix Dynamic Server Version 7.31.TC2 -- On-Line (CKPT REQ) -- Up
00:00:31 -- 347584 Kbytes
Blocked:CKPT
===========------------- - - - - - -
E:\INFORMIX\bin\onstat -g lsc:
Informix Dynamic Server Version 7.31.TC2 -- On-Line (CKPT REQ) -- Up
00:00:31 -- 347584 Kbytes
Blocked:CKPT
Light Scan Info
descriptor address next_lpage next_ppage ppage_left bufcnt look_aside
===========------------- - - - - - -
E:\INFORMIX\bin\onstat -g lap:
Informix Dynamic Server Version 7.31.TC2 -- On-Line (CKPT REQ) -- Up
00:00:31 -- 347584 Kbytes
Blocked:CKPT
Light Append Info
session id address cur_ppage la_npused la_ndata la_nrows bufcnt
===========------------- - - - - - -
E:\INFORMIX\bin\onstat -g ddr:
Informix Dynamic Server Version 7.31.TC2 -- On-Line (CKPT REQ) -- Up
00:00:31 -- 347584 Kbytes
Blocked:CKPT
DDR -- Down --
===========------------- - - - - - -
E:\INFORMIX\bin\onstat -g dis:
Informix Dynamic Server Version 7.31.TC2 -- On-Line (CKPT REQ) -- Up
00:00:31 -- 347584 Kbytes
Blocked:CKPT
There are 1 servers found
Server : ol_baan
Server Number : 0
Server Type : IDS
Server Status : Up
Server Version: Informix Dynamic Server Version 7.31.TC2
Shared Memory : 0x20000000
INFORMIXDIR : E:\INFORMIX
ONCONFIG : E:\INFORMIX/etc/ONCONFIG.ol_baan
SQLHOSTS : \\BAAN
Host : baan.soenen.com
===========------------- - - - - - -
E:\INFORMIX\bin\onstat -g arc:
Informix Dynamic Server Version 7.31.TC2 -- On-Line (CKPT REQ) -- Up
00:00:32 -- 347584 Kbytes
Blocked:CKPT
num DBSpace Q Size Q Len Buffer partnum size scanner
Dbspaces - Archive Status
name number level date log log-position
rootdbs 1 0 05/02/2003.17:38 61939 0x155018
ol_baan 2 0 05/02/2003.17:38 61939 0x155018
baandb_dbs 3 0 05/02/2003.17:38 61939 0x155018
baandb_plog 4 0 05/02/2003.17:38 61939 0x155018
baandb_llog 5 0 05/02/2003.17:38 61939 0x155018
baandb_000 7 0 05/02/2003.17:38 61939 0x155018
baandb_100 8 0 05/02/2003.17:38 61939 0x155018
===========------------- - - - - - -
E:\INFORMIX\bin\onstat -g dll:
Informix Dynamic Server Version 7.31.TC2 -- On-Line (CKPT REQ) -- Up
00:00:32 -- 347584 Kbytes
Blocked:CKPT
===========------------- - - - - - -
E:\INFORMIX\bin\onstat -g sym:
Informix Dynamic Server Version 7.31.TC2 -- On-Line (CKPT REQ) -- Up
00:00:32 -- 347584 Kbytes
Blocked:CKPT
Symbol tables:
total 1
addr symbols mode lowsaddr highsaddr symlist namepool slot symtabname
25377538 9126 abs 401020 7e8de0 2537c018 25398018 0 oninit
===========------------- - - - - - -
E:\INFORMIX\bin\onstat -g ras:
Informix Dynamic Server Version 7.31.TC2 -- On-Line (CKPT REQ) -- Up
00:00:32 -- 347584 Kbytes
Blocked:CKPT
Diagnostics Current Settings
AFCRASH 0x00000201
AFFAIL 0x00000001
AFWARN 0x00000001
AFDEBUG 0
AFLINES 0
BLOCKTIMEOUT 3600
Block Status Unblocked
DUMPCORE 0
DUMPGCORE 0
DUMPSHMEM 1
DUMPCNT 1
DUMPDIR \tmp
SYSALARMPROGRAM E:\INFORMIX/etc/evidence.bat
===========------------- - - - - - -
Environment Variables:
AF_CLASS=3
AF_DIR=\tmp
AF_FILE=\tmp\af.3ef9958
AF_FILE_NAME=af.3ef9958
ALRM_AFCRASH=3
ALRM_AFFAIL=2
ALRM_AFWARN=1
BITMASK=513
BLOCK_SYSTEM=off
BSE=e:\baan
BSE_TMP=e:\baan\tmp
CATPATH=C:\ARCSERVE\database
checkcrash=0
checkhang=0
checkrelease=0
CLIENT_LOCALE=EN_US.CP1252
COMPRESS="None"
COMPUTERNAME=BAAN
ComSpec=C:\WINNT\system32\cmd.exe
CONTINUOUS_LOG=0
crash_server=0
DBA=informix
DBLANG=EN_US.CP1252
DBSERVERNAME=ol_baan
DB_LOCALE=EN_US.8859-1
DEBUG=on
DIAG_AFWARN=off
display_message=0
DO_ONSTAT_A=off
DO_ONSTAT_G_ALL=off
DUMPDIR=\tmp
DUMPFILE="None"
dump_core_file=0
dump_gcore_file=0
dump_shared_memory=0
GOT_ALL_STACKS=no
hang_server=0
HOSTNAME=BAAN
IBIN=E:\INFORMIX\bin
informixdir=E:\INFORMIX
INFORMIXSERVER=ol_baan
INFORMIXSQLHOSTS=\\BAAN
LNNAME=ARCSERVE
LONG_BLOCK_TIME=3600
MYECHO=echo
NTRESKIT=C:\NTRESKIT
NUMBER_OF_PROCESSORS=2
ONCHECK=E:\INFORMIX\bin\oncheck
ONCONFIG=ONCONFIG.ol_baan
ONMODE=E:\INFORMIX\bin\onmode
ONSTAT=E:\INFORMIX\bin\onstat
OS=Windows_NT
Os2LibPath=C:\WINNT\system32\os2\dll;C:\TNGFW\BIN
OSAGENT_PORT=14016
OUTPUT=on
Path=C:\WINNT\system32;C:\WINNT;C:\TNGFW\BIN;C:\CA_APPSW;C:\NTRESKIT;e:\baan
\bin;e:\informix\bin
PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH
POOL=0
PRINT_POOL=off
PROCESSOR_ARCHITECTURE=x86
PROCESSOR_IDENTIFIER=x86 Family 6 Model 1 Stepping 9, GenuineIntel
PROCESSOR_LEVEL=6
PROCESSOR_REVISION=0109
PROMPT=$P$G
REGMACHINE=\\BAAN
required_thread_hang=0
RETURN_VAL=NULL
RNNAME=BAAN
RSTCB=0x0
SEND_DBA_MAIL=off
SEND_RAS_MAIL=off
SERVER_LOCALE=EN_US.CP1252
SES_ID=2
SHORT_BLOCK_TIME=600
SystemDrive=C:
SystemRoot=C:\WINNT
TCB=0x254f2d00
THREAD_ID=7
TMPDIR=C:\TMP
USERPROFILE=C:\WINNT\Profiles\informix
windir=C:\WINNT
WINROOT=C:\WINNT
WRITE_TO_CONSOLE=off
===========------------- - - - - - -
E:\INFORMIX\bin/oninit -V:
Informix Dynamic Server Version 7.31.TC2 Software Serial Number AAC#J726137
===========------------- - - - - - -
E:\INFORMIX\bin\onstat -V:
Informix Dynamic Server Version 7.31.TC2 Software Serial Number AAC#J726137
===========------------- - - - - - -
E:\INFORMIX\bin\oncheck -V:
Informix Dynamic Server Version 7.31.TC2 Software Serial Number AAC#J726137
===========------------- - - - - - -
E:\INFORMIX\bin\onmode -V:
Informix Dynamic Server Version 7.31.TC2 Software Serial Number AAC#J726137
-------------------------------
End System Alarm Program Output
-------------------------------
12:26:51 E:\INFORMIX/etc/evidence.bat 3 \tmp af.3ef9958 2 0x0 7 0x254f2d00
513 0 0 0 0
12:26:51 See Also: af.3ef9958, shmem.3ef9958.0
12:29:17
------------------ End of assertion failure 0 -----------------
Obnoxio The Clown
> Hi,
>
> your help is greatly appreciated on this matter !!
> 12:26:32 Action: Please notify Informix Technical Support.
The other 3528 lines of this post were just a waste of bandwidth.