Historical Analysis by DB Segments

On this panel, you can select detailed items of database segment analysis information. DB Historical Data Analyzer shows the historical trend of the selected items for the database data set group identified by the DBNAME and DDNAME fields.

The following figure shows the Historical Analysis by DB Segments panel.

Figure 1. Historical Analysis by DB Segments
 
                        HISTORICAL ANALYSIS BY DB SEGMENTS
 COMMAND ===>
 
   DBNAME = DSCRSDVN   DDNAME = DSCRSDV0   DSG = 01     1st Entry  = 03/26/2020
   DB-ORG = HDAM                           ACC = ESDS   Last Entry = 10/07/2021
                                                        Entries    = 00076
   Select one of the following groups and press ENTER. 
 
   GROUP NUMBER ===> _         Enter S in front of items to be processed. 
 
                    1. _ Total number of segments
                       _ Total number of dependent segments
                       _ Total number of segments by segment code
                    2.   Percent of root segments
                    3.   Occurrence of segments per root by segment code
                    4.   Length of longest segment
                    5.   Average length of segments by segment code 
 
   ENTRIES TO BE SELECTED 
 
           From Date = 10 / 01 / 2020    May specify the desired date
           To Date   = 10 / 07 / 2021    Input format is "MM/DD/YYYY"

Select a group number (1 to 5), and select one or more items under the selected group, if necessary. Press Enter to pass the control to ICU, or enter END to return to the Graph Selection Menu panel.

The items shown on this panel are:

Group number 1
  • Total number of segments
  • Total number of dependent segments
  • Total number of segments by segment code

These items are applicable to HISAM, HDAM, HIDAM, PHDAM, and PHIDAM DSG A-J.

Group number 2
Percentage of root segments within the total number of segments. This item applies to the primary data set groups of HISAM, HDAM, HIDAM, PHDAM, and PHIDAM databases.
Group number 3
Occurrence of segments per root by segment code. This item applies to the primary data set groups of HISAM, HDAM, HIDAM, PHDAM, and PHIDAM databases.
Group number 4
Length of the longest segment. This item applies to the primary data set groups of HDAM, HIDAM, PHDAM, and PHIDAM databases.
Group number 5
Average length of segments by segment code. These items are applicable to HISAM, HDAM, HIDAM, PHDAM, and PHIDAM DSG A-J.
Tip: If you select items related to segment code (for example, total number of segments by segment code), you might get a busy chart if the database data set group has many segment codes. In such a case, consider excluding an appropriate number of segment codes on the ICU panel 2.3 to make the chart more simple and clear.