At a high level, the steps you need to perform to set the identity columns of files being replicated by a data group are listed below. You may want to plan for the time required for investigation steps and time to run the command to set values.
-
Run the SETIDCOLA command in check only mode first to determine if you need to set values. See Checking for replication of tables with identity columns.
-
Determine whether limitations exist in the replicated tables that would prevent you from running the command to set values. See SETIDCOLA command limitations.
-
Determine what increment value is appropriate for use for all tables replicated by the data group. Consider the needs of each table. Also consider the MIMIX backlog at the time you plan to use the command. See Examples of choosing a value for INCREMENTS .
-
From the appropriate system, as defined in When the SETIDCOLA command is useful specify a data group and the number of increments to skip in the command:
SETIDCOLA DGDFN(name system1 system2) ACTION(*SET) INCREMENTS(number)