sqlmgr

---

Description

sqlmgr is the command used to start and stop the Pervasive.SQL relational engine as either a daemon process or in console mode. To start sqlmgr, bti.ini should be placed into directory /usr/local/psql/etc. This file contains ODBC settings and description of ODBC DSNs for the server. (Note that the primary way to start or stop the database engines is with the shell script psql. See Starting and Stopping the Database Engine on Linux .)

Port and network protocol in bti.ini should be specified as below:

[SQLManager]
MgrPort=1583
MgrUseTransport=TCP

Each DSN should be described in odbc.ini as follows:

[DSN name]
Driver=/usr/local/psql/lib/libsrde.so
Description=Test Pervasive database
DBQ=DBName

To create a DBName see dbmaint .

Synopsis

sqlmgr [ -start | -stop | -console ] 

Options

sqlmgr -start sqlmgr -stop sqlmgr -console

starts sqlmgr stops sqlmgr starts sqlmgr in console mode

Examples

1. SQLMGR required settings:

   ; configure sqlmgr port
   [SQLManager]
   MgrUseTransport=TCP
   MgrPort=1583 
   

2. Server data source - the one to which remote calls are redirected:

   ; Test
   [dsn.srv]
   Driver=/usr/local/psql/lib/libsrde.so
   Description=Test Pervasive database
   ; DBName - named database
   DBQ=DEMODATA 
   

In addition, each data source should be mentioned in the section [ODBC Data Sources] in odbc.ini such as the following:

[ODBC Data Sources]
dsnName1=Pervasive.SQL data base dsnName2=Pervasive.SQL data base  

An easy way to verify DBName and DSN configuration settings is to run the supplied odbctest program as user psql:

% /usr/local/psql/bin/odbctest DSN=DEMODATA

See Also

butil(1), btadmin(1), syslogd(1), smb.conf(5), dbmaint(1)

API Programmer's Reference - describes the Pervasive.SQL API

Notes

Sqlmgr Daemon Mode

To start the SQL Manager as a daemon process (assuming $PVSW_ROOT/bin is in your path) run

% sqlmgr -start

As a daemon, sqlmgr relinquishes the control terminal and becomes the owner of the process group. To stop the database server process, run

% sqlmgr -stop

---

Note
The package installation script automatically launches sqlmgr and incorporates its execution into rc scripts for automatically starting and stopping the database server as part of the system boot sequence.

---

Sqlmgr Console Mode

To start the SQL database server in console mode (assuming $PVSW_ROOT/bin is in your path) run

% sqlmgr -console

Console mode is functionally equal to daemon mode, except that system messages are printed to standard out instead of /dev/console (or the system log).

Press ^C to exit sqlmgr console mode.