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 properly modify and execute this member.
Note: If CETN500 (MSMCCS 5.0) exists in your CA Common Services for z/OS, verify that the SQL plans are synchronized in the CA Datacom/MSM database Release 5.1 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 is represented by DDDEF CAW0EXP.
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 Release 5.1 with the SCS Address Spaces Containing Code from a Previous Version
CA CSM Release 5.1 does not contain all of the SQL plans for CA MSM V4.0. This may cause you to receive an SQL -124 return code when connecting to an SCS address space of a previous version (CETN400).
After completing an upgrade to CA CSM Release 5.1 from CA MSM V4.0, follow the instructions provided in this section to import SQL plans from the CETN400 library. In the instructions, replace CETN500 with CETN400. Do so if you plan to connect to one or more CA CSM address spaces, which still contain code of a previous version (CETN400), and you cannot upgrade your CA Common Services for z/OS with CETN500.
|
Copyright © 2014 CA.
All rights reserved.
|
|