Starting and Stopping the Database Engine

This section outlines how to start and stop the Pervasive PSQL engine. Some engine configuration parameters, you need to stop and restart the engine in order for a particular change in your configuration to take effect.

To start and stop the database engine, follow the instructions for your platform:

Starting and Stopping the Server Engine on a Windows Server

Starting and Stopping the Database Engine on NetWare

Starting and Stopping the Database Engine on Linux

Starting and Stopping the Server Engine on a Windows Server

On Windows server environments, Pervasive PSQL Server runs as services. The services are loaded as part of the installation process and are set to be always available if you followed the default installation.

Services Dependencies

Additional Pervasive PSQL products such as Pervasive DataExchange and Pervasive Full Text Search also install services.

Pervasive DataExchange depends on both Pervasive.SQL (transactional) and Pervasive.SQL (relational) services. Pervasive Full Text Search depends only on Pervasive.SQL (relational) service. The following table summarizes the behavior of the dependent services for start, stop, and restart actions of the database engine services.

Note that the behavior of the dependent services is the same regardless with which application you start, stop, or restart the database engine services (PCC, Windows Services, Net Start, Btisc).

Table 2-1 Action of Dependent Services Based on Action of Database Engine Services
Database Engine Service	Service Action for Data Exchange	Service Action for Full Text Search
Pervasive.SQL (transactional)	no action	no action
	Stop	no action
	Restart	no action
Pervasive.SQL (relational)	no action	no action
	Stop	Stop
	Restart	Restart

If you start the service for DataExchange or Full Text Search, the Pervasive.SQL (relational) service starts as a prerequisite service.

Note
The dependent services stop without displaying a message that they will be stopped.

To start the database services on a Windows server by using PCC

See To start or stop services .

To stop the database services on a Windows server by using PCC

See To start or stop services .

To start the database services on a Windows server by using services

Click Start 4 Settings 4 Control Panel.

Double-click Administrative Tools then double-click Services.

A dialog box similar to Figure 2-1 appears.

Figure 2-1 Services Dialog Box

Right-click Pervasive.SQL (relational) then click Start. Right-click Pervasive.SQL (transactional) then click Start.

To stop the database services on a Windows server by using services

Click Start 4 Settings 4 Control Panel.

Double-click Administrative Tools then double-click Services.

A dialog box similar to Figure 2-1 appears.

Figure 2-2 Services Dialog Box

Right-click Pervasive.SQL (relational) then click Stop. Right-click Pervasive.SQL (transactional) then click Stop.

To start the database services on a Windows server by using Net Start or Btisc.exe

Click Start 4 Run.

Type one of the following:

net start "Pervasive.SQL (<transactional | relational>)"

btisc start "Pervasive.SQL (<transactional | relational>)"

Click OK.

Note
Btisc.exe is located in the \PVSW\BIN folder.

To stop the database services on a Windows server by using Net Stop or Btisc.exe

Click Start 4 Run.

Type one of the following:

net stop "Pervasive.SQL (<transactional | relational>)"

btisc stop "Pervasive.SQL (<transactional | relational>)"

Click OK.

Btisc.exe is located in the \PVSW\BIN folder.

Starting and Stopping the Workgroup Engine on Windows

To start the Workgroup Engine on Windows

Click Engines from the Pervasive program on the Start menu.

Click Start Workgroup Engine.

To stop the Workgroup Engine on Windows

On the Windows taskbar, right-click the Pervasive Database icon:

Click Stop Engines and Exit.

Note
You will receive a warning message when trying to stop the engine if any of the following is true:

There are active clients.

No activity took place since the engine loaded.

10 seconds has not elapsed since the last operation took place.

Starting and Stopping the Database Engine on NetWare

To start the Database Engine on NetWare

Note
You must load AFTER311.NLM before you load the MicroKernel.

Enter each of the following commands separately from the console window:

BSTART 
MGRSTART

Pervasive PSQL supports NetWare Storage Services (NSS) volumes on NetWare 5.0 and up. NSS volumes must be mounted before starting the database engine. That is, before accessing the server with the database engine.

As an example:

LOAD NSS 
MOUNT ALL 
SYS:ETC\INITSYS.NCF 
BSTART 
MGRSTART

Also, database updates performed against data files on NSS volumes may run more slowly than with earlier versions of NetWare. As noted in Novell TID 2952147 (http://www.novell.com), "NSS is optimized for reading files." Updates "will almost always perform a little faster on the legacy file system."

Based on this information, you may wish to store frequently-updated data files on regular NetWare volumes rather than NSS volumes.

To stop the Database Engine on NetWare

Enter each of the following commands separately from the console window:

MGRSTOP

BSTOP

Note
Never enter the BSTOP command before the MGRSTOP command.

Tip
If NetWare does not allow you to stop the engines with these commands because of dependencies on other modules, first enter the command BTRV UNLINK, then perform the commands noted above.

Starting and Stopping the Database Engine on Linux

In Linux, the database engine runs as a daemon. The daemon is loaded as part of the installation process and is set to be always available if you followed the complete installation.

You must be logged in as the root user to start and stop the Pervasive PSQL v9 Service Pack 2 daemon process. We recommend that you use the shell script psql to start and stop the process.

To start the Database Engine on Linux

Enter the following at the command line:

/etc/rc.d/init.d/psql start

To stop the Database Engine on Linux

Enter the following at the command line:

/etc/rc.d/init.d/psql stop