Looking for help on how to automate/batch the update source/target table descriptions & mapping of source/target column for a z/OS DB2 source to Solaris Oracle target mirror continuous subscription.

A common task for us is to ALTER ADD columns to tables currently used in multiple CDC subscriptions. The manual work required to do this via Management Console is tedious and time consuming. Thus I'm looking an alternative process to use - i.e. batch and/or script.

For a subscription where the source is z/OS DB2 and the target is Solaris Oracle, does anyone know how to build a batch process or script to do the following - I have z/OS CDC commands for all but steps 4 & 5):

Mirror Continuous Subscription XXXXXXXX: Source = z/OS DB2, Target = Solaris Oracle
(1) End Replication for XXXXXXXX (Can be done via z/OS CDC command ENDTSMIR)
(2) OUTSIDE OF CDC - On DB2 source, do ALTER ADD COLUMN on table abc
(3) OUTSIDE OF CDC - ON Oracle target, do ALTER ADD COLUMN on table abc
(4) For table abc within subscription XXXXXXXX, update source table & target table descriptions
(5) For table abc, map all columns - including new ones - based on column name from source to targe
(6) 'Describe' operation on subscription XXXXXXXX (Can be done via z/OS CDC command STRTSDCS)
(7) Mark table abc for REFRESH in subscription XXXXXXXX (Can be done via z/OS CDC command SETMIRSTS)
(8) Start Replication for XXXXXXXX (Can be done via z/OS CDC command STRTSMIR)