pdb_gen_id

Returns the current value of the database generation ID, or updates the value of the database generation ID.

Syntax

pdb_gen_id [number]

Parameters

Examples

Usage

  • When pdb_gen_id is invoked with no option, it returns the current value of the database generation ID stored in the RASD.

  • When pdb_gen_id is invoked with the number option, it updates the value of the database generation ID in the RASD. 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 RASD 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.

Related reference
ra_helplocator
ra_locator