Displaying database statistics

Displaying database statistics

Overview

The BROWSE option in the "Database Statistics" Menu enables you to display statistics for the selected subsystem.

Procedure

  1. Select option 1 BROWSE from the "Database Statistics Menu (D.3.1) to call the "Display Statistic Values" input panel.

    PEB5UBP1 ---------------------------------------------------------------------
    Command ===> _________________________________________________________________

    Display Statistic Values

    Start Date (MM/DD/YYYY) ===> 01.01.2010
    End Date (MM/DD/YYYY) ===> TODAY_____

    Selection ===> M per (H)our, (D)ay, (M)onth

    Subdivision by
    SSID, Sysclone, Sysplex ===> Y (Y)es, (N)o

    Optional Selection Criteria:

    Subsystem ID ===> *___
    Sysclone Name ===> *_
    Sysplex Name ===> *_______



    Press ENTER to display the Database Statistics Table.
    Press END to return to the previous menu.

  2. Enter the time selection criteria to limit the date range of the records that are to be reflected in the statistics (Start Date/End Date).

    Note: When specifying a time range, please remember that the longer the time range, the longer the selection process takes.

  3. Select the interval that is to be the basis for your statistics (Hourly, Daily, Monthly).
  4. Set field Subdivisdion by SSID, Sysclone, Sysplex to YES or NO, depending on your requirements and the product concerned (you will find more information in the documentation for the product).
  5. Specify the optional selection criteria. For more information on the specifications in each of the following fields, refer to the table.

Result

The "Statistics Table (...)" is displayed in accordance with the selection criteria you specified. The table below is an example of monthly statistics, with field Subdivision by SSID, Sysclone, Sysplex set to Yes:

PEB5UB10 -------------------------------------------------- Row 1 of 56
 Command ===> ________________________________________________ Scroll ===> PAGE

 Statistics Table (Monthly)

 S - Display daily statistics

 Sel SSID Sysc Sysplex Date IN_PAGES OUT_PAGES ARCH_PAGES
 TW30 30 PLEX30 03/2013 5 0 0
 F09A TA INSTPLEX 03/2013 59675 0 6
 S TW30 30 PLEX30 04/2013 10858 0 0
 F09A TA INSTPLEX 04/2013 240517 0 0
 TW30 30 PLEX30 05/2013 175340 0 0
 F09A TA INSTPLEX 05/2013 51808 0 550
******************************** BOTTOM OF DATA ********************************








Note

The results that you receive depend on the Beta Systems product you are generating statistics for. All results tables will include the Date, and if field Subdivision by SSID, Sysclone, Sysplex is set to YES, also the SSID, Sysc and Sysplex columns. However, columns such as Count, IN_PAGES, OUT_PAGES, ARCH_PAGES, for example, are product dependent. Please refer to the relevant Beta Systems product documentation for details.

Line command S

  • Line command S in front of a month in the "Statistics Table (Monthly)" table displays the daily statistics for that month.
  • Line command S in front of a day in the "Statistics Table (Daily)" table displays the hourly statistics for that day. In the "Statistics Table (Daily)" table you can scroll to the right and the left (normally PF11/PF10 respectively).
  • Line command S is not available in the "Statistics Table (Hourly)" table.