CLS_OPT

CHAR(1)

No

Shows when the URT will be closed. A T indicates closure at the end of the last logical unit of work to use the URT (that is, when the USERS column goes to 0). An R means closure at the end of the run-unit. This column is initially set to the close-option of the plan that opens the URT. On subsequent uses, a T is upgraded to R if the close-option of the plan instigating the usage is R. Once updated to R, the value never reverts to T. Rows containing values other than T and R are not part of this table.

DB_TBL_NAME

CHAR(3)

No

Shows the CA Datacom/DB table name.

DBID

SMALLINT

No

Lists the CA Datacom/DB database ID.

JOB_NAME

CHAR(8)

No

Shows the job name.

MUF_NAME

CHAR(8)

No

Logical name for this MUF.

REQ_STAMP

TIMESTAMP

No

Lists the timestamp of your request to read this table.

RUN_UNIT

INTEGER

No

Lists the run unit number.

URT_NBR

SMALLINT

No

Shows the URT number (assigned by SQL).

USERS

SMALLINT

No

Lists the number of LUWs using the URT.