CBSIO

INTEGER

No

Shows the plan option CBSIO.

CLOSE_OPT

CHAR(1)

No

Lists the plan close option.

DATE_LAST_USED

DATE

No

Shows the last date a statement of the plan began executing in the MUF.

DATE_OPENED

DATE

No

Shows the date the plan was opened.

ISO_LVL

CHAR(1)

No

Shows the isolation level.

MSG_OPT

CHAR(2)

No

Lists the plan option MSG.

MUF_NAME

CHAR(8)

No

Logical name for this MUF.

OPT_MODE

CHAR(1)

No

Shows the plan option OPT.

PLAN_AUTHID

CHAR(18)

No

Shows the plan authorization ID.

PLAN_NAME

CHAR(18)

No

Lists the plan name.

PRIORITY

SMALLINT

No

Shows the plan priority.

REQ_STAMP

TIMESTAMP

No

Lists the timestamp of your request to read this table.

TIME_LAST_USED

TIME

No

Lists the last time a statement of the plan began executing in the MUF.

TIME_OPENED

TIME

No

Shows the time the plan was opened.

USERS_BATCH

SMALLINT

No

Shows the number of batch jobs using the plan.

USERS_ONLINE

SMALLINT

No

Shows the number of online active LUWs using the plan.

WAIT_SECONDS

INTEGER

No

Lists the plan option wait minutes times 60 plus the wait seconds ((wait minutes X 60) + wait seconds).