Previous Topic: Apply Maintenance to CA CSMNext Topic: Back Out Maintenance from CA CSM

Maintaining CA CSM › Maintenance › Apply Maintenance to CA CSM › SQL Plan Updates

SQL Plan Updates

You may need to apply updates that affect CA Datacom/MSM SQL plans. These SQL plans are delivered as CA Common Services for z/OS maintenance. CA Common Services for z/OS include the sample JCL member MSMCXPLN that you can use to update these SQL plans in the MUF environment.

Implement Latest SQL Plans

The member MSMCXPLN, located in your CA Common Services for z/OS SMP/E environment sample JCL library, is modeled JCL that can be used to update CA Datacom/MSM SQL plans. Execute this JCL whenever you apply PTFs that contain at least one module element and a related SQL plan element. You will be notified that sample JCL member MSMCXPLN requires modification and execution by a ++HOLD condition action occurring during the process of applying the PTF. Follow the instructions that are provided in the ++HOLD comments to modify and execute this member properly.

Note: If CETN600 (MSMCCS 6.0) exists in your CA Common Services for z/OS, verify that the SQL plans are synchronized in the CA Datacom/MSM database Version 6.0 and your running CA Common Services for z/OS libraries. Submit the MSMCXPLN job from the CA Common Services for z/OS JCL library for each MSMC*SQL member in the CA Common Services for z/OS library that DDDEF CAW0EXP represents.

Data Set Reference for Sample JCL

To locate the data set name for the appropriate sample JCL library, refer to the DDDEF element CAW0JCL.

Data Set Reference for SQL Plan

To locate the data set name for the appropriate SQL plan library, refer to the DDDEF element CAW0EXP.

Running CA CSM Version 6.0 with the SCS Address Spaces Containing Code from a Previous Version

CA CSM Version 6.0 does not contain the same version of SQL plans for previous versions of CETN400 and CETN500. This situation may cause you to receive an SQL -124 return code when connecting to a previous version SCS address space (CETN400 or CETN500).

After you upgrade to CA CSM Version 6.0, follow the instructions that are provided in this section to import SQL plans from the CETN400 or CETN500 library. In the instructions, replace CETN600 with CETN400 or CETN500. Do this if you plan to connect to one or more CA CSM address spaces that still contain code of a previous version (CETN400 or CETN500), and you cannot upgrade your CA Common Services for z/OS with CETN600.