Secondary Index Summary report


The Secondary Index Summary report describes the secondary index segments defined for the database.

One section appears for each secondary index segment defined.

The Secondary Index Summary report contains the following fields.


Field

Description

SECONDARY INDEX DBD NAME

The DBD name of the secondary index named by the LCHILD statement of the input DBD.

TARGET SEGMENT

The segment in which the XDFLD statement is defined.

SOURCE SEGMENT

The segment named by the SEGMENT parameter on the XDFLD statement.

POINTER FROM INDEX

The type of pointer (INDX or SYMB) between the source database and this index, as defined in the LCHILD statement.

EXIT ROUTINE

The name of the index maintenance routine.

NULLVAL

The value to suppress the creation of index pointer segments.

SEARCH FIELDS

The source segment fields used to search the index, from the SRCH parameter on the XDFLD statement.

DUPLICATE DATA FIELDS

The source segment data stored in the index, from the DDATA parameter on the XDFLD statement.

SUBSEQUENCE FIELDS

The source segment subsequence fields concatenated in the index pointer segment, from the SUBSEQ parameter on the XDFLD statement.

CONSTANT

The character assigned to each index pointer segment. (This field does not appear in all reports of this type.)

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*

BMC AMI Database Integrity for IMS 5.1