11.12.1 Changing the local work table buffer

This subsection explains how to change the number of pages in the local work table buffer while the HADB server is running.

You can use the adbmodbuff command to change the number of pages in the local work table buffer specified for the adb_dbbuff_wrktbl_clt_blk_num operand in the server definition.

The following is the procedure for using the adbmodbuff command to change the number of pages in the local work table buffer.

Procedure

Check the value specified for the adb_dbbuff_wrktbl_clt_blk_num operand in the server definition.

Use the adbls -d lbuf command to check the number of pages in the local work table buffer specified for the adb_dbbuff_wrktbl_clt_blk_num operand in the server definition.

The following shows an execution example of the adbls -d lbuf command.

Command specification example
```
adbls -d lbuf
```
When the adbls -d lbuf command is executed, an output result is displayed such as that shown in the following.

Example of output result of the executed command
```
CNUMBER    PAGE_SIZE PAGE_NUM
0          256       128 S
1          256       128 S
```
The number of pages in the local work table buffer specified for the adb_dbbuff_wrktbl_clt_blk_num operand in the server definition is output under PAGE_NUM in the row where CNUMBER is 0.
Change the number of pages in the local work table buffer.

Based on the output you checked in step 1, use the adbmodbuff command to change the number of pages in the local work table buffer specified for the adb_dbbuff_wrktbl_clt_blk_num operand in the server definition.

In this way, you can change the number of pages in the local work table buffer specified for the adb_dbbuff_wrktbl_clt_blk_num operand in the server definition while the HADB server is running.

Note that the content changed by the adbmodbuff command is lost when the HADB server terminates. If you want to retain the changed content for use during the next startup, incorporate the changed content into the server definition. For details about how to modify the server definition, see 8.5.2 Modifying the server definition.

In the following cases, you cannot change the number of pages in the local work table buffer by using the adbmodbuff command:

When the adb_dbbuff_wrktbl_clt_blk_num operand in the client definition is specified

Because the client definition takes precedence over the server definition, you cannot change the number of pages in the local work table buffer that are used even if you execute the adbmodbuff command.
When the export option adb_export_wrktbl_blk_num is specified

Because the export option takes precedence over the server definition, you cannot change the number of pages in the local work table buffer that are used even if you execute the adbmodbuff command.

Note

For details about the adb_dbbuff_wrktbl_clt_blk_num operand in the server definition, see the description of the adb_dbbuff_wrktbl_clt_blk_num operand in 7.2.2 Operands related to performance (set format).
For details about the adbmodbuff command, see adbmodbuff (Change Buffer) in the manual HADB Command Reference.
For details about the adbls -d lbuf command, see adbls -d lbuf (Display Local Work Table Buffer Information) in the manual HADB Command Reference.

To Page Top