Migrating to Version 10.1 with ARCH_LEVEL 1001 (z/OS)

When you install APAR PM75119 for Q Replication Version 10.1 on z/OS®, you must migrate the control tables to the 1001 architecture level to match the code base.

1. Shut down the Q Capture and Q Apply tasks.
2. Follow these steps to run the ASNQ1001 sample job to migrate the control tables to architecture level 1001:
   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
      • !ASH to the name of your Q Apply schema
      • !APPDB to the name of the database that contains the Q Apply control tables
      • !APPTEIF1 and !APPTEIF2 to the name of new or existing table spaces in the database that contains the Q Apply control tables
      Recommendation: Put each control table in its own table space. For any control tables that have indexes, alter the table to specify VOLATILE CARDINALITY. By declaring the control tables VOLATILE, you can avoid table space scans on the control tables that are caused by outdated statistics on the tables. For example:

      ALTER TABLE capture_schema.IBMQREP_SIGNAL VOLATILE CARDINALITY;

   4. Run the statements that pertain to the Q Capture control tables. These statements start with //MIGQCAP1 EXEC PGM=IKJEFT01,DYNAMNBR=20 and end with these two lines:

      SUB_CREATOR VARCHAR(12) WITH DEFAULT NULL;
      COMMIT;

   5. Run the statements that pertain to the Q Apply control tables. These statements start with //MIGQAPP1 EXEC PGM=IKJEFT01,DYNAMNBR=20 and end with !ASH.IBMQREP_APPEVENTS ( EVENTTIME);.
3. Start the Q Capture task with the lsn option or the override_restartq=y option. Using one of these start options is required because the level of the message format changed for this version of Q Capture. Specify the following statements in the JCL, depending on the option:

   lsn

   // PARM='CAPTURE_SERVER=DSN!! capture_schema=!CSH'
   //SYSIN DD *
   LSN=0000:XXXX:XXXX:XXXX:XXXX
   MAXCMTSEQ=0000:XXXX:XXXX:XXXX:XXXX

   Where 0000:XXXX:XXXX:XXXX:XXXX is the LSN value from the ASN7901I message that the Q Capture program issued when it was shut down.

   override_restartq

   // PARM='CAPTURE_SERVER=server capture_schema=schema
   // OVERRIDE_RESTARTQ=Y'

4. Optional: To fall back to an ARCH_LEVEL value of 100Z, update the ARCH_LEVEL columns in IBMQREP_CAPPARMS or IBMQREP_APPLYPARMS to the old value and start Q Capture with the lsn option or with a SYSIN DD * input.