onstat -d

Use the -d option to display information for chunks in each storage space. You can interpret output from this option as follows. 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

fchunk

Is the ID number of the first chunk

nchunks

Is the number of chunks in the storage space

flags

Uses the following letter codes to describe each storage space:

Position 1:

M

Mirrored

N

Not Mirrored

Position 2:

R

Being recovered

P

Physically recovered, waiting for P -- logical recovery

L

Being logically recovered

X

Newly mirrored

D

Disabled

Position 3:

B

Blobspace

S

Sbspace

T

Temporary dbspace

Position 4:

B

Has big chunks (IDS)

owner

Is the owner of the storage space

name

Is the name of the storage space

The line immediately following the storage-space list includes the number of active spaces (the current number of dbspaces in the database server instance including the rootdbs) and the number of total spaces.

Active spaces refers to the current number of storage spaces in the database server instance including the rootdbs. Total 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 page

free

Is the number of free pages in the chunk for a dbspace

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:

O

Online

D

Down

X

Newly mirrored

I

Inconsistent

R

Being recovered

N

Renamed and either down or inconsistent (IDS)

Position 3:

-

Dbspace

B

Blobspace

S

Sbspace

Position 4:

B

Big chunk (IDS)

pathname

Is the pathname of the physical device

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

For information on how to solve problems indicated by flags in position 2 of both the storage space and chunk sections, see Monitoring Restores.