Returns the current value of the database generation ID, or updates the value of the database generation ID.
pdb_gen_id [number]
The value of the new database generation ID to be used when the database generation ID is updated.
pdb_gen_id
This command returns the current value of the database generation ID.
pdb_gen_id 10
This command updates the database generation ID to the value 10.
When pdb_gen_id is invoked with no option, it returns the current value of the database generation ID stored in the Sybase Replication Agent transaction log system table (DB2 UDB, and Microsoft SQL Server) or in the RASD (Oracle).
When pdb_gen_id is invoked with the number option, it updates the value of the database generation ID in the Sybase Replication Agent transaction log system table (DB2 UDB, and Microsoft SQL Server) or in the RASD (Oracle). Changing the database generation ID takes effect immediately.
The database generation ID is the first 2 bytes of the origin queue ID. The database generation ID is used by Replication Server to support recovery operations, which may require the Sybase Replication Agent to re-send transactions.
During recovery, if the Sybase Replication Agent must re-send operations that the Replication Server has already processed, you can change the database generation ID to prevent the Replication Server from recognizing the operations as already processed.
For more information about the origin queue ID, see ra_helplocator, or refer to the chapter for your specific primary data server in the Sybase Replication Agent Primary Database Guide.
If the Sybase Replication Agent transaction log (DB2 UDB, and Microsoft SQL Server) or the RASD (Oracle) does not exist, the pdb_gen_id command returns an error.
The pdb_gen_id command with no parameters is valid when the Sybase Replication Agent instance is in the Admin state.