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