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. It must be a number between 0 and 32767.
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 Replication Agent transaction log system table (UDB) or in the RASD (Oracle or Microsoft SQL Server).
When pdb_gen_id is invoked with the number option, it updates the value of the database generation ID in the Replication Agent transaction log system table (UDB) or in the RASD (Oracle or Microsoft SQL Server). 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 Replication Agent to re-send transactions.
During recovery, if the 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 Replication Agent Primary Database Guide.
If the Replication Agent transaction log (UDB) or the RASD (Oracle or Microsoft SQL Server) does not exist, the pdb_gen_id command returns an error.
The pdb_gen_id command with parameters is valid when the Replication Agent instance is in the Admin or Replication Down state.