Layout of HISTORY data set record

This reference topic describes the layout of HISTORY data set records.

This topic describes product-sensitive programming interface information. See Programming interface information to understand the restrictions associated with this type of material.

Begin product-sensitive programming interface information.

The layout has the four types of HISTORY data set records. You can use the FABGHIR macro to map these records with the DSECT name HISTREC.

Subsections:

HISTORY data set control record

This control record contains the following information:

  • HD Pointer Checker runtime list which shows all dates of the HD Pointer Checker runs and the number of runs a day
  • Number of database data set table records in the HISTORY data set
  • Number of database data set records in the HISTORY data set

Database data set (DBDS) table record

This record contains key date list entries. Each entry contains the following information:

  • Key date field of the database data set records for the database data set
  • Number of database data set records of the same key date for the database data set
  • A flag indicating whether HD Pointer Checker CHECK process was done for the database data set

Database data set (DBDS) record

This record contains analysis information of a database data set collected by HD Pointer Checker.

There are three types of database data set records as follows:

Statistics record 1

This is the first record of database data set records with the same key date for the database data set. It contains following information:

  • Database description information
  • HD Pointer Checker runtime option information
  • Pointer validation information
  • HISAM, HIDAM index, or secondary index information
  • HD Pointer Checker output records count information
Statistics record 2

This is the second record of database data set records with the same key date for the database data set.

  • Free space statistics information
  • Tuning statistics information
  • DB records distribution statistics information
  • HD Pointer Checker output records count information
Segment statistics record

This is the third or up to 255th record of database data set records with the same key date for the database data set. One record can contain the information of two segments.

  • Segments statistics information

HD Pointer Checker runtime record

This record contains the key date and the names of all database data sets processed by the last HD Pointer Checker run in one day.

Macro intended for customer use

The macro identified in this topic is provided to allow a customer installation to write programs that use the services of DB Historical Data Analyzer. Use only this macro to request or receive the services of DB Historical Data Analyzer.

DB Historical Data Analyzer provides only the following product-sensitive macro:

FABGHIR
This macro is used to map the HISTORY data set records with the DSECT name HISTREC.

End product-sensitive programming interface information.