Reading log records

Reading DB2® log records is useful for diagnostic and recovery purposes.

This information discusses three approaches to writing programs that read log records.

Contents of the log
The log contains the information that is needed to recover the results of program execution, the contents of the database, and the DB2 subsystem. The log does not contain information for accounting, statistics, traces, or performance evaluation.
The physical structure of the log
The active log consists of VSAM data sets with certain required characteristics.
Reading log records with IFI
You can use the READA (read asynchronously) request of the instrumentation facility interface (IFI) to read log records into a buffer. Use the READS (read synchronously) request to read specific log control intervals from a buffer. You can use these requests online while DB2 is running.
Reading log records with OPEN, GET, and CLOSE
You can use the assembler language DSNJSLR macro to submit OPEN, GET, and CLOSE functions. Use this stand-alone method to capture log records that you cannot read with the instrumentation facility interface (IFI) when DB2 stops running.
Reading log records with the log capture exit routine
You can use the log capture exit routine to capture DB2 log data in real time. You can use this exit routine online while DB2 is running.

Parent topic: Operation and recovery