7.1 Specification formats for server definition operands

1

set adb_db_path = DB-directory-name

System configuration

2

[set adb_rpc_port = HADB-server-port-number]

3

[set adb_sys_max_users = maximum-number-of-concurrent-connections]

4

[set adb_core_path = name-of-output-destination-directory-for-error-information-(core-files)]

5

[set adb_blk_path_wrk = path-name-of-block-special-file-of-work-table-DB-area-file]

6

[set adb_dbarea_wrk_page_size = page-size-of-work-table-DB-area]

7

[set adb_sys_rthd_num = number-of-processing-real-threads]

Performance

8

[set adb_sys_uthd_num = number-of-pseudo-threads-that-can-be-generated-in-a-real-thread]

9

[set adb_sys_memory_limit = maximum-size-of-memory-used-by-the-HADB-server]

10

[set adb_sql_exe_max_rthd_num = maximum-number-of-SQL-processing-real-threads]

11

[set adb_sql_exe_hashgrp_area_size = hash-group-area-size]

12

[set adb_sql_exe_hashtbl_area_size = hash-table-area-size]

13

[set adb_sql_exe_hashflt_area_size = hash-filter-area-size]

14

[set adb_sql_opt_drvtbl_grping_prior = {LOCAL|GLOBAL}]

15

[set adb_sys_rthd_area_max = maximum-size-of-real-thread-private-memory-that-can-be-allocated]

16

[set adb_sys_proc_area_max = maximum-size-of-process-common-memory-that-can-be-allocated]

17

[set adb_sys_shm_huge_page_size = multiple-of-the-single-page-size-in-HugePages]

18

[set adb_dbbuff_wrktbl_glb_blk_num = number-of-pages-in-global-buffer-for-global-work-tables]

19

[set adb_dbbuff_wrktbl_clt_blk_num = number-of-pages-in-buffer-for-local-work-tables]

20

[set adb_sql_tbldef_cache_size = table-definition-pool-size]

21

[set adb_log_usrfile_num = number-of-user-log-files]

System logs

22

[set adb_log_usrfile_size = initial-size-of-user-log-file[,threshold-where-user-log-file-size-is-reduced]]

23

[set adb_log_usrbuf_num = number-of-user-log-buffers]

24

[set adb_log_rec_msg_interval = output-interval-of-message-showing-database-recovery-processing-time-elapsed]

25

[set adb_sys_max_users_wrn_pnt = output-threshold-for-warning-message-regarding-maximum-number-of-concurrent-connections[,reset-threshold-for-warning-message-output]]

Status monitoring

26

[set adb_sys_memory_limit_wrn_pnt = output-threshold-for-warning-message-regarding-HADB-server-memory-usage[,reset-threshold-for-warning-message-output]]

27

[set adb_rpc_wait_time = upper-limit-for-wait-time]

28

[set adb_rpc_tcp_keepalive_time = no-communication-time-after-which-KeepAlive-probe-starts]

29

[set adb_sql_prep_delrsvd_words = reserved-word-to-be-unregistered[,reserved-word-to-be-unregistered]...]

SQL statements

30

[set adb_sys_trn_iso_lv = {READ_COMMITTED | REPEATABLE_READ}]

31

[set adb_sql_text_out = {Y | N}]

32

[set adb_sql_trc_out = {Y | N}]

33

[set adb_sql_trc_param = {Y | N}]

34

[set adb_sql_trc_accesspath = {Y | N}]

35

[set adb_sql_trc_level = {SQL | CALL}]

36

[set adb_sql_trc_txtfile_size = maximum-capacity-of-an-SQL-trace-file]

37

[set adb_sql_order_mode = {BYTE | ISO}]

38

[set adb_sql_prep_dec_div_rs_prior = {INTEGRAL_PART | FRACTIONAL_PART}]

39

[set adb_sql_default_dbarea_shared = default-name-of-data-DB-area-that-stores-tables-or-indexes]

40

[set adb_sql_rngidx_preread ={ALL|NO|range-index-name[,range-index-name]...}]

Range indexes

41

[set adb_sta_log_max_size = maximum-size-of-statistics-log-file]

Statistical information

42

[set adb_sta_log_path = name-of-output-destination-directory-for-statistics-log-files]

43

[set adb_sta_log_size_unit = {G|M}]

44

[set adb_syndict_storage_path = storage-directory-for-synonym-dictionary-files]

Synonym search

45

[set adb_syndict_node_storage_path = multi-node-synonym-dictionary-storage-directory]

46

[set adb_audit_log_path = audit-trail-directory]

Audit trail facility

47

[set adb_audit_log_max_size = maximum-size-of-audit-trail-file]

48

[set adb_audit_log_max_num = maximum-number-of-audit-trail-file-generations]

49

[set adb_sys_multi_node_info = node-host-name[:node-port-number], node-host-name[:node-port-number][,node-host-name[:node-port-number]] ...]

Multi-node function

50

[set adb_sys_node_start_wait_time = upper-limit-for-time-to-wait-for-startup-completion-of-other-nodes]

51

{{

[adbbuff -g global-buffer-name

{-n DB-area-name[,DB-area-name] ... | -o }

[-p number-of-pages-in-global-buffer]

[-a number-of-pages-in-global-buffer-dedicated-to-range-indexes]

[-v memory-size-used-for-table-scan-buffer[,maximum-memory-size-used-per-real-thread]]

[-k number-of-sectors-in-table-scan-buffer-for-batch-loading-segments]]

}}

Global buffer

52

{{

[adbcltgrp -g client-group-name

[-m maximum-number-of-concurrent-connections-for-the-specified-client-group]

[-u guaranteed-minimum-number-of-concurrent-connections-for-the-specified-client-group]

[-r maximum-number-of-processing-real-threads-usable-by-the-specified-client-group]

[-e guaranteed-minimum-number-of-processing-real-threads-usable-by-the-specified-client-group]

[-w output-threshold-for-warning-message-regarding-maximum-number-of-concurrent-connections-for-the-specified-client-group[,reset-threshold-for-warning-message-output]]]

}}

Client-group facility

53

[adbcltgrp -g command

[-m maximum-number-of-concurrent-connections-for-the-specified-command-group]

[-u guaranteed-minimum-number-of-concurrent-connections-for-the-specified-command-group]

[-r maximum-number-of-processing-real-threads-usable-by-the-specified-command-group]

[-e guaranteed-minimum-number-of-processing-real-threads-usable-by-the-specified-command-group]

[-w output-threshold-for-warning-message-regarding-maximum-number-of-concurrent-connections-for-the-specified-command-group[,reset-threshold-for-warning-message-output]]]