Columns - Locked Rows

To customize the list of locked rows:

  1. In the System i Navigator window, expand the system you want to use.
  2. Expand Databases and the database that you want to work with.
  3. Expand Schemas.
  4. Expand the Table container.
  5. Right-click the table with which you want to work and select Locked rows.
  6. From the View menu, select Customize this View, then Columns.

Note: You can also right click in the Locked rows window and select Customize this View, then Columns.

Some of the following columns are available only when you access row lock from a table in database. The following columns are available for locked row lists:

Column Description
Lock Request Type The type of lock request. For more information on the possible values for this field, see Lock request types.
Lock Space The identifier of the lock space holding the lock.
Lock Status The current status of the lock. For more information on the possible values for this field, see Lock status.
Row Number The number of the row that is currently locked.
Scope The association of the lock with the job, thread, or the lock space. For more information on the possible values for this field, see Scope.
Thread The identifier of the thread holding, waiting for, or requesting the lock.
Job The name of the job that issued the lock request
User The user name of the job that issued the lock request.
Number The system-assigned job number of the job that issued the lock request.
Current User The current user for the job that issued the lock request.