Date: 05/10/2006
NV version: 7.1.1 only for HP-UX;7.1.2 and later version for all other OS
OS version: All
Application version: Sybase 12.5.2 and later
Plugin version: All
Description:
Restoring "sybsystemdb" fails when "enable xact coordination" is enabled.
Symptoms:
The restore job will fail with "Sybase Message: 'This operation is invalid when the run value of configuration parameter 'enable xact coordination' is on. Please retry after disabling this configuration parameter' ".
Cause of Problem:
"enable xact coordination" parameter enables or disables Adaptive Server transaction coordination services. When this parameter is enabled, Adaptive Server ensures that updates to remote Adaptive Server data commit or roll back with the original transaction. With this option enabled, restoring subsystemdb database fails.
Ask a system administrator to disable the "enable xact coordination". By default, it's enabled (i.e., set to 1).
1. Run [sp_configure "enable xact coordination",0] from sql command.
2. Stop/Start ASA service (don't need to restart backupserver service)
3. Restore sybsystemdb database and then make it online as required.
