Altibase Server Configuration for IPC Communication#
Overview#
There are four communication methods between the database server and client provided by Altibase. Among these, this document describes the Altibase and OS configurations required for IPC communication.
- TCP/IP
- Unix Domain Socket
- IPC using shared memory
- IPCDA (supported from Altibase 7.1)
- SSL/TLS (supported from Altibase version 6.5.1)
For a description of each communication method, please refer to the "12. Server/Client Communication" section from the Administrator's manual.
Manual Page:
Version#
All the Altibase versions
Altibase Server Configurations#
By default, the Altibase server does not allow IPC access. So, in order to connect to the Altibase server with the IPC connection type, the Altibase server properties must be changed.
Related properties cannot be changed while the Altibase server is running. Therefore, the Altibase server needs to be restarted in order to change the property value.
IPC_PORT_NO#
This property is required when running an Altibase server on a Windows system.
Unix and Linux use the 'Unix domain socket' in the form of a file for IPC connection, but Windows does not support this, so a TCP port is required for IPC connection.
In Windows, IPC connections communicate using shared memory, semaphores, and mutexes over TCP connections.
IPC_CHANNEL_COUNT#
This property configures the maximum number of IPC sessions that can be connected to the Altibase server. The default value is 0, and the Altibase server is configured not to allow IPC access.
IPC_FILEPATH#
IPC communicates with the Altibase server with the 'Unix domain socket' in the form of a file. If the 'Unix domain socket' file does not exist or the path is set incorrectly, the connection will fail. Starting from Altibase server version 5.5.1.4.2, the user can change this path arbitrarily with the IPC_FILEPATH property, and the setting value can be checked in the performance view.
SELECT NAME, MEMORY_VALUE1 FROM X$PROPERTY WHERE NAME = 'IPC_FILEPATH';
Altibase server versions prior to 5.5.1.4.2 cannot change the default path and do not provide a separate verification method.
- The default setting of Altibase server version 4.3.9
The location and name of the Unix domain socket file is $ALTIBASE_HOME/trc/alti-ipc. - The default setting of Altibase server version 4.3.9 or later and earlier than 5.5.1.4.2
The location and name of the Unix domain socket file is $ALTIBASE_HOME/trc/cm-ipc.
How to change properties#
-
Changing altibase.properties file
Change the required values among the properties described above in the $ALTIBASE_HOME/conf/altibase.properties file and save the altibase.properties file.$ cd $ALTIBASE_HOME/conf $ vi altibase.properties -
Restarting Altibase DB
Restart the Altibase server to reflect the changed property values to the Altibase server.$ server restart -
Checking properties
Check that the values have been properly reflected.$ is iSQL> SELECT NAME, MEMORY_VALUE1 FROM X$PROPERTY WHERE NAME IN ('IPC_FILEPATH', 'IPC_CHANNEL_COUNT', 'IPC_FILEPATH'); -
Testing IPC connection
Try to test the iSQL connection with the IPC type.$ export ISQL_CONNECTION=IPC # Change the environment variable that sets the iSQL connection type. $ is ----------------------------------------------------------------- Altibase Client Query utility. Release Version 7.1.0.6.5 Copyright 2000, ALTIBASE Corporation or its subsidiaries. All Rights Reserved. ----------------------------------------------------------------- ISQL_CONNECTION = IPC, SERVER = localhost # ISQL_CONNECTION = IPC 으로 나오고 iSQL 프롬프트가 떠야 IPC 접속 성공 iSQL>
OS Configurations#
Shared memory and semaphore resources are used for IPC communication. Therefore, to use the IPC type, the related kernel parameters must be set.
Please refer to the documents below depending on the OS. There is no recommended configurations for AIX and Windows.
- Linux: Linux Setup Guide for Altibase
- SunOS: Solaris Setup Guide for Altibase
- HP-UX: HP-UX Setup Guide for Altibase
- AIX: AIX Setup Guide for Altibase
How the application communicates#
Please refer to each manual for how to set the connection properties in the application program.
- CLI/ODBC: Refer to 2. Altibase CLI function -> SQLDriverConnect function description in CLI User's Manual.
- APRE (C/C++ Precompiler): From Precompiler User's Manual 6. Embedded SQL statement -> SQL statement related to connection -> CONNECT
- JDBC: From the JDBC User's Manual 1. Getting Started with JDBC -> Connection Information