Summary of index database checking
HD Pointer Checker checks several items regarding primary and secondary indexes. What you can check varies depending on how it is run and what you specify on the control statement.
- For information about specifying the PROCCTL control statement, see FABPMAIN PROCCTL data set.
- For information about specifying the ICEIN control statement when running HD Pointer Checker in IMS HP Image Copy, IMS Database Reorganization Expert, or IMS Online Reorganization Facility jobs, see the User's Guide of each product.
- For information about specifying the ADD command or the UTILGBL statement when running HD Pointer Checker in IMS Database Recovery Facility jobs, see the IMS Recovery Solution Pack IMS Database Recovery Facility User's Guide.
If a segment/edit compression routine is defined in the index source segment, specify the data set that contains the segment/edit compression routine in the IMS2 or STEPLIB DD statement to do the index check in an HD Pointer Checker job or IMS HP Image Copy job.
If a secondary index database maintenance exit routine is defined in the index source segment, specify the data set that contains the secondary index database maintenance exit routine in the IMS2 or STEPLIB DD statement to do the index check
The tables in the following subsections show what you can check for each index database type and how to specify it on the control statement. "Yes" indicates that the check is available, and how to specify it is shown in brackets. Even if "Yes" is specified, there are restrictions, which are described in each table.
HIDAM primary index
- Basic Check
- Checks the number of root segments and index pointer segments.
- Validates the pointer values (RBA of the root segment) of the index pointer segments.
- Index Key Check
- Validates the key values of the index pointer segments.
Function | HD Pointer Checker processor (FABPMAIN) | Single Step HASH Check option run from IMS HP Image Copy | HASH Check option run from IMS Database Reorganization Expert | HASH Check option run from IMS Online Reorganization Facility | HASH Check option run from IMS Database Recovery Facility | |
---|---|---|---|---|---|---|
PROCCTL PROC HASH=NO | PROCCTL PROC HASH=YES | ICEIN HDPC=Y | ICEIN HDPC=Y | ICEIN HDPC=Y or PTRCHECK(Y) | ADD PC() | |
Basic Check | Yes (DATABASE statement of the index database) (Required) | Yes (DATABASE statement of the index database) | Yes (Specify the index database in ICEIN) | Yes (Specify the index database in ICEIN) | Yes (Specify the index database in ICEIN or specify the HIDAM database and PTRCHECK(Y) in HRFSYSIN) | Yes (Specify the index database or the BLD_PRIMARY option) |
Index Key Check | Yes (PROC IXKEYCHK=YES) | Yes (PROC IXKEYCHK=YES) (See 1) | Yes (GLOBAL IXKEYCHK=YES) (See 1) | Yes (GLOBAL IXKEYCHK=YES) (See 1 and 2) | Yes (GLOBAL IXKEYCHK=YES in ICEIN) (See 1 and 2)) | No |
Notes:
|
Secondary index of non-HALDB
- Basic Check
- Checks the number of index source segments and index pointer segments.
- Validates the pointer values (RBA of the index target segment) of the index pointer segments.
- When the index database has an overflow data set, validates the pointers that point to the logical records in the overflow data set.
- Index Key Check
- Validates the key values of the index pointer segments.
- Symbolic Pointer Check
- Validates the symbolic index pointers.
- Suppressed Segment Check
- Checks that the index pointer segments are suppressed correctly by using the secondary index maintenance exit routine.
Function | HD Pointer Checker processor (FABPMAIN) | Single Step HASH Check option run from IMS HP Image Copy | HASH Check option run from IMS Database Reorganization Expert | HASH Check option run from IMS Online Reorganization Facility | HASH Check option run from IMS Database Recovery Facility | |
---|---|---|---|---|---|---|
PROCCTL PROC HASH=NO | PROCCTL PROC HASH=YES | ICEIN HDPC=Y | ICEIN HDPC=Y | ICEIN HDPC=Y or PTRCHECK(Y) | ADD PC() | |
Basic Check | Yes (DATABASE statement of the index database) (See 4 and 6) | YES (DATABASE statement of the index database) (See 1, 3, and 4) | Yes (Specify the index database in ICEIN) (See 1 and 3) | Yes (Specify the index database in ICEIN) (See 1, 2, and 3) | Yes (Specify the index database in ICEIN or specify an indexed database and PTRCHECK(Y) in HRFSYSIN) (See 1, 2, and 3) | Yes (Specify the index database or the BLD_SECONDARY() option) (See 1, 3, and 9) |
Index Key Check | Yes (PROC IXKEYCHK=YES) (See 5 and 8) | YES (PROC IXKEYCHK=YES) (See 5 and 7) | YES (GLOBAL IXKEYCHK=YES) (See 7) | YES (GLOBAL IXKEYCHK=YES) (See 2 and 7) | YES (GLOBAL IXKEYCHK=YES in ICEIN) (See 2 and 7) | No |
Symbolic Pointer Check | Yes (PROC SYMIXCHK=YES) | No | No | No | No | No |
Suppressed Segment Check | Yes (OPTION SPIXCHK=YES) | Yes (OPTION SPIXCHK=YES) | Yes (This check is done with the Basic Check) | Yes (This check is done with the Basic Check) | Yes (This check is done with the Basic Check) | No |
Notes:
|
Primary index of HALDB PHIDAM
- Basic Check
- Checks the number of root segments and index pointer segments.
- Validates the pointer values (RBA of the root segment) of the index pointer segments.
- Index Key Check
- Validates the key values of the index pointer segments.
Function | HD Pointer Checker processor (FABPMAIN) | Single Step HASH Check option run from IMS HP Image Copy | HASH Check option run from IMS Database Reorganization Expert | HASH Check option run from IMS Online Reorganization Facility | HASH Check option run from IMS Database Recovery Facility | |||
---|---|---|---|---|---|---|---|---|
PROCCTL PROC HASH=NO DATABASE DATASET=REAL | PROCCTL PROC HASH=NO DATABASE DATASET=IMAGECOPY | PROCCTL PROC HASH=YES DATABASE DATASET=REAL | PROCCTL PROC HASH=YES DATABASE DATASET=IMAGECOPY | ICEIN HDPC=Y | ICEIN HDPC=Y | ICEIN HDPC=Y or PTRCHECK(Y) | ADD PC() | |
Basic Check | Yes (DATABASE statement of the PHIDAM database) (Required) | No (ignored even if the DATABASE statement of the PHIDAM database is specified.) | Yes (DATABASE statement of the PHIDAM database) (Required) | No (ignored even if the DATABASE statement of the PHIDAM database is specified.) | No | No | No | No |
Index Key Check | Yes (PROC IXKEYCHK=YES) | No | YES (PROC IXKEYCHK=YES) (See Note) | No | No | No | No | No |
Note: If some of the root segments are split to prefix and data portions and
physically deleted, HASH Check of index key is not done.
|
Secondary index of HALDB (PSINDEX)
- Basic Check
- Checks the number of index source segments and index pointer segments.
- Validates the pointer values of the index pointer segments.
- Index Key Check
- Validates the key values of the index pointer segments.
- EPS Check
- Validates whether the relationship among the index target segments, the index list entries (ILE) in the indirect list data set (ILDS), and the index pointer segments are correct.
- Suppressed Segment Check
- Checks that the index pointer segments are suppressed correctly by using the secondary index maintenance exit routine.
Function | HD Pointer Checker processor (FABPMAIN) | Single Step HASH Check option run from IMS HP Image Copy | HASH Check option run from IMS Database Reorganization Expert | HASH Check option run from IMS Online Reorganization Facility | HASH Check option run from IMS Database Recovery Facility | |
---|---|---|---|---|---|---|
PROCCTL PROC HASH=NO | PROCCTL PROC HASH=YES | ICEIN HDPC=Y | ICEIN HDPC=Y | ICEIN HDPC=Y or PTRCHECK(Y) | ADD PC() | |
Basic Check | Yes (DATABASE statement of the index database) (See 1) | No | No | No | No | No |
Index Key Check | Yes (PROC IXKEYCHK=YES) (See 2, 3, and 4) | No | No | No | No | No |
EPS Check | Yes (PROC EPSCHK=YES) (See 5) | No | No | No | No | No |
Suppressed Segment Check | Yes (OPTION SPIXCHK=YES) | No | No | No | No | No |
Notes:
|