sections; added sections on Guardian and installing multiple servers. Removed “if-you-do-not-find-the-re- lease-notes” tip. Heavily edited and extended the “Testing your installation” sections. The “Other things

14.4.1. SET SESSION IDLE TIMEOUT . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 626 14.4.2. SET STATEMENT TIMEOUT . . . . . . . . . . . . in PSQL are: ALTER SESSION RESET SET BIND SET DECFLOAT SET ROLE SET SESSION IDLE TIMEOUT SET STATEMENT TIMEOUT SET TIME ZONE SET TRUSTED ROLE Example of Management Statements in PSQL create or isolation level of the current transaction: 'READ COMMITTED', 'SNAPSHOT' or 'CONSISTENCY'. LOCK_TIMEOUT Lock timeout of the current transaction. NETWORK_PROTOCOL The protocol used for the connection: 'TCPv4'

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 47 18.13. SET LOCAL_TIMEOUT. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . These include: • NO AUTO UNDONE • IGNORE LIMBO • LOCK TIMEOUT number Example: SET TRANSACTION WAIT SNAPSHOT NO AUTO UNDONE LOCK TIMEOUT 10;  If you request help on the set in isql then the set OFF Warnings: ON Bail on error: OFF Local statement timeout: 0 Keep transaction params: ON SET TRANSACTION 18.2. SET AUTOddl SQL> SET AUTOddl [on | off];

command to close a database is: gfix -sh[utdown] OPTION TIMEOUT database_name  Before Firebird 3, the command line switch was -⁠shut. The TIMEOUT parameter is the time, in seconds, that the shutdown must command to complete in, you can abort the shutdown by using the -⁠o[nline] command (see below) if the timeout period has not completed. 11.1.1. Preventing New Connections -⁠at[tach] prevents any new connections SYSDBA and the database owner. The shutdown will fail if there are any sessions connected after the timeout period has expired. It makes no difference if those connected sessions belong to the Chapter 11

SAVEPOINT Внутренние точки сохранения Точки сохранения и PSQL SET TRANSACTION IGNORE LIMBO LOCK TIMEOUT NO AUTO UNDO 9. Операторы PSQL Блок BEGIN ... END может быть пустым BREAK CLOSE CURSOR DECLARE { SNAPSHOT [TABLE STABILITY] | READ COMMITTED [[NO] RECORD_VERSION] } ] [WAIT | NO WAIT] [LOCK TIMEOUT seconds] [NO AUTO UNDO] [IGNORE LIMBO] [RESERVING | USING ] ::= Она задаёт базы данных, к которым транзакция может получить доступ; • Опции IGNORE LIMBO и LOCK TIMEOUT не доступны в ESQL; • Опции IGNORE LIMBO и NO WAIT являются взаимоисключающими; • Опции по умолчанию

транзакции — CURRENT_TRANSACTION. Значения: "READ_COMMITED", "SNAPSHOT" или "CONSISTENCY". LOCK_TIMEOUT Время ожидания транзакцией высвобождения ресурса при блокировке, в секундах. NETWORK_PROTOCOL Протокол SNAPSHOT [TABLE STABILITY] | READ COMMITTED [[NO] RECORD_VERSION] }] [NO WAIT | WAIT [LOCK TIMEOUT seconds]] [NO AUTO UNDO] [IGNORE LIMBO] [RESTART REQUESTS] [RESERVING | USING ] ONLY); • режим разрешения блокировок (WAIT, NO WAIT) с возможным дополнительным уточнением LOCK TIMEOUT; • уровень изоляции (READ COMMITTED, SNAPSHOT, TABLE STABILITY); • средства резервирования или

isolation level of the current transaction: 'READ COMMITTED', 'SNAPSHOT' or 'CONSISTENCY'. LOCK_TIMEOUT Lock timeout of the current transaction. Added in 2.5.3. READ_ONLY Returns 'TRUE' if current transaction SNAPSHOT [TABLE STABILITY] | READ COMMITTED [[NO] RECORD_VERSION] }] [WAIT | NO WAIT] [LOCK TIMEOUT seconds] [NO AUTO UNDO] [IGNORE LIMBO] [RESERVING | USING ] Chapter access mode (READ WRITE, READ ONLY) • lock resolution mode (WAIT, NO WAIT) with an optional LOCK TIMEOUT specification • isolation level (READ COMMITTED, SNAPSHOT, TABLE STABILITY) • a mechanism for reserving

[[NO] RECORD_VERSION] } | NO AUTO UNDO | RESTART REQUESTS | IGNORE LIMBO | LOCK TIMEOUT seconds | RESERVING | USING ::= [, Datenzugriffsmodus (READ WRITE, READ ONLY) • Auflösungsmodus sperren (WAIT, NO WAIT) mit einer optionalen LOCK TIMEOUT Spezifikation • Isolationsstufe (READ COMMITTED, SNAPSHOT, SNAPSHOT TABLE STABILITY).  Die Isolationsstufe Transaktion WAIT wird angehalten, bis der Konflikt gelöst ist. Wenn für die Transaktion WAIT ein LOCK TIMEOUT angegeben ist, wird nur für die in dieser Klausel angegebene Anzahl von Sekunden gewartet. Wenn

isc_dpb_lc_ctype Character set UTF8 isc_dpb_sql_role_name User role RDB$ADMIN * isc_dpb_connect_timeout Connection timeout 10 * isc_dpb_user_name User name SYSDBA isc_dpb_password User password masterkey

команду ping 192.13.14.1 заменив вымышленный IP-адрес Вашим реальным. Внимание Если Вы получаете timeout-сообщения (и не знаете, что с этим делать), изучите материал Using Firebird – глава 6: Network Configuration