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.

and samples:

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:

EQQDPLNP ------------------- PRODUCING DAILY PLANS ----------------------------
Option ===>                                                                    
                                                                               
Select one of the following :                                                  
                                                                               
1 REPLAN           -  Replan current planning period                           
2 EXTEND           -  Extend the current planning period                       
3 TRIAL            -  Produce a trial plan                                     
4 PRINT CURRENT    -  Print statistics for current planning period             
          
6 ARCHIVE          -  Archive old current plans

Select option 6 (ARCHIVE) to display the following panel:

EQQXSUBP -------------- GENERATING JCL FOR A BATCH JOB ------------------------
Command ===>                                                                   
                                                                               
Enter/change data below and press ENTER to submit/edit the JCL.                
                                                                               
JCL to be generated for: Archive old current plans                             
                                                                               
SYSOUT CLASS       ===> _           (Used only if output to system printer)    
LOCAL PRINTER NAME ===> ________    (Used only if output on local printer)     
                                    (Used only if CLASS is blank)              
DATASET NAME       ===> ____________________________________________           
                                    (Used only if CLASS and LOCAL PRINTER      
                                    are both blank). If blank default name     
                                    used is TWSIDD1.TWSI.ARCCP.LIST            
                                                                               
SUBMIT/EDIT JOB    ===> E           S to submit JOB, E to edit                 
                                                                               
Job statement    :                                                             
 ===> //TWSIDP  JOB (880000),'TWSCWSB SYS',MSGCLASS=D,________________________ 
 ===> //  CLASS=D,MSGLEVEL=(1,1)______________________________________________ 
 ===> ________________________________________________________________________ 
 ===> ________________________________________________________________________

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.