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 RASD. This is the value of the database generation ID at the primary database.
When pdb_gen_id is invoked with the number option, it updates the value of the database generation ID in the RASD, and at the primary database. 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 Mirror Replication Agent to re-send transactions.
During recovery, if the Mirror 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.
If the system database repository does not exist in the RASD (because the Mirror Replication Agent has not been initialized), the pdb_gen_id command returns an error.
The pdb_gen_id command is valid when the Mirror Replication Agent instance is in either Admin or Replicating state.