asncatm: Migrating Q Replication control tables (z/OS)

Use the asncatm command on z/OS® to migrate the Q Capture or Q Apply control tables to a specified version and function level. You can also use the utility to activate program function to a specified level, or to check the control tables to ensure that they are correctly defined.

Syntax

upgrade-options

Parameters

upgrade

Specify to generate an SQL script to migrate the Q Capture (qcap) or Q Apply (qapp) control tables. The script creates any new tables that are required, alters existing tables, and updates the value of the CONTROL_TABLES_LEVEL column in the IBMQREP_CAPPARMS table.

You must specify a control tables level that is higher than or the same as the installed level of IBM® InfoSphere® Data Replication for Db2® for z/OS. If the level is equal, the utility checks the value of CURRENT_LEVEL and generates repair scripts for missing tables or columns.

Note: If in an earlier release the IBMQREP_CAPENVINFO or IBMQREP_APPENVINFO control tables were created on the source or target database, the asncatm utility does not remove these tables. The tables are not used on z/OS. You can use the following SQL statements to remove them and their associated table spaces:

DROP TABLE schema.IBMQREP_CAPENVINFO;
DROP TABLE schema.IBMQREP_APPENVINFO;
DROP TABLESPACE capture_server.tablespace_name;
DROP TABLESPACE apply_server.tablespace_name;

check

Specify to prompt the asncatm utility to check the existing Q Capture or Q Apply control tables to see if they are correctly defined, and if not to issue scripts to correct them.

schema

Specifies the schema of the control tables that you want to upgrade or check. The default is ASN.

db

Specifies the Db2 subsystem where the control tables are located. This value can also be the Db2 data sharing group name.

asnpath

Specifies the location where you want the asncatm program to write the output SQL files and its log file. You can specify either a path name or an MVS™ data set high-level qualifier (HLQ).

debug

Specify to prompt the asncatm utility to generate additional debugging information for IBM Support.

upgrade-options:

rrrr.nnn: Specifies the major release number (rrrr) and function level within that release (nnn) at which you want the control tables to be created. For example, the first level for Version 11.4 is 1140.0 and the first new function level for V11.4 is 1140.100.
latest: Specify to update the control tables to the latest released version. This is the default.
activate: Specify to instruct the Q Capture or Q Apply program to use function up to the specified level. You can specify a version and function level or specify latest to activate the latest released version.
runnow: Specifies whether the asncatm program should execute the generated SQL file for the upgrade or check actions. By default (n), the program does not run the generated script.

Example: Upgrade Q Capture control tables and activate function level

The following example upgrades the Q Capture control tables to the 1140.100 level and activates function level 1140.100 on DQRG.

//ASNCATM  EXEC PGM=ASNCATM,REGION=0M,
// PARM='/UPGRADE QCAP CONTROL_TABLE_LEVEL=LATEST DB=DB2A
//             ASNPATH=//''OEUSR01'

//SYSIN    DD *
SCHEMA=DEMO10
RUNNOW=N
DEBUG=N
ACTIVATE=LATEST

This job generates the following SQL script file in z/OS for you to check and run: OEUSR01.DB2A.DEMO10.ASNCATM.QCAP.UPG.SQL. The job also generates the following log file: OEUSR01.DB2A.DEMO10.ASNCATM.LOG.

Example: Upgrade Q Apply control tables and activate function level

The following example upgrades the Q Apply control tables to the 1140.100 level and activates function level 1140.100 on DQRG.

//ASNCATM  EXEC PGM=ASNCATM,REGION=0M,
// PARM='/UPGRADE QAPP CONTROL_TABLE_LEVEL=LATEST  DB=DB2A
//             ASNPATH=//''OEUSR01'

//SYSIN    DD *
SCHEMA=DEMO10
RUNNOW=N
DEBUG=N
ACTIVATE=LATEST

This job generates the following SQL script file in z/OS for you to check and run: OEUSR01.DB2A.DEMO10.ASNCATM.QAPP.UPG.SQL. The job also generates the following log file: OEUSR01.DB2A.DEMO10.ASNCATM.LOG.