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. 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. |
|
Copyright © 2015 CA Technologies.
All rights reserved.
|
|