Usage Note 18467: Member lock is not available for SPDE.any.DATA, lock held by another process when multiple processes attempt to access the same SPD Engine data set
When multiple processes attempt to access the same SPDE data set, the message:
ERROR: Member lock is not available for SPDE.any.DATA, lock held by
another process
may be generated in the log ("any" is the name of the data set).
The message is generated when attempting to obtain write access to
a SPDE data set. Write access requires exclusive access to the data
set which can not be granted while any other process has either
write or read access.
While the above scenario can occur at any maintenance level, file
handle caching was introduced in 9.1.3 (9.1 TS1M3SP4) and may cause
the problem to occur more frequently. File handle caching can be
disabled by specifying the following in the autoexec file:
options debug='spde: cache_disable';
The option has to be set for every process that accesses (read or
write) the SPDE data set and prior to establishing the SPDE libname.
Operating System and Release Information
| Product Family | Product | System | Reported Release | Fixed Release* |
| SAS System | Base SAS | Solaris for x64 | 9.1 TS1M3 SP4 | |
| Microsoft Windows XP Professional | 9.1 TS1M3 SP4 | |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
| Type: | Usage Note |
| Priority: | |
| Topic: | Data Management ==> Access ==> SAS I/O
|
| Date Modified: | 2007-11-06 16:21:20 |
| Date Created: | 2006-09-08 13:56:03 |