Analyzing and Recovering Journaled Transactions

This chapter discusses journaled transactions and how to analyze, recover, and redo them using the Journal Analyzer visual tool.

Journal Analyzer

The Journal Analyzer utility allows you to view and analyze journaled transactions and individual underlying statements. It also enables you to create SQL scripts, which are used to recover or redo individual row operations without redoing or rolling back the whole database or table.

The Journal Analyzer is supported in Ingres 2.6 and above.

In the Journal Analyzer, you can:

• View past transactions and their begin/end timestamps, duration, LSN, and user, and the number of insert, update, and delete statements within the transaction
• View tables and rows involved in the transaction
• View before and after images and corresponding LSN for row changes within the transaction
• View rolled back transactions
• View some types of statements, such as create table or create index, inserts, updates, and deletes, and recover or redo journaled insert, update, and delete statements
• Recover and redo transactions immediately or generate scripts to do it at another time or in another database
• Recover and redo multiple transactions at one time, allowing, for example, the replaying of whole sequences of journal files on a remote node/database
• Recover and redo individual row changes

For detailed instructions on using the Journal Analyzer, see the Journal Analyzer online help.

Start Journal Analyzer

To start the Journal Analyzer:

Windows:

Do one of the following:

• Click Start on the taskbar and choose Programs, Ingres, Ingres Journal Analyzer.
• From within Ingres Visual Manager's right-click popup menu, select Journal Analyzer, or click the Journal Analyzer toolbar button.
• Type ija at the command prompt.

UNIX:

• Type ija at the command prompt.

Journal Analyzer Window

In the Journal Analyzer window, the left pane consists of the vnode, databases, and tables. In the left pane, you can drill down to the desired vnode, database, and (optionally) table. When a database or table has been selected, the right pane appears as follows:

Controls in the right pane are as follows:

• Filter

  Use the Filter options to control the quantity and type of transactions that are displayed, based on different criteria such as the transaction date and time, checkpoint number, user, and so on.

• View

  Clicking the View button displays transaction information that is currently in the journals. You must click the View button to refresh the data when you change the filter criteria.

• Move Logs to Journals

  To see any recent transactions that are in the transaction log file—but have not yet moved to the journals—click Move Log to Journals.