|
PxPlus SQL Server |
The PxPlus SQL Server allows the PxPlus SQL ODBC Driver, the PxPlus SQL Command Line Client, or any application using the PVKIO library to access PxPlus data on a remote system. The SQL Server can run on Windows and UNIX/Linux boxes; therefore, for example, it allows an ODBC application on Windows to access data on a UNIX/Linux box.
A Windows version and a UNIX/Linux version of the PxPlus SQL Server are available. The Windows version of the PxPlus SQL Server has its own installer. For installation procedures, see File IO Product Installation and Activation (Windows). The UNIX/Linux version of the PxPlus SQL Server has a stand-alone installation package. For installation procedures, see File IO Product Installation and Activation (UNIX/Linux).
Using a Web browser, you can check that the PxPlus SQL server is running correctly. See Checking the Server (Info Page).
Run the server from the Command Line using the following syntax:
dir/pxpsqlsvr [-f configfile] [-p tcpport]
Where:
|
dir |
Directory path; e.g. /usr/pxpsqlsvr |
|
-f configfile |
Path and file name of the SQL Server configuration file. If no configuration file is located, the server will not start, and an error message will be displayed or printed to the log file (if debug is enabled). See Configuration File. If this option is not specified, the server defaults to: ./pxpsqlsvr.conf, followed by |
|
-p tcpport |
TCP/IP port number on which the server is to listen. This overrides the port number specified in the pxpsqlsvr.conf file. |
The following arguments can also be used with the PxPlus SQL Server executable (pxpsqlsvr) at the Command Line:
|
-h or--help |
Display a message listing the available command line options with brief descriptions. |
|
-v or--version |
Display the server version information. Example: PxPlus SQL Server Ver: 5.00.0000 For: RedHat Enterprise Linux 3.0 |
|
-d or--debug |
Enable output to the debug log file pxpsqlsvr.log. |
|
-s or--shutdown |
Server shutdown. See Shutting Down the Server. |
Using a Web browser, you can check that the PxPlus SQL server is running correctly and get usage information by pointing at the PxPlus SQL Server IP address and port.
In the browser bar, you would enter:
sql_server_ip:sql_server_port
Example:
Example for server on 192.168.1.104 port 20223:
http://192.168.1.104:20223
If the server is running, this will load the Info page, which displays information about the server and its usage:
Hello from: PxPlus® SQL Server
Version: 7.10.0000
Registered: Yes (If not registered, it will show "Registered: Demo".)
Usage Info
Number of user slots in use: 0
Number of connections: 0
Number of files opened: 0 (The number of files opened will only display if the PxPlus SQL Server is running on Windows.)
(Support for loading an Info page was added in PxPlus 2023.)
The PxPlus SQL Server records the process ID (pid) of the server in the pxpsqlsvr.pid file to assist in shutting down the server.
Example:
pxpsqlsvr -s or
pxpsqlsvr --shutdown
Provided the server can locate the pxpsqlsvr.pid file, the running server will be shut down properly; otherwise, an error message will be displayed on standard out. Alternately, the server can be shutdown using a SIGHUP signal:
kill -1 pid
Where:
pid is the process ID of the PxPlus SQL Server, pxpsqlsvr.