Previous Topic: Build JCL and SQLNext Topic: Enable User Access


Unload and Load

After building JCL and SQL, there is load and unload JCL and SQL in the CA Gen JCL and SQL libraries. To successfully complete the unload and load procedure, you must perform the following steps:

Perform the following jobs to complete the unloading and loading of the data tables. Use this table as a checklist as you run the jobs.

JCL Name

Description

HE1UNLD

Unloads a copy of the existing encyclopedia data tables.

HE2LOAD

Loads the existing encyclopedia data tables into the new Host Encyclopedia.

CEUREOR

Executes the DB2 REORG utility. If this job fails, there is no restore; you must reload all data tables by re-running HE2LOAD.

CEUCOPY

Executes the DB2 COPY utility and creates a full image copy of all tablespaces. This is required to activate new tables because HE2LOAD runs with LOG NO.

CEJOB06

Executes the DB2 RUNSTATS utility for the encyclopedia tables.

CEJOB07A

Executes a DB2 BIND of the CA Gen packages to take advantage of the RUNSTATS statistics from CEJOB06.

CEJOB09

Updates the DMAX table for the new schema.

This job updates the DMAX table MAX_RELEASE with the new encyclopedia name, the name entered for Encyclopedia Name in the Set Encyclopedia Variables screen.

To avoid cross-encyclopedia contention, ensure this name is unique across all encyclopedias.

CEJOB10

Loads the required functions model to the new encyclopedia.
Model name: IEF_SUPPLIED_FUNCTIONS in the data set 'CAI.CAGEN.CEHBDATV(FUNCMODL).'

CEJOB10 may return a condition code of 0 even if it fails. For more information, look for an error message in userid.IEF.LOGFILE.

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 models.

Resubmit CEJOB10.

CEJOB11

Processes the function 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 that the functions model is removed from the list of models, follow these steps:

Display the CA Gen Main Menu.

On the command line, type:1.3.5

Press Enter.

Verify IEF_SUPPLIED_FUNCTIONS is not on the list.

CEJOB12

Loads the optional Sample model to the new encyclopedia. Model name: GEN SAMPLE MODEL 8 5 in the data set: 'CAI.CAGEN.CEHBDATV(SAMPMODL)'

CEJOB12 may return a condition code of 0 even if it fails. For more information, look for an error message in userid.IEF.LOGFILE.

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 added models

Resubmit CEJOB12.

CEJOB13

 

Loads the optional help model to the new encyclopedia. Model name: GEN SAMPLE HELP MODEL 8 5 in the data set: 'CAI.CAGEN.CEHBDATV (HELPMODL)'

CEJOB13 may return a condition code of 0 even if it fails. For more information, look for an error message in userid.IEF.LOGFILE.

To verify the model has been 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 the command: FREE DA (userid.IEF.SYSPRINT)

Delete added models

Resubmit CEJOB13.