We have a problem about store procedure on SMP machine.
For example, We issue this command on another machine:
1> exec AL8200...chinaday
2> go
(AL8200 is a Sybase SQL Server on SMP machine)
a. if we set "max number of engines" value to 1, we can get the result
of store procedure
b. if we set "max number of engines" value to 2, we can't get the
result of store procedure. It's hang.
This SMP machine is DEC Alpha 8200 with 2-cpu and 512 MB RAM.
OS is Digital UNIX V3.2c (rev. 148),
The DBMS is Sybase SQL Server System 11.0
Could anybody know the solution about this problem?
Thanks in advance.
Shyh-ji Lay