Retrieves the generation number for a primary database.
admin get_generation, data_server, database
The data server with the primary database.
The database whose generation number you are retrieving.
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.
For more information about the distribute command, refer to “distribute” in Chapter 5, “Creating a Replication Agent,” in the Replication Server Design Guide.
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.
Any user may execute this command.