Usage Note 36245: "A lock is not available....lock held by another process" error occurs when running the %OMABAKUP macro
 |  |  |  |
Because the metadata server process locks tables when it is active, it is necessary to properly pause the server before you run a backup of the metadata. Normally, running the %OMABAKUP macro is sufficient for this task, because it submits the METAOPERATE procedure to pause the repositories before it begins to make the backup copies.
However, if your metadata server is configured to run in a Microsoft Windows 2003 Failover Cluster environment, %OMABAKUP will likely fail with errors similar to the following:
Note that the name of the data set might vary.
This error occurs because when the %OMABAKUP macro pauses the metadata server, the Cluster Service will attempt to restart it. If it succeeds, by the time the %OMABAKUP macro begins copying the tables to the backup location, the server is again running and has locked the tables.
To circumvent the problem, you must first take the group offline using the Cluster Administrator or CLUSTER command. Then, once the group is offline, you can make a backup copy of your metadata repository data sets.
You can find more information in this paper: Deploying a SAS® Metadata Server to a Windows Server 2003 Failover Cluster. For additional details on the CLUSTER command, see the Microsoft TechNet website.
Operating System and Release Information
| Product Family | Product | System | SAS Release | |
| Reported | Fixed* | |||
| SAS System | SAS Metadata Server | Microsoft Windows Server 2003 Datacenter Edition | 9.1 TS1M3 SP4 | |
| Microsoft Windows Server 2003 Enterprise Edition | 9.1 TS1M3 SP4 | |||
| Microsoft Windows Server 2003 Standard Edition | 9.1 TS1M3 SP4 | |||
| Microsoft Windows Server 2003 Enterprise 64-bit Edition | 9.1 TS1M3 SP4 | |||
| Microsoft Windows Server 2003 Datacenter 64-bit Edition | 9.1 TS1M3 SP4 | |||
| Type: | Usage Note |
| Priority: | |
| Topic: | System Administration ==> Servers ==> Metadata System Administration |
| Date Modified: | 2010-05-26 10:49:44 |
| Date Created: | 2009-06-16 14:48:54 |