Determine the position of a logical-log record

Use the onstat -x command to determine the position of a logical-log record.

The curlog and logposit fields provide the exact position of a logical-log record. If a transaction is not rolling back, curlog and logposit describe the position of the most recently written log record. When a transaction is rolling back, these fields describe the position of the most recently “undone” log record. As the transaction rolls back, the curlog and logposit values decrease. In a long transaction, the rate at which the logposit and beginlg values converge can help you estimate how much longer the rollback is going to take.

For an onstat -x command example, see monitoring a global transaction in the chapter on multiphase commit protocols in the HCL Informix® Administrator's Guide.


Copyright© 2020 HCL Technologies Limited