16.3.5 Creating server definitions on all nodes

When you use the multi-node function, you need to create a server definition on each node. When doing so, you must specify the adb_sys_multi_node_info operand.

For details about how to create a server definition, see 8.5 Creating and modifying a server definition. For details about the operands in the server definition, see 7. Designing the Server Definition.

You must specify the same value on each node for the following operands. If you omit an operand, omit it from all nodes. If the specification values are different, HADB servers in the multi-node configuration will not be able to start.

adb_dbarea_wrk_page_size
adb_sys_multi_node_info (The values also need to be specified in the same order.)
adb_sys_max_users
adb_sys_max_users_wrn_pnt
adb_sys_trn_iso_lv
adb_sql_order_mode
adb_sql_prep_delrsvd_words (The values also need to be specified in the same order.)
adb_rpc_port
adb_sql_prep_dec_div_rs_prior
adb_sql_default_dbarea_shared
adb_syndict_storage_path
adbcltgrp (-g, -m, -u, and -w options)

You must specify the following operands on all nodes when using the audit trail facility. The values specified for the operands do not need to be the same on all nodes. If any of these operands are specified on some nodes but not others, HADB servers in the multi-node configuration will not be able to start.

adb_audit_log_path

■ Server definition specification example

A server definition specification example is provided below. In this example, the specification content is identical on all nodes. However, except for the operands that need to have the same specification values, you can change the specification values for each node.

set adb_db_path = /HADB/db
set adb_rpc_port = 23650
set adb_sys_max_users = 10
set adb_sys_rthd_num = 40
set adb_sys_uthd_num = 128
set adb_sql_exe_max_rthd_num = 4
set adb_sys_rthd_area_max = 1024
set adb_sys_proc_area_max = 8192
set adb_sys_multi_node_info =172.16.0.11:23651,\    ...1
                             172.16.0.12:23651,\    ...2
                             172.16.0.13:23651      ...3
 
adbbuff -g TBLBUF01 \
        -n ADBUTBL01 \
        -p 1000000 \
        -v 1024
adbbuff -g IDXBUF01 \
        -n ADBUIDX01 \
        -p 2500000

Explanation

Specify IP address 172.16.0.11 and port number 23651 for communication between HADB servers on master node hadb01.
Specify IP address 172.16.0.12 and port number 23651 for communication between HADB servers on slave node hadb02.
Specify IP address 172.16.0.13 and port number 23651 for communication between HADB servers on slave node hadb03.

To Page Top