store procedure on SMP machine

store procedure on SMP machine

Post by Shyh-ji L » Tue, 27 Oct 1998 04:00:00



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

 
 
 

1. store procedrue on SMP machine

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 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 processor and 512 MB
RAM, SQL Server is Sybase SQL Server system 11.0, OS is
Digital UNIX v3.2c (rev. 148)

Could anyon have solution about this problem?

Thanks in advance.
Shyh-ji Lay

2. SQL Mathmatics with Times and Dates

3. Compiling Stored Procedures for SMP

4. Help Needed with: SysListView32

5. Using proc affinity for large SMP machines

6. Where to buy SQL Server 2000?

7. Can't install SQL 2000 on a cloned SMP machine

8. NYC - **Junior Sybase DBA** - Career in Finance

9. Using an SMP machine to make multiple indices on the

10. Using an SMP machine to make multiple indices on the same table

11. Using an SMP machine to make multiple indices on the same

12. Configuring Oracle for an SMP machine