The onlog utility displays the contents of a logical-log file, either on disk or on backup.
The onlog output is useful in debugging situations when you want to track a specific transaction or see what changes have been made to a specific tblspace. (For information about interpreting the logical-log file contents, see Interpreting Logical-Log Records.)
Any user can run all of the onlog options except the -l option. Only user informix on UNIX or a member of the Informix-Admin group on Windows can run the -l option.
If the database server is in offline mode when you execute onlog, only the files on disk are read. If the database server is in quiescent or online mode, onlog also reads the logical-log records stored in the logical-log buffers in shared memory (after all records on disk have been read).
When the database server reads a logical-log file with status U from disk while in online mode, the database server denies all access to the logical-log files, effectively stopping database activity for all sessions. (For more information, see onstat -l.) For this reason, it is recommended that you wait until the files have been backed up and then read the contents of the logical-log files from backup.
Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]