Escorrentía

Review the following considerations before running the jobs to create a new encyclopedia.

The SQL and JCL for the encyclopedia build process are in the SQL and JCL libraries.

Run the build jobs defined in the table below in the exact manner and order in which they are presented. Running the jobs in a different sequence, or omitting a job, causes errors and failures.

Each job must be run on the CPU containing the unloaded and allocated Host Encyclopedia software and your DB2 subsystem.

These jobs create the z/OS Host Encyclopedia DB2 tables for AllFusion Gen. Use this table as a checklist as you run the following jobs. You must run the jobs in the order listed in the table.

JCL Name Description

CEJOB02 For storage groups, this job is not required. For data set storage type VSAM, this job deletes existing and creates new VSAM data sets for DB2 objects. Ignore return code 8; this means the data set for deletion did not exist.

CEJOB03 Executes a DB2 BIND of the dynamic SQL program TIUUSQL to AllFusion Gen DB2 subsystem.

Run Jobs to Create the Encyclopedia

JCL Name Description

CEJOB04 Creates DB2 objects for AllFusion Gen and populates the DXCPID table. Also inserts the installer ID into the user table with Encyclopedia administrator authority. Ignore SQL code of 552. This means the databases already exist, but do not affect processing.

CEJOB05

CAJOB05

Loads schema tables for 9.1.A5, 9.0.A2, and 8.0.A3, which contain static data representing the meta-model. You must have IBM DB2 utilities to execute this job. You can also use the equivalent job that uses CA Unicenter DB2 products. If you are using utilities from other vendors, customize this job accordingly.

Loads schema tables for 9.1.A5, 9.0.A2, and 8.0.A3, which contain static data representing the meta-model. Customers must have CA Unicenter DB2 products to execute this job. You can also use the equivalent job that uses IBM utilities. If you are using utilities from other vendors, customize this job accordingly.

This job returns RC=4 if DB2 Products UTIL parmlib contains SET-COPYPENDING TO (NO). RC=4 is acceptable unless the optional job CEJOB05A is to be run subsequently. In that case, you must run DB2 backup (job CAUCOPY) before running CEJOB05A.

CEJOB05A (Optional)

Relaxes migration rules by modifying values on the schema tables that provide operational rules for object migrations using version control.

CEJOB06

CAJOB06

Executes the DB2 RUNSTATS utility for the Host Encyclopedia tables and index. You must have IBM DB2 utilities to execute this job. You can also use the equivalent job that uses CA Unicenter DB2 products. If you are using utilities from other vendors, customize this job accordingly.

Executes the DB2 PDASTATS utility for the Host Encyclopedia and index. Customers must have CA Unicenter DB2 products to execute this job. You can also use the equivalent job that uses IBM utilities. If you are using utilities from other vendors, customize this job accordingly.

CEJOB07A CEJOB07B

Binds DBRMs into packages.

Binds AllFusion Gen plans to use the packages (only run once). CEJOB08 This job grants DB2 authority to PUBLIC on all AllFusion Gen

plans and DB2 SELECT authority on Public Interface Table views.

Run Jobs to Create the Encyclopedia

JCL Name Description

CEJOB10 Loads the Functions model to the new encyclopedia (required): Model name: IEF_SUPPLIED_FUNCTION in the data set

‘CAI.MVSHE.TRAN(FUNC91A5).’

CEJOB10 may return a condition code of 0 even if it fails. To verify, the Functions model has been added to the list of models, display the AllFusion Gen Main Menu, enter 1.3.5 on the command line, and press Enter. On the Model Statistics screen, move the cursor to the Model Name field and press F4 to display the list of models. Verify the Functions model appears on the list. If the model is missing, look for an error message in userid.IEF.LOGFILE. If CEJOB10 abends with U3001 ONCODE 84 when SYSPRINT is Allocated, the

userid.IEF.SYSPRINT data set is unavailable. To correct the error, navigate out of AllFusion Gen concatenation, issue a FREE DA (userid.IEF.SYSPRINT) command, delete any added models, and resubmit CEJOB10.

CEJOB11 Processes the Functions model. This job inserts the model information into the schema SMDL table and deletes the model information from the data DMDL table. The expected return code is 20.

To verify the Functions model is removed from the list of models, display the list of models by entering 1.3.5 on the command line and pressing enter. Verify

IEF_SUPPLIED_FUNCTIONS is not on the list.

CEJOB12 Loads the Sample model to the new encyclopedia (optional): Model name: GEN SAMPLE MODEL R76 in the data set: ‘CAI.MVSHE.TRAN(SAMPMODL)’

CEJOB12 may return a condition code of 0 even if it fails.

CEJOB12 may return a condition code of 0 even if it fails. To verify the model has been added to the list of models, display the AllFusion Gen Main Menu, enter 1.3.5 on the command line, and press Enter. On the Model Statistics screen, move the cursor to the Model Name field and press F4 to display the list of models. Verify the Sample model appears on

Run Jobs to Create the Encyclopedia

JCL Name Description

CEJOB13 Loads the Help model to the new encyclopedia (optional): Model name: GEN SAMPLE HELP MODEL R76 in the data set: ’CAI.MVSHE.TRAN (HELPMODL)’

CEJOB13 may return a condition code of 0 even if it fails. To verify the model has been added to the list of models, display the AllFusion Gen Main Menu, enter 1.3.5 on the command line, and press Enter. On the Model Statistics screen, move the cursor to the Model Name field and press F4 to display the list of models. Verify the Help model appears on the list. If the model is missing, look for an error message in userid.IEF.LOGFILE. If CEJOB13 abends with U3001 ONCODE 84 when SYSPRINT is Allocated, the userid.IEF.SYSPRINT data set is unavailable. To correct the error, navigate out of

AllFusion Gen concatenation, issue a FREE DA

(userid.IEF.SYSPRINT) command, delete any added models, and resubmit CEJOB13.

CEJOB06

CAJOB06

Run this job again. It executes the IBM DB2 RUNSTATS utility for the Host Encyclopedia tables and indexes.

Run this job again. It executes the DB2 PDASTATS utility for the Host Encyclopedia tables and indexes. A RUNSTATS of the AllFusion Gen data tables (after loading the models in

CEJOB10), followed by a REBIND of all AllFusion Gen plans, speeds access of the Encyclopedia.