Unload and Load
After completing the preceding task, there is load and unload JCL and SQL in the AllFusion Gen JCL and SQL libraries. To complete the unload and load procedure successfully, you must:
Check in all models before executing Step 1 of this procedure. Execute the steps of this task in the order in which they appear. Execute each step on the CPU that contains the Host Encyclopedia. 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
HEIUNLD 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 AllFusion Gen packages to take
advantage of the RUNSTATS statistics from CEJOB06. CEJOB09 Updates the DMAX table for the new schema.
This job replaces the new encyclopedia name in the DMAX table with the name of the old encyclopedia. You need to update MAX_RELEASE with the new encyclopedia’s name. To avoid cross-encyclopedia contention, find the row with ENCYNAME in the first column (MAX_MNEMONIC), update MAX_RELEASE with the new encyclopedia name.
Unload and Load
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 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, display the list of models as in Footnote b and check that 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. 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 the list. If the model is missing, look for an error message in userid.IEF.LOGFILE. If CEJOB12 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
Enable User Access
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.
Enable User Access
To enable user access, you need to add each of your users to the encyclopedia by selecting the user access control function from the Host Encyclopedia Functions Menu. Each user needs access to your site-specific ISPF/AllFusion Gen logon CLIST to establish the environment.