CA-7 Online task: ABEND U0309 after applying PTFs

Products

• CA 7 Workload Automation

Issue/Introduction

It can happen that the CA7ONL Task abends U0309 with errors like below reported, after PTFs applied:

 02.22.39 STC00433  ADSTRT:DB00135I - CONNECT TO ADSTRT            FSG9     STC00430 FSG9     M-15.1 I-15.1 0009
 02.22.39 STC00433  ADSTRT:DB00101I - STARTED JOB-CA7      NUMBER-63872 CXX=FSG9     MUFNAME=FSG9
 02.22.39 STC00433  CAL2D024I CA Datacom OPEN successful for SASSIQDC
 02.22.39 STC00433  CAL2D308E SQL error, Table(CA7_ACT_CPM_FLOW  ) Func(PREPARE) RC(-0124)
 02.22.39 STC00433  CAL2D309E SQL error, PLAN MFWA.SASSIQDC_CA7151721MFWA DOES NOT EXIST
 02.22.40 STC00433  IEA995I SYMPTOM DUMP OUTPUT  338
    338               USER COMPLETION CODE=0309
    338              TIME=02.22.39  SEQ=00506  CPU=0000  ASID=008A
    338              PSW AT TIME OF ERROR  078D1000   802DE1FC  ILC 2  INTC 0D
    338                ACTIVE MODULE           ADDRESS=00000000_002DD000  OFFSET=000011FC
    338                NAME=SASSIQDC

...

How to fix this problem.

Environment

Release :  

Component : CA-7

Resolution

This abend can occur if any of the applied PTFs does contain a ++HOLD ACTION requiring an 'After Apply' activity on the Datacom DB and this activity was not executed correctly. 

For example we have seen this problem in CA-7 12.1, after apply of PTF SO15185, which contains the following ++HOLD ACTION :

...
                      **************************                          
                      * STEPS    TO    PERFORM *                          
                      **************************                          
Run CAL2JCL job AL2DCA70.  Make sure you always use the most current      
version of AL2DCA70 from the CAL2JCL dataset.  Expect a return code of    
zero from all steps.    

....        
                                                                           
This PTF provides JCL (AL2DBI05) to execute a job that will rename         
a reserved column in the CA7_ZERO_RECORDS Datacom table to make the        
JCL_RETRY column available to SQL queries.                                 
                                                                           
(1) Run job AL2DBI05 to rename the reserved column to JCL_RETRY.           
                                                                           
          ).    

...

and it was not executed correctly against the involved CA7 DB instance.

If this doesn't help addressing the abend, Please open a Support case, providing all the available documentation.