Exporting the data into the DB2 database

When you have loaded the data into the historical database you can export it into the DB2® database.

Procedure

  1. Open the CICS® PA ISPF interface if it is not already open.
  2. Select 5 Historical Database from the Primary Option Menu screen.
  3. Select 5 Export.
  4. Select the historical database STATSHDB that you have built.
  5. Type s next to the name of the container within the historical database to select it.
  6. Select the reports to be exported to DB2.
  7. Select 2 Load. The assumption here is that option 1 has been used previously and the DB2 table has been created.
  8. Press Enter to build the DB2 load JCL.
  9. Submit the job. The statistics alert data is loaded into the DB2 database.

Results

You have now finished configuring the alerts and loading the data onto the DB2 database. You can now analyze the statistics alerts using the CICS PA plug-in to the CICS Explorer®.


pa_exporting_data_into_db.html | Timestamp icon Last updated: Sunday, 4 June 2017