onstat -d

Use the -d option to display information for chunks in each storage space. You can interpret output from this option as follows.

Example Output

Figure 34. onstat -d Output

IBM Informix Dynamic Server Version 10.00.UC1     -- On-Line -- Up 00:01:23 -- 27648 Kbytes

Dbspaces
address  number   flags      fchunk   nchunks  pgsize   flags    owner    name
a3217d8  1        0x60001    1        1        2048     N  B     informix rootdbs
a426e40  2        0x60001    2        1        4096     N  B     informix dbsp1
a415630  3        0x60001    3        1        8192     N  B     informix dbsp2
 3 active, 2047 maximum

Chunks
address  chunk/dbs  offset     size       free       bpages     flags pathname
a321928  1     1    0          30000      12173                 PO-B  /local1/engines
a321b00  2     2    0          2400       2347                  PO-B  /local1/engines
a415780  3     3    0          1200       1147                  PO-B  /local1/engines
 3 active, 32766 maximum

NOTE: The values in the "size" and "free" columns for DBspace chunks are
      displayed in terms of "pgsize" of the DBspace to which they belong.

Expanded chunk capacity mode: always

Output Description

The first section of the display describes the storage spaces:

address

Is the address of the storage space in the shared-memory space table

number

Is the unique ID number of the storage space assigned at creation

flags

Uses the following hexadecimal values to describe each storage space:

0x00000000: Mirror not allowed and dbspace is unmirrored
0x00000001: Mirror is allowed and dbspace is unmirrored
0x00000002: Mirror is allowed and dbspace is mirrored
0x00000004: Down
0x00000008: Newly mirrored
0x00000010: Blobspace
0x00000020: Blobspace on removable media
0x00000040: Blobspace is on optical media
0x00000080: Blobspace is dropped
0x00000100: Blobspace is the optical STAGEBLOB
0x00000200: Space is being recovered
0x00000400: Space is fully recovered
0x00000800: Logical log is being recovered
0x00001000: Table in dbspace is dropped
0x00002000: Temporary dbspace
0x00004000: Blobspace is being backed up
0x00008000: Sbspace
0x0000a001: Temporary sbspace
0x00010000: Physical or logical log changed
0x00020000: Dbspace or chunk tables have changed
0x20002: Dbspace or chunk tables have changed and dbspace is mirrored
0x60001: Dbspace has large chunks and is unmirrored. Any changes triggers changes on rootdbspace

fchunk

Is the ID number of the first chunk

nchunks

Is the number of chunks in the storage space

pgsize

Is the size of the dbspace pages in bytes

flags

Uses the following letter codes to describe each storage space:

Position 1:

M: Mirrored
N: Not mirrored

Position 2:

X: Newly mirrored
P: Physically recovered, waiting for P -- logical recovery
L: Being logically recovered
R: Being recovered

Position 3:

B: Blobspace
S: Sbspace

Position 4:

B: Dbspace has large chunks greater than 2 GB

owner

Is the owner of the storage space

name

Is the name of the storage space

In the line immediately following the storage-space list, active refers to the current number of storage spaces in the database server instance including the rootdbs and maximum refers to total allowable spaces for this database server instance.

The second section of the onstat -d output describes the chunks:

address

Is the address of the chunk

chk/dbs

Is the chunk number and the associated space number

offset

Is the offset into the file or raw device in pages

size

Is the size of the chunk in terms of the page size of the dbspace to which it belongs.

free

Is the number of free pages in the chunk in terms of the page size of the dbspace to which it belongs.

For a blobspace, a tilde indicates an approximate number of free blobpages.

For an sbspace, indicates the number of free pages of user data space and total user data space.

bpages

Is the size of the chunk in blobpages

Blobpages can be larger than disk pages; therefore, the bpages value can be less than the size value.

For an sbspace, is the size of the chunk in sbpages

flags

Provides the chunk status information as follows:

Position 1:

P: Primary
M: Mirror

Position 2:

N: Renamed and either Down or Inconsistent
O: Online
D: Down
X: Newly mirrored
I: Inconsistent

Position 3:

-: Dbspace
B: Blobspace
S: Sbspace
T: Temporary dbspace

Position 4:

B: Has large chunks greater than 2 GB

pathname

Is the pathname of the physical device

In the line immediately following the chunk list, active displays the number of active chunks (including the root chunk) and maximum displays the total number of chunks.

For information about page reads and page writes, refer to onstat -D.