Database Extract Statistics report
Database Extract Statistics Report
-Segm Length- --Number of Segments Extracted- Logically
Database Segment Level Min Max Phase 1 Phase 2 Total Related DB
-------------------------------------------------------------------------------
DJ2E SUBURB 01 62 62 6 77 83
LINKSTR 02 28 28 509 3517 4026 DJ3E
NSTREET 02 30 30 3 28 31
INSHIRE 02 20 20 6 77 83 DJ1E
LETRBOX 02 34 34 2 28 30
Subtotal DJ2E 526 3727 4253
DJ3E STREET 01 32 32 0 3048 3048
INSUB 02 18 18 0 4026 4026 DJ2E
Subtotal DJ3E 0 7074 7074
DJ1E SHIRE 01 53 53 0 10 10
SHIRENP 02 11 11 0 10 10
LINKSUB 02 18 18 0 85 85 DJ2E
Subtotal DJ1E 0 105 105
Grand total 526 10906 11432
Phase 1 = Extract using keys Phase 2 = Resolution of logical relationships
*** End of IMS Extract Report ***The following is a description of each column in this report.
- Database
- This column contains the name of the primary database and the names of the databases that are logically related to the primary database.
- Segment
- This column contains the names of the segments in the primary and logically related databases.
- Level
- The level of the segment.
- Segm Length
- Min
- The minimum length of the segment as defined in the DBD.
- Max
- The maximum length of the segment as defined in the DBD.
For fixed-length segments, the minimum length and maximum length will be the same.
- Number of Segments Extracted
- Phase 1
- The number of segment occurrences extracted during phase 1 of the Extract. Phase 1 is that part of the extract that precedes the resolution (or chasing) of logical relationships.
- Phase 2
- The number of segment occurrences extracted when resolving (or chasing) logical relationships.
- Total
- The total number of segments occurrences extracted.
- Logically Related DB
- The database in which this segment's logical parent resides.
The following is a description of the rows in this report.
- Subtotal
- These rows contain totals for each database:
- Phase 1
- The total number of segment occurrences extracted from the database during phase 1.
- Phase 2
- The total number of segment occurrences extracted from the database during phase 2.
- Total
- The total number of segment occurrences extracted from the database.
- Grand total
- This row contains the totals for the listed databases:
- Phase 1
- The total number of segment occurrences extracted from the listed databases during phase 1.
- Phase 2
- The total number of segment occurrences extracted from the listed databases during phase 2.
- Total
- The total number of segment occurrences extracted from the listed databases.