Versions Compared

Old Version 1

changes.mady.by.user richard.nahm

Saved on

compared with

New Version Current

changes.mady.by.user richard.nahm

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

ALTIBASE HDB 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 HDB 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 HDB 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

  1. 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.

    Code Block
    languagebash
    $ cd $ALTIBASE_HOME/conf
$ vi altibase.properties

  2. Restarting ALTIBASE HDB
    Restart the Altibase server to reflect the changed property values to the Altibase server.

    Code Block
    $ server restart

  3. Checking properties
    Check that the values have been properly reflected.

    Code Block
    languagesql
    $ is
iSQL> SELECT NAME, MEMORY_VALUE1 FROM X$PROPERTY WHERE NAME IN ('IPC_FILEPATH', 'IPC_CHANNEL_COUNT', 'IPC_FILEPATH'); 

  4. Testing IPC connection
    Try to test the iSQL connection with the IPC type.

    Code Block
    $ export ISQL_CONNECTION=IPC                                                # Change the environment variable that sets the iSQL connection type.
$ is
-----------------------------------------------------------------
     Altibase Client Query utility.
     Release Version 5.5.1.4.6
     Copyright 2000, ALTIBASE Corporation or its subsidiaries.
     All Rights Reserved.
-----------------------------------------------------------------
ISQL_CONNECTION = IPC, SERVER = localhost, PORT_NO = 20300                  # IPC connection is successful only when ISQL_CONNECTION = IPC appears and the iSQL prompt appears.
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.

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 HDB 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