35.2.2 Format of the buffer-modifying option

(1) Specification format

set adb_dbbuff_wrktbl_clt_blk_num = number-of-local-work-table-buffer-pages

The specification rules for this buffer-modifying option are the same as for the server definition. For details about the specification rules for the server definition, see Syntax rules for the server definition in the HADB Setup and Operation Guide.

To Page Top

(2) Explanation of specification format

• adb_dbbuff_wrktbl_clt_blk_num = number-of-local-work-table-buffer-pages

~<integer>((5 to 100,000,000))

Specifies the number of local work table buffer pages.

Specifying this option enables you to change temporarily the value of the server definition's adb_dbbuff_wrktbl_clt_blk_num operand (in which case this option's value takes precedence).

The value specified in this option will be lost when the HADB server is terminated.

If either of the following is specified, the number of local work table buffer pages will not be changed despite that this option is specified:

• adb_dbbuff_wrktbl_clt_blk_num operand in the client definition

• adb_export_wrktbl_blk_num export option

Note

• For details about the adb_dbbuff_wrktbl_clt_blk_num operand in the server definition, see the topic Operands related to performance (set format) in Detailed descriptions of the server definition operands in Designing the Server Definition in the HADB Setup and Operation Guide.

• For details about the adb_dbbuff_wrktbl_clt_blk_num operand in the client definition, see the topic Operands related to performance in Contents of operands in the client definition in Designing Client Definitions in the HADB Application Development Guide.

• For details about the adb_export_wrktbl_blk_num export option, see 14.2.2 Format of export options.

• For details about the SQL statements used to create local work tables, see the topic Work tables created when SQL statements are executed in Considerations when executing an SQL statement that creates work tables in Designs Related to Improvement of Application Program Performance in the HADB Application Development Guide.

To Page Top