|
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:
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.
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
A dialog box similar to Figure 2-1 displays:

A dialog box similar to Figure 2-2 appears.

To stop the database services on Windows NT or 2000 by using services
A dialog box similar to Figure 2-1 displays:

A dialog box similar to Figure 2-2 appears.

To start the database services on Windows NT or 2000 by using Net Start or Btisc.exe
To stop the database services on Windows NT or 2000 by using Net Start or Btisc.exe
To start the database services on Windows NT or 2000 by using PCC
To stop the database services on Windows NT or 2000 by using PCC
To start the Workgroup Engine on Windows
To stop the Workgroup Engine on Windows
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:
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:
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.
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
|
Chapter contents
Prev topic: Using Pervasive.SQL
|