Logical log control file

On mainframe targets, the control file is a variable block (VB) output file. Think of the control file as linked to the corresponding logical log data file. Be sure to include it if you export a logical log for use on another platform or with other software.

The format of the logical log control file does not define an order for the different types of records that it contains. The only requirement is that the Type Record always appears first.

This section lists the logical log control records in the order in which they normally occur in a logical log, showing the layout of each record. The section also defines a record status for each record to describe the scope of the record’s information. The status can be one of the following:

• DB2 specific: contains information that is specific to the Db2 log and Db2 databases.

• Platform independent: contains information that can apply to other database software.

This section contains the following topics:

• Type record (XTYP)
• Control file ID record (DCNT)
• Data sharing member record (DDSM)
• Work ID record (DWRK)
• Work ID description record (DWKD)
• Logical log data set record (DLDS)
• Logical log description record (DLUS)
• Log information record (DLGI)
• Log information end record (DLGE)
• Open transaction record (DOTR)
• Current path record (XPTH)
• SysStrings base record (DSS1)
• SysStrings transtable record (DSS2)
• Data change header description record (XHDF)
• Table space information record (DTSI)
• Table information record (DTBI)
• Table byte count record (DTBB)
• Table record count record (DTBC)
• Table synonym and alias record (DTOB)
• Db2 column information record (DCLI)
• Db2 column description record part two (DCL2)
• Logical log column information record (DLCI)
• LOB column description record (DLOB)
• XML column description record (DXML)
• XMLSTRING data set name record (DXSF)
• LOB/XML cluster data set record (CLUS)
• Index information record (DIXI)
• Index column description record (DICL)
• Clustering index information record (DCXI)
• Clustering index column description record (DCCL)
• Filter ID record (DFID)
• Filter anchor record (DFIL)
• Filter description record (DFDS)
• Filter line record (DFLN)
• Filter line data record (DLIN)