3.1.6 Setting system properties
Use system properties to set up an execution environment for application programs. The following table lists the properties that can be specified as system properties.
- Important
-
-
In the following table, properties from 1 to 18 are functionally the same as the operands in the client definition.
-
Property 19 and subsequent properties specify the settings related to the Exception trace log.
-
No. |
Property name |
Description |
|
---|---|---|---|
1 |
adb_clt_rpc_srv_host |
Specifies the host name of the HADB server at the connection destination. Functionally, this property is the same as the adb_clt_rpc_srv_host operand in the client definition. For details about this property and its permitted values, see the description of the adb_clt_rpc_srv_host operand in the client definition. |
|
2 |
adb_clt_rpc_srv_port |
Specifies the port number of the HADB server that is used for communication between the HADB client and the HADB server. Functionally, this property is the same as the adb_clt_rpc_srv_port operand in the client definition. For details about this property and its permitted values, see the description of the adb_clt_rpc_srv_port operand in the client definition. |
|
3 |
adb_clt_rpc_con_wait_time |
Specifies the maximum amount of time to wait for HADB server connection processing to be completed. Functionally, this property is the same as the adb_clt_rpc_con_wait_time operand in the client definition. For details about this property and its permitted values, see the description of the adb_clt_rpc_con_wait_time operand in the client definition. |
|
4 |
adb_clt_rpc_sql_wait_time |
Specifies the following wait times:
For details about the wait time monitoring performed if this property is specified, see 3.2 Handling unresponsive application programs. Functionally, this property is the same as the adb_clt_rpc_sql_wait_time operand in the client definition. For details about this property and its permitted values, see the description of the adb_clt_rpc_sql_wait_time operand in the client definition. |
|
5 |
adb_clt_ap_name |
Specifies the identification information (application identifier) for the application program that is to be connected to the HADB server. Functionally, this property is the same as the adb_clt_ap_name operand in the client definition. For details about this property and its permitted values, see the description of the adb_clt_ap_name operand in the client definition. |
|
6 |
adb_clt_group_name |
Specifies the name of the client group to which the application belongs. Functionally, this property is the same as the adb_clt_group_name operand in the client definition. For details about this property and its permitted values, see the description of the adb_clt_group_name operand in the client definition. |
|
7 |
adb_clt_fetch_size |
Specifies the maximum number of rows that are to be sent as retrieval results from the HADB server to the HADB client by a single FETCH process. Functionally, this property is the same as the adb_clt_fetch_size operand in the client definition. For details about this property and its permitted values, see the description of the adb_clt_fetch_size operand in the client definition. |
|
8 |
adb_dbbuff_wrktbl_clt_blk_num |
Specifies the number of local work table buffer pages. Functionally, this property is the same as the adb_dbbuff_wrktbl_clt_blk_num operand in the client definition. For details about this property and its permitted values, see the description of the adb_dbbuff_wrktbl_clt_blk_num operand in the client definition. |
|
9 |
adb_sql_exe_max_rthd_num |
Specifies the maximum number of SQL processing real threads. Functionally, this property is the same as the adb_sql_exe_max_rthd_num operand in the client definition. For details about this property and its permitted values, see the description of the adb_sql_exe_max_rthd_num operand in the client definition. |
|
10 |
adb_sql_exe_hashgrp_area_size |
Specifies the size (in kilobytes) of the hash grouping area. Functionally, this property is the same as the adb_sql_exe_hashgrp_area_size operand in the client definition. For details about this property and its permitted values, see the description of the adb_sql_exe_hashgrp_area_size operand in the client definition. |
|
11 |
adb_sql_exe_hashtbl_area_size |
Specifies the size (in megabytes) of the hash table area. Functionally, this property is the same as the adb_sql_exe_hashtbl_area_size operand in the client definition. For details about this property and its permitted values, see the description of the adb_sql_exe_hashtbl_area_size operand in the client definition. |
|
12 |
adb_sql_exe_hashflt_area_size |
Specifies the size (in megabytes) of the hash filter area. Functionally, this property is the same as the adb_sql_exe_hashflt_area_size operand in the client definition. For details about this property and its permitted values, see the description of the adb_sql_exe_hashflt_area_size operand in the client definition. |
|
13 |
adb_sql_prep_delrsvd_use_srvdef |
Specifies whether reserved words are to be unregistered if specified as such in the adb_sql_prep_delrsvd_words operand in the server definition. Functionally, this property is the same as the adb_sql_prep_delrsvd_use_srvdef operand in the client definition. For details about this property and its permitted values, see the description of the adb_sql_prep_delrsvd_use_srvdef operand in the client definition. |
|
14 |
adb_clt_trn_iso_lv |
Specifies the transaction isolation level. Functionally, this property is the same as the adb_clt_trn_iso_lv operand in the client definition. For details about this property and its permitted values, see the description of the adb_clt_trn_iso_lv operand in the client definition. |
|
15 |
adb_clt_trn_access_mode |
Specifies the transaction access mode. Functionally, this property is the same as the adb_clt_trn_access_mode operand in the client definition. For details about this property and its permitted values, see the description of the adb_clt_trn_access_mode operand in the client definition. |
|
16 |
adb_clt_sql_text_out |
Specifies whether SQL statements issued by the HADB client are to be output to the client message log files and the server message log files. Functionally, this property is the same as the adb_clt_sql_text_out operand in the client definition. For details about this property and its permitted values, see the description of the adb_clt_sql_text_out operand in the client definition. |
|
17 |
adb_clt_sql_order_mode |
Specifies the sort order for character string data in a SELECT statement in which the ORDER BY clause is specified. Functionally, this property is the same as the adb_clt_sql_order_mode operand in the client definition. For details about this property and its permitted values, see the description of the adb_clt_sql_order_mode operand in the client definition. |
|
18 |
adb_sql_prep_dec_div_rs_prior |
Specifies the minimum scaling value of the result of a division operation (arithmetic operation) specified in an SQL statement when the data type of the result is DECIMAL. Functionally, this property is the same as the adb_sql_prep_dec_div_rs_prior operand in the client definition. For details about this property and its permitted values, see the description of the adb_sql_prep_dec_div_rs_prior operand in the client definition. |
|
19 |
adb_jdbc_exc_trc_out_path |
Specifies the absolute path of the directory to which exception trace logs are to be output. |
For details about these properties and their permitted values, see (b) Setup for acquisition of the exception trace log (setting properties) in (1) Methods to be acquired and setup for log acquisition in 7.7.2 Exception trace log. |
20 |
adb_jdbc_info_max |
Specifies the maximum number of information items to be output to one file. |
|
21 |
adb_jdbc_cache_info_max |
Specifies the maximum number of information items to be stored in memory. |
|
22 |
adb_jdbc_trc_out_lv |
Specifies the trace acquisition level. |
- Important
-
The values of the properties listed in the preceding table can also be specified by using user properties or the properties of the URL to be used for connection.
For details about the user properties, see (d) Values to be specified in the info argument (specifying the user properties) in (2) Connecting to the HADB server with the getConnection method in 7.3.1 Using the getConnection method of the DriverManager class to connect to the HADB server.
For details about the properties of the URL to be used for connection, see (a) Values to be specified in the url argument (specifying the URL for the connection) in (2) Connecting to the HADB server with the getConnection method in 7.3.1 Using the getConnection method of the DriverManager class to connect to the HADB server.
For details about the priority of each specification, see 7.3.3 Connection information priorities.
- Note
-
The property names of system properties were changed in HADB 03-00, as shown below. The previous property names are still supported, but if you have upgraded your HADB to version 03-00 or later, we recommend that you change the property names.
No.
Property name before change (property name used in HADB versions earlier than 03-00)
Property name after change (property name used in HADB version 03-00 or later)
1
adb_jdbc_ap_name
adb_clt_ap_name
2
adb_jdbc_dbbuff_wrktbl_blk_num
adb_dbbuff_wrktbl_clt_blk_num
3
adb_jdbc_fetch_size
adb_clt_fetch_size
4
adb_jdbc_rpc_sql_wait_time
adb_clt_rpc_sql_wait_time
5
adb_jdbc_rpc_srv_host
adb_clt_rpc_srv_host
6
adb_jdbc_rpc_srv_port
adb_clt_rpc_srv_port
7
adb_jdbc_sql_delrsvd_use_srvdef
adb_sql_prep_delrsvd_use_srvdef
8
adb_jdbc_sql_hashgrp_area_size
adb_sql_exe_hashgrp_area_size
9
adb_jdbc_sql_hashtbl_area_size
adb_sql_exe_hashtbl_area_size
10
adb_jdbc_sql_max_rthd_num
adb_sql_exe_max_rthd_num
11
adb_jdbc_sql_order_mode
adb_clt_sql_order_mode
12
adb_jdbc_sql_text_out
adb_sql_text_out
13
adb_jdbc_trn_access_mode
adb_clt_trn_access_mode
14
adb_jdbc_trn_iso_lv
adb_clt_trn_iso_lv