Falling back from Version 11.4

After you migrate the Q Capture and Q Apply control tables to Version 11.4 with ARCH_LEVEL 1140, you might need to fall back to the previous ARCH_LEVEL of 1021, or to an earlier V11.4 function level.

1. Shut down the Q Capture and Q Apply tasks.
2. Follow these steps to run the SASNSAMP(ASNQFALL) sample job to fall back to architecture level 1021:
   1. Locate the sample in the SASNSAMP partitioned data set.
      The sample includes SQL statements to fall back for both the 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 (recommended value: DSNTIA91)
      • DSN!!0 to the prefix of the target library for Db2
      • !CSH to the name of your Q Capture schema
      • !ASH to the name of your Q Apply schema
   4. Run the statements that pertain to the Q Capture control tables (step MIGQCAP2):

      UPDATE !CSH.IBMQREP_CAPPARMS SET ARCH_LEVEL='1021';
      UPDATE !CSH.IBMQREP_CAPPARMS SET COMPATIBILITY = '1021';
      

   5. Run the statement that pertains to the Q Apply control tables (step MIGQAPP2):

      UPDATE !ASH.IBMQREP_APPLYPARMS SET ARCH_LEVEL = '1021';

3. Optional: If you are only falling back Q Apply to 1021 and keeping Q Capture at 1140, follow these steps:
   1. Stop the Q Capture program and update the APPLY_LEVEL column in the IBMQREP_SENDQUEUES table to 1021.
   2. After Q Apply has processed all messages from the 1140 Q Capture program, stop Q Apply and update the ARCH_LEVEL column in IBMQREP_APPLYPARMS to 1021. (The Q Apply program at ARCH_LEVEL 1021 cannot process messages from Q Capture at 1140.)
4. Optional: If you are only falling back Q Capture to 1021 and keeping Q Apply at 1140, stop Q Capture and set the ARCH_LEVEL and COMPATIBILITY columns in the IBMQREP_CAPPARMS table to 1021. The Q Apply program at ARCH_LEVEL 1140 can process messages from Q Capture at 1021.
5. To fall back to an earlier V11.4 function level, for example level 1140.100, run the following statements at the Q Capture and Q Apply servers:

   Q Capture server

   UPDATE IBMQREP_CAPPARMS SET CURRENT_LEVEL  = ‘1140.100’;
   UPDATE IBMQREP_SENDQUEUES SET  APPLY_LEVEL = ‘1140.100’;
   

   Q Apply server

   UPDATE IBMQREP_APPLYPARMS SET CURRENT_LEVEL  = ‘1140.100’; 
   UPDATE IBMQREP_RECVQUEUES SET CAPTURE_LEVEL = ‘1140.100’; 
   

   You need to  change the STEPLIB to the library that you used for the old library and bind with the old library (only if you freed the old packages). Q replication uses version auto, so it keeps the old packages unless you freed them.