The Set Identity Column Attribute (SETIDCOLA) command performs a RESTART WITH alteration on the identity column of any SQL tables defined for replication in the specified data group. For each table, the new restart value determines the identity column value for the next row added to the table. Careful selection of values can ensure that, when applications are started, the identity column starting values exceed the last values used prior to the switch or save/restore operation.
If you use Lakeview-provided product-level security, the minimum authority level for this command is *OPR.
The Data group definition (DGDFN) parameter identifies the data group against which the specified action is taken. Only tables that are identified for replication by the specified data group are addressed.
The Action (ACTION) parameter specifies what action is to be taken by the command. Only tables which can be replicated by the specified data group are acted upon. Possible values are:
*SET The command checks and sets the attribute of the identity column of each table which meets the criteria. This is the default value.
*CHECKONLY The command checks for tables which have identity columns. It does not set the attributes of the identity columns. The result of the check is reported in the job log. If there are affected tables, message LVE3E2C will be issued. If no tables are affected, message LVI3E26 will be issued.
The Number of jobs (JOBS) parameter specifies the number of jobs to use to process tables which meet the criteria for processing by the command. A table will only be updated by one job; each job can update multiple tables. The default value, *DFT, is currently set to one job. You can specify as many as 30 jobs.
The Number of increments to skip (INCREMENTS) parameter specifies how many increments of the counter which generates the starting value for the identity column to skip. The value specified is used for all tables which meet the criteria for processing by the command. Be sure to read the information in Examples of choosing a value for INCREMENTS . Possible values are:
*DFT Skips the default number of increments, currently set to 1 increment. Following a planned switch where tables are synchronized, you can usually use *DFT.
number-of-increments-to-skip Specify the number of increments to skip. Valid values are 1 through 2,147,483,647. Following an unplanned switch, use a larger value to ensure that you skip any values used on the production system that may not have been replicated to the backup system.