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:
   • LRECL is greater than or equal to 300 bytes.
   • RECFM is VB.
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.