Use of the DeskTop Reporter. Part A.

Prerequisites

1. The DeskTop Reporter is installed from the client CD.

   For details, see the installation instructions that accompany the client CD.

2. (Optional) SAS software.

   For full functionality and ease of use, installation of SAS/CONNECT software on the client host is highly recommended to make the downloading of data integrated and seamless.

   Should you want to remove, modify, or add objects in the IT Service Vision DeskTop Reporter, installation of SAS/AF software on the client host is required.

Actions

The client CD has some demonstration data that will allow a user of the DeskTop Reporter to do immediate experimentation. The DeskTop Reporter also contains a set of reports that can be run against the demonstration data.

1. View the reports.

   From the DeskTop Reporter's main menu, select Mainframe and then DB2 Reports. Choose one of the supplied reports from the list:

   • DB2 Accounting Report.

     The data are a subset of the data in the day level of the XDBACCT (DB2 accounting) table. XDBACCT stores data from the DB2 Accounting records.

     The DB2 Accounting Report is subset during the mainframe summary, and the summary code can be customized to suit the needs of your site. You can drill-down on this report from System ID to Subsystem ID, DB2 Plan Name, Date, Hour of Day, DB2 AuthID, DB2 Connection Name, and DB2 Connection Type. Metrics can be shown on the graph by clicking on the column. The metrics that are available in the report are: ASCB TCB Time, Average Accumulated Elapsed Time in DB2, Sum of the Elapsed Time in DB2 and Number of Entry/Exit Events, Sum of Wait Time due to Synchronous Execution, Average of Wait Time due to Synchronous Execution, Sum of Wait Trace Events Processed, and Average of Wait Trace Events Processed.

   • DB2 Statistics Report.

     The data are a subset of the data in the day level of the XDBSTA0 (DB2 interval statistics: subtype 0) table. XDBSTA0 stores data from the DB2 Statistics records.

     You can drill-down on the DB2 Statistics Report from System ID to Subsystem ID. The metrics that are available in the report are: Active Log Output CI Created, Calls To Write Active Log Buffer, Average of IFI Read Requests, Sum of IFI Read Requests, Log Write Requests, Log Write Request (Using Force), Number of Control Intervals and Waits.

   • DB2 Statement Analysis Report.

     The data are a subset of the data in the day level of the XDBSTA1 (DB2 interval statistics: subtype 1) table. XDBSTA1 stores data from the DB2 Statistics records.

     You can drill-down on the More DB2 Statistics Report from System ID to Subsystem ID, date, shift, and hour. The metrics that are available are the average number of DELETE, FETCH, INSERT, OPEN CURSOR, PREPARE, SELECT, and UPDATE statements.

   By default, these reports run on the demonstration data that is on the client CD. You will be able to run the supplied or customized reports on your own data by following the instructions that follow.

Use of the DeskTop Reporter. Part B.

In this task, you run the IT Service Vision client's supplied reports on data from the production PDB.

Prerequisites

1. Write access to the daily production job on the IT ServiceVision server.

Actions

1. Copy the following code, in this order, to your IT Service Vision production job directly after the invocation of the %CPREDUCE macro.
   
   
   1. Here is the LIBNAME statement to allocate a the SAS data library for the summarized SAS data sets:

         LIBNAME DOWNLOAD 'your.download';

   2. Here are examples (from member CMEISDWN in the CPMISC PDS) of the %CPEISSUM macro code that generates summarized SAS data sets in the library that has a libref of DOWNLOAD:

         %CPEISSUM(XDBACCT,
                   n_detail=0,
                   n_days=1,
                   n_weeks=0,
                   n_months=0,
                   n_years=0,
                   outlib=work);
      
         %CPEISSUM(XDBSTA0 XDBSTA1,
                   n_detail=0,
                   n_days=2,
                   n_weeks=0,
                   n_months=0,
                   n_years=0,
                   outlib=work);

      Feel free to customize them to your needs.

      Member CMEISDWN of the CPMISC PDS describes the usage of the %CPEISSUM macro. The syntax of this macro is:

         %CPEISSUM(tablist,                                  #1
                   n_detail=,                                #2
                   n_days=,                                  #3
                   n_weeks=,                                 #4
                   n_months=,                                #5
                   n_years=,                                 #6
                   outlib=libref,                            #7
                   sourcat= );                               #8

      where the parameters are:

      1. List of tables from your production PDB.
      2. The number of days of data to be downloaded from the detail level.
      3. The number of days of data to be downloaded from the day level.
      4. The number of weeks of data to be downloaded from the week level.
      5. The number of months of data to be downloaded from the month level.
      6. The number of years of data to be downloaded from the year level.
      7. A temporary location for the data. (You can specify the temporary SAS data library WORK here.)
      8. The location of your summary code. The default location is PGMLIB.CPSAMP, which contains supplied code that you can use as-is (or copy elsewhere, modify, and use by pointing to it here).

      By running this, a member named PGMLIB.CPSAMP.tablenm.SOURCE is included and run to summarize the data and load the data into DOWNLOAD.

Use of the DeskTop Reporter. Part C.

1. Download the summarized data to the client host.

   After macro %CPEISSUM runs, a user on the IT Service Vision client can download the SAS library containing a subset of PDB data to the PC by using the SAS/CONNECT software and the Download Data button from the IT Service Vision for MVS DeskTop Reporter menu.