Monday 11 April 2011

ASE : Database Engines: Status and Settings

Setting and Displaying Database Engines

Two configuration parameters control the number of dataserver processes (engines) which are active
in the server: "max online engines" and "number of engines at startup".
Most shops with 4-cpu servers will set these to 3.


If the number of engines at startup is lower than the max online engines, how do you tell the
number of engines which are active?

There are two ways:

1) select * from master..sysengines

2) at the UNIX prompt, use the ps -ef command to list all running processes. Note the dataserver
processes, each is an engine.


How to start/stop an engine?

-- start engine #4

sp_engine 'online',4
go

-- stop engine #4

sp_engine 'offline',4
go

No comments:

Post a Comment