Migrating to Version 11.4 with ARCH_LEVEL 1140 (z/OS)

You can use the asncatm utility or the ASNQ1140 sample job to migrate the Q Capture and Q Apply control tables to the 1140 architecture level to match the IBM Data Replication for Db2® for z/OS® Version 11.4 code base.

1. Shut down the Q Capture and Q Apply tasks.
2. Select one of these options to migrate the control tables to architecture level 1140:

   • Run the asncatm utility. For example, the following command migrates the Q Capture control tables to the latest level (CONTROL_TABLE_LEVEL=LATEST) and activates the latest function level (ACTIVATE=LATEST).

     //ASNCATM  EXEC PGM=ASNCATM,REGION=0M,
     // PARM='/UPGRADE QCAP CONTROL_TABLE_LEVEL=LATEST DB=!DSNX
                 ACTIVATE=LATEST RUNNOW=N ASNPATH=//''!HLQ'

     For details on using asncatm, see asncatm: Upgrading Q Replication control tables (z/OS). Activating a new function level after you migrate is recommended but not mandatory. For more details, see Activating function levels (z/OS).

   • Run the SASNSAMP(ASNQ1140) sample job. Follow these steps:

     1. Locate the sample in the SASNSAMP partitioned data set. The sample includes SQL statements for migrating Q Capture and Q Apply control tables.
     2. Add a valid job card.
     3. Edit the sample to replace the following names:
        • !DSNx to the name of your Db2 subsystem
        • DSNTIA!! to the plan name for DSNTIAD on your Db2 subsystem
        • DSN!!0 to the prefix of the target library for Db2
        • !CSH to the name of your Q Capture schema
        • !CAPDB to the name of the database that contains the Q Capture control tables
        • !CAPTS to the name of a new or existing table space in the database that contains the Q Capture control tables
        • !ASH to the name of your Q Apply schema
        • !APPDB to the name of the database that contains the Q Apply control tables
        • !APPTS to the name of a new or existing table space in the database that contains the Q Apply control tables
        • !STOGRP to the name of your stogroup
     4. Run the statements that pertain to the Q Capture control tables (step MIGQCAP1). This step makes the following changes:
        • Alter adds some columns.
        • Alters column MAX_TRANS in the IBMQREP_CAPPARMS table to the integer data type.
        • Creates a new table, IBMQREP_SUB_PARTS, and a table space for it.
        • Sets the IBMQREP_CAPPARMS ARCH_LEVEL to 1140.
        • Adds these columns to IBMQREP_CAPPARMS:
          • POSSIBLE_LEVEL WITH DEFAULT NULL
          • CURRENT_LEVEL WITH DEFAULT '1140.0'
          • CONTROL_TABLES_LEVEL WITH DEFAULT '1140.0‘
        • Adds the APPLY_LEVEL column to the IBMQREP_SENDQUEUES table and sets its value to the current COMPATIBILITY value of the IBMQREP_CAPPARMS table.
     5. Run the statements that pertain to the Q Apply control tables (step MIGQAPP1). This step makes the following changes:
        • Alter adds some columns,
        • Creates a new table, IBMQREP_TARGET_PARTS, and a table space for it.
        • Sets the IBMQREP_APPLYPARMS ARCH_LEVEL to 1140.
        • Adds these columns to IBMQREP_APPLYPARMS:
          • POSSIBLE_LEVEL WITH DEFAULT NULL
          • CURRENT_LEVEL WITH DEFAULT '1140.0'
          • CONTROL_TABLES_LEVEL WITH DEFAULT '1140.0‘
        • Adds CAPTURE_LEVEL to the IBMQREP_RECVQUEUES table and sets the CAPTURE_LEVEL value to NULL. The value is populated when the 1140 Q Capture program sends a message to 1140 Q Apply.
3. Run the ASNV1140 sample job to see if you are missing any tables and columns.
   This sample generates alters for the missing tables and columns.
4. Bind ASNQBNDL with the new 1140 DBRM.
    The plans and packages do not change.
5. Change the STEPLIB to point to the 1140 libraries.
6. Start Q Capture and Q Apply.