Hitachi

Hitachi Advanced Database Setup and Operation Guide


5.7 Designing a work table DB area

A work table DB area is used for storing work tables. A work table is created when you execute an SQL statement that creates a work table.

You specify the page size (in kilobytes) of the work table DB area in the adb_init_wrk_page_size operand, which is an initialization option in the adbinit command. For the page size of the work table DB area, specify 256 kilobytes in most cases.

If the page size of the work table DB area is too small, it will be unable to store work tables with long row lengths. An error might occur depending on the SQL statement that is executed. An example in which an error would occur is when executing a SQL statement that results in a work table with a long row length because the columns that constitute the work table include columns with long definition lengths. Therefore, you must consider the row length of the resulting work table when specifying the page size of the work table DB area. For details about how to determine the row length of work tables, see 5.9.2 Determining the number of pages for base rows that are needed for storing work tables.

To change the page size of a work table DB area, specify the new page size in kilobytes for the adb_dbarea_wrk_page_size operand in the server definition. Then, restart the HADB server.

For details about the SQL statements that create work tables, see Work tables created when SQL statements are executed under 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.