Perform a Parallel Upgrade

This scenario describes how a database administrator (DBA) performs a successful parallel upgrade. The Parallel Upgrade process builds an independent ddb 15.0 Multi-User Facility (MUF) into which candidate ddb 14.0 MUF resources are loaded and upgraded. The candidate 14.0 MUF environment resources that are involved in the Parallel Upgrade process are the CXX, ddd (DD), and Data Definition Directory (DDD) databases.
datacom151
This scenario describes how a database administrator (DBA) performs a successful parallel upgrade. The Parallel Upgrade process builds an independent
CA Datacom®/DB
15.0 Multi-User Facility (MUF) into which candidate
CA Datacom®/DB
14.0 MUF resources are loaded and upgraded. The candidate 14.0 MUF environment resources that are involved in the Parallel Upgrade process are the CXX,
CA Datacom® Datadictionary™
(DD), and Data Definition Directory (DDD) databases.
On this page:
Overview
The Parallel Upgrade process provides a means where you can upgrade a MUF instance to the next release level without interrupting application processing until the upgraded system resources are ready to be implemented back into their original environment. This process involves editing and running three new 15.0 installation JCL members in addition to the traditional BDUPG
sfx
JCL members used to perform an upgrade while the candidate 14.0 MUF is out of service. This is accomplished by:
  • Creating stable backups of candidate 14.0 MUF system resources
  • Loading those resources into a standalone Parallel Upgrade MUF environment
  • Editing and executing upgrade JCL members in the Parallel Upgrade MUF environment
  • Creating 15.0 DBUTLTY backups of those now upgraded system resources
After the upgrade process completes successfully, the Parallel Upgrade environment system resource backups can be returned to their original environment at any time.
The only requirements for using the Parallel Upgrade process are:
  • The 14.0 candidate MUF CXX, DD, and DDD resources are stable DBUTLTY backups (closed when the backup is done).
  • The upgraded resources are returned to their original environment, not a different environment.
  • No structural changes are done to the DD and DDD content from the time the backups were taken until they are returned to the environment.
In a non-SQL
CA Datacom®/DB
environment this means:
  • No user database definition structure or attribute value changes
  • No new
    CA Dataquery
    users added or data access privileges changed
  • No CA IDEAL application changes
  • No CA MetaCOBOL+ application changes
In an SQL
CA Datacom®/DB
environment, all of the above plus:
  • No changes to application programs having imbedded SQL statements
  • No manual static SQL plan rebinds
  • No CREATE or ALTER functions performed
The Parallel Upgrade procedure is accomplished in two phases.
  • Parallel Upgrade phase
    - Builds an independent
    CA Datacom®/DB
    15.0 Multi-User Facility (MUF) where candidate
    CA Datacom®/DB
    14.0 MUF resources are loaded and upgraded to Version 15.0.
  • Implementation phase
    - Takes the resources upgraded by the Parallel Upgrade process and returns them to the original candidate MUF environment.
    This process is documented in a separate scenario. For more information, see the scenario about "How to Implement Parallel Upgrade Resources."
Review Prerequisites
Before you perform a parallel upgrade from Version 14.0 to 15.0, complete the following prerequisites:
  • Verify that you have a version of z/OS as supported by IBM.
  • Have experience with the
    CA Datacom®/DB
    installation and upgrade process.
  • Make sure that you understand how the
    CA Datacom®/DB
    MUF startup options are used.
  • Verify that the following
    CA Datacom®/DB
    system DBIDs (database IDs) defaults are being used:
    • CA Datacom® Datadictionary™
      (DD) as 002
    • Data Definition Directory (DDD) as 015
    • Dynamic System Tables (DST) as 1000
Performing a Parallel Upgrade
As a DBA in your mainframe environment, you can install, maintain, deploy, configure, and customize features for the database product. To complete the installation of your Parallel Upgrade MUF environment:
  1. Modify JCL member BDCUS00 in the Version 15.0 CAI.SHLQ.CABDSAMP dataset.
  2. Submit it.
