Previous Topic: Reorganize Files and Monitor Space Usage

Next Topic: Implementing Status Monitor Filters

Setting Up the Alert Monitor › Implement the Alert History Function › Extract Alert Data for Reporting

Extract Alert Data for Reporting

You can extract alert data from the Alert History database in a character separated values (CSV) format for processing by external reporting and analysis tools. The default field separator character is comma (,). You can change it in the ALERTHIST parameter group.

To extract alert data for reporting and analysis

  1. Allocate a sequential data set with the following attributes:
  2. Enter /ALHIST.

    The History Menu appears.

  3. Type EX at the prompt, and specify the data set name that you have allocated in the Extract DSN field.

    (Optional) If you want to limit the extracted data, select an Alert Monitor filter through the Filter Name field.

    Press Enter.

    The data is extracted to the specified data set.

  4. Transfer the data set to your personal computer (PC) in ASCII format, and save it with an appropriate extension. (For example, if you plan to use Microsoft Excel to process the data, use the .csv extension.)

    The extracted data is saved in a text file.

  5. Open the text file by using your preferred PC application.

    The extracted data is presented in your preferred format for analysis.

  6. Analyze your data by applying facilities such as graphs and charts, tables, and macros.