CNS_POOL_SIZE

INTEGER

No

Shows the memory used for constraint enforcement.

CURSORS_OPEN

INTEGER

No

Shows the number of open cursors.

LUW_POOL_SIZE

INTEGER

No

Shows the memory used by current requests and open cursors.

LUWS

INTEGER

No

Shows the number of open logical units of work, that is, units of recovery.

MEM_OTHER

INTEGER

No

Lists other dynamically allocated memory.

MUF_NAME

CHAR(8)

No

Logical name for this MUF.

PLAN_POOL_SIZE

INTEGER

No

Shows the memory used for a cache copy of statements executed in open plans.

PLANS_ACTIVE

SMALLINT

No

Shows the number of plans currently executing a statement in the MUF (plans with open LUWs) or with at least one open cursor.

PLANS_OPEN

SMALLINT

No

Lists the number of open plans.

REQ_STAMP

TIMESTAMP

No

Shows when you made your request.

STMTS_CACHE

INTEGER

No

Lists the number of statements that have been executed in open plans.

TASKS_ACTIVE

SMALLINT

No

Lists the number of tasks with requests active in the MUF.

TASKS_ATTACHED

SMALLINT

No

Shows the number of tasks currently allocated (less than or equal to the maximum number of tasks specified at MUF start-up).

TTM_BLKS_ALLOC

INTEGER

No

Shows the number of 4K-blocks allocated in the temporary table area.

TTM_BLKS_IN_USE

INTEGER

No

Lists the number of temporary table area 4K-blocks currently in use.

TTM_BLKS_MAX_USE

INTEGER

No

Lists the highest number of 4K-blocks used.

URTS

SMALLINT

No

Lists the number of open User Requirements Tables.