If you are running CA Repository for z/OS 7.2 and need to change the work load manager (WLM) name for one or more stored procedures, the following steps must be performed.
Solution
1. At the main installation panel, select Option 2 for "DB2 DEFAULTS". Update the value stored in "WLM Environment Name" with the new WLM name.
Hit the Enter key and then exit the "DB2 DEFAULTS" screen. Exit the installation panel to update the DBXPARM file.
2. Link the stored procedures into the new WLM step library. If both the old and the new work load managers use the same library, skip this step.
The stored procedures can be linked by running the installation job in .CCPSJCL member P$INS09. Alternatively, copy the stored procedures from your Repository Load library to the new WLM run library.
3. Drop and recreate or alter the stored procedures with the new WLM_ENVIRONMENT name. If the stored procedures are dropped from the system, they will need to be recreated. The new WLM name defined in step 1 is used when generating the DDL for the "CREATE PROCEDURE" syntax. To generate the DDL to create the stored procedures, access the main installation panel and select option 7 to "CREATE DB2 OBJECTS". As only the stored procedures need to be recreated, delete all SQL statements except for the "CREATE PROCEDURE" statements in this job. Failure to do so will result in -601 errors.
4. Bind the DB2 stored procedure packages by selecting Option 9 "PLANS" from the main installation panel. Enter 'A' in the 'Prepare Package Field'. Modify the generated JCL to bind only those stored procedures that have changed.
5. Restart the Work Load Manager.