CEJOB02

Not required for storage groups.

For data set storage type VSAM, this job removes existing VSAM data sets for DB2 objects and creates new ones.

CEJOB03

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

If your site has Host Construction and the target for generated applications is on a different DB2 subsystem than the Host Encyclopedia, bind TIUUSQL for both subsystems and grant DB2 EXECUTE authority to PUBLIC for plans on the target's subsystem.

CEJOB04

Creates DB2 objects for CA Gen and populates the DXCPID table and inserts the installer ID into the user table with encyclopedia administrator authority. Ignore SQL code of 552 because it means the databases already exist, but does not affect processing.

CEJOB05

Loads schema tables for the Current Schema, Prior Schema, and Second Prior Schema. The schemas 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. When using utilities from other vendors, customize this job accordingly.

Note: For the schema designation for Current Schema, Prior Schema, and Second Prior Schema, see the Release Notes.

CAJOB05

Loads schema tables for the Current Schema, Prior Schema, and Second Prior Schema. The schemas 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. When 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 CEJOB05A job runs subsequently. To run CEJOB05A subsequently, you must run DB2 backup, job CAUCOPY or CEACOPY, 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

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. When using utilities from other vendors, customize this job accordingly.

CAJOB06

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. When using utilities from other vendors, customize this job accordingly.

CEJOB07A

Binds Host Encyclopedia DBRMs into packages.

CEJOB07B

Binds CA Gen Host Encyclopedia plans to use packages. Only run this job once.

CEJOB08

Grants DB2 authority to PUBLIC on all CA Gen plans and DB2 SELECT authority on Public Interface Table views.

CEJOB09

Updates the DMAX tables for the CA Gen schema.

CEJOB10

Required to load the functions model to the new encyclopedia:

Model name: IEF_SUPPLIED_FUNCTIONS in the 'CAI.CAGEN.CEHBDATV(FUNCMODL)' data set.

CEJOB10 may return a condition code of 0 even if it fails. For additional information, see the userid.IEF.LOGFILE for an error message.

To verify, the functions model was added to the list of models, follow these steps:

Display the CA Gen Main Menu.

On the command line, type: 1.3.5

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 CEJOB10 abends with U3001 ONCODE 84 when SYSPRINT is Allocated, the userid.IEF.SYSPRINT data set is unavailable.

To correct the error, follow these steps:

Navigate out of CA Gen concatenation.

Issue this command: FREE DA (userid.IEF.SYSPRINT).

Delete added model functions.

Resubmit CEJOB10.

CEJOB11

Processes the functions model, 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 press enter. Verify IEF_SUPPLIED_FUNCTIONS is not on the list.

CEJOB12

Loads the sample model to the new encyclopedia and is optional.

Model name: GEN SAMPLE MODEL 8 5 in the CAI.CAGEN.CEHBDATV(SAMPMODL) data set

CEJOB12 may return a condition code of 0 even if it fails. For additional information, see the userid.IEF.LOGFILE for an error message.

To verify the model was added to the list of models, follow these steps:

Display the CA Gen Main Menu

On the command line, type 1.3.5

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 the list.

If CEJOB12 abends with U3001 ONCODE 84 when SYSPRINT is Allocated, the userid.IEF.SYSPRINT data set is unavailable.

To correct the error, follow these steps:

Navigate out of CA Gen concatenation.

Issue this command: FREE DA (userid.IEF.SYSPRINT).

Delete the sample model.

Resubmit CEJOB12.

CEJOB13

Loads the help model to the new encyclopedia and is optional.

Model name: GEN SAMPLE HELP MODEL 8 5 in the CAI.CAGEN.CEHBDATV (HELPMODL) data set.

CEJOB13 may return a condition code of 0 even if it fails. For additional information, see the userid.IEF.LOGFILE for an error message.

To verify the model was added to the list of models, follow these steps:

Display the CA Gen Main Menu

On the command line, type: 1.3.5

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 CEJOB13 abends with U3001 ONCODE 84 when SYSPRINT is Allocated, the userid.IEF.SYSPRINT data set is unavailable. To correct the error, follow these steps:

Navigate out of CA Gen concatenation

Issue this command: FREE DA (userid.IEF.SYSPRINT)

Delete the help model.

Resubmit CEJOB13.

CEJOB06

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

CAJOB06

Run this job again. It executes the DB2 PDASTATS utility for the Host Encyclopedia tables and indexes. A RUNSTATS of the CA Gen data tables, after loading the models in CEJOB10, followed by a REBIND of all CA Gen plans, speeds encyclopedia access.

CEJOB07A

Executes bind replace on all packages.