- 论坛徽章:
- 0
|
我的INFORMIX的在做SELECT条件查询时，很慢（表中只有三百多条纪律），不知道为什么，我用onstat -a把但是的配置和系统情况查询出来，现在把它贴出来，大家帮我看看！
INFORMIX-OnLine Version 7.23.UC6 -- On-Line -- Up 1 days 02:43:13 -- 100704 Kbytes
Message Log File: /usr/informix/online.log
10:02:12 Checkpoint Completed: duration was 0 seconds.
10:07:15 Checkpoint Completed: duration was 0 seconds.
10:12:18 Checkpoint Completed: duration was 0 seconds.
10:17:21 Checkpoint Completed: duration was 0 seconds.
10:22:24 Checkpoint Completed: duration was 0 seconds.
10:27:27 Checkpoint Completed: duration was 0 seconds.
10:32:30 Checkpoint Completed: duration was 0 seconds.
10:37:33 Checkpoint Completed: duration was 0 seconds.
10:42:36 Checkpoint Completed: duration was 0 seconds.
10:47:39 Checkpoint Completed: duration was 0 seconds.
10:52:42 Checkpoint Completed: duration was 0 seconds.
10:57:45 Checkpoint Completed: duration was 0 seconds.
11:02:49 Checkpoint Completed: duration was 0 seconds.
11:07:52 Checkpoint Completed: duration was 0 seconds.
11:12:55 Checkpoint Completed: duration was 0 seconds.
11:17:59 Checkpoint Completed: duration was 0 seconds.
11:23:02 Checkpoint Completed: duration was 0 seconds.
11:28:05 Checkpoint Completed: duration was 0 seconds.
11:33:08 Checkpoint Completed: duration was 0 seconds.
11:38:12 Checkpoint Completed: duration was 0 seconds.
Configuration File: /usr/informix/etc/onconfig
#**************************************************************************
#
# INFORMIX SOFTWARE, INC.
#
# Title: onconfig.std
# Description: INFORMIX-OnLine Configuration Parameters
#
#**************************************************************************
# Root Dbspace Configuration
ROOTNAME rootdbs # Root dbspace name
ROOTPATH /dev/chunk1 # Path for device containing root dbspace
ROOTOFFSET 0 # Offset of root dbspace into device (Kbytes)
ROOTSIZE 2000000 # Size of root dbspace (Kbytes)
# Disk Mirroring Configuration Parameters
MIRROR 0 # Mirroring flag (Yes = 1, No = 0)
MIRRORPATH # Path for device containing mirrored root
MIRROROFFSET 0 # Offset into mirrored device (Kbytes)
# Physical Log Configuration
PHYSDBS rootdbs # Location (dbspace) of physical log
PHYSFILE 120000 # Physical log file size (Kbytes)
# Logical Log Configuration
LOGFILES 12 # Number of logical log files
LOGSIZE 60000 # Logical log size (Kbytes)
# Diagnostics
MSGPATH /usr/informix/online.log # System message log file path
CONSOLE /dev/console # System console message path
ALARMPROGRAM /usr/informix/log_full.sh # Alarm program path
# System Archive Tape Device
TAPEDEV /dev/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 /u/log_file # Log tape device path
LTAPEBLK 16 # Log tape block size (Kbytes)
LTAPESIZE 500000 # Max amount of data to put on log tape (Kbytes)
# Optical
STAGEBLOB ,1 # INFORMIX-OnLine/Optical staging area
# System Configuration
SERVERNUM 1 # Unique id corresponding to a OnLine instance
DBSERVERNAME online # Name of default database server
DBSERVERALIASES # List of alternate dbservernames
NETTYPE ipcshm,1,40,CPU # Configure poll thread(s) for nettype
DEADLOCK_TIMEOUT 60 # Max time to wait of lock in distributed env.
RESIDENT 0 # 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 1 # 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 800000 # Maximum number of locks
BUFFERS 20000 # Maximum number of shared buffers
NUMAIOVPS # Number of IO vps
PHYSBUFF 32 # Physical log buffer size (Kbytes)
LOGBUFF 32 # Logical log buffer size (Kbytes)
LOGSMAX 12 # Maximum number of logical log files
CLEANERS 1 # Number of buffer cleaner processes
SHMBASE 0x82000000 # Shared memory base address
SHMVIRTSIZE 8000 # initial virtual shared memory segment size
SHMADD 8192 # 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 60 # LRU percent dirty begin cleaning limit
LRU_MIN_DIRTY 50 # 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 /usr/informix/etc/dr.lostfound # 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 /tmp/bar_act.log
BAR_MAX_BACKUP 0
BAR_RETRY 1
BAR_NB_XPORT_COUNT 10
BAR_XFER_BUF_SIZE 31
# Read Ahead Variables
RA_PAGES # 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 # 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
FILLFACTOR 90 # 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)
MAX_PDQPRIORITY 100 # Maximum allowed pdqpriority
DS_MAX_QUERIES # Maximum number of decision support queries
DS_TOTAL_MEMORY # Decision support memory (Kbytes)
DS_MAX_SCANS 1048576 # 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 2 # To hint the optimizer
ONDBSPACEDOWN 2 # Dbspace down option: 0 = CONTINUE, 1 = ABORT, 2 = WAIT
LBU_PRESERVE 0 # Preserve last log for log backup
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
Userthreads
address flags sessid user tty wait tout locks nreads nwrites
87c42014 ---P--D 1 root - 0 0 0 467 2704
87c42450 ---P--F 0 root - 0 0 0 0 15145
87c4288c ---P--B 6 root - 0 0 0 5 0
87c43540 ---P--D 9 root - 0 0 0 0 0
87c44a6c Y--P--- 41 posp ttyp0 87d81acc 0 1 10 0
87c44ea8 Y--P--- 32 posp - 87dbd438 0 1 72966 1888
87c452e4 Y--P--- 31 posp - 87d0dad4 0 1 78739 2000
87c45b5c Y--P--- 33 posp - 87dbdbc0 0 1 47322 1888
8 active, 128 total, 17 maximum concurrent
Latches with lock or userthread set
name address lock wait userthread
flushr0 87c4022c 1 0 87ccd10c
Locks
address wtlist owner lklist type tblsnum rowid key#/bsiz
82793d8c 0 0 0 HDR+ 100002 204 0
82793df4 0 87c452e4 0 S 100002 204 0
82793f2c 0 87c44a6c 0 S 100002 204 0
82793f60 0 87c44ea8 0 S 100002 204 0
82793f94 0 87c45b5c 0 S 100002 204 0
5 active, 800000 total, 131072 hash buckets
Buffers
address userthread flgs pagenum memaddr nslots pgflgs xflgs owner waitlist
36 modified, 20000 total, 32768 hash buckets, 2048 buffer size
Tblspaces
n address flgs ucnt tblnum physaddr npages nused npdata nrows nextns
2 87c4065c 0 1 100001 10000e 250 216 0 0 5
156 87c6d388 0 4 10009d 185d39 16 9 4 59 2
2 active, 211 total
Dbspaces
address number flags fchunk nchunks flags owner name
87c400ec 1 1 1 1 N informix rootdbs
1 active, 2047 maximum
Chunks
address chk/dbs offset size free bpages flags pathname
87c40158 1 1 0 1000000 291984 PO- /dev/chunk1
1 active, 2047 maximum
Physical Logging
Buffer bufused bufsize numpages numwrits pages/io
P-2 15 16 12455 890 13.99%
phybegin physize phypos phyused %used
10003f 60000 3579 31 0.05
Logical Logging
Buffer bufused bufsize numrecs numpages numwrits recs/pages pages/io
L-1 0 16 35603 3803 3270 9.4 1.2
address number flags uniqid begin size used %used
84f4018c 1 U-B---- 37 10ea9f 30000 2 0.01%
84f401a8 2 U------ 38 115fcf 30000 30000 100.00%
84f401c4 3 U---C-L 39 11d4ff 30000 22388 74.63%
84f401e0 4 U-B---- 28 124a2f 30000 2 0.01%
84f401fc 5 U-B---- 29 12bf5f 30000 2 0.01%
84f40218 6 U-B---- 30 13348f 30000 2 0.01%
84f40234 7 U-B---- 31 13a9bf 30000 2 0.01%
84f40250 8 U-B---- 32 141eef 30000 3 0.01%
84f4026c 9 U-B---- 33 14941f 30000 2 0.01%
84f40288 10 U-B---- 34 15094f 30000 2 0.01%
84f402a4 11 U-B---- 35 157e7f 30000 2 0.01%
84f402c0 12 U-B---- 36 15f3af 30000 2 0.01%
Profile
dskreads pagreads bufreads %cached dskwrits pagwrits bufwrits %cached
69941104 69941122 314366385 77.75 19556 31639 78927 75.22
isamtot open start read write rewrite delete commit rollbk
1441302 120040 211898 407687 16874 17892 2061 8136 0
ovlock ovuserthread ovbuff usercpu syscpu numckpts flushes
0 0 0 311.24 285.62 247 636
bufwaits lokwaits lockreqs deadlks dltouts ckpwaits compress seqscans
21704143 0 1968798266 0 0 6 1892 30131
ixda-RA idx-RA da-RA RA-pgsused lchwaits
42804 36 69762307 69804795 795
MT global info:
sessions threads vps lngspins
4 20 11 0
sched calls thread switches yield 0 yield n yield forever
total: 71845916 66438759 5952592 250842 34703954
per sec: 4 4 0 2 0
Virtual processor summary:
class vps usercpu syscpu total
cpu 1 233.53 94.48 328.01
aio 6 77.70 189.71 267.41
lio 1 0.01 0.09 0.10
pio 1 0.00 0.15 0.15
adm 1 0.00 1.19 1.19
msc 1 0.00 0.00 0.00
total 11 311.24 285.62 596.86
Individual virtual processors:
vp pid class usercpu syscpu total
1 157 cpu 233.53 94.48 328.01
2 158 adm 0.00 1.19 1.19
3 159 lio 0.01 0.09 0.10
4 160 pio 0.00 0.15 0.15
5 161 aio 3.03 7.67 10.70
6 162 msc 0.00 0.00 0.00
7 163 aio 3.52 8.90 12.42
8 164 aio 3.97 9.64 13.61
9 165 aio 6.14 14.84 20.98
10 166 aio 24.06 59.94 84.00
11 167 aio 36.98 88.72 125.70
tot 311.24 285.62 596.86
Queue statistics not enabled
Wait statistics not enabled
Threads:
tid tcb rstcb prty status vp-class name
2 87c3f404 0 2 sleeping(Forever) 3lio lio vp 0
3 87c3f768 0 2 sleeping(Forever) 4pio pio vp 0
4 87c3facc 0 2 sleeping(Forever) 5aio aio vp 0
5 87c3fe50 0 2 sleeping(Forever) 6msc msc vp 0
6 87cb931c 0 2 sleeping(Forever) 7aio aio vp 1
7 87ccd10c 87c42014 4 sleeping(secs: 1) 1cpu main_loop()
8 87ccd7ec 0 2 running 1cpu sm_poll
9 87ce19b0 0 2 sleeping(Forever) 1cpu sm_listen
10 87d3d430 0 2 sleeping(secs: 2) 1cpu sm_discon
11 87d3d688 87c42450 2 sleeping(Forever) 1cpu flush_sub(0)
12 87d3da94 0 2 sleeping(Forever) 8aio aio vp 2
13 87d3dca0 0 2 sleeping(Forever) 9aio aio vp 3
14 87d4b0c0 0 2 sleeping(Forever) 10aio aio vp 4
15 87d4b290 0 2 sleeping(Forever) 11aio aio vp 5
16 87d4b740 87c4288c 2 sleeping(secs: 49) 1cpu btclean
32 87d313b0 87c43540 4 sleeping(secs: 1) 1cpu onmode_mon
55 87d0dd2c 87c452e4 2 cond wait(sm_read) 1cpu sqlexec
56 87dbd690 87c44ea8 2 cond wait(sm_read) 1cpu sqlexec
57 87dbde18 87c45b5c 2 cond wait(sm_read) 1cpu sqlexec
65 87d81d24 87c44a6c 2 cond wait(sm_read) 1cpu sqlexec
Spin locks with waits:
Num Waits Num Loops Avg Loop/Wait Name
384 384 1.00 mtcb mutex_list_lock
773 776 1.00 vproc vp_lock, id = 1
2 2 1.00 vproc vp_lock, id = 5
2 2 1.00 vproc vp_lock, id = 7
1 1 1.00 vproc vp_lock, id = 8
1 1 1.00 mutex lock, name = sbpool
522 522 1.00 mutex lock, name = bbpool
222 222 1.00 mutex lock, name = aioshcb
1312 1312 1.00 mutex lock, name = vpc aio
2 2 1.00 mutex lock, name = iovp aio 0
1 1 1.00 mutex lock, name = iovp aio 1
50 50 1.00 mutex lock, name = ioq gfd 3
16 16 1.00 tcb lock, tid = 4
8 8 1.00 tcb lock, tid = 6
3 3 1.00 tcb lock, tid = 12
13 13 1.00 tcb lock, tid = 55
9 9 1.00 tcb lock, tid = 56
3 3 1.00 tcb lock, tid = 57
2252 2252 1.00 shmcb sh_lock
982 982 1.00 pool po_lock, name = global
1007 1008 1.00 pool po_lock, name = mt
596 596 1.00 sh_ra_list_lock
2188984368 799995 0.00 lockfr0
65536 1 0.00 fast mutex, flush
Locked mutexes:
mid addr name holder lkcnt waiter waittime
290 87ccdb94 uselock2 65 0
295 87ccdd10 uselock7 55 0
296 87ccdd5c uselock8 56 0
297 87ccdda8 uselock9 57 0
Mutexes with waiters:
mid addr name holder lkcnt waiter waittime
Conditions with waiters:
cid addr name waiter waittime
292 87d0dad4 sm_read 55 220
297 87dbd438 sm_read 56 25
302 87dbdbc0 sm_read 57 5
343 87d81acc sm_read 65 14261
Conditions:
cid addr name waiter waittime
1 8200ac44 main 0 -1
2 82013c50 block 0 -1
3 87c06ff8 nsf.wait 0 -1
5 87c76f00 sm_poll_con 0 -1
6 82013bd8 adt_cond 0 -1
7 87c1ee6c gfile 0 -1
8 87c1eefc gfile 0 -1
9 87c1ef8c gfile 0 -1
10 87c1f01c gfile 0 -1
11 87c1f0ac gfile 0 -1
12 87c1f13c gfile 0 -1
13 87c1f1cc gfile 0 -1
14 87c1f25c gfile 0 -1
15 87c1f2ec gfile 0 -1
16 87c1f37c gfile 0 -1
17 87c1f40c gfile 0 -1
18 87c1f49c gfile 0 -1
19 87c1f52c gfile 0 -1
20 87c1f5bc gfile 0 -1
21 87c1f64c gfile 0 -1
22 87c1f6dc gfile 0 -1
23 87c1f76c gfile 0 -1
24 87c1f7fc gfile 0 -1
25 87c1f88c gfile 0 -1
26 87c1f91c gfile 0 -1
27 87c1f9ac gfile 0 -1
28 87c1fa3c gfile 0 -1
29 87c1facc gfile 0 -1
30 87c1fb5c gfile 0 -1
31 87c1fbec gfile 0 -1
32 87c1fc7c gfile 0 -1
33 87c1fd0c gfile 0 -1
34 87c1fd9c gfile 0 -1
35 87c1fe2c gfile 0 -1
36 87c1febc gfile 0 -1
37 87c1ff4c gfile 0 -1
38 87c3e090 gfile 0 -1
39 87c3e120 gfile 0 -1
40 87c3e1b0 gfile 0 -1
41 87c3e240 gfile 0 -1
42 87c3e2d0 gfile 0 -1
43 87c3e360 gfile 0 -1
44 87c3e3f0 gfile 0 -1
45 87c3e480 gfile 0 -1
46 87c3e510 gfile 0 -1
47 87c3e5a0 gfile 0 -1
48 87c3e630 gfile 0 -1
49 87c3e6c0 gfile 0 -1
50 87c3e750 gfile 0 -1
51 87c3e7e0 gfile 0 -1
52 87c3e870 gfile 0 -1
53 87c3e900 gfile 0 -1
54 87c3e990 gfile 0 -1
55 87c3ea20 gfile 0 -1
56 87c3eab0 gfile 0 -1
57 87c3eb40 gfile 0 -1
58 87c3ebd0 gfile 0 -1
59 87c3ec60 gfile 0 -1
60 87c3ecf0 gfile 0 -1
61 87c3ed80 gfile 0 -1
62 87c3ee10 gfile 0 -1
63 87c3eea0 gfile 0 -1
64 87c3ef30 gfile 0 -1
65 87c3efc0 gfile 0 -1
66 87c3f050 gfile 0 -1
67 87c3f0e0 gfile 0 -1
68 87c3f170 gfile 0 -1
69 87c3f200 gfile 0 -1
70 87c3f290 gfile 0 -1
71 87ccd318 drcb_bqe 0 -1
72 87ccd3a8 drcb_bqf 0 -1
73 87ccd484 drbt_sndq 0 -1
74 87ccd514 drbt_rcvq 0 -1
75 87ccd688 netnorm 0 -1
76 87ccd764 arrived 0 -1
77 87ccd7a8 closing 0 -1
78 87ce184c netnorm 0 -1
79 87ce1928 arrived 0 -1
80 87ce196c closing 0 -1
81 87cb9570 sl_mux_recv 0 -1
83 87d3d2cc netnorm 0 -1
84 87d3d3a8 arrived 0 -1
85 87d3d3ec closing 0 -1
86 820127dc cp 0 -1
87 820126b4 plogpl 0 -1
88 82012730 plogothr 0 -1
89 82012590 log 0 -1
90 87d3d8e4 logbf0 0 -1
91 87d3d928 logbf1 0 -1
92 87d3d96c logbf2 0 -1
93 87d4bc3c pt_100001 0 -1
118 87c06ad0 pt_100002 0 -1
119 87d5f074 pt_100003 0 -1
125 87d817b0 pt_10009d 0 -1
126 87d95074 pt_1000a3 0 -1
127 87dbd074 pt_1000a0 0 -1
128 87dd1028 pt_10009e 0 -1
129 87dd1104 pt_1000b0 0 -1
130 87dd1194 pt_1000a1 0 -1
131 87dd1224 pt_1000b8 0 -1
132 87dd12b4 pt_10009f 0 -1
133 87d21074 pt_1000b1 0 -1
134 87d21104 pt_1000aa 0 -1
135 87d21194 pt_1000a7 0 -1
136 87cb97cc pt_1000a9 0 -1
137 87cb985c pt_1000ab 0 -1
138 87e7b074 pt_1000b2 0 -1
139 87e7b104 pt_1000b5 0 -1
140 87e7b194 pt_1000b9 0 -1
141 87e7b224 pt_1000b4 0 -1
142 87e7b2b4 pt_1000cf 0 -1
143 87e300ac pt_1000c0 0 -1
149 87d0d7fc pt_10003f 0 -1
150 87d4bccc pt_100069 0 -1
151 87d4b94c pt_100066 0 -1
152 87c06b60 pt_100064 0 -1
153 87e9e060 pt_100076 0 -1
154 87e9e0f0 pt_100067 0 -1
155 87e9e180 pt_10007e 0 -1
156 87e9e210 pt_100065 0 -1
157 87d5f104 pt_100077 0 -1
158 87d5f194 pt_100070 0 -1
159 87d5f224 pt_10006d 0 -1
160 87e91074 pt_10006f 0 -1
161 87e91104 pt_100071 0 -1
162 87d31570 pt_100078 0 -1
163 87d31600 pt_10007b 0 -1
164 87d31690 pt_10007f 0 -1
165 87d31720 pt_10007a 0 -1
166 87d317b0 pt_100096 0 -1
167 87dd1344 pt_100088 0 -1
173 87cb98ec pt_100082 0 -1
183 87e65764 pt_100084 0 -1
190 87e39484 pt_100097 0 -1
191 87e39514 pt_10008b 0 -1
192 87e395a4 pt_100087 0 -1
193 87d4bd5c pt_100085 0 -1
194 87d4bdec pt_100083 0 -1
195 87d4b9dc pt_100092 0 -1
221 87e9a9c0 pt_10008f 0 -1
222 87d6b074 pt_10009a 0 -1
223 87d81840 pt_100081 0 -1
224 87d95104 pt_100090 0 -1
225 87da9074 pt_10008a 0 -1
240 87e3c014 pt_1000c5 0 -1
241 87d6b104 pt_1000d1 0 -1
242 87d6b194 pt_1000ca 0 -1
243 87d6b224 pt_1000c6 0 -1
244 87d6b2b4 pt_1000cd 0 -1
245 87da9104 pt_1000d2 0 -1
246 87da91e0 pt_1000c9 0 -1
248 87d21224 pt_1000ba 0 -1
249 87d212b4 pt_1000d4 0 -1
250 87cb99c8 pt_1000c3 0 -1
251 87d4ba6c pt_100095 0 -1
252 87d95194 pt_10008d 0 -1
253 87da92bc pt_100086 0 -1
288 87dd14b8 sl_mux_recv 0 -1
289 87d0d8d8 netnorm 0 -1
290 87d0d9b4 arrived 0 -1
291 87d0d9f8 closing 0 -1
292 87d0dad4 sm_read 55 220
293 87d0dfb0 sl_mux_recv 0 -1
294 87d31028 netnorm 0 -1
295 87d31104 arrived 0 -1
296 87d31148 closing 0 -1
297 87dbd438 sm_read 56 25
298 87dbd934 sl_mux_recv 0 -1
299 87dbd9c4 netnorm 0 -1
300 87dbdaa0 arrived 0 -1
301 87dbdae4 closing 0 -1
302 87dbdbc0 sm_read 57 5
309 87e9a1f4 pt_10006e 0 -1
339 87d0d6d4 sl_mux_recv 0 -1
340 87d818d0 netnorm 0 -1
341 87d819ac arrived 0 -1
342 87d819f0 closing 0 -1
343 87d81acc sm_read 65 14261
3620 87ddf3f4 pt_100089 0 -1
4971 87e39680 pt_10009c 0 -1
13892 87d31840 pt_100080 0 -1
21038 87e3013c pt_100009 0 -1
21039 87e301cc pt_100006 0 -1
21040 87dd14fc pt_100004 0 -1
21041 87cb9a58 pt_100016 0 -1
21042 87e39710 pt_100007 0 -1
21043 87ce1b70 pt_10001e 0 -1
21044 87ce1c00 pt_100005 0 -1
21045 87e450b8 pt_100017 0 -1
21046 87e45148 pt_100010 0 -1
21047 87e451d8 pt_10000d 0 -1
21048 87e45268 pt_100018 0 -1
21049 87e452f8 pt_10001b 0 -1
21050 87e45388 pt_10001f 0 -1
21051 87e45418 pt_10001a 0 -1
21052 87e454a8 pt_f 0 -1
21053 87e45538 pt_100008 0 -1
21054 87e455c8 pt_10000a 0 -1
21055 87e45658 pt_10000b 0 -1
21056 87e456e8 pt_10000c 0 -1
21057 87e45778 pt_10000e 0 -1
21058 87e45808 pt_10000f 0 -1
21059 87e45898 pt_100011 0 -1
21060 87e45928 pt_100012 0 -1
21061 87e459b8 pt_100013 0 -1
21062 87e45a48 pt_100014 0 -1
21063 87e45ad8 pt_100015 0 -1
21064 87e45b68 pt_100019 0 -1
21065 87e45bf8 pt_10001c 0 -1
21066 87e45c88 pt_10001d 0 -1
21067 87e45d18 pt_100020 0 -1
21068 87e45da8 pt_100021 0 -1
21069 87e45e38 pt_100022 0 -1
21070 87e45ec8 pt_100023 0 -1
21071 87e45f58 pt_100024 0 -1
21072 87e45fe8 pt_100025 0 -1
21073 87e46078 pt_100026 0 -1
21074 87e46108 pt_100027 0 -1
21075 87e46198 pt_100028 0 -1
21076 87e46228 pt_100029 0 -1
21077 87e462b8 pt_10002a 0 -1
21078 87e46348 pt_10002b 0 -1
21079 87e463d8 pt_10002c 0 -1
21080 87e46468 pt_10002d 0 -1
21081 87e464f8 pt_10002e 0 -1
21082 87e46588 pt_10002f 0 -1
21083 87e46618 pt_100030 0 -1
21084 87e466a8 pt_100031 0 -1
21085 87e46738 pt_100032 0 -1
21086 87e467c8 pt_100033 0 -1
21087 87e46858 pt_100034 0 -1
21088 87e468e8 pt_100035 0 -1
21089 87e46978 pt_100036 0 -1
21090 87e46a08 pt_100037 0 -1
21091 87e46a98 pt_100038 0 -1
21092 87e46b28 pt_100039 0 -1
21093 87e46bb8 pt_10003a 0 -1
21094 87e46c48 pt_10003b 0 -1
21095 87e46cd8 pt_10003c 0 -1
21096 87e46d68 pt_10003d 0 -1
21097 87e46df8 pt_10003e 0 -1
21098 87e46e88 pt_100040 0 -1
21099 87e46f18 pt_100041 0 -1
21100 87e46fa8 pt_100042 0 -1
21101 87e47038 pt_100043 0 -1
21102 87e470c8 pt_100044 0 -1
21103 87e47158 pt_100045 0 -1
21104 87e471e8 pt_100046 0 -1
21105 87e47278 pt_100047 0 -1
21106 87e47308 pt_100048 0 -1
21107 87e47398 pt_100049 0 -1
21108 87e47428 pt_10004a 0 -1
21109 87e474b8 pt_10004b 0 -1
21110 87e47548 pt_10004c 0 -1
21111 87e475d8 pt_10004d 0 -1
21112 87e47668 pt_10004e 0 -1
21113 87e476f8 pt_10004f 0 -1
21114 87e47788 pt_100050 0 -1
21115 87e47818 pt_100051 0 -1
21116 87e478a8 pt_100052 0 -1
21117 87e47938 pt_100053 0 -1
21118 87e479c8 pt_100054 0 -1
21119 87e47a58 pt_100055 0 -1
21120 87e47ae8 pt_100056 0 -1
21121 87e47b78 pt_100057 0 -1
21122 87e47c08 pt_100058 0 -1
21123 87e47c98 pt_100059 0 -1
21124 87e47d28 pt_10005a 0 -1
21127 87d5f2b4 pt_10005d 0 -1
21128 87d5f344 pt_10005e 0 -1
21129 87d5f3d4 pt_10005f 0 -1
21130 87d5f464 pt_100060 0 -1
21131 87d5f4f4 pt_100061 0 -1
21132 87d5f584 pt_100062 0 -1
21133 87d5f614 pt_100063 0 -1
21134 87d5f6a4 pt_100068 0 -1
21135 87d5f734 pt_10006a 0 -1
21136 87d5f7c4 pt_10006b 0 -1
21137 87d5f854 pt_10006c 0 -1
21138 87d5f8e4 pt_100072 0 -1
21139 87d5f974 pt_100073 0 -1
21140 87d5fa04 pt_100074 0 -1
21141 87d5fa94 pt_100075 0 -1
21142 87d5fb24 pt_100079 0 -1
21143 87d5fbb4 pt_10007c 0 -1
21144 87d5fc44 pt_10007d 0 -1
21145 87d5fcd4 pt_10008c 0 -1
21146 87d5fd64 pt_10008e 0 -1
21147 87d5fdf4 pt_100091 0 -1
21148 87d5fe84 pt_100093 0 -1
21149 87d5ff14 pt_100094 0 -1
21150 87d5ffa4 pt_100098 0 -1
21151 87ddf438 pt_100099 0 -1
21152 87ddf4c8 pt_10009b 0 -1
21153 87ddf558 pt_1000a2 0 -1
21154 87ddf5e8 pt_1000a4 0 -1
21155 87ddf678 pt_1000a5 0 -1
21156 87ddf708 pt_1000a6 0 -1
21157 87ddf798 pt_1000a8 0 -1
21158 87ddf828 pt_1000ac 0 -1
21159 87ddf8b8 pt_1000ad 0 -1
21160 87ddf948 pt_1000ae 0 -1
21161 87ddf9d8 pt_1000af 0 -1
21162 87ddfa68 pt_1000b3 0 -1
21163 87ddfaf8 pt_1000b6 0 -1
21164 87ddfb88 pt_1000b7 0 -1
21165 87ddfc18 pt_1000bb 0 -1
21166 87ddfca8 pt_1000bc 0 -1
21167 87ddfd38 pt_1000bd 0 -1
21168 87ddfdc8 pt_1000be 0 -1
21169 87ddfe58 pt_1000bf 0 -1
21170 87ddfee8 pt_1000c1 0 -1
21171 87ddff78 pt_1000c2 0 -1
21172 87e2c03c pt_1000c4 0 -1
21173 87e2c0cc pt_1000c7 0 -1
21174 87e2c15c pt_1000c8 0 -1
21175 87e2c1ec pt_1000cb 0 -1
21176 87e2c27c pt_1000cc 0 -1
21177 87e2c30c pt_1000ce 0 -1
21178 87e2c39c pt_1000d0 0 -1
21179 87e2c42c pt_1000d3 0 -1
27304 87d6b5e8 sl_mux_recv 0 -1
Pool Summary:
name class addr totalsize freesize #allocfrag #freefrag
resident R 82002014 53886976 14208 2 2
res-buff R 85366014 40976384 14208 2 2
global V 87c02014 221944 86888 587 64
mt V 87c06014 1564984 437592 1043 38
rsam V 87c40014 262144 1208 649 1
aio V 87c78014 499712 72240 178 24
gls V 87c7c014 24576 5096 348 5
dictpool V 87c80014 139264 8396 128 13
procpool V 87c82014 8192 7148 4 1
XTF_mem V 87c9e014 24576 15212 4 2
main_loop() V 87d26014 16384 6320 111 2
2 V 87d32014 8192 3604 7 1
shmcon M 88402014 434176 12160 2 2
3 V 87d40014 16384 4160 206 1
5 V 87d54014 8192 3604 7 1
btclean V 87dc4014 16384 6304 111 1
onmode_mon V 87de4014 16384 7220 108 1
31 V 87eac014 57344 27600 323 14
32 V 87ec6014 65536 35780 323 15
33 V 87eca014 57344 27564 323 13
41 V 87e0e014 40960 14040 280 6
5404 V 87dd4014 8192 3604 7 1
Blkpool Summary:
name class addr size #blks
global V 87c02080 0 0
Segment Summary:
(resident segments are not locked)
id key addr size ovhd class blkused blkfree
0 1381451777 82000000 94928896 2264 R 11581 7
1 1381451778 87c00000 8192000 716 V 374 626
2 1381451779 88400000 499712 596 M 54 7
Total: - - 103620608 - - 12009 640
Block bitmap for resident segment address 82000000:
(bitmap address = 82000248, bitmap size = 1452)
82000248:ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff
82000268:ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff
82000288:ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff
820002a8:ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff
820002c8:ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff
820002e8:ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff
82000308:ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff
82000328:ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff
82000348:ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff
82000368:ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff
82000388:ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff
820003a8:ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff
820003c8:ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff
820003e8:ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff
82000408:ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff
82000428:ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff
82000448:ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff
82000468:ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff
82000488:ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff
820004a8:ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff
820004c8:ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff
820004e8:ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff
82000508:ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff
82000528:ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff
82000548:ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff
82000568:ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff
82000588:ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff
820005a8:ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff
820005c8:ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff
820005e8:ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff
82000608:ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff
82000628:ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff
82000648:ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff
82000668:ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff
82000688:ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff
820006a8:ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff
820006c8:ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff
820006e8:ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff
82000708:ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff
82000728:ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff
82000748:ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff
82000768:ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff
82000788:ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff
820007a8:ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff
820007c8:ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff ffffffff
820007e8:ffffffff f8ffffff 00000000
Block bitmap for virtual segment address 87c00000:
(bitmap address = 87c00248, bitmap size = 12
87c00248:ffffffff ffffffff ffffffff ffffffff ffffffff ffffbfff ffffffff 8ff0bfff
87c00268:fbfeefff 7fffffff fff7fdff dffcffff 003e0184 00000000 00000000 00000000
87c00288:00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
87c002a8:00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
Dictionary Cache: Number of lists: 31, Maximum list size: 10
list# size refcnt dirty? heapptr table name
--------------------------------------------------------
0 1 0 no 87ed941c pospdb@online:pos.posp_file
1 3 0 no 87ee241c pospdb@online:pos.posp_unit
0 no 87ed141c pospdb@online:posp.t_card
0 no 87e0201c ccundb@online:ccun.td_cardtable
4 3 0 no 87ee6c1c ccundb@online:ccun.tc_spcresponsecode
0 no 87ef201c ccundb@online:informix.syscolumns
0 no 87c81730 ccundb@online:ccun.td_amcoperator
5 2 0 no 87ed8c1c pospdb@online:nhpre.c_tounitno
0 no 87e0601c ccundb@online:ccun.td_commodule
6 4 0 no 87ebb434 ccundb@online:ccun.td_transdefinition
0 no 87dfd834 ccundb@online:ccun.td_historytrans
0 no 87dfc01c ccundb@online:ccun.td_spcexeptionlog
0 no 87dfac1c ccundb@online:ccun.td_transobject
7 1 0 no 87ee741c ccundb@online:ccun.td_translog
9 1 0 no 87eabc1c ccundb@online:ccun.endday
10 1 0 no 87dfc81c ccundb@online:ccun.td_termserhis
11 1 0 no 87e06c1c ccundb@online:ccun.td_sysparameter
12 1 0 no 87e0581c ccundb@online:ccun.tc_packparameter
13 1 0 no 87eaac1c ccundb@online:ccun.td_hostparameter
14 2 0 no 87eb641c ccundb@online:ccun.td_merchant
0 no 87e04c1c ccundb@online:ccun.td_fieldtable
16 3 0 no 87eba01c ccundb@online:ccun.td_soterm
0 no 87dfa41c ccundb@online:ccun.td_amcoperatinglog
0 no 87eab41c sysmaster@online:informix.systabnames
18 2 0 no 87ef281c ccundb@online:informix.sysindexes
0 no 87ed001c pospdb@online:pos.bank_ref
19 3 0 no 87ed841c pospdb@online:pfpos.c_maskwork
0 no 87ebc41c ccundb@online:ccun.td_thisbatchtrans
0 no 87ee641c ccundb@online:ccun.td_rspcodecontrast
20 2 0 no 87edc81c pospdb@online:pos.posp_c_trans
0 no 87ed801c pospdb@online:hxpos.serial
21 1 0 no 87c80318 pospdb@online:pos.c_operf
22 1 0 no 87ee3160 pospdb@online:pos.c_seraccf
24 2 0 no 87e03870 ccundb@online:ccun.td_kindexparameter
0 no 87e07c1c ccundb@online:ccun.td_reckey
25 1 0 no 87e186c8 ccundb@online:informix.systables
26 1 0 no 87edd99c pospdb@online:pfpos.luck_way
27 1 0 no 87e0441c ccundb@online:ccun.td_sysparaversion
30 1 0 no 87c80f30 pospdb@online:pos.c_syslog
Total number of dictionary entries: 39
Distribution Cache:
Number of lists : 31
DS_POOLSIZE : 50
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.
Stored Procedure Cache:
Number of lists : 31
PC_POOLSIZE : 50
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.
VP Scheduler Statistics:
vp pid class semops busy waits spins/wait
1 157 cpu 22 0 0
2 158 adm 0 0 0
3 159 lio 3271 0 0
4 160 pio 891 0 0
5 161 aio 1309090 0 0
6 162 msc 3 0 0
7 163 aio 1362955 0 0
8 164 aio 2488548 0 0
9 165 aio 2595394 0 0
10 166 aio 2566275 0 0
11 167 aio 2559980 0 0
AIO global info:
6 aio classes
4 open files
64 max global files
AIO I/O queues:
q name/id len maxlen totalops dskread dskwrite dskcopy
adt 0 0 0 0 0 0 0
msc 0 0 1 1 0 0 0
aio 0 0 4 32 7 2 0
pio 0 0 1 890 0 890 0
lio 0 0 1 3270 0 3270 0
gfd 3 0 25 69956500 69941104 15396 0
AIO I/O vps:
class/vp s io/s totalops dskread dskwrite dskcopy wakeups io/wup errors
msc 0 i 0.0 1 0 0 0 2 0.5 0
aio 0 i 28.1 2701301 2699003 2285 0 1309017 2.1 0
aio 1 i 28.1 2699488 2696269 3211 0 1362887 2.0 0
aio 2 i 28.1 2700673 2697728 2944 0 2488486 1.1 0
aio 3 i 28.8 2768545 2766680 1864 0 2595294 1.1 0
aio 4 i 33.9 3259218 3257336 1882 0 2565868 1.3 0
aio 5 i 36.6 3517074 3515235 1839 0 2559934 1.4 0
pio 0 i 0.0 890 0 890 0 890 1.0 0
lio 0 i 0.0 3270 0 3270 0 3271 1.0 0
AIO global files:
gfd pathname totalops dskread dskwrite io/s
3 /dev/chunk1 17650427 17632244 18183 183.5
AIO big buffer usage summary:
class reads writes
pages ops pgs/op holes hl-ops hls/op pages ops pgs/op
kio 0 0 0.00 0 0 0.00 0 0 0.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 70036896 17632244 3.97 95774 52092 1.84 15396 14023 1.10
pio 0 0 0.00 0 0 0.00 12440 890 13.98
lio 0 0 0.00 0 0 0.00 3803 3270 1.16
global network information:
#netscb connects read write q-free q-limits q-exceed
7/ 15 5394 132002 132276 0/ 0 0/ 0 0/ 0
Individual thread network information (basic):
netscb type thread name sid fd poll reads writes q-nrm q-exp
87eb3090 ipcshm sqlexec 41 0 0 11 11 -2/ 0 0/ 0
87eb2aa4 ipcshm sqlexec 33 0 0 18784 18784 -3490/ 0 0/ 0
87ec50c0 ipcshm sqlexec 32 0 0 19235 19236 -3549/ 0 0/ 0
87ec41b8 ipcshm sqlexec 31 0 0 17146 17146 -3202/ 0 0/ 0
87d4fd78 ipcshm sm_discon 5 0 0 0 0 0/ 0 0/ 0
87d3ef88 ipcshm sm_listen 3 0 0 5394 0 0/ 0 0/ 0
87c7f8a4 ipcshm sm_poll 2 0 0 116063 0 0/ 0 0/ 0
Individual thread network information (times):
netscb thread name sid open read write address
87eb3090 sqlexec 41 09:00:35 07:42:40 07:42:40
09/06/04
87eb2aa4 sqlexec 33 08:59:42 11:40:16 11:40:16
09/06/04
87ec50c0 sqlexec 32 08:59:42 11:39:56 11:39:56
09/06/04
87ec41b8 sqlexec 31 08:59:42 11:36:41 11:36:41
09/06/04
87d4fd78 sm_discon 5 08:57:11
09/06/04
87d3ef88 sm_listen 3 08:57:11
09/06/04
87c7f8a4 sm_poll 2 08:57:06
09/06/04
Network mailbox information:
box netscb thread name max received in box max in box full signal
Client Type Calls Accepted Rejected Read Write
sqlexec yes 5394 0 126608 132276
srvinfx yes 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 5394 0
crsamexec yes 0 0 0 0
safe yes 0 0 0 0
Totals 5394 0 132002 132276
Network Shared Memory Data for Poll Thread: 0
Free Message Buffer Bitmap
(bitmap address = 87c7fd80, bitmap size 383)
87c7fd80:ffff00ff ffffffff 000000ff ffffffff ffffffff ffffffff ffffffff ffffffff
87c7fda0:ffffffff ffffffff ffffffff ffffffff
Free Message Buffer Status Bitmap
(bitmap address = 8840901c, bitmap size 40)
8840901c:7bfcffff ff
Message Buffer Table
bufid clientid addr
16 2 8840d164
17 2 8840d578
18 2 8840d98c
19 2 8840dda0
20 2 8840e1b4
21 2 8840e5c8
22 2 8840e9dc
23 2 8840edf0
64 7 88419524
65 7 88419938
66 7 88419d4c
67 7 8841a160
68 7 8841a574
69 7 8841a988
70 7 8841ad9c
71 7 8841b1b0
72 8 8841b5c4
73 8 8841b9d8
74 8 8841bdec
75 8 8841c200
76 8 8841c614
77 8 8841ca28
78 8 8841ce3c
79 8 8841d250
80 9 8841d664
81 9 8841da78
82 9 8841de8c
83 9 8841e2a0
84 9 8841e6b4
85 9 8841eac8
86 9 8841eedc
87 9 8841f2f0
Message Buffer Status Table
clientid netscb addr addr offset
2 87eb3090 884044b4 44b4
7 87ec41b8 88404ea0 4ea0
8 87ec50c0 8840509c 509c
9 87eb2aa4 88405298 5298
clientid clientPID state #serverbufs #clientbufs #rdwrts
2 855 Connected 4 4 24
8 695 Connected 4 4 38473
7 696 Connected 4 4 34294
9 694 Connected 4 4 37570
Stack usage:
TID Total Max Current Thread Name
bytes % bytes %
2 32768 903 2 572 1 lio vp 0
3 32768 991 3 572 1 pio vp 0
4 32768 3039 9 572 1 aio vp 0
5 131072 2947 2 572 0 msc vp 0
6 32768 3039 9 572 1 aio vp 1
7 32768 4407 13 1276 3 main_loop()
8 32768 1267 3 780 2 sm_poll
9 32768 6059 18 2848 8 sm_listen
10 32768 995 3 508 1 sm_discon
11 32768 1587 4 820 2 flush_sub(0)
12 32768 2638 8 572 1 aio vp 2
13 32768 3039 9 572 1 aio vp 3
14 32768 3039 9 572 1 aio vp 4
15 32768 3039 9 572 1 aio vp 5
16 32768 4267 13 516 1 btclean
32 32768 1391 4 904 2 onmode_mon
55 32768 6018 18 968 2 sqlexec
56 32768 6286 19 968 2 sqlexec
57 32768 6286 19 968 2 sqlexec
65 32768 4331 13 968 2 sqlexec
session #RSAM total used
id user tty pid hostname threads memory memory
5404 root - 0 - 0 8192 4588
41 posp ttyp0 855 scokb 1 40960 26920
33 posp - 694 scokb 1 57344 29780
32 posp - 695 scokb 1 65536 29756
31 posp - 696 scokb 1 57344 29744
5 root - 0 - 0 8192 4588
3 root - 0 - 0 16384 12224
2 root - 0 - 0 8192 4588
Sess SQL Current Iso Lock SQL ISAM F.E.
Id Stmt type Database Lvl Mode ERR ERR Vers
41 - pospdb NL Not Wait 0 0 7.23
33 - pospdb NL Not Wait 0 0 7.23
32 - pospdb NL Not Wait 0 0 7.23
31 - pospdb NL Not Wait 0 0 7.23
Partition profiles
partnum lkrqs lkwts dlks touts isrd iswrt isrwt isdel bfrd bfwrt seqsc
15 0 0 0 0 2 0 0 0 592 0 0
1048771 2313183 0 0 0 27 4156 6 0 588988 13531 27
1048777 55460 0 0 0 23617 5022 5018 0 180745 26095 0
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 247 0 0 0 0 0 0 0 6889 6411 5928 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 4547 0 0 0 257 0 0 0 0 74 0 0 927 489 0 264 0
19 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
65 101 0 0 0 0 43 5 0 0 0 0 0 161 10 0 0 0
56 933016 0 0 0 0 42651 3180 3514 0 0 0 0 405356 15507 0 0 8372
55 1034807 0 0 0 0 40701 2851 3152 0 0 0 0 416542 13946 0 0 7473
57 521256 0 0 0 0 40821 3139 3467 0 0 0 0 302608 15249 0 0 8183
Light Scan Info
descriptor address next_lpage next_ppage ppage_left bufcnt look_aside
Light Append Info
session id address cur_ppage la_npused la_ndata la_nrows bufcnt
DDR -- Down --
There are 1 servers found
Server : online
Server Number : 1
Server Type : ODS
Server Status : Up
Server Version: INFORMIX-OnLine Version 7.23.UC6
Shared Memory : 0x82000000
INFORMIXDIR : /usr/informix
ONCONFIG : /usr/informix/etc/onconfig
SQLHOSTS : /usr/informix/etc/sqlhosts
Host : scokb
Btree Cleaner Info
btcleanr pool flags pools npend busypnum head tail free
87c4288c 87dbe014 1 1 0 0 0 0 87dbedd4
nreqs dups success dfrmv unnec ditems ditlks cmprs palcs
279 3 75 75 127 2060 198 74 1
outstanding requests
address next partnum pagenum keynum
0 pending, 1024 total, 1024 hash buckets, 1 pools |
|
免费注册
发表于 2004-09-09 10:33
