The type of lock that was requested. Possible values are:
Shared - Read
The row is locked for read. Regardless of scope, the row may be shared by all lock requests other than Exclusive-update. It may also be shared by some Exclusive-update lock requests (see Exclusive-update row of this table for more details).
Shared - Internal
The row is locked internally for read. For a short period of time the operating system holds an internal lock to prevent the row from being updated while it is being read.
Note: For the shared - internal lock request type, you will not directly specify the lock type on each I/O. The system will determine what type of lock to acquire, and how long to hold it, based on the commitment control lock level in effect at the time of the I/O.For more information on lock level parameters, see the Commit lock level article in the i5/OS Information Center
.
Exclusive - Update
The row is locked for update. Only one Exclusive-update lock is allowed on a row at the same time, regardless of scope. A row that is locked with a thread scoped Exclusive-update lock may be shared with a thread scoped Shared-read lock for the same thread, or a process scoped Shared-read lock for the same process, or a lock space scoped Shared-read lock for a lock space that is attached to the same thread. A row that is locked with a process scoped Exclusive-update lock may be shared with a process scoped Shared-read lock for the same process, or a thread scoped Shared-read lock for any thread in the same process. A row that is locked with a lock space scoped Exclusive-update lock may be shared with a lock space scoped Shared-read lock for the same lock space, or a thread scoped Shared-read lock for a thread to which the same lock space is attached.