Secondary Index Definition report

SECONDARY INDEX DBD NAME

The DBD name of the secondary index.

TARGET DBD NAME

The name of the target DBD.

XDFLD NAME

The index field name specified in the source segment. It is the name used in the NAME operand of the XDFLD macro in the indexed DBD.

TARGET SEGMENT

The database segment pointed to by the secondary index pointer segment.

SOURCE SEGMENT

The database segment containing the data that the Index Build function uses to build the secondary index segment.

SHARED INDEX CONSTANT

A one-byte constant that identifies all pointer segments for a specific index in a shared index database. The value in the constant field is part of the index key. This field appears only for shared secondary indexes.

DATABASE DDNAME(S)

The ddname(s) of the database for which the secondary index was built.

SEARCH FIELD(S)

The following fields specify the data in the search field, which is the key to the secondary index pointer segment. All data in the search field comes from the source segment.

• NAME—The name used to identify the search field.
• START—The starting location of the search field.
• LENGTH—The length (in bytes) of the data in the search field.
• TYPE—The type of data in the search field.

SUBSEQUENCE FIELD(S)

The following fields specify the data in the subsequence fields, which the Index Build function uses to make non-unique keys unique:

• NAME—The name used to identify the subsequence field.
• START—The starting location of the subsequence field.
• LENGTH—The length (in bytes) of the data in the subsequence field.
• TYPE—The type of data in the subsequence field.

DUPLICATE DATA FIELD(S)

The following fields specify the data in the duplicate data fields:

• NAME—The name used to identify the duplicate data field.
• START—The starting location of the duplicate data field.
• LENGTH—The length (in bytes) of the data in the duplicate data field.
• TYPE—The type of data in the duplicate data field.

NULLVAL

A one-byte hexadecimal value used to suppress entries in the secondary index database.

TYPE OF POINTER

The type of pointer used for the secondary index. Direct pointing points to a segment by using its physical address. Symbolic pointing points to a segment by using its key.

SET IMAGE COPY NEEDED FLAG

Whether the DBRC RECON data sets have the ICNEEDED flag turned on or off for this index DBD.

LAYOUT OF THE INDEX RECORD

The fields described in Index record fields specify the location and the number of bytes used for each field in the secondary index pointer segment.

n-BYTE DELETE BYTE

The delete byte and its location in the secondary index pointer segment. The delete byte determines when a segment was flagged for deletion from the database.

n-BYTE pointerType POINTER

The pointer fields and their location in the secondary index pointer segment. pointerType is DIRECT or SYMBOLIC.

n-BYTE SHARED INDEX CONSTANT

The shared index constant field and its location in the secondary index pointer segment.

n-BYTE SEARCH FIELD(S)

The search fields and their locations in the secondary index pointer segment.

n-BYTE SUBSEQUENCE FIELD(S)

The subsequence fields and their locations in the secondary index pointer segment.

n-BYTE DUPLICATE DATA

The duplicate data fields and their locations in the secondary index pointer segment.

n-BYTE FILLER

A null field used to make a segment’s length an even number of bytes.