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:

0x0001

No mirror

0x0002

Mirror

0x0004

Down

0x0008

Newly mirrored

0x0200

Space is being recovered

0x0400

Space is fully recovered

0x0800

Logical log is being recovered

0x1000

Table in dbspace is dropped

0x2000

Temporary dbspace

0x8000

Root dbspace

0x00010000

Critical dbspace

0x00020000

No log replay required

0x0040000

Dbspace added by ALTER DBSLICE

0x0080000

Dbspace does not contain a logslice

0x0100000

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 describes each storage space:

Position 1

M

Mirrored

N

Not mirrored

Position 2

X

Newly mirrored

P

Physically recovered, waiting for logical recovery

L

Being logically recovered

R

Being recovered

Position 3

S

Skip logical replay for this dbspace

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 the 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 pages.

free

is the number free pages in the chunk for a dbspace.

bpages

is blank.

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

Position 3

-

Dbspace

T

Temporary dbspace

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.