Returns the name of the Maintenance User for the primary database connection.
ra_maintid
Replication Server requires a Maintenance User name for each database connection. The Maintenance User name for a database connection is defined with the Replication Server create connection or alter connection command.
When the primary database Maintenance User name is changed in the Replication Server (using the alter connection command), Replication Server sends the new Maintenance User name to the Mirror Replication Agent, if the Mirror Replication Agent is in Replicating state.
Each time the Mirror Replication Agent goes into Replicating state, it automatically retrieves the primary database Maintenance User name from the Replication Server.
When ra_maintid is invoked, it returns the name of the primary database Maintenance User currently stored in the RASD, as follows:
Maintenance User ---------------- SYS (1 row affected)
If ra_maintid is invoked when the Mirror Replication Agent is in Replicating state, the correct Maintenance User name is always returned, because it is retrieved from the Replication Server when the Mirror Replication Agent goes to Replicating state.
If ra_maintid is invoked when the Mirror Replication Agent is in Admin state, the value returned from the RASD may not be correct, because it could have been changed in the Replication Server after the last time the Mirror Replication Agent retrieved the value and stored it in the RASD.
If ra_maintid is invoked when the primary database connection is down, it returns an error.
The ra_maintid command is valid when the Mirror Replication Agent instance is in either Admin or Replicating state.