Library > Products > Pervasive.SQL > Pervasive.SQL 9.1 > User's Guide > Using Pervasive.SQL > Starting and Stopping the Database Engine

PreviousUser's Guide (9.1 revision 1) Next

Starting and Stopping the Database Engine

Show this topic in Library frames

This section outlines how to start and stop the Pervasive.SQL 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

On Windows server environments, Pervasive.SQL 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.

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

  1. Click Start 4 Settings 4 Control Panel.
  2. Double-click Administrative Tools then double-click Services.

    3. A dialog box similar to Figure 2-1 appears.

    Figure 2-1 Services Dialog Box

  3. 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

  1. Click Start 4 Settings 4 Control Panel.

  2. Double-click Administrative Tools then double-click Services.

    3. A dialog box similar to Figure 2-1 appears.

    Figure 2-2 Services Dialog Box

  3. 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

  1. Click Start 4 Run.
  2. Type one of the following:
    1. net start "Pervasive.SQL (<transactional | relational>)"
    2. btisc start "Pervasive.SQL (<transactional | relational>)"
  3. Click OK.
    4. Note
    Btisc.exe is located in the \PVSW\BIN folder.

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

  1. Click Start 4 Run.
  2. Type one of the following:
    1. net stop "Pervasive.SQL (<transactional | relational>)"
    2. btisc stop "Pervasive.SQL (<transactional | relational>)"
  3. Click OK.
    4. Note
    Btisc.exe is located in the \PVSW\BIN folder.

Starting and Stopping the Workgroup Engine on Windows

To start the Workgroup Engine on Windows

  1. Click Engines from the Pervasive program on the Start menu.
  2. Click Start Workgroup Engine.

To stop the Workgroup Engine on Windows

  1. On the Windows taskbar, right-click the Pervasive Database icon: .
  2. Click Stop Engines and Exit.
    3. 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.SQL 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.SQL 9 SP1 (9.1) 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  

Chapter contents
Publication contents

Prev topic: Using Pervasive.SQL
Next topic: Granting Administrative Rights for the Database Engine