Reading complete log data (IFCID 0306)

You can use IFI READS calls for IFCID 0306 to read complete log records.

Before you begin

If you plan to store the expansion dictionary for compressed log records in the compression dictionary data set, see Storing the expansion dictionary for compressed log records in the compression dictionary data set.

About this task

Begin program-specific programming interface information.IFI READS calls for IFCID 0306 perform the following functions:

  • IFCID 0306 can request Db2 to decompress log records if compressed, before passing them to the return area of your IFI program.
  • In a data sharing environment, Db2 merges log records if the value of the IFI READS qualification WQALFLTR is X'00'. If WQALFLTR is X'03', log records are not merged.
  • IFCID can retrieve log records from the archive data sets.
  • Complete log records are always returned.

Procedure

To use IFCID 0306:

Issue an IFI READS call. 
CALL DSNWLI(READS,ifca,return_area,ifcid_area,qual_area)
IFCID 0306 must appear in the IFCID area. IFCID 0306 returns complete log records. Multi-segmented control interval log records are combined for a complete log record.

Generally, catalog and directory objects cannot be in group buffer pool RECOVER-pending (GRECP) status when an IFCID 0306 request accesses the compression dictionary. Only log entries for tables that are defined with DATA CAPTURE CHANGES enabled are decompressed.

End program-specific programming interface information.