SQL Plans updates (AL2DCA70) and loadlib maintenance level

Products

• CA 7 Workload Automation

Issue/Introduction

CA7 r12.1 has maintenance being applied that requires HOLD actions to rename reserved columns (for example LU02663) and to import new/updated SQL plans (for example LU03294). Once run, the HOLD action jobs AL2DBI04 and AL2DCA70 respectively will alter the CA7 Datacom Data Base and Data Dictionary, which lives independently from the loadlib that is at that time used by the CA7 main task.

Once this HOLD action is complete, will CA7 only start with the loadlib that contains the maintenance?  Is it possible to swap back to the CA7 target data sets that do not contain the maintenance unless a back out of the HOLD actions?

Environment

Release :  

Component : CA 7

Resolution

In general, when changes to the SQL plan occur as requested by a PTF, a new version is created and AL2DCA70 needs to run to import the new version into the database, but the old version is still present in the DB. 

Below is a sample scenario :

FixA applied   -  related AL2DCA70 runs - database now contains  Version A Plan

FixB applied   -  related AL2DCA70 runs -  database now contains Version A and Version B Plans

If You start CA7 using loadlib with FixA -  all is good as it will find Version A Plan in database.

If You start CA 7 using loadlib with FixB - all is good as it will find Version B Plan in the database.

So, the new plan versions will be both present in the database and they should be seen as different levels : 

- without any PTF applied that requires AL2DCA70 execution, the database plan is at level 0

- after apply of PTF1 that requires AL2DCA70 execution, the database plan is at level 1 but also level 0 is in place.

If the CA7 loadlib is backed out from level1 to level 0 , CA 7 will know that it needs to use the level 0 database plan even though the new data is still there.

In the end, It will work with either loadlib as long as the AL2DCA70 has been correctly executed and the new plan are applied, there is no backing out of the plan and no need to remove the plan.