Run Upgrade Jobs

Starting Your Product › How to Configure Without CA CSM › Configuring Host Encyclopedia and Host Construction › Upgrade an Host Encyclopedia › Run Upgrade Jobs

Run Upgrade Jobs

These upgrade jobs amend the z/OS Host Encyclopedia DB2 tables to work with the CA Gen software.

The jobs BLDRPROF, CEJOB14R and CEJOB15R relate to Host Construction and CA Gen runtime environments when DB2 is the target database. They must be run on each DB2 subsystem used for applications generated by CA Gen.

You must have IBM DB2 utilities or CA DB2 utilities or equivalent utilities from other vendors to execute the following jobs. If you are using utilities from other vendors, customize these jobs accordingly.

CEJOB05
CAJOB05
CEJOB06
CAJOB06
CEUREOR
CAUREOR
CEUCOPY
CAUCOPY

Use this table as a checklist as you run the following jobs. n/a is used if the job does not apply.

JCL Name	Description	6.5 to 8.5	7/7.5 to 8.5	7.6 to 8.5	8 to 8.5
CEJOB03	Executes a DB2 BIND of the dynamic SQL program TIUUSQL to CA Gen DB2 subsystem. Bind this plan and grant DB2 EXECUTE authority to PUBLIC for each DB2 subsystem that is a target for CA Gen generated applications. Only bind TIUUSQL to other DB2 subsystems if using TIUUSQL to install DDL or to bind applications onto the subsystems.	√	√	√	√
CVJOB04A	Upgrades Host Encyclopedia from 7 to 8.5, and 7.5 to 8.5.	n/a	√	n/a	n/a
CVJOB04B	Upgrades Host Encyclopedia from 7.6 to 8.5.	n/a	n/a	√	n/a
CVJOB04C	Upgrades Host Encyclopedia from 6.5 to 8.5.	√	n/a	n/a	n/a
CEJOB05 CAJOB05	Reloads schema tables with releases, 9.0.A2, 9.1.A5, and 9.2.A6, using the IBM DB2 LOAD utility. Reloads schema tables with releases 9.0.A2, 9.1.A5, and 9.2.A6. It uses CA's Fast Load utility.	√ √	√ √	√ √	√ √
CEJOB05A	Relaxes migration rules.	optional	optional	optional	optional
CEUREOR CAUEROR	Executes the DB2 REORG utility using the IBM REORG utility. It includes Data, Schema, and Public Interface databases. Executes the CA DB2 RAPID REORG utility.	√ √	√ √	√ √	√ √
CEUCOPY CAUCOPY	Executes the IBM DB2 COPY utility to create a full image copy of all tablespaces. Executes the DB2 QUICK COPY utility to create a full image copy of all tablespaces.	√ √	√ √	√ √	√ √
CEJOB06 CAJOB06	Executes the DB2 RUNSTATS utility for the Host Encyclopedia schema tables. Executes the CA PDASTATS utility.	√ √	√ √	√ √	√ √
CEJOB07A	Binds Host Encyclopedia DBRMs into packages.	√	√	√	√
CEJOB07B	Binds CA Gen Host Encyclopedia plans.	√	√	√	√
CEJOB08	This job grants to PUBLIC, DB2 authority on all CA Gen plans, and DB2 SELECT authority on Public Interface Table views. An SQLCODE of +562 indicates privileges have been granted.	√	√	√	√
CEJOB09	Updates the DMAX tables for the CA Gen schema.	√	√	√	√
CEJOB10	Loads Schema Functions Model to Host Encyclopedia.	√	√	√	√
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. Verify that IEF_SUPPLIED_FUNCTIONS is not on the list.	√	√	√	√
CEJOB12	Loads Sample Model to Host Encyclopedia.	optional	optional	optional	optional
CEJOB13	Loads Help Model to Host Encyclopedia.	optional	optional	optional	optional
CEJOB14R	Binds CA Gen runtime DBRM TIROLBCM into a DB2 package.	√	√	√	√
BLDRPROF	Builds RPROF tables and indexes. It is not required to run this job if the applications built with the new release of CA Gen will use an existing RPROF table.	optional	optional	optional	optional
CEJOB15R	Binds CA Gen runtime DBRM TIRPROFD into a DB2 package.	√	√	√	√