Deleting a Mirror Replication Agent instance

You can delete a Mirror Replication Agent instance at any time by invoking ma_admin with the -d option.

If you delete a Mirror Activator instance, Mirror Activator does not unmark any primary database objects marked for replication, nor does it delete its transaction log objects. Before you shut down and delete a Mirror Activator instance, unmark primary database objects and deinitialize the Mirror Activator so that it removes the objects it created in the primary database.

Before you delete a Mirror Replication Agent instance, you should:

Shut down the Mirror Replication Agent instance, if it is running. See “Shutting down the Mirror Replication Agent instance”.

If the Mirror Replication Agent software is installed on a Microsoft Windows platform, verify that none of the files in the instance subdirectories are open, and that no application or window is accessing the instance subdirectories.

You must set the SYBASE environment before you invoke the Mirror Replication Agent ma_admin utility. See “Preparing to use the utilities”.

Open an operating system command window on the Mirror Replication Agent host machine.

At the operating system prompt, navigate to the Mirror Replication Agent bin directory.

On Microsoft Windows platforms:
```
cd %SYBASE%\MA-15_2\bin
```
where %SYBASE% is the path to the Mirror Replication Agent installation directory.
On UNIX platforms, enter:
```
cd $SYBASE/MA-15_2/bin
```
where $SYBASE is the path to the Mirror Replication Agent installation directory.

In the Mirror Replication Agent bin directory, invoke the ma_admin utility with the -d option to delete a Mirror Replication Agent instance:

ma_admin -d inst_name

where inst_name is the name of the Mirror Replication Agent instance you want to delete.

The following message appears:

Are you sure you want to delete the Mirror Replication Agent instance inst_name? [y/n]

Enter y to delete the Mirror Replication Agent instance.

After the instance is deleted, the operating system prompt returns.

If the instance is running when you invoke ma_admin with the -d option, the utility returns an error message:

Cannot delete Mirror Replication Agent instance 'inst_name' because it is currently running.

To shut down a Mirror Replication Agent instance, log in to its administrative port, and use the shutdown command. See “Shutting down the Mirror Replication Agent instance”.

Verify that the Mirror Replication Agent instance was deleted properly using one of the following methods:

Invoke the ma_admin utility with the -v option, and specify the name of the deleted Mirror Replication Agent instance:
```
ma_admin -v inst_name
```
where inst_name is the name of the deleted Mirror Replication Agent instance.

When you verify a Mirror Replication Agent instance with the -v option, the utility looks for an instance directory with the specified instance name under the Mirror Replication Agent base directory, and looks for the correct subdirectories under the Mirror Replication Agent instance directory.
Invoke the ma_admin utility with the -l option:
```
ma_admin -l
```
The -l option lists all verifiable Mirror Replication Agent instances, which should not include the one you just deleted.
As an alternative to using the ma_admin utility, you can use operating system commands to verify that the Mirror Replication Agent instance directories were deleted correctly.

On Microsoft Windows platforms, if any application is accessing a file or directory associated with a Mirror Activator instance when you delete the instance, the open file or directory is not deleted. An error message informs you of the file or directory not deleted.

To finish deleting a Mirror Activator instance after a file or directory access conflict occurs on a Microsoft Windows platform, you must:

Manually delete the file or directory

Verify that the file or directory is not open in any application