Setting the identity column attribute for replicated files - assure_mimix - 10.0

Assure MIMIX Administrator Reference

Product type
Software
Portfolio
Integrate
Product family
Assure
Product
Assure MIMIX™ Software
Version
10.0
Language
English
Product name
Assure MIMIX
Title
Assure MIMIX Administrator Reference
Copyright
2023
First publish date
1999
ft:lastEdition
2024-05-07
ft:lastPublication
2024-05-07T13:36:02.962500

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.

  1. 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.

  2. Determine whether limitations exist in the replicated tables that would prevent you from running the command to set values. See SETIDCOLA command limitations.

  3. 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 .

  4.  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)