pdb_gen_id

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 Replication Agent to re-send transactions.

During recovery, if Replication Agent must re-send operations that Replication Server has already processed, you can change the database generation ID to prevent Replication Server from recognizing the operations as already processed.

For more information about the origin queue ID, see ra_helplocator, or refer to the section 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.