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

SQLMGR required settings:

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

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

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.