Retrieves the generation number for a primary database.
admin get_generation, TOKYO_DS, pubs2
Current generation number for TOKYO_DS.pubs2 is 0
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.