Generating batch reports on database statistics

Overview

The BATCH option in the "Database Statistics Menu" enables you to use _beta report to generate reports containing selected statistics on database usage.

Procedure

1. Select option 2 BATCH from the"Database Statistics Menu" to call the "Statistic Batch Report" panel:

   PEB5UBP2 ---------------------------------------------------------------------
   Command ===> _________________________________________________________________
   
   Statistics Batch Report
   
   Start Date (MM/DD/YYYY) ===> YESTERDAY.
   End Date (MM/DD/YYYY) ===> TODAY_____
   
   Selection ===> D per (H)our, (D)ay, (M)onth
   
   RPGPRINT/WORKFILE Options ===> Y (Y)es,(N)o
   
   
   Optional Selection Criteria:
   
   Subsystem ID ===> ____
   Sysclone Name ===> __
   Sysplex Name ===> ________
   
   
   
   Press ENTER to generate the respective batch job.
   Press END to return to the previous menu.
   
   

2. Specify the start and end dates and any other selection criteria relevant to your product/report.
3. When you are satisfied with your specifications, press ENTER
   • If you set the RPGPRINT/WORKFILE Options field to (N)o, the procedure is now complete.
   • If you set the RPGPRINT/WORKFILE Options field to (Y)es, the "RPGPRINT/RPGWORK Options" panel is displayed:

     PEB5UBOP ---------------------------------------------------------------------
     Command ===> _________________________________________________________________
     
     RPGPRINT Options:
     
     Class ===> _ Writer Name ===> ________
     Forms Number ===> ____ User ID ===> ________
     Destination ===> ________
     
     RPGWORK Options:
     
     Type ===> ___ (T)RK,(C)YL
     Prim. Space ===> __
     Sec. Space ===> __
     
     Job Card:
     ===> //UBPREP JOB 1,ACCOUNT,CLASS=A,MSGCLASS=P,NOTIFY=&SYSUID
     ===> //*_____________________________________________________________________
     ===> //*_____________________________________________________________________
     ===> //*_____________________________________________________________________
     
     Press ENTER to continue with the job generation. Press UP to display the
     previous page. Press END to return to the previous menu.
     

4. Only if you set the RPGPRINT/WORKFILE Options field to (Y)es:

   Fill in the fields as required and press ENTER.

5. The job is generated and the JCL is displayed, enabling you to accept or modify the entries before submitting the job.

Result

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.