onstat -g xmp [query_id]

Prints information about currently executing iterator instances for the query specified by the query_id parameter. If the query_id parameter is omitted, prints information about all queries executing at the coserver at which the command is issued.

The onstat -g xmp command only displays information local to the coserver at which the command is issued. Combine this command with the xctl utility to display information for all coservers in the system.

Example Output

informix@aw3:~> onstat -g xmp 288
IBM Informix Extended Parallel Server Version 8.50.UN439 -- On-Line -- Up 115 days 00:09:01 
-- 223232 Kbytes
XMP Query Segments for Plan-id : 288
segid  width  numbr  qryid  sessid    flags      seqno 
0      1      1      288       1.150   0x11a      1     
2      2      1      288       1.150   0x118      3     
4      2      1      288       1.150   0x118      4     

XMP Query Operators for Plan-id : 288
opaddr     qry  segid branch brtid opname  phase  rows   in1        in2       
0x1393a160 288  2     0-0    685   xchg    create 0      0x1393a2b0 0x0       
0x1393a2b0 288  2     0-0    685   group   create 0      0x1393a6a4 0x0       
0x1393a6a4 288  2     0-0    685   hjoin   probe  25266  0x1393a9a4 0x1393aa9c
0x1393a9a4 288  2     0-0    685   xchg    done   498437 0x0        0x0       
0x1393aa9c 288  2     0-0    685   xchg    next   597125 0x0        0x0       
0x13732e80 288  4     0-0    686   xchg    open   664284 0x13739dcc 0x0       
0x13739dcc 288  4     0-0    686   scan    next   664656 0x0        0x0

Output Description - XMP Query Segments

segid

Id for segment in the query execution tree

width

Degree of parallelism in the branch of the query execution tree

numbr

Number of branches in segment

qryid

Id associated with query

sessid

Session id associated with query, local to coserver at which command is issued

flags

Segment control flags

seqno

Activation sequence number

Output Description - XMP Query Operators

opaddr

Memory address of iterator being displayed

qry

Id of query of which iterator is part

segid

Segment in which iterator is located in query execution tree

branch

Branch and branch instance in which iterator is located in query execution tree

brtid

Id of thread executing segment

opname

Name of operator

phase

State the iterator is in

rows

Number of rows operator has produced

in1

Memory address of input iterator 1 (iterator below it in query execution tree)

in2

Memory address of input iterator 2 (iterator below it in query execution tree)