A CAI.HLQ.INSTJCL dataset is created containing the JCL members that are required to create the Parallel Upgrade MUF environment.
Benefits
  • The primary benefit is that the candidate 14.0 MUF remains fully operational and available while its CXX, DD, and DDD are upgraded to Version 15.0.
  • The Version 15.0 $DCBDEDT upgrade JCL member only needs to be modified once instead of having to edit it for each MUF environment that needs to be upgraded. This saves upgrade preparation time and reduces or eliminates the possibility of encountering JCL errors during the upgrade process.
  • If any problems are encountered when running the upgrade JCL members, they can be addressed during normal business hours without the constraint or pressure of the environment being out of service as with the traditional upgrade method.
  • The required downtime to get from Version 14.0 to Version 15.0 is reduced from an hour or more to just a few minutes.
The following graphic shows the workflow that is associated with creating and utilizing the
CA Datacom®/DB
Parallel Upgrade process.
Perform a Parallel Upgrade_3
Review Recommended Method for Modifying JCL Members
To update the variables in all installation JCL members, use the CAI.THLQ.CABDSAMP member $DCBDEDT. This method is preferable to editing each member manually.
The $DCBDEDT member contains the macro ISREDIT. Updating and saving the $DCBDEDT member in your SYSPROC or TSO CLIST dataset allows all the variables in each Parallel Upgrade JCL member to be modified to site standards before submission.
After you modify the $DCBDEDT member, save it to your SYSPROC or TSO CLIST dataset using any name that you want. No additional changes are necessary to the saved member since all upgrades are done in this single parallel upgrade MUF environment.
In the following steps, UPG15 is used as the name of the modified and saved $DCBDEDT macro. When you enter the UPG15 command, the edit macro is activated to allow custom tailoring of each JCL member before submission.
Example
The following three ISREDIT macro entry examples contain a "from" character string followed by a "to" character string. Change the “to” character string to a value that matches your sites standards.
/* WKSHT #2 */ ISREDIT C ALL "CAI.SHLQ" "CAI.SHLQ" /* WKSHT #3 */ ISREDIT C ALL "CAI.THLQ" "CAI.THLQ" /* WKSHT #4 */ ISREDIT C ALL "CAI.CHLQ" "CAI.CHLQ"
Create the CAI.HLQ.INSTJCL and CAI.HLQ.PAR.INSTJCL Installation JCL Libraries
This task performs one-time Parallel Upgrade MUF setup steps. It is the beginning point for the Version 14.0 to Version 15.0 Parallel upgrade process. Perform this task only once since the group of datasets and their contents are unique to the parallel upgrade MUF. Modify and Execute CAI.HLQ.PAR.INSTJCL Upgrade JCL Members is the starting point. When edited and executed, the CAI.THLQ.CABDSAMP dataset member BDCUS00 creates and populates the following:
  • CAI.HLQ.INSTJCL dataset
  • CAI.CHLQ.CUSLIB dataset
  • CAI.CHLQ.CUSMAC dataset
  • CAI.CHLQ.CUSPROC dataset
Follow these steps:
  1. Locate CAI.THLQ.CABDSAMP dataset member BDCUS00. This member allocates the CAI.HLQ.INSTJCL dataset. It also copies the
    CA Datacom®
    Version 15.0 upgrade JCL members from the CAI.THLQ.CABDSAMP library into the CAI.HLQ.INSTJCL dataset.
    Type
    UPG15
    in the command line and press Enter. The ISREDIT macro is invoked, and all the member variables are changed to your site standards.
    Submit the member for execution and then cancel out of it. The changes should not be saved because the members in the CAI.SHLQ.CABDSAMP dataset are under SMP/E control.
  2. Locate CAI.HLQ.INSTJCL dataset member BDUPG01P. This member populates the Parallel Upgrade MUF CAI.CHLQ.CUSPROC dataset.
    Type
    UPG15
    in the command line and press Enter. The ISREDIT macro is invoked, and all the member variables are changed to your site standards.
    Submit the member for execution and then cancel out of it. The changes should not be saved because the members in the CAI.SHLQ.CABDSAMP dataset are under SMP/E control
  3. Locate CAI.HLQ.INSTJCL member BDCUSPAR. This member allocates and populates the CAI.HLQ.PAR.INSTJCL JCL library dataset.
    Type
    UPG15
    in the command line and press Enter. The ISREDIT macro is invoked, and all the member variables are changed to your site standards.
    Submit the member for execution and then cancel out of it so the changes are not saved. Re-editing and rerunning members is easier if an error was made when the ISREDIT macro was modified and saved to your SYSPROC or TSO CLIST dataset.
