sysadmin set_dsi_generation

Changes a database generation number in the Replication Server to prevent the application of transactions in the DSI stable queue after a replicate database is restored.

Syntax

sysadmin set_dsi_generation, gen_number, primary_data_server,
       primary_database, replicate_data_server, replicate_database

Parameters

gen_number – The new generation number of the database. The number is an integer between 0 and 65,535.
primary_data_server – The name of the data server at the primary site.
primary_database – The name of the primary database.
replicate_data_server – The name of the replicate data server.
replicate_database – The name of the replicate database.

Examples

Example 1 – Sets new DSI generation number to 105. The previous number was 104 or less:
```
sysadmin set_dsi_generation 105 NY_DS, ny_db, SF_DS,
         sf_db
```

Usage

Use sysadmin set_dsi_generation during the recovery of a database dump. Changing the generation number except during recovery may cause incorrect data at replicate databases.

See the Replication Server Administration Guide Volume 2 for a complete description of the recovery procedure.

Permissions

sysadmin set_dsi_generation requires “sa” permission.