Show TOC

sysadmin set_dsi_generationLocate this document in the navigation structure

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.