Modify and Execute CAI.HLQ.PAR.INSTJCL Upgrade JCL Members
This is the starting point for each candidate MUF upgrade process. The following CAI.HLQ.PAR.INSTJCL members use the Parallel Upgrade MUF environment to convert a Version 14.0 MUF system resources to a Version 15.0 format. At the end of the process, 15.0 backups are created for implementation back into the environment from which they originally came.
  • $DCBDEDT - ISREDIT macro
  • @BDWKSHT - Upgrade JCL variable definitions
  • BDCICS - Create version 15.0 DDOL CICS CSD members
  • ADSDC14 - 14.0
    CA Datacom® Datadictionary™
    comparator utility
  • ADSDC15 - 15.0
    CA Datacom® Datadictionary™
    comparator utility
  • APFADD - Sample batch CA SYSVIEW APF authorization JCL
  • BDCUSUPG - 15.0 MUF custom macro assembly and link edit
  • BDUPG02 - 14.0 Upgrade MUF startup JCL
  • BDUPG03 - 14.0 DBUTLTY CXX, DD, and DDD backup JCL
  • BDUPG04 - 14.0 Upgrade MUF shutdown JCL
  • BDUPG05 - 15.0 Upgrade MUF startup JCL
  • BDUPG06 - 14.0 to 15.0
    CA Datacom® Datadictionary™
    conversion
  • BDUPG07 - 15.0 DBUTLTY CXX, DD, and DDD backup JCL
  • BDUPG08 - 15.0 Upgrade MUF shutdown JCL
  • DBUTLTYB - 14.0 Candidate MUF DBUTLTY CXX, DD, and DDD backup JCL
  • DBUTLTYL - 15.0 DBUTLTY CXX, DD, and DDD upgrade MUF load JCL
  • DBUTLTYU - 15.0 Sample DBUTLTY CXX report JCL
  • IDCAMSRN - IDCAMS JCL to rename BDUPG07 CXX, DD, and DDD backup datasets
Follow these steps:
  1. Locate CAI.HLQ.PAR.INSTJCL dataset member BDCUSUPG. This member assembles and link edits all the Version 15.0 CAI.CHLQ.CUSMAC custom macro members and populates the CAI.CHLQ.CUSPROC dataset. Before you submit this member for execution, review all custom macro members and update the macro parameter values as needed for the MUF about to be upgraded.
    Type
    UPG15
    in the command line and press Enter. The ISREDIT macro is invoked, and all the member variables are changed to your site standards.
    Submit the member for execution and then cancel out of it so the changes are not saved. Re-editing and rerunning members is easier if an error was made when the ISREDIT macro was modified and saved to your SYSPROC or TSO CLIST dataset
  2. Locate CAI.HLQ.PAR.INSTJCL member DBUTLTYB. This member executes a Version 14.0 DBUTLTY to create backups of a candidate 14.0 MUF CXX, DD, and DDD datasets.
    Type
    UPG15
    in the command line and press Enter. The ISREDIT macro is invoked, and all the member variables are changed to your site standards.
    Submit the member for execution and then cancel out of it so the changes are not saved.
  3. Locate CAI.HLQ.PAR.INSTJCL member DBUTLTYL. This member executes a Version 14.0 DBUTLTY to load the candidate 14.0 MUF CXX, DD, and DDD backups from the prior step into the Parallel Upgrade MUF environment datasets.
    Type
    UPG15
    in the command line and press Enter. The ISREDIT macro is invoked, and all the member variables are changed to your site standards.
    Submit the member for execution and then cancel out of it so the changes are not saved.
  4. Locate CAI.HLQ.PAR.INSTJCL member BDUPG02. This member starts the Version 14.0 Parallel Upgrade MUF containing the CXX, DD, and DDD backups that the prior step loaded.
    Type
    UPG15
    in the command line and press Enter. The ISREDIT macro is invoked, and all the member variables are changed to your site standards.
    Submit the member for execution and then cancel out of it so the changes are not saved.
  5. Locate CAI.HLQ.PAR.INSTJCL member ADSDC14. This member executes the 14.0 DDSDCLM
    CA Datacom® Datadictionary™
    comparator utility to verify the candidate MUF 14.0 DD database is ready for conversion to Version 15.0. Any errors that are identified in the job output must be addressed before proceeding to the next step.
    Type
    UPG15
    in the command line and press Enter. The ISREDIT macro is invoked, and all the member variables are changed to your site standards.
    Submit the member for execution and then cancel out of it so the changes are not saved.
  6. Locate CAI.HLQ.PAR.INSTJCL member BDUPG03. This member executes DBUTLTY to create backups of the verified 14.0 Parallel Upgrade MUF CXX, DD, and DDD datasets.
    Type
    UPG15
    in the command line and press Enter. The ISREDIT macro is invoked, and all the member variables are changed to your site standards.
    Submit the member for execution and then cancel out of it so the changes are not saved.
  7. Locate CAI.HLQ.PAR.INSTJCL member BDUPG04. This member stops the Version 14.0 Parallel Upgrade MUF.
    Type
    UPG15
    in the command line and press Enter. The ISREDIT macro is invoked, and all the member variables are changed to your site standards.
    Submit the member for execution and then cancel out of it so the changes are not saved.
  8. Locate CAI.HLQ.PAR.INSTJCL member BDUPG05P. This member starts the Version 15.0 Parallel Upgrade MUF.
    Type
    UPG15
    in the command line and press Enter. The ISREDIT macro is invoked, and all the member variables are changed to your site standards.
    Submit the member for execution and then cancel out of it so the changes are not saved.
  9. Locate CAI.HLQ.PAR.INSTJCL member BDUPG06. This member converts the Version 14.0
    CA Datacom® Datadictionary™
    database to Version 15.0. It also replaces the Version 14.0 Dynamic System Tables database definition with a Version 15.0 database definition.
    Type
    UPG15
    in the command line and press Enter. The ISREDIT macro is invoked, and all the member variables are changed to your site standards.
    Submit the member for execution and then cancel out of it so the changes are not saved.
  10. Locate CAI.HLQ.PAR.INSTJCL member BDUPG07. This member executes DBUTLTY to create backups of the 15.0 Parallel Upgrade MUF CXX, DD, and DDD datasets.
    Type
    UPG15
    in the command line and press Enter. The ISREDIT macro is invoked, and all the member variables are changed to your site standards.
    Submit the member for execution and then cancel out of it so the changes are not saved.
  11. Locate CAI.HLQ.PAR.INSTJCL member BDUPG08. This member stops the Version 15.0 Parallel Upgrade MUF.
    Type
    UPG15
    in the command line and press Enter. The ISREDIT macro is invoked, and all the member variables are changed to your site standards.
    Submit the member for execution and then cancel out of it so the changes are not saved.
  12. Locate CAI.HLQ.PAR.INSTJCL member IDCAMSRN. This member renames the Version 15.0 Parallel Upgrade MUF backup datasets to a unique name relating back to the candidate MUF of origination. Refer to the member edit instructions regarding the naming convention that was used.
    Type
    UPG15
    in the command line and press Enter. The ISREDIT macro is invoked, and all the member variables are changed to your site standards.
    Submit the member for execution and then cancel out of it so the changes are not saved.
This completes the Parallel Upgrade process for one candidate Version 14.0 MUF instance. To upgrade another candidate 14.0 MUF to Version 15.0, return to Modify and Execute CAI.HLQ.INSTJCL Upgrade JCL Members and repeat all the steps.
Implement the Version 15.0 system resources
When the upgrade process has been successfully completed, implement the 15.0 upgraded system resources back into their original environment. Implementing the 15.0 resources is accomplished with the following steps:
  1. Shut down the candidate MUF.
  2. Execute a single DBUTLTY to load Parallel Upgrade environment 15.0 CXX, DD, and DDD backups.
  3. Modify the original 14.0 candidate MUF and associated CICS startup JCL.
  4. Update the
    CA Datacom® Datadictionary™
    On-Line (DDOL) sign-on/off panels.
  5. Restart the candidate MUF and its associated CICS regions.
For more information, see the scenario about "How to Implement Parallel Upgrade MUF Resources."