Statistics exception report

Use this procedure to create a report (the Exception Report) that lists the exception conditions that the BMCTRIG utility finds.

The BMCTRIG utility records the exceptions that it finds in the DASD MANAGER PLUS EXCEPTIONS2 table. You can produce exception reports by using the DASD MANAGER PLUS report function. This function lets you specify a variety of selection criteria for creating the reports.

Related topics

Using

Standard-reports

You can perform any of the following actions:

  • Choose specific objects or use a wildcard pattern to report on a group of related objects
  • Specify a utility function
  • Select only certain actions (with or without a wildcard)
  • Restrict the search to a specific date and time

The BMCTRIG utility also produces a batch report when the utility encounters exception conditions. See Setting-up-a-BMCTRIG-job.

To create a statistics exception report

  1. Access the Statistics Exception Selection panel as follows:
    1. On the DASD MANAGER PLUS main menu, select Reports and press Enter.

    2. On the Report Selection menu, select Statistics Exceptions Report and press Enter.

      Statistics Exception Selection panel

      DEMO ----------------- Statistics Exception Selection --------------
      COMMAND ===>                                                                  
                                                                                  
      Type data and press Enter.                                                     
                                                                                    
                                                                                    
       Object Type  . . . . .     (TB,TS,IX)                                         
       Object Name  . . . . .                                                        
                                                                                    
                                            YYYY-MM-DD-HH.MM                         
       Exception Date . . . . >  (> or =)                                            
                                                                                    
       Select Exception type? N   (Y/N to see exception types and select one)
  2. On this panel, specify the selection criteria to use when choosing rows from the EXCEPTIONS2 table for the report as follows:
    1. In the Object Type field, type TS (table space), TB (table), or IX (index) to indicate the type of object for which you want to display statistics exceptions.
    2. In the Object Name field, type the object name to display exception data for a particular object. The object name can be fully qualified, nonqualified, or a wildcard pattern.
    3. In the Exception Date field, type a greater than or equal to character followed by the starting date to display exception data beginning at that date.The exception date format is YYYY-MM-DD-HH.MM where YYYY indicates a four-digit year, MM a two-digit month, DD a two-digit day, HH a two-digit hour, and MM a two-digit minute.
    4. In the Select Exception type field, type Y to display statistics for a single type of exception.

    5. Press Enter.One of the following events happens:

      • If you have specified Select Exception type = Y, the Statistics Exceptions Type Selection panel appears (Figure 2) and you can select an exception type.

        Statistics Exception Type Selection panel

         DEMO -------------- Statistics Exception Type Selection -----------------------
         COMMAND ===>                                                                   
                                                                                       
         Type the number of the exception you wish to select and press Enter.           
                                                                                       
           0    1. Card        18. Pctclust    35. Loadstat    52. NoRTSCpy             
                2. Copy        19. Reorgpend   36. Reorcopy    53. Ixdirty              
                3. Copyage     20. Reorgspace  37. Reormods    54. Aysyrat              
                4. Copypend    21. Rows/Key    38. Unclust     55. Gipcdec              
                5. Dirty       22. Space       39. Reormdel    56. Perfdeg              
                6. Dirtyic     23. Totalind    40. Reorstat    57. Sypcinc              
                7. Extents     24. Totaloff    41. Statmods    58. Reordspc             
                8. Farind      25. Bstatage    42. Statmdel    59. Reordels             
                9. Faroff      26. Cstatage    43. Copymods    60. Reorins              
               10. Leafdist    27. Pctdrop     44. Rebdcopy    61. Reorleaf             
               11. Levelinc    28. Ficage      45. Rebdstat    62. Achkpend             
               12. Levelmin    39. Pseudodl    46. Appndins    63. Chkpend              
               13. Levels      30. Ixicage     47. Arerpend    64. Icpypend             
               14. Nostats     31. Leaftoff    48. Reorglob    65. Rbdpend              
               15. Nonuniform  32. LeafFoff    40. Loborgr                              
               16. Pacthi      33. Areopend    50. Lobfrspc                             
               17. Pactlo      34. Loadcopy    51. NoRTStat

      • If you have specified Select Exception type = N, DASD MANAGER PLUS displays an Exceptions Selection panel that shows all exceptions found for the specified objects (above figure, Statistics Exception Type Selection panel).

        Exceptions Selection panel

        DEMO ----------------- Exceptions Selection -------- Row 1 to 14 of 21,878
        COMMAND ===>                                              SCROLL ===> PAGE

        Please type an option and press Enter.

        S = Display exception.    D = Delete exception.    Z = Zoom Object Name.
                                                                     MORE DATA ==>
                                                                              Current
        Act Owner/DB Object Name                 Type Part Exception          Value
        ----------------------------------------------------------------------------
            CCB      XCPPART                     IX      1 EXTENTS                1
            CCB      XCPPART                     IX      1 EXTENTS                1
            CCB      XCPPART                     IX      1 EXTENTS                1
            CCB      XCPPART                     IX      1 EXTENTS                1
            CCB      XCPPART                     IX      1 EXTENTS                1
            CCB      XCPPART                     IX      1 EXTENTS                1

      The Exception Selection panel contains the following fields:

      • Act indicates whether to:
        • Select (S) the panel entry to display the Exceptions report
        • Delete (D) the entry
        • Zoom (Z) the entry to see the entire object name
      • Owner/DB is the owner (creator) of the index, table, or table space.
      • Object Name is the Db2 object name.
      • Type is the Db2 object type: TS (table space), IX (index), or TB (table).
      • Part is the number of the table space partition or index space partition.
      • Exception is the type of exception identified by BMCTRIG.
      • Current Value is the value with the latest timestamp in the DASD MANAGER PLUS tables.
      • Last Update is the latest timestamp for the current value in the DASD MANAGER PLUS tables.
      • Active indicates whether the exception is active.

  3. To display the exception details for an item in the list, type S next to the item in the Act field.

    Exceptions report for a single exception type

    DEMO -------------------------- Exceptions ----------------- Row 1 to 10 of 10
    COMMAND ===>                                                  SCROLL ===> PAGE

    Object Name  : CALDB.CALTS002                     Timestamp : yyyy-mm-dd-09.30
      Type . . . : TS

    Action Taken : A447617S GENERATED
      Utility JCL: 'RDACAL2.PDS(A447617Z)'

                      Current  Compare  Trigger
    Part Exception     Value    Value    Value
    ------------------------------------------------------------------------------
       1 COPYAGE         67        0        0
       2 COPYAGE         67        0        0
       3 COPYAGE         67        0        0
       4 COPYAGE         67        0        0
       5 COPYAGE         67        0        0
       6 COPYAGE         67        0        0
       7 COPYAGE         67        0        0

    The Exception report contains the following fields:

    • Object Name is the fully qualified object name.
    • Type is the Db2 object type: TS (table space), IX (index), or TB (table).
    • Action Taken is the action that the product generated or submitted when the exception occurred.
    • Utility JCL is the name of the data set that contains the generated JCL.
    • Part is the number of the table space partition or index space partition.
    • Exception is the type of exception. Exceptions correspond to BMCTRIG triggers.
    • Current Value is the value having the latest timestamp in the DASD MANAGER PLUS tables.

    • Compare Value is the value that the product is comparing to the current value or the portion of the formula for computing the compare value.

      Important

      The Compare Value is applicable only if a trigger required a previous value for its computation. For example, a trigger that identifies a percentage increase requires a previous value from which to calculate the change.

    • Trigger Value is the value set as a trigger by the user to indicate that an exception has occurred in the Db2 database.

    The following figure shows the Exceptions Selection panel that appears when you specify Select Exception Type N on the initial Statistics Exception Selection panel.

    Exceptions Selection panel

    DEMO --------------------- Exceptions Selection ------- Row 1 to 14 of 114,090
    COMMAND ===>                                                  SCROLL ===> PAGE

    Please type an option and press Enter.
    S = Display exception.    D = Delete exception.    Z = Zoom Object Name.
                                                                     MORE DATA ==>
                                                                 Current
    Act Owner/DB Object Name        Type Part Exception          Value
    ------------------------------------------------------------------------------
        QZUDA1   QZUS01A1           TS      0 DSEXTENT               1
        QZUDA1   QZUS01A1           TS      0 EXTENTS                1
        QZUDA1   QZUS01A1           TS      0 FARIND                 0
        QZUDA1   QZUS01A1           TS      0 PACTHI                94
        QZUDA1   QZUS01A1           TS      0 REORSPAC              90
        QZUDA1   QZUS01A1           TS      0 SPACE                 90
        QZUDA1   QZUS01A1           TS      0 TOTALIND               0
        QZUDA1   QZUS02A1           TS      0 DSEXTENT               1
        QZUDA1   QZUS02A1           TS      0 EXTENTS                1

    For a description of the fields on this panel, see the above figure, Exceptions Selection panel. By selecting an entry on this Exceptions Selection panel, you display an Exceptions report that shows the current values, compare values, and threshold values for all exceptions found for the specified object .

    Exceptions report for all exception types found for object

    DEMO -------------------------- Exceptions ----------------- Row 1 to 10 of 20
    COMMAND ===>                                                  SCROLL ===> PAGE

    Object Name  : CALDB.CALTS002                     Timestamp : yyyy-mm-dd-13.09
      Type . . . : TS

    Action Taken : V276788S GENERATED
      Utility JCL: 'RDACAL2.PDS(V27678PO)'

                     Current   Compare    Trigger
    Part Exception    Value     Value      Value
    ------------------------------------------------------------------------------
       1 REORSPAC         1         1          0
       1 SPACE            1         1          0
       2 REORSPAC         1         1          0
       2 SPACE            1         1          0
       3 REORSPAC         1         1          0
       3 SPACE            1         1          0
       4 REORSPAC         1         1          0

    For a description of the fields on this panel, see the above figure, Exceptions report for a single exception type.

    Important

    In this report, the ISPF RIGHT and LEFT commands are unavailable for scrolling right or left, respectively, To scroll right or left, enter GORIGHT or GOLEFT or use the standard function keys.




 

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