Reading complete log data (IFCID 0306)

Several benefits are associated with use of IFCID 0306 to read log data.

About this task

Begin program-specific programming interface information.The benefits of using IFCID 0306 are:

  • 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'01', 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.

Start of changeGenerally, 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 of change

End program-specific programming interface information.