Output Description

address

is the address of the lock in the lock table. If a user thread is waiting for this lock, the address of the lock appears in the wait field of the onstat -u (users) output.

wtlist

is the first entry in the list of user threads that is waiting for the lock, if there is one.

owner

is the shared-memory address of the thread that is holding the lock. This address corresponds to the address in the address field of onstat -u (users) output.

lklist

is the next lock in a linked list of locks held by the owner just listed.

type

uses the following codes to indicate the type of lock:

HDR

Header

B

Bytes

S

Shared

X

Exclusive

I

Intent

U

Update

IX

Intent-exclusive

IS

Intent-shared

SIX

Shared, intent-exclusive

lockid

is the tblspace number of the locked resource.

rowid

is the row identification number. The rowid provides the following lock information:

• If the rowid equals zero, the lock is a table lock.
• If the rowid ends in two zeros, the lock is a page lock.
• If the rowid is six digits or fewer and does not end in zero, the lock is probably a row lock.
• If the rowid is more than six digits, the lock is probably an index key-value lock.

key#/bsiz

is the index key number, or the number of bytes locked for a VARCHAR lock.

The maximum number of locks available is specified as LOCKS in the ONCONFIG file.