Displays the Row resource information of a transaction.
The columns are:
Table: The name of the local database file, or table, under commitment control for the commitment definition.
Schema: The name of the schema that contains the file, or table.
Partition: The name of the file, or table, member, or partition.
Commit: The total number of record, or row, level changes to the file, or table, that have been committed since the commitment definition was created.
Rollback: The total number of record, or row, level changes to the file, or table, that have been rolled back since the commitment definition was created.
Pending: The total number of record, or row, level changes to the file, or table, pending a commit or rollback for the commitment definition.
Lock level: The level of record, or row, locking for this file, or table. Possible values are:For more details about lock level, see Default lock level.
- All
- Change
- Cursor Stability
Status: The status of the file, or table.
Journal: The journal in which changes to the file, or table are recorded. This value is provided only if a journal name was specified when the API resource associated with the exit program was added. If no journal name was specified, this field is zero.
Journal schema: The schema in which the journal can be located. This value is provided only if a journal name was specified when the API resource associated with the exit program was added. If no journal name was specified, this field is zero.
Commit Cycle ID The commit cycle identifier of the current logical unit of work (LUW) for this file's journal. This value is provided only if a journal name was specified when the API resource associated with the exit program was added. If no journal name was specified, this field is zero.