Secondary Index Duplicate Key report
The Secondary Index Duplicate Key report shows information about secondary indexes that have duplicated keys.
This report is generated by the INDEXBLD command.
The following figure is an example of the Secondary Index Duplicate Key report.
IMS HPFP UTILITIES - FPA INDEXBLD "Secondary Index Duplicate Key Report" PAGE: 1
5698-FPP V2R1 2021-04-07 17:22:42
DUPLICATE KEY VALUE INFORMATION:
# OF KEYS
PARTITION NUMBER OF USED MORE
GROUP DBDNAME DDNAME SEGMENT SEQUENCE FIELD (HEX) (CHARACTER) DUPLICATES THAN ONCE
--------- -------- -------- ----------------------------------------------------- *------------------------* ---------- ----------
DBD00001 S000001R C4C4F2F2 C9C4E7F1 *DD22IDX1 * 1
C4C4F2F2 C9C4E7F2 *DD22IDX2 * 1
(TOTAL) 2 2
--------- -------- -------- ----------------------------------------------------- *------------------------* ---------- ----------
GROUP001 DBD00002 S000002R F1F1F1F1 F1F1F1F1 F1F1F1F1 F1F1F1F1 F1F1F1F1 F1F1F1F1 *111111111111111111111111*
F1F1F1F1 F1F1F1F1 F1F1F1F1 F1F1F1F1 *1111111111111111 * 10
F2F2F2F2 F2F2F2F2 F2F2F2F2 F2F2F2F2 F2F2F2F2 F2F2F2F2 *222222222222222222222222*
F2F2F2F2 F2F2F2F2 F2F2F2F2 F2F2F2F2 *2222222222222222 * 10
(TOTAL) 20 2
--------- -------- -------- ----------------------------------------------------- *------------------------* ---------- ----------
GROUP001 DBD00003 S000003R F3F3F3F3 F3F3F3F3 F3F3F3F3 F3F3F3F3 F3F3F3F3 F3F3F3F3 *333333333333333333333333*
F3F3F3F3 F3F3F3F3 F3F3F3F3 F3F3F3F3 *3333333333333333 * 10
F4F4F4F4 F4F4F4F4 F4F4F4F4 F4F4F4F4 F4F4F4F4 F4F4F4F4 *444444444444444444444444*
F4F4F4F4 F4F4F4F4 F4F4F4F4 F4F4F4F4 *444444444444444444 * 10
(TOTAL) 20 2
--------- -------- -------- ----------------------------------------------------- *------------------------* ---------- ----------
GROUP001 (GROUP TOTAL) 40 4
DUPLICATE POINTER SEGMENT DATA SET INFORMATION:
INDEX
DBDNAME DDNAME DSNAME ALLOCATION
-------- -------- ------------------------------------------------------- -----------
DBD00001 S000001R HPFP.S000001R.DUP DYNALLOC
DBD00002 S000002R HPFP.S000002R.DUP DYNALLOC
DBD00003 S000003R HPFP.S000003R.DUP DYNALLOC- PARTITION GROUP
- The first DBD name in the partition group.
- DBDNAME
- The name of the DBD.
- DDNAME
- The ddname of the secondary index database data set.
- SEGMENT SEQUENCE FIELD
- The key value in hexadecimal and character format.
- NUMBER OF DUPLICATES
- The number of occurrences of this key value in this DBD. For example, 10 is printed if a key value is used 10 times.
- # OF KEYS USED MORE THAN ONCE
- The number of duplicate keys. For example, 2 is printed if key values DD22IDX1 and DD22IDX2 are used more than once in this DBD.
- DUPLICATE POINTER SEGMENT RECORD DATA SET INFORMATION
- INDEX DBDNAME
- The name of the secondary index DBD.
- DDNAME
- The DD name of the duplicate pointer segment record data set.
- DSNAME
- The name of the duplicate pointer segment record data set.
- ALLOCATION
- One of the following values is printed:
- JCL DD
- The duplicate pointer segment record data set was specified by a S0nnnnnR DD statement in the JCL.
- DYNALLOC
- The duplicate pointer segment record data set was allocated dynamically by the DUPKEYDSNMASK keyword or the FILECTL subcommand.