Database Calendar report example


The following figure is an example of the Database Calendar report:


*** MVIMS ***                                        IMS PERFORMANCE REPORTER                                          *** MVIMS ***
CURRENT DATE - mm/dd/yyyy <1>                         DATABASE CALENDAR REPORT <2>                                                  
                                                           month yyyy <3>                                                           
************************************************************************************************************************************
*   S U N D A Y   *    M O N D A Y   *   T U E S D A Y  * W E D N E S D A Y*  T H U R S D A Y *    F R I D A Y   *S A T U R D A Y  *
************************************************************************************************************************************
*                 *         1        *         2        *         3        *         4        *         5        *         6       *
*                 *                  *                  *                  *                  *                  *                 *
*                 *                  *                  *                  *                  *                  *                 *
*                 *                  *                  *                  *                  *                  *                 *
*                 *                  *                  *                  *                  *                  *                 *
*                 *                  *                  *                  *                  *                  *                 *
*                 *                  *                  *                  *                  *                  *                 *
*                 *                  *                  *                  *                  *                  *                 *
************************************************************************************************************************************
*        7        *         8        *         9        *        10        *        11        *        12        *        13       *
*                 *                  *                  *                  *                  *                  *                 *
*                 *                  *                  *                  *                  *                  *                 *
*                 *                  *                  *                  *                  *                  *                 *
*                 *                  *                  *                  *                  *                  *                 *
*                 *                  *                  *                  *                  *                  *                 *
*                 *                  *                  *                  *                  *                  *                 *
*                 *                  *                  *                  *                  *                  *                 *
************************************************************************************************************************************
*       14        *        15        *        16        *        17        *        18        *        19        *        20       *
*                 *                  *                  *                  *                  *               <4>* #DB           49*
*                 *                  *                  *                  *                  *               <5>* G-CALS      21.4*
*                 *                  *                  *                  *                  *               <6>* U-CALS       4.1*
*                 *                  *                  *                  *                  *               <7>* READS        3.7*
*                 *                  *                  *                  *                  *               <8>* WRITES       1.1*
*                 *                  *                  *                  *                  *               <9>* N-I/O        0.0*
*                 *                  *                  *                  *                  *              <10>* IO/CAL       0.1*
************************************************************************************************************************************
*       21        *        22        *        23        *        24        *        25        *        26        *        27       *
*#DB            9 * #DB          186 * #DB          185 * #DB          185 * #DB          179 * #DB          164 * #DB           53*
*G-CALS       3.0 * G-CALS      10.3 * G-CALS      11.6 * G-CALS       9.7 * G-CALS      10.2 * G-CALS      19.3 * G-CALS       8.3*
*U-CALS       1.3 * U-CALS       1.0 * U-CALS       1.0 * U-CALS       1.1 * U-CALS       1.1 * U-CALS       1.0 * U-CALS       2.2*
*READS        0.8 * READS        5.6 * READS        5.8 * READS        6.1 * READS        6.8 * READS        7.2 * READS        1.4*
*WRITES       0.1 * WRITES       0.6 * WRITES       0.5 * WRITES       0.5 * WRITES       0.6 * WRITES       0.6 * WRITES       0.5*
*N-I/O        0.0 * N-I/O        0.0 * N-I/O        0.0 * N-I/O        0.0 * N-I/O        0.0 * N-I/O        0.0 * N-I/O        0.0*
*IO/CAL       0.2 * IO/CAL       0.5 * IO/CAL       0.5 * IO/CAL       0.6 * IO/CAL       0.6 * IO/CAL       0.3 * IO/CAL       0.1*
************************************************************************************************************************************
*       28        *        29        *        30        *        31        *                  *                  *                 *
*#DB           10 * #DB          194 *                  *                  *                  *                  *                 *
*G-CALS       1.3 * G-CALS      10.3 *                  *                  *                  *                  *                 *
*U-CALS       0.1 * U-CALS       1.0 *                  *                  *                  *                  *                 *
*READS        0.6 * READS        6.3 *                  *                  *                  *                  *                 *
*WRITES       0.0 * WRITES       0.5 *                  *                  *                  *                  *                 *
*N-I/O        0.0 * N-I/O        0.0 *                  *                  *                  *                  *                 *
*IO/CAL       0.4 * IO/CAL       0.6 *                  *                  *                  *                  *                 *
************************************************************************************************************************************

  MAX DATABASES                    AVG GETS  <12>  11.4   AVG READS   <15>    6.1                                                   
  USED W/I MONTH   <11>  194       AVG UPDS  <13>   1.1  AVG WRITES   <16>    0.6                                                   
                                 DBIO/CALLS  <14>   0.5   AVG NO IO   <17>    0.0

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*