Skip to content

ALTER DATABASE LINKER

ALTER DATABASE LINKER#

Syntax#

alter_database_linker ::=

Prerequisites#

This statement can be executed by the SYS user connected in sysdba administrator mode.

Description#

Starts or terminates the AltiLinker.

START#

Starts the AltiLinker, provided that no running AltiLinker process exists.

STOP#

Stops the AltiLinker. However, for AltiLinker shutdown to succeed, there should be no transactions using the database link. If there is a transaction using the database link, this statement will fail.

STOP FORCE#

Forcefully stops the AltiLinker process, regardless of there being a transaction using the database link.

DUMP#

If this statement is executed while the AltiLinker process is running, operations which are currently being executed by the threads within the AltiLinker process are output to a file. The output file is fixed as $ALTIBASE_HOME/trc/altibase_lk_dump.log and is overwritten every time the ALTER DATABASE LINKER DUMP statement is executed.

Examples#

iSQL(sysdba)> ALTER DATABASE LINKER START;
Alter success.
iSQL(sysdba)> ALTER DATABASE LINKER STOP;
Alter success.
iSQL(sysdba)> ALTER SESSION LINKER STOP FORCE;
Alter success.
iSQL(sysdba)> ALTER SESSION LINKER DUMP;
Alter success.