11.4.10 Changing the maximum number of chunks
To change the value for the maximum number of chunks that was specified when a multi-chunk table was defined (value specified for CHUNK), execute the ALTER TABLE statement. The following shows the procedure for changing the value.
Procedure:
-
Check the value for the maximum number of chunks that was specified when a multi-chunk table was defined.
Check the value specified as the maximum number of chunks when defining the multi-chunk table based on the explanation in (13) When identifying the maximum number of chunks created in all multi-chunk tables under B.22 Searching a dictionary table.
-
Execute the ALTER TABLE statement to change the value for the maximum number of chunks.
The following shows a specification example of the ALTER TABLE statement.
Specification example
This example changes the value for the maximum number of chunks for the shop table (SHOPSLIST) to 500.
ALTER TABLE "SHOPSLIST" CHANGE OPTION CHUNK=500
- Important
-
-
Determine the value to be specified for CHANGE OPTION CHUNK of the ALTER TABLE statement based on the explanation in (4) Determining the maximum number of chunks under 5.2.4 Points to consider in defining a multi-chunk table.
-
Check whether the value specified for CHANGE OPTION CHUNK of the ALTER TABLE statement does not exceed the maximum number of chunks that can be managed in one data DB area, described in 5.6.2 Points to consider in storing a multi-chunk table in the data DB area.
-