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.

Table 3‒3: System properties that can be specified
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: How long a HADB client waits for the HADB server to respond to a processing request. How long to wait to secure processing real threads if a shortage occurs when multiple `SELECT` statements are executed concurrently in the same connection. 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`

To Page Top