Event recording report

The Event Recording report retrieves and displays specific rows from the DASD MANAGER PLUS database EVENTS table, which contains utility generation information. If you enable the Record Events option when generating a job, the product logs the job in the EVENTS table.

To create an event recording report

1. Access the Event Recording Request panel as follows:
   1. On the DASD MANAGER PLUS main menu, select Reports and press Enter.

   2. On the Report Selection Menu, select Event Recording Report and press Enter.The Event Recording Request panel is displayed.

       DB25 --------------------- Event Recording Request ----------------------------
       COMMAND ===>
      
       Type data and press Enter.
      
                Display Events on DB2 Objects
                  Object Type
                  Object Name
      
                Display Events by Function
                  Function Name
      
                Restrict to Action
                  Action Name
      
                Restrict by Timestamp
                                   YYYY-MM-DD-HH.MM.SS
                  Start Time
                  End   Time

2. Specify the selection criteria as follows:

   • Use any combination of the following criteria for selecting rows to include in the report:
     • Choose 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

       Fields that you leave blank return all values for those criteria.

   • To report on events by function, type the Function Name. Use any of the following utility names or names of services that you defined, but do not use wildcards:
     • ALTERSEC
     • BMCCPRS
     • BMCREORG
     • BMCSTATS
     • BMCTRIG
     • BMCUPRS
     • BMCUNLOAD
     • CHEK DA
     • CHEK LOB
     • DSN1COPY
     • FULLCOPY
     • INCRCOPY
     • LOAD
     • MERGECOPY
     • MODISTAT
     • MODIFY
     • QUIESCE
     • RECOVER
     • REORG
     • REPAIR
     • RESIZE
     • AMICOPY
     • AMIREORG
     • REP REC
     • REP SET
     • RUNSTATS
     • START DB
     • STOP
     • STOP DB
     • STOSPACE
     • SYNC
     • UNLOAD
   • To report on events for a certain action or group of actions, type the Action Name. You can use a wildcard.
   • To report on events for a certain object, specify the Object Name. Use a fully qualified name, a nonqualified name, or wildcard characters in this field.
   • To report on events for a certain type of object, specify the Object Type. The Object Type can be TS, TB, or IX.
   • To restrict the report to events that fall within a certain time frame, specify Start Time and End Time. If you leave the Start field blank, the report includes all rows from the beginning of the EVENTS table. If you leave the End field blank, the report includes all rows to the end of the EVENTS table. The format is YYYY-MM-DD-HH.MM.SS.

3. After you specify all of the search criteria, press Enter.The Event List displays the rows that match your selection criteria.

   Event List

   DEDK ------------------------------- Event List ----------- Row 1 to 34 of 822
   COMMAND ===>                                                  SCROLL ===> PAGE
                                                                     MORE DATA==>
   Z = Zoom Object and Name                                                       
                                              Obj                                 
   Act Object   Name                          Typ Function RC Action              
   -------------------------------------------------------------------------------
       QZUDA1   QZUS01A1                       TS BMCSTATS  0                     
       QZUDA1   QZUS01A1                       TS BMCSTATS  0                     
       QZUDA1   QZUS01A1                       TS BMCSTATS  0                     
       QZUDA1   QZUS01A1                       TS BMCSTATS  0                     
       QZUDA1   QZUS01A1                       TS BMCSTATS  0                     
       QZUDA1   QZUS01A1                       TS BMCSTATS  0                     
       QZUDA1   QZUS01A1                       TS BMCSTATS  0                     
       QZUDA1   QZUS01A1                       TS BMCSTATS  0                     
       QZUDA1   QZUS01A1                       TS BMCSTATS  0                     
       QZUDA1   QZUS01A1                       TS BMCSTATS  0                     
       QZUDA1   QZUS01A1                       TS BMCSTATS  0                     
       QZUDA1   QZUS01A1                       TS BMCSTATS  0

   The Event List contains the following fields:

   • Act is the action field where you can enter Z to zoom the object and name. Entering Z displays the long name in a pop-up panel.
   • Object Name is the two-part qualified name of the object: databaseName.tableSpaceName for a table space or creator.indexName for an index.
   • Function is the utility or object manipulation that the product runs.
   • RC is the return code from the utility or SQL.
   • Action is the Action that ran the job.
   • Timestamp is the DB2 timestamp value showing when the event ran.
   • Elapse Time is the elapsed CPU time in seconds.

   Note

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