Informix Logo



ONSTAT COMMANDS

Материал прислан Евгением Нечаевым


Monitoring Related Onstat Options

The -g options for the onstat utility are used for MT (mutli-threaded) monitoring. They are in place solely for the use in the support and debugging of OnLine DSA. They are minimally documented in the manuals on purpose (and there is no plan to change this in the future).

Some more onstat -g options with column explanations:


 onstat -g seg

Print shared memory segment statistics

Example:

INFORMIX-OnLine Version 7.11.UC1 -- On-Line -- Up 04:10:05 -- 11168 Kbytes
Segment Summary:(resident segments are not locked)

id key addr size ovhd class blkused blkfree

3619 1386432513 a000000  999424 824 R 118 4
1524 1386432514 a0f4000 2048000 624 V 250 0
1525 1386432515 a2e8000  589824 604 M  68 4
1526 1386432516 a378000 8388608 720 V 132 892

Columns:

id: Unique segment ID
key: Unique shared memory key for segment (in decimal)
addr: address of this segment
size: size of the segment
ovhd: overhead in segment
class: memory class

R = MT_SHM_CLASS_RESIDENT 1
V = MT_SHM_CLASS_VIRTUAL 2
M = MT_SHM_CLASS_MESSAGE 3

blkused: Number of blocks used
blkfree: Number of blocks free


onstat -g con

Print conditions with waiters

Example:

INFORMIX-OnLine Version 7.11.UC1 -- On-Line -- Up 03:42:44 -- 11168 Kbytes

Conditions with waiters:

cid addr name waiter waittime

589 a634360 sm_read 39 4021

Columns:

cid: Conditions unique identifier
addr: Shared memory address
name: Condition name
waiter: Thread id of waiter
waittime: Number of seconds the waiter has been waiting


onstat -g iof

Print disk I/O statistics by chunk/file

Example:

INFORMIX-OnLine Version 7.11.UC1 -- On-Line -- Up 03:51:18 -- 11168 Kbytes

AIO global files:

gfd pathname totalops dskreads dskwrites io/s

3 rootchunk 1870 528 1342 1.1
4 chunk2 3 3 0 0.0
5 chunk3 3 3 0 0.0

Columns:

gfd: global file descriptor
totalops: Total number of reads and writes combined.
dskred/dskwrite: Number of read/write system calls.
io/s: Average I/O operation per second.


onstat -g iov

Prints I/O statistics by virtual processor

Example:

INFORMIX-OnLine Version 7.11.UC1 -- On-Line -- Up 04:43:32 -- 11168 Kbytes

AIO I/O vps:

class/vp s io/s totalops dskread dskwrite dskcopy wakeups io/wup

kio 0 i 0.0 67 61 6 0 142 0.5
msc 0 i 0.0 3 0 0 0 4 0.8
aio 0 i 0.0 8 3 1 0 13 0.6
aio 1 i 0.0 2 0 1 0 12 0.2
aio 2 i 0.0 0 0 0 0 10 0.0
aio 3 i 0.0 0 0 0 0 10 0.0
pio 0 i 0.0 0 0 0 0 10 0.0
lio 0 i 0.0 0 0 0 0 10 0.0

Columns:

class: the class of the virtual processor
vp: virtual processor number within the class
s: the state of the virtual processor

f forked
i idle
s searching for work to perform
b busy doing work
o opening a file
c closing a file

io/s: average I/O operations per second
totalops: total number of I/O operations by this virtual processor
dskread/dskwrite: number of disk reads/writes by this virtual processor
dskcopy: number of times the virtual processor copied data from one disk to another (for purposes of mirroring)
wakeups: number of times this virtual processor woke up from the idle state
io/wup: average number of I/O operations per wakeup


onstat -g ntu

Prints profile information about the network threads (includes shared memory connections)

Example:

INFORMIX-OnLine Version 7.11.UC1 -- On-Line -- Up 04:31:33 -- 11168 Kbytes

global network information:

#netscb connects read write q-free q-limits q-exceed

6/ 7 6 32 32 0/ 0 10/ 10 0/ 0

Individual thread network information (basic):

netscb type thread name sid fd poll reads writes q-nrm q-exp

a3e7cd0 ipcshm sqlexec 15 0 0 8 8 0/ 0 0/ 0
a2600c8 tlitcp tlitcplst 6 1 5 0 0 0/ 0 0/ 0
a2540c8 ipcshm sm_discon 5 0 0 0 0 0/ 0 0/ 0
a2440c8 ipcshm sm_listen 3 0 0 6 0 0/ 0 0/ 0
a2360c8 tlitcp tlitcppoll 2 0 5 0 0 0/ 0 0/ 0
a22a0c8 ipcshm sm_poll 1 0 0 37 0 0/ 0 0/ 0

Columns:

netscb: the address of the network session control block data structure
type: the connection type
thread name: name of the thread
sid: session id
fd: file descriptor of the connection created for the thread
poll: mail box number of the poll thread that OnLine uses for polling input data for this thread
reads: number of times this poll thread read data from the network
writes: number of times this poll thread wrote data to the network
q-nrm: the current count of normal data buffers and the highest count of normal data buffers used by this thread (current#/highest#)
q-exp: the current count of expedited data buffers and the highest count of expedited data buffers used by this thread (current#/highest#)


Session and Thread Related Onstat -g options

onstat -g ses [sesid]

Session relates statistics:

Session related statistics can be seen via onstat -g ses. Without argument onstat -g ses will give high level information on all the current sessions running on the system. If a session ID is provided as an argument a great deal of detail is provided to help understand what the session is doing and the resources it's using.

Example:

% onstat -g ses

INFORMIX-OnLine Version 7.12.UC1 -- On-Line -- Up 00:25:11 -- 8976 Kbytes

session #RSAM total used

id user tty pid hostname threads memory memory

10 informix - 0 - 0 8192 6944
9 jdo 1 4554 idgie 1 40960 36768
4 informix - 0 - 0 8192 5088
2 informix - 0 - 0 16384 7784
1 informix - 0 - 0 8192 5088

% onstat -g ses 9

INFORMIX-OnLine Version 7.12.UC1 -- On-Line -- Up 00:25:19 -- 8976 Kbytes

session #RSAM total used

id user tty pid hostname threads memory memory

9 jdo 1 4554 idgie 1 40960 36768

tid name rstcb flags curstk status

36 sqlexec a11d514 Y--P--- 1792 cond wait(sm_read)

Memory pools count 1

name class addr totalsize freesize #allocfrag #freefrag

9 V a3c2010 40960 4192 134 9

name free used name free used

overhead 0 104 scb 0 80
opentable 0 4240 filetable 0 816
misc 0 32 log 0 2120
temprec 0 1608 blob 792 0
ralloc 0 7168 gentcb 0 192
ostcb 0 2056 net 0 3984
sqscb 0 8544 rdahead 0 104
hashfiletab 0 280 osenv 0 1832
buft_buffer 1968 2128 sqtcb 696 1272
fragman 736 208

Sess SQL Current Iso Lock SQL ISAM F.E.

Id Stmt type Database Lvl Mode ERR ERR Vers

9 SELECT stores7 NL Not Wait 0 0 7.12

Current statement name : slctcur

Current SQL statement :

select * from customer

Last parsed SQL statement :

select * from customer

Column Descriptions for onstat -g ses [sesid]:

session id: The session ID summerized on this line of output
user: The user name associated with this session
tty: The current tty for this session
pid: The ppid of the front end application that created this particular session
hostname: The hostname from which the frontend application was started from.
#RSAM threads: The total number of rsam threads currently forked to work for this session
total memory: The total amount of memory allocated for this session
used memory: The total amount of memory used by this session
tid: The thread identification number.
name: The name of the thread
rstcb: The hexidecimal address in shared memory for the RSAM task control block.
flags: The flags of the thread
curstk: The current stack size.
status: The current status of the thread. .......
name: Name of the memory pool allocated for this session.
class: The class that this memory pool belongs. V = virtual R = resident
addr: The hexadecimal address of the memory pool in shared memory
total size: The current size of the memory pool in bytes.
freesize: The amount of memory in pool that is currently marked as free.
#allocfrag: The number of memory fragments in pool.
#freefrag: The number of memory fragments that are marked as free.


onstat -g sql [sesid]

SQL related statistics:

SQL related stats can be found from onstat -g sql. Without an argument the output provided will inform you of all current sessions and a brief overview of the SQL related functionality. If a session ID is provided as an argument then the output is much more detailed to help understand exactly what is happening within the thread at an SQL layer.

Example:

% onstat -g sql

INFORMIX-OnLine Version 7.12.UC1 -- On-Line -- Up 00:18:34 -- 8976 Kbytes

Sess SQL Current Iso Lock SQL ISAM F.E.

Id Stmt type Database Lvl Mode ERR ERR Vers

3 - stores7 NL Not Wait 0 0 7.12

% onstat -g sql 3

INFORMIX-OnLine Version 7.12.U -- On-Line -- Up 00:18:40 -- 8976 Kbytes

Sess SQL Current Iso Lock SQL ISAM F.E.

Id Stmt type Database Lvl Mode ERR ERR Vers

3 - stores7 NL Not Wait 0 0 7.12

Last parsed SQL statement :

select * from customer

Column Descriptions for onstat -g sql [sesid]:

Sess Id: The session ID summerized on this line of
SQL Stmt type: The statement type of the last parsed SQL statement.
Current Database: The current database for the given session ID.
Iso Lvl: The current isolation level for the session.
Lock Mode: The current lock mode for the session.
SQL ERR: The returned SQL error code for last parsed SQL statement.
ISAM ERR: The returned isam error code for last parsed SQL statement.
F.E. Vers: The version of the frontend tool responsible for this session.
Last parsed SQL statement: The last SQL statement parsed. This does not necessarily mean the current SQL statement.


onstat -g [ath|wai|act|rea]

The details of onstat -g 'ath', 'wai', 'act' and 'rea' are all the same. They have been combined here to make things easier. The output is grouped as follows:

ath: All threads.
wai: All threads waiting or on the wait queue
act: All threads currently running or on the run queue.
rea: All threads that are ready to run but haven't been scheduled on the run queue yet (on the ready queue).

Example:

INFORMIX-OnLine Version 7.12.UC1 -- On-Line -- Up 01:08:49 -- 8976 Kbytes

Threads:

tid tcb rstcb prty status vp-class name

2 a1f6a98 0 2 yield forever 3lio lio vp 0
3 a1f6ef0 0 2 yield forever 4pio pio vp 0
4 a1f7370 0 2 yield forever 5aio aio vp 0
5 a1f77f0 0 2 yield forever 6msc msc vp 0
6 a20a860 0 2 yield forever 7aio aio vp 1
7 a20ac70 a11c010 4 sleeping(secs: 1) 1cpu main_loop()
8 a20b5a8 0 2 running 1cpu sm_poll
9 a21f4c0 0 2 yield forever 1cpu sm_listen
10 a27ca70 0 2 sleeping(secs: 2) 1cpu sm_discon
11 a27ce60 a11c444 2 yield forever 1cpu flush_sub(0)
12 a27d2b0 0 4 yield forever 1cpu kaio
13 a27d8d8 0 2 yield forever 8aio aio vp 2
14 a27dcc8 0 2 yield forever 9aio aio vp 3
15 a0faf48 0 2 yield forever 10aio aio vp 4
16 a28a810 0 2 yield forever 11aio aio vp 5
17 a28b130 a11c878 2 sleeping(secs: 17) 1cpu btclean
32 a25e778 a11ccac 4 sleeping(secs: 1) 1cpu onmode_mon
34 a25f430 a11d514 2 cond wait(sm_read) 1cpu sqlexec

Column Description for onstat -g [ath|wai|act|rea]

tid: The thread identification number.
tcb: The hexadecimal address of the thread control block.
rstcb: The hexadecimal address of the RSAM thread control block
prty: The priority of the thread. This is not configurable.
status: The current status of the thread.
vp-class: The class of VP that the thread is scheduled on
Name: The name of the thread


onstat -g sle

Sleeping threads with timeouts:

The onstat -g sle command can be used to find all threads that are on the sleep queue and the time remaining before they will be run again.

Example:

% onstat -g sle

INFORMIX-OnLine Version 7.12.U -- On-Line -- Up 00:32:54 -- 8976 Kbytes

Sleeping threads with timeouts: 4 threads

tid v_proc rstcb name time

6 1 a11c010 main_loop() 1
29 1 a11ccac onmode_mon 1
9 1 0 sm_discon 2
12 1 a11c878 btclean 10

Column Descriptions for onstat -g sle

tid: The Thread ID of the sleeping thread.
v_proc: The virtual processor that the thread is scheduled to run on. See onstat -g sch
rstcb: The address in shared memory of the RSAM Thread Control Block. See onstat -u.
name: The name of the thread that is sleeping
time: The time that the thread will remain on the sleep queue.


onstat -g stk

Stack information:

The onstat -g stk command will provide the current stack for a given thread.

Example:

% onstat -g stk 3

INFORMIX-OnLine Version 7.12.UC1 -- On-Line -- Up 00:01:26 -- 8976 Kbytes

Stack for thread: 31 sqlexec

base: 0x0a580010
len: 33280
pc: 0x002e40a0
еos: 0x0a587b00
0x002e8eb0 mt_wait (0xa25e958, 0xa25e900, 0xa8c80e0, 0x0,0xffffffff, 0x4)
0xef7305a0 ***unknown*** (0xa2879b8, 0xa587fb4, 0xa35f448, 0x0,0xffffffff, 0xa287cf8)
0xef70cca4 ***unknown*** (0xa35f448, 0xa588020, 0xa287ea0, 0xffffffff,0xffff9c36, 0xa58808c)
0x00143e88 asf_recv (0x3c0000, 0xa588088, 0x1094, 0xa2860e8, 0x0,0x0)
0x00143ff4 _iread (0xa588146, 0x2, 0xa35f42c, 0xa35f428, 0x1, 0x0)
0x00142a40 _igetint (0x0, 0x0, 0x0, 0xa35e378, 0x1c, 0xa5881ac)
0x0013e91c sqmain (0x3c0160, 0x3b771c, 0xc, 0x3c0000, 0xa,0xa35e260)
0x002ed624 startup (0x0, 0x2, 0xa160414, 0xa1603d8, 0xa25ea50, 0x1)
0xef730184 ***unknown*** (0x0, 0x0, 0x0, 0x0, 0x0, 0x0)
0x00000000 ***unknown***

Detailed look at onstat -g stk tid

The stack trace indicates the current stack trace of internal functions that are being executed. Anything marked as "***unknown***" can be assumed to be a system call.

Descriptions of output for onstat -g stk

"31 sqlexec": The thread ID and thread name of the thread responsible for the following stack. In this case it's thread ID 31 and it is an sqlexec thread.
base: The address in memory of the base of the stack
len: The number of bytes allocated for the stack.
pc: The program counter indicating were in the stack we currently are executing. See $INFORMIXDIR/etc/sym.out.
tos: The address in memory of the top of stack


onstat -g sts

Stack statistics and usage can be found in onstat -g sts.

Example:

% onstat -g sts

INFORMIX-OnLine Version 7.12.UC1 -- On-Line -- Up 00:45:47 -- 8976 Kbytes

Stack usage:

TID Total Max Current Thread Name

bytes % bytes %

2 32768 2094 6 1088 3 lio vp 0
3 32768 2094 6 1088 3 pio vp 0
4 32768 2220 6 1088 3 aio vp 0
5 131072 2191 1 1088 0 msc vp 0
6 32768 11035 33 2008 6 main_loop()
7 32768 2575 7 1456 4 sm_poll
8 32768 7382 22 3304 10 sm_listen
9 32768 1087 3 1088 3 sm_discon
10 32768 4462 13 1392 4 flush_sub(0)
11 32768 3115 9 1680 5 kaio
12 32768 1111 3 1112 3 btclean
14 32768 3115 9 1680 5 kaio
28 32768 3115 9 1680 5 kaio
29 32768 2049 6 1944 5 onmode_mon
31 32768 9326 28 1808 5 sqlexec

Column Descriptions for onstat -g sts:

TID: The Thread ID of the summarized thread
Total: The total amount of shared memory set aside for the stack.
Max bytes: The maximum bytes used in the stack at any one time.
%: The percentage of the total stack used when Max bytes were reached.
Current bytes: The current count of used bytes in the allocated stack.
%: The percentage of the total stack currently.
Thread Name: The name of the thread being summarized.


onstat -g tpf

Thread profiles:

The following is information from an onstat -g tpf a thread ID is specified. If a thread ID was not specified, the identical output would have been provided except a line of output would have existed for every thread running in the system.

Example:

% onstat -g tpf 31

INFORMIX-OnLine Version 7.12.UC1 -- On-Line -- Up 01:00:09 -- 8976 Kbytes

Thread profiles

tid lkreqs lkw dl to lgrs isrd iswr isrw isdl isct isrb lx bfr bfw lsus lsmx seq

31 293 0 0 0 0 4198 0 0 0 0 0 0 8573 0 0 0 1349

Column Descriptions for onstat -g tpf:

lkw: The number of time the thread had to wait for a specific lock.
dl: The number of dead locks detected by the thread.
to: The number of remote deadlock time-outs.
lgrs: The number of log records the threads transaction spans.
isrd: The number of reads performed.
iswr: The number of writes performed.
iswr: The number of rewrites performed.
isdl: The number of deletes performed.
isct: The number of commits performed.
isrb: The number of rollbacks performed.
lx: The number of long transactions.
bfr: The number of buffer reads.
bfw: The number of buffer writes.
lsus: The log space used.
lsmx: The maximum log space used.
seq: The number of sequential scans performed.


Virtual Processor Related Onstat -g Options

onstat -g glo

This option can be used to get statistics/information on a number of system wide areas including CPU utilization of individual Virtual Processors.

Example:

INFORMIX-OnLine Version 7.12.UC3 -- On-Line -- Up 23:18:54 -- 11168 Kbytes

MT global info:

sessions threads vps lngspins

1 20 10 0

sched calls thread switches yield 0 yield n yield forever

total: 1081704 384441 737577 212334 1547
per sec: 7 3 4 2 0

Virtual processor summary:

class vps usercpu syscpu total

cpu 1 3.36 1.67 5.03
aio 4 0.32 0.10 0.42
pio 1 0.05 0.04 0.09
lio 1 0.04 0.05 0.09
tli 1 0.06 0.04 0.10
str 0 0.00 0.00 0.00
shm 0 0.00 0.00 0.00
adm 1 0.01 0.03 0.04
opt 0 0.00 0.00 0.00
msc 1 0.12 0.03 0.15
adt 0 0.00 0.00 0.00
total 10 3.96 1.96 5.92

Individual virtual processors:

vp pid class usercpu syscpu total

1 527 cpu 3.36 1.67 5.03
2 528 adm 0.01 0.03 0.04
3 529 lio 0.04 0.05 0.09
4 530 pio 0.05 0.04 0.09
5 531 aio 0.08 0.01 0.09
6 532 msc 0.12 0.03 0.15
7 533 aio 0.17 0.03 0.20
8 534 aio 0.02 0.04 0.06
9 535 aio 0.05 0.02 0.07
10 536 tli 0.06 0.04 0.10
tot 3.96 1.96 5.92

Column Descriptions for onstat -g glo

sessions: Current number of sessions
threads: Current number of threads.
vps: Number of virtual processors currently in place.
lngspins: Number of long spins experienced (a long spin is defined as spinning for a lock, mutex, etc. for more than 10,000 times before aquiring the resource).
sched calls: Number of scheduled calls.
thread switches: Number of thread switches.
yield 0: Number of mt_yield(0)'s (mt_yield() is the function in the product code that a thread will call when it is going to yield). This puts the thread back on the ready queue.
yield n: Number of mt_yield(n) where n > 0. This puts the thread on the sleep queue.
yield forever: Number mt_yield(n) where n < 0. This puts the thread on the sleep queue.
class: Class of CPU that is summerized on this line of output.
vps: Number of virtual processors derfined as this particular class.
usercpu: Amount (in seconds) of user CPU time per class of VP or per actual VP.
syscpu: Amount (in seconds) of system CPU time per class of VP or per actual VP.
total: Total CPU time aquired for this class of virtual processor or per actual virtual processor (system + user).
vp: Virtual processor ID.
pid: The process ID of this particular virtual processor.


onstat -g sch

This option displays Virtual Processor scheduler statistics.

Example:

INFORMIX-OnLine Version 7.12.UC3 -- On-Line -- Up 23:18:59 -- 11168 Kbytes

VP Scheduler Statistics:

vp pid class semops busy waits spins/wait

1 527 cpu 20 0 0
2 528 adm 0 0 0
3 529 lio 20 0 0
4 530 pio 20 0 0
5 531 aio 12 0 0
6 532 msc 17 0 0
7 533 aio 18 0 0
8 534 aio 18 0 0
9 535 aio 18 0 0
10 536 tli 2 0 0

Column Descriptions for onstat -g sch

vp: The ID of the virtual processor.
pid:
The PID of the virtual processor.
class:
The class of the virtual processor.
semops:
Sempops performed by the virtual processor. When a VP has nothing to do, it will go to sleep on a semaphore. When a thread comes along with a task to be performed, the VP will be woken up to perform the task.
busy waits:
The number of times the VP went into busy wait. If you have MULTIPROCESSOR set to 1(meaning you have a multi-processor machine), if a VP has nothing to do, it will go into a "busy wait" before it goes to sleep on a semaphore. Basically, a busy wait is when the VP spins looking for work. It's more expensive to spin than to go to sleep on a semaphore, but it's more expensive to be woken up from a semaphore when there is work to be done.
spins/wait:
The average number of spins per busy wait.


Network Related Onstat Commands

onstat -g ntu

INFORMIX-OnLine Version 7.12.U -- On-Line -- Up 01:10:27 -- 8976 Kbytes

global network information:

#netscb connects read write q-free q-limits q-exceed

3/ 3 4 21 21 1/ 1 10/ 10 0/ 0

Individual thread network information (basic):

netscb type thread name sid fd poll reads writes q-nrm q-exp

a2cfb30 tlitcp sqlexec 9 2 5 5 5 0/ 1 0/ 0
a28c0e8 tlitcp tlitcplst 2 1 5 4 0 0/ 0 0/ 0
a2800e8 tlitcp tlitcppoll 1 0 5 19 0 0/ 0 0/ 0

This global network information appears on all of the onstat outputs shown:

#netscb - total current number of network session control blocks count of all network session control blocks ever allocated
connects - total connects done
read - total reads done
write - total writes done
q-free - number of free buffers on the queue number of buffers even simultaneously on the queue
q-limits - maximum number of buffers that can be on the queue maximum:
q-exceed - number of times q-limits have been exceeded
netscb - address of the network session control block
type - identifier of the protocol this thread uses thread name - name of this thread
sid - session id associated with this thread
fd - file descriptor for the thread
poll - mail box number of the poll thread
reads - sequence number of the current read
writes - sequence number of the current write
q-nrm - number of buffers on the expedited data queue
q-exp - maximum number of buffers ever on the expedited data queue


onstat -g ntt

INFORMIX-OnLine Version 7.12.U -- On-Line -- Up 01:11:07 -- 8976 Kbytes

global network information:

#netscb connects read write q-free q-limits q-exceed

3/ 3 4 21 21 1/ 1 10/ 10 0/ 0

Individual thread network information (times):

netscb thread name sid open read write address

a2cfb30 sqlexec 9 13:07:15 13:07:15 13:07:15
a28c0e8 tlitcplst 2 11:57:54 13:07:15
a2800e8 tlitcppoll 1 11:57:53

netscb - address of the network session control block
thread name - name of the thread
sid - session id of the thread

The next three entries show only time if the event occurred today and a time and date if the event occurred prior to today.

open - time of the last open event
read - time of the last close event
write - time of the last write event
address - address of the server, only valid on listener thread


onstat -g ntm

INFORMIX-OnLine Version 7.12.U -- On-Line -- Up 01:11:27 -- 8976 Kbytes

global network information:

#netscb connects read write q-free q-limits q-exceed

3/ 3 4 21 21 1/ 1 10/ 10 0/ 0

Network mailbox information:

box netscb thread name max received in box max in box full signal

5 a2800e8 tlitcppoll 10 13 0 2 0 yes
6 a28c0e8 tlitcplst 10 0 0 0 0 no

box - mail box number
netscb - address of the network session control block
thread name - name of the thread owning the mail box
max received - maximum number of envelopes this mail box will hold in box - count of the pieces in the mail box
max in - highest number of pieces that were ever in the mailbox
box full - number of times the mail box was found full
signal - yes, waiting for mail or has PID associated with it no, all other cases


onstat -g ntd

INFORMIX-OnLine Version 7.12.U -- On-Line -- Up 01:11:52 -- 8976 Kbytes

global network information:

#netscb connects read write q-free q-limits q-exceed

3/ 3 4 21 21 1/ 1 10/ 10 0/ 0

Client Type Calls Accepted Rejected Read Write

sqlexec yes 4 0 17 21
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
ontape yes 0 0 0 0
srvstat yes 0 0 0 0
asfecho yes 0 0 0 0
listener yes 0 0 4 0
crsamexec yes 0 0 0 0
safe yes 0 0 0 0
Totals 4 0 21 21

Client Type - client type
Calls - yes, clients of this type are being allowed connections no, connections of this type are not currently allowed
Accepted - number of times this client type has had a thread spawned
Rejected - number of times this client type has been rejected
Read - total number of messages sent from this client type
Write - total number of message sent to this client type


Memory Related Onstat Options

onstat -g mem

Pool Summary:

name class addr totalsize freesize #allocfrag #freefrag

resident R a002018 475136 16240 2 2
res-buff R a076018 221184 14192 2 2
global V a0b6018 245760 91504 503 16
mt V a0ba018 1441792 467272 1379 28
rsam V a0e2018 303104 2488 911 3
aio V a11c018 499712 62552 185 27
gls V a120018 24576 2480 348 2
dictpool V a124018 24576 5296 20 3
procpool V 128018 16384 9160 10 2
XTF_mem V a146018 8192 1096 4 1
main_loop() V a1f4018 16384 5816 111 2
2 V a200018 8192 3544 7 1
3 V a20e018 16384 3280 206 1
4 V a21c018 16384 3280 206 1
5 V a22c018 16384 3280 206 1
7 V a23e018 8192 3544 7 1
8 V a240018 8192 3544 7 1
btclean V a25c018 16384 6752 108 1
onmode_mon V a26a018 16384 6752 108 1
18 V a280018 32768 5112 265 3
19 V a284018 8192 3544 7 1

name - name assigned to the pool
class - what type of memory the pool resides in R=resident, V=virtual
addr - address of the pool header
totalsize - total size of the pool in bytes
freesize - number of free bytes in the pool
#allocfrag - number of contiguous areas of memory within the pool that are allocated
#freefrag - number of contiguous areas of memory that are not used within the pool

Pool names and their contents:

resident - overhead, tracking structures, locks res-buff
global - global shared memory pool
mt - structures used for processing of the threads
rsam - rsam information: chunks, dbspaces, etc.
aio - structures having to do with I/O
gls - GLS messages and environment
dictpool - data for the data dictionary
procpool - data for the stored procedure pool
XTF_mem - buffers for the extended tracing facility
main_loop() - private data for the main_loop() thread
btclean - private data for the btree cleaner
onmode_mon - private data for the onmode monitor thread
### - private data for a single session number

Other pools that are not currently allocated on the above system:

labels - related to the hashing structures
opcache - optical cache
DDR - data replication buffer
LGR - occurs only when a suspended restore continues
ovrfl_buff - may be a subdivision of resident shared memory
aio_fpf - ?
statistics - used to tracked queue statistics, if on <sess_id>_SORT_<sortid> - sorting area for the given session id


onstat -g afr 18

INFORMIX-OnLine Version 7.20.UC2 -- On-Line -- Up 17:52:26 -- 8720 Kbytes

Allocations for pool name 18:

addr size usage

a23c000 2136 log
a23c858 512 gentcb
a23ca58 648 sqtcb
a23cce0 40 gentcb
a23cd08 40 gentcb
a23cd30 40 gentcb
a23cd58 40 gentcb
a23df88 40 gentcb
a23dfb0 40 gentcb
a23dfd8 40 gentcb
a280000 120 overhead
a280078 48 scb
a2800a8 48 scb
a2800d8 40 ostcb
a280100 4304 sqscb
a2811d0 48 fragman
a281200 40 sqscb
a281228 64 rdahead
a281268 56 filetable
a2812a0 40 osenv

addr -address where the block header begins
size -size of the body of the block
usage -what this block was allocated for


onstat -g ffr 18

INFORMIX-OnLine Version 7.20.UC2 -- On-Line -- Up 17:52:55 -- 8720 Kbytes

Free list for pool name 18:

addr size

a2874b0 2896
a287088 168
a286000 2048

addr - address of the header on the free block
size - number of bytes in the free block


onstat -g seg

INFORMIX-OnLine Version 7.20.UC2 -- On-Line -- Up 17:53:38 -- 8720 Kbytes

Segment Summary:

(resident segments are not locked)

id key addr size ovhd class blkused blkfree

1602 1386104833 a000000 737280 836 R 86 4
703 1386104834 a0b4000 8192000 720 V 334 666

Total: - - 8929280 - - 420 670

id - the operating system id for this shared memory segment
key - the key assigned to this shared memory segment, in decimal
addr - the address where the beginning of this segment is attached to the OnLine executables
size - the size of the segment, in bytes
ovhd -
class - the type of segment:R=resident,V=virtual,M=communications
blkused - number of 8K blocks of the segment that are used
blkfree - number of 8K blocks of the segment that are free
 


Украинская баннерная сеть
 

[Home]

Сайт поддерживается группой пользователей Информикс на Украине.

Hosted by NO-more.