DURATION

CHAR(6)

No

Contains the time the lock has been held in the format mmm:ss where mmm is minutes and ss is seconds. If the lock is a share, then the time is for the first task getting the share. The formatting is the same as the ACTIVE_TASKS and STATUS in that a value of less than one second is reflected as all blanks and a value of greater than 999:59 is reflected as +++:++.

JOBNAME

CHAR(8)

No

Contains the job name owning this task. If a job name begins with three asterisks (***), it means that the value lock is owned by a system task.

LOCK_LENGTH

SMALLINT

No

Contains the length of the lock in its internal form. A length of over 50 indicates the value has been truncated. This condition allows duplicates to not be provided.

LOCK_TYPE

CHAR(9)

No

Contains the type of lock. It can be EXCLUSIVE or SHARE.

LOCK_VALUE

CHAR(64)

No

Contains the value lock with limited formatting. Known values locked, that have binary or hexadecimal fields, are formatted in a useful way. Unknown values are formatted in another way with character and hexadecimal values provided. This formatted format is how the table must be queried, if all values are being acquired. Because of the truncation of the value, actual unique entries that are duplicated within the first externalized 64 bytes have only the first occurrence externalized (this condition is very unlikely). The formatting sets the first 6 bytes to be the first 6 bytes of the value lock, followed by a blank, and then match that done for the ACTIVE_TASKS conditions of waiting for a value lock. It is also the same format as that used for the console STATUS command and the DBUTLTY FUNCTION=COMM,OPTION=STATUS.

MUF_NAME

CHAR(8)

No

Name of the MUF specified in the MUF Multi-User startup option or the MUF job name.

TASK_NUMBER

SMALLINT

No

Contains the task number owning this value lock. Some internal locks are acquired and assigned to system tasks or are assigned to the primary task of the job.