Data Buffer

Name of the buffer

Size

Buffer size, in bytes

In-Use

Current number of pages assigned to the buffer

Max

Maximum number of pages that can be assigned to the buffer

Getstg

An indicator if the buffer is allocated from operating system storage or from a DC/UCF storage pool

Prfetch=Min

The minimum number of pages that must be in the buffer before prefetch is used for every read request

Prefetch

If prefetch processing is allowed or disabled for the buffer

Journal Buffer

Name of the journal buffer

Size

Buffer size, in bytes

# In-Use

Current number of journal blocks in use

Waits

Number of times a task had to wait for a journal buffer to become available (all journal buffers were involved in an I/O)

DB

Number of writes of journal blocks due to the system writing a database buffer to the database

Ckpt

Number of writes of journal blocks due to a COMT, ENDJ, or ABRT checkpoint record

# of Recoveries

Number of times the system had to rollback changes

I/O's

Number of journal blocks used in recovery that had to be read from the journal file (I/O required)

in Buffer

Number of journal blocks used in recovery that were found in the journal buffer (no I/O required)

Waits on Prior IO

Number of times tasks had to wait for previously issued journal writes to complete

Forced IO: Deadlock

Number of times the system was forced to write the active journal buffer due to a deadlock preventing other tasks from filling the active journal buffer (which would normally cause the active journal buffer to be written)

Split

Number of times I/O was forced to avoid a small split journal record

User-defined

The user defined maximum number of full-word entries in the synonym table.

System-Calculated

The system calculated maximum number of full-word entries in the synonym table. This is calculated by multiplying the maximum number of pages in the buffer by two and then rounding up to the nearest power of two.

Total-space Used

The number of bytes actually used by the synonym table.

Initial

The number of pages initially allocated for the buffer.

Addit'l

The number of pages to be reserved for the buffer each time more pages need to be reserved.

Num-alloc

The number of times more pages have been added to the buffer.

Size-Init

The number of bytes used for the initial allocation of pages for the buffer.

Size-Add'l

The number of additional bytes allocated to the buffer.

Tot-space

The total number of bytes allocated to the buffer.

Stg-pools

The number of bytes allocated to the buffer from storage pools.

Getmain'd

The number of bytes allocated to the buffer from the operating system.

Above-16mb

The number of bytes allocated to the buffer from above the 16-megabyte line.

Below-16mb

The number of bytes allocated to the buffer from below the 16-megabyte line.

Total

The total number of bytes allocated to the buffer.