Starting and Stopping the Database Engine

---

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

---

Note
Btrieve v6.15 Users: If you have any log (.LOG) files you want to roll forward, you must do so before you load the Pervasive.SQL V8 MicroKernel, which uses a different logging scheme. You must use both the v6.15 or earlier engine and its accompanying Roll Forward Utility. Refer to your Btrieve v6.15 or earlier documentation for information about logging and instructions about how to roll files forward.

---

Starting and Stopping the Server Engine on a Windows Server

On Windows NT or 2000, 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 Typical installation.

To start the database services on Windows NT or 2000 by using services

1. Click Start4Settings4Control Panel.
2. Do one of the following:
   1. On Windows NT, double-click on the Services icon.

A dialog box similar to Figure 2-1 displays:

 
Figure 2-1 Windows NT Services Dialog Box

1. On Windows 2000, double-click Administrative Tools then double-click Services.

A dialog box similar to Figure 2-2 appears.

 
Figure 2-2 Windows 2000 Services Dialog Box

3. Do one of the following:
   1. On Windows NT, click Pervasive.SQL (relational) then click Start. Click Pervasive.SQL (transactional) then click Start.
   2. On Windows 2000, right-click Pervasive.SQL (relational) then click Start. Right-click Pervasive.SQL (transactional) then click Start.

To stop the database services on Windows NT or 2000 by using services

1. Click Start4Settings4Control Panel.
2. Do one of the following:
   1. On Windows NT, double-click on the Services icon.

A dialog box similar to Figure 2-1 displays:

 
Figure 2-3 Windows NT Services Dialog Box

1. On Windows 2000, double-click Administrative Tools then double-click Services.

A dialog box similar to Figure 2-2 appears.

 
Figure 2-4 Windows 2000 Services Dialog Box

3. Do one of the following:
   1. On Windows NT, click Pervasive.SQL (relational) then click Stop. Click Pervasive.SQL (transactional) then click Stop.
   2. On Windows 2000, right-click Pervasive.SQL (relational) then click Stop. Right-click Pervasive.SQL (transactional) then click Stop.

To start the database services on Windows NT or 2000 by using Net Start or Btisc.exe

1. Click Start4Run.
2. Type one of the following:
   1. net start "Pervasive.SQL (<transactional | relational>)"
   2. btisc start "Pervasive.SQL (<transactional | relational>)"
3. Click OK.

---

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

---

To stop the database services on Windows NT or 2000 by using Net Start or Btisc.exe

1. Click Start > Run.
2. Type one of the following:
   1. net stop "Pervasive.SQL (<transactional | relational>)"
   2. btisc stop "Pervasive.SQL (<transactional | relational>)"
3. Click OK.

---

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

---

To start the database services on Windows NT or 2000 by using PCC

1. Click Start4Programs4Pervasive.SQL V84Control Center.
2. In the Namespace, click on a registered engine.
3. Click Action4Tasks.
4. Do one of the following:
   1. Click Start All Pervasive Services to start both the relational and transactional services.
   2. Click Start Relational Service to start the relational service.
   3. Click Start Transactional Service to start the transactional service.

To stop the database services on Windows NT or 2000 by using PCC

1. Click Start4Programs4Pervasive.SQL V84Control Center.
2. In the Namespace, click on a registered engine.
3. Click Action4Tasks.
4. Do one of the following:
   1. Click Stop All Pervasive Services to stop both the relational and transactional services.
   2. Click Stop Relational Service to stop the relational service.
   3. Click Stop Transactional Service to stop the transactional service.

Starting and Stopping the Workgroup Engine on Windows

To start the Workgroup Engine on Windows

1. Click Start4Programs4Pervasive.SQL V84Engines4Pervasive.SQL 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.

---

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 Typical installation.

You must be logged in as the root user to start and stop the Pervasive.SQL V8 daemon process. We recommend that you use the shell script psql to start and stop the process. However, you may start and stop individual daemons by using mkded and sqlmgr.

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