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 example, see monitoring a global transaction in the chapter on multiphase commit protocols in the IBM Informix Administrator's Guide.
Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]