admin get_generation
Retrieves the generation number for a primary database.
Syntax
admin get_generation, <data_server>, <database>
Parameters
The data server with the primary database.
The database whose generation number you are retrieving.
Examples
admin get_generation, TOKYO_DS, pubs2
Current generation number for TOKYO_DS.pubs2 is 0
Usage
The database generation number is the first 2 bytes of the origin queue ID generated by a RepAgent for log records. The generation number is a parameter of the Log Transfer Language (LTL) distribute command.
The generation number should be incremented following a load for the primary database. Incrementing the number prevents Replication Server from ignoring (as duplicates) any transactions applied after the load.
Increment the generation number by executing Adaptive Server dbcc settrunc in the Adaptive Server database.