Extracted report
The Extracted report provides a count of the number of segments (by segment name and segment code) that were extracted from each area of the database.
A database total is also provided. If segment count for an area is zero, it means that the extracted area is empty.
This report is generated by the EXTRACT command.
If you make one of the following specifications, this report is not printed:
- GLOBAL SCAN=YES
- GLOBAL SCAN=SITE_CREATE
- GLOBAL SCAN=SITE_REPORT
The following figure shows an example of the Extracted report.
IMS HPFP UTILITIES - FPA EXTRACT "Extracted report" PAGE: 1
5698-FPP V2R1 2021-11-22 11:25:42
SEGMENTS EXTRACTED FROM DATABASE: DEDBJN21
- AREA NO: 1 AREANAME: DB21AR0 DDNAME: DB21AR0 DSNAME: HPFP.MDB21AR0.ADSFP
(JCL DD ALLOCATION)
STARTED DATE: 2021-11-22 TIME: 11:25:42 ENDED DATE: 2021-11-22 TIME: 11:25:42
IOVF
- TOTAL CI'S : 9
- UNUSED CI'S : 6
- UNUSED CI RATIO : 67 (%)
SDEP
- TOTAL CI'S : 77
- UNUSED CI'S : 52
- UNUSED CI RATIO : 68 (%)
- RANGE : X'00005800' TO X'00018C00'
- LOGICAL BEGIN : CYCLE COUNT X'00000001' RBA X'00005800'
- LOGICAL END : CYCLE COUNT X'00000001' RBA X'0000B800'
- LOGICAL BEGIN TS : X'D194CC50C010E341'
SUMMARY OF KEY SEQUENCE ERRORS
- NUMBER OF RELATED DB RECORDS : 0
- NUMBER OF THE SEGMENTS DETECTED AS KEY SEQUENCE ERROR : 0
- ERROR SEGMENTS SUM TOTAL INCLUDING CHILD SEGMENTS : 0
SEGMENT SEGMENT SEGMENT SEGMENTS SEGMENTS SKIPPED BY SKIPPED BY SKIPPED BY
CODE NAME HIERARCHY READ EXTRACTED KEY ERROR CRITERIA(SEL) CRITERIA(OUT)
------- -------- ---------------- ----------- ----------- ----------- ------------- -------------
1 ROOTSEG1 1 20 0 0 0 20
2 SDEPSEG1 2 18 0 0 18 0
3 DD101 2 9 0 0 0 9
4 DD201 3 9 8 0 1 0
5 DD301A 4 12 0 0 6 6
6 DD401 5 5 0 0 5 0
7 DD501 6 1 0 0 1 0
8 DD601 7 1 0 0 1 0
9 DD701 8 1 0 0 1 0
10 DD801 9 1 0 0 1 0
11 DD901 10 1 0 0 1 0
12 DDA01 11 1 0 0 1 0
13 DDB01 12 1 0 0 1 0
14 DDC01 13 1 0 0 1 0
15 DDD01 14 1 0 0 1 0
16 DDE01 15 1 0 0 1 0
17 DD301B 4 4 0 0 4 0
18 DD102 2 3 0 0 3 0
19 DD202 3 0 0 0 0 0
20 DD302 4 0 0 0 0 0
21 DD103 2 2 0 0 2 0
22 DD104 2 1 0 0 1 0
IMS HPFP UTILITIES - FPA EXTRACT "Extracted report" PAGE: 2
5698-FPP V2R1 2021-11-22 11:25:42
-----------------------------------------------------------------------------------------------------------
** TOTAL ** 93 8 0 50 35
- DATABASE: DEDBJN21 TOTAL
SEGMENT SEGMENT SEGMENT SEGMENTS SEGMENTS SKIPPED BY SKIPPED BY SKIPPED BY
CODE NAME HIERARCHY READ EXTRACTED KEY ERROR CRITERIA(SEL) CRITERIA(OUT)
------- -------- ---------------- ----------- ----------- ----------- ------------- -------------
1 ROOTSEG1 1 20 0 0 0 20
2 SDEPSEG1 2 18 0 0 18 0
3 DD101 2 9 0 0 0 9
4 DD201 3 9 8 0 1 0
5 DD301A 4 12 0 0 6 6
6 DD401 5 5 0 0 5 0
7 DD501 6 1 0 0 1 0
8 DD601 7 1 0 0 1 0
9 DD701 8 1 0 0 1 0
10 DD801 9 1 0 0 1 0
11 DD901 10 1 0 0 1 0
12 DDA01 11 1 0 0 1 0
13 DDB01 12 1 0 0 1 0
14 DDC01 13 1 0 0 1 0
15 DDD01 14 1 0 0 1 0
16 DDE01 15 1 0 0 1 0
17 DD301B 4 4 0 0 4 0
18 DD102 2 3 0 0 3 0
19 DD202 3 0 0 0 0 0
20 DD302 4 0 0 0 0 0
21 DD103 2 2 0 0 2 0
22 DD104 2 1 0 0 1 0
-----------------------------------------------------------------------------------------------------------
** TOTAL ** 93 8 0 50 35The following figure shows an example of the Extracted report when the SDEPSCAN subcommand is specified.
IMS HPFP UTILITIES - FPA EXTRACT "Extracted report" PAGE: 1
5698-FPP V2R1 2023-06-30 11:25:42
SEGMENTS EXTRACTED FROM DATABASE: DEDBJN21
- AREA NO: 1 AREANAME: DB21AR0 DDNAME: DB21AR0 DSNAME: HPFP.MDB21AR0.ADSFP
(JCL DD ALLOCATION)
STARTED DATE: 2023-06-30 TIME: 11:25:42 ENDED DATE: 2023-06-30 TIME: 11:25:42
IOVF
- TOTAL CI'S : 9
- UNUSED CI'S : 6
- UNUSED CI RATIO : 67 (%)
SDEP
- TOTAL CI'S : 77
- UNUSED CI'S : 52
- UNUSED CI RATIO : 68 (%)
- RANGE : X'00005800' TO X'00018C00'
- LOGICAL BEGIN : CYCLE COUNT X'00000001' RBA X'00005800'
- LOGICAL END : CYCLE COUNT X'00000001' RBA X'0000B800'
- LOGICAL BEGIN TS : X'D194CC50C010E341'
- SDEPSCAN RANGE : STARTRBA X'00006800' STOPRBA X'00009800'
SUMMARY OF KEY SEQUENCE ERRORS
- NUMBER OF RELATED DB RECORDS : 0
- NUMBER OF THE SEGMENTS DETECTED AS KEY SEQUENCE ERROR : 0
- ERROR SEGMENTS SUM TOTAL INCLUDING CHILD SEGMENTS : 0
SEGMENT SEGMENT SEGMENT SEGMENTS SEGMENTS SKIPPED BY SKIPPED BY SKIPPED BY
CODE NAME HIERARCHY READ EXTRACTED KEY ERROR CRITERIA(SEL) CRITERIA(OUT)
------- -------- ---------------- ----------- ----------- ----------- ------------- -------------
1 ROOTSEG1 1 0 0 0 0 0
2 SDEPSEG1 2 18 18 0 0 0
3 DD101 2 0 0 0 0 0
4 DD201 3 0 0 0 0 0
5 DD301A 4 0 0 0 0 0
6 DD401 5 0 0 0 0 0
7 DD501 6 0 0 0 0 0
8 DD601 7 0 0 0 0 0
9 DD701 8 0 0 0 0 0
10 DD801 9 0 0 0 0 0
11 DD901 10 0 0 0 0 0
12 DDA01 11 0 0 0 0 0
13 DDB01 12 0 0 0 0 0
14 DDC01 13 0 0 0 0 0
15 DDD01 14 0 0 0 0 0
16 DDE01 15 0 0 0 0 0
17 DD301B 4 0 0 0 0 0
18 DD102 2 0 0 0 0 0
19 DD202 3 0 0 0 0 0
20 DD302 4 0 0 0 0 0
21 DD103 2 0 0 0 0 0
22 DD104 2 0 0 0 0 0
IMS HPFP UTILITIES - FPA EXTRACT "Extracted report" PAGE: 2
5698-FPP V2R1 2023-06-30 11:25:42
-----------------------------------------------------------------------------------------------------------
** TOTAL ** 18 18 0 0 0
- DATABASE: DEDBJN21 TOTAL
SEGMENT SEGMENT SEGMENT SEGMENTS SEGMENTS SKIPPED BY SKIPPED BY SKIPPED BY
CODE NAME HIERARCHY READ EXTRACTED KEY ERROR CRITERIA(SEL) CRITERIA(OUT)
------- -------- ---------------- ----------- ----------- ----------- ------------- -------------
1 ROOTSEG1 1 0 0 0 0 0
2 SDEPSEG1 2 18 18 0 0 0
3 DD101 2 0 0 0 0 0
4 DD201 3 0 8 0 0 0
5 DD301A 4 0 0 0 0 0
6 DD401 5 0 0 0 0 0
7 DD501 6 0 0 0 0 0
8 DD601 7 0 0 0 0 0
9 DD701 8 0 0 0 0 0
10 DD801 9 0 0 0 0 0
11 DD901 10 0 0 0 0 0
12 DDA01 11 0 0 0 0 0
13 DDB01 12 0 0 0 0 0
14 DDC01 13 0 0 0 0 0
15 DDD01 14 0 0 0 0 0
16 DDE01 15 0 0 0 0 0
17 DD301B 4 0 0 0 0 0
18 DD102 2 0 0 0 0 0
19 DD202 3 0 0 0 0 0
20 DD302 4 0 0 0 0 0
21 DD103 2 0 0 0 0 0
22 DD104 2 0 0 0 0 0
-----------------------------------------------------------------------------------------------------------
** TOTAL ** 18 18 0 0 0- AREA NO
- The area number.
- AREANAME
- The area name.
- DDNAME
- The DDNAME with the following information.
- (DYNAMIC ALLOCATION):
- DDNAME is allocated dynamically.
- (JCL DD ALLOCATION):
- DDNAME is specified in the JCL statement.
- DSNAME
- The DSNAME of the area name DDNAME.
- INPUT DSNAME WAS RENAMED TO DSNAME
- The input area data set is renamed for the processing of the CHANGE command by specifying the IRENAME subcommand.
- TOTAL CI'S
- The total number of CI in each IOVF and SDEP part.
- UNUSED CI'S
- The number of unused CI in each IOVF and SDEP part.
- UNUSED CI RATIO
- The ratio of unused CI in each IOVF and SDEP part.
- RANGE
- The SDEP logical begin and logical end RBAs.
- LOGICAL BEGIN
- The cycle count and RBA of SDEP logical begin.
- LOGICAL END
- The cycle count and RBA of SDEP logical end.
- LOGICAL BEGIN TS
- The timestamp of the SDEP logical begin.
- SDEPSCAN RANGE
- The range specified by the SDEPSCAN subcommand. If the address specified for the STARTRBA or STOPRBA keyword does not fall on an SDEP boundary, it will be adjusted. For details, see STARTRBA keyword or STOPRBA keyword.
- SUMMARY OF KEY SEQUENCE ERRORS
- The summary of number of records when a sequence error in a key
sequence field is detected.
- NUMBER OF RELATED DB RECORDS
- The number of the DB records that have segments that were detected as key sequence errors in extracting processes.
- NUMBER OF THE SEGMENTS DETECTED AS KEY SEQUENCE ERROR
- The number of the segments that were detected as key sequence errors in extracting processes.
- ERROR SEGMENTS SUM TOTAL INCLUDING CHILD SEGMENTS
- The number of the segments that were detected as key sequence errors in extracting processes and its child segments.
- SEGMENT CODE
- The segment code.
- SEGMENT NAME
- The segment name.
- SEGMENT HIERARCHY
- The segment hierarchy.
- SEGMENTS READ
- The number of segments that are read.
- SEGMENTS EXTRACTED
- The number of segments that are extracted.
- SKIPPED BY KEY ERROR
- The number of segments that are skipped by the key sequence error.
- SKIPPED BY CRITERIA(SEL)
- The number of segments that are skipped by the following reasons:
- The segments did not meet the criteria that are specified in the SELECT subcommand.
- This segment type was not treated as the input segment.
- SKIPPED BY CRITERIA(OUT)
- The number of segments that are skipped by the following reasons:
- The segments did not meet the criteria that are specified in the OUTPUT subcommand.
- This segment type was not treated as the output segment.
- DATABASE TOTAL
- The total number of segments that are extracted for the database.