Setting up the environment
About this task
To use the archiving capabilities of the host system
and to be able to archive and run historical reports, set up the environment
on the controller by performing the following steps:
- Run EQQJOBS to create or modify the following skeletons:
- EQQDBARS
- Historical data archiver.
- EQQDPEXS
- Daily plan extend skeleton.
- EQQDPRCS
- Daily plan replan skeleton.
- EQQPCS08
- To set up the working directory.
- EQQPCS09
- To allocate VSAM and GDG files.
- EQQDBOPT
- To set DBOPT parameters.
- EQQDBENC
- To encrypt the password specified in the DBOPT statement.
- EQQSERP
- To set server parameters.
- EQQCONP
- To set batch options, if controller and tracker run in the same address space.
- EQQCONOP
- To set batch options, if controller and tracker run in separate address spaces.
- Run EQQPCS09 to allocate a VSAM data set and a Generation Data
Group (GDG) root, used by the archiving process, with the following
characteristics:
- NOEMPTY
- Specifies that only the oldest GDG generation is to be deleted and uncataloged when the generation number reaches the maximum limit.
- SCRATCH
- Specifies that all the control information, related to a GDG generation, is to be deleted when the system deletes that generation.
- LIMIT(255)
- Specify how many versions will be kept in the generation data group.
- Run EQQPCS08 to customize the working directory.
For details about steps 1-3, see Planning and Installation.
- Customize the parameter library as follows. For details about
the BATCHOPT, DBOPT, SERVOPTS, and AUTHDEF statements, see Customization and Tuning.
- In the BATCHOPT initialization statement, set the JRUNHISTORY parameter to YES.
- In the parameter library, add a member that contains only the DBOPT statement, specifying the parameters to connect to the database and manage the historical data archiving process.
- In the SERVOPTS statement, set the DBOPTPRM parameter to the name of the member containing the DBOPT statement.
- Optionally, in the AUTHDEF statement set SUBRESOURCES (RP.REPTYPE) to include the RP.REPTYPE subresource. For details, refer to section Setting up RACF authorization.
- Encrypt the password to access the database. For details, refer to section Encrypting the password in DBOPT statement.
- Set up the relational database. For details, refer to section Setting up the database in the distributed environment or Creating the database in the z/OS environment.
- Set up the RACF® definitions. For details, refer to section Setting up RACF authorization.
- Make sure you installed the REXX Compiler and you defined the TSO Compiler Programming Table, IRXCMPTM.
To populate the relational database with historical data,
perform the following steps:
- Run a daily planning EXTEND or REPLAN. During this step, the old current plan is copied into a Generation Data Grouping (GDG) entry data set by using a REPRO command. The GDG data set is identified in the daily planning EXTEND or REPLAN batch job by the EQQOCPBK ddname.
- Periodically, archive the old current plans. Select option 3 (DAILY PLANNING) from the main menu. The following panel is displayed:
- Select option 6 (ARCHIVE) to display the following panel:
- Press Enter to generate a JCL that, for each GDG entry related
to the root you specified, will start a program that:
- Converts the sequential GDG data set to the predefined VSAM using REPRO.
- Reads the records from the VSAM and archives the historical data in the database.
- Deletes the processed GDG, if the process is successful.
Note: You obtain a JCL tailored according to the EQQDBARS skeleton JCL, generated by the EQQJOBS dialog. Before submitting the JCL, specify at least 128 MB as region value.