5.6.2 Points to consider in storing a multi-chunk table in the data DB area
When you store multi-chunk tables and the indexes defined for those tables in one data DB area, consider the following points:
-
The maximum number of chunks that can be managed in one data DB area is 30,000.
-
Take into account the number of chunks in indexes, in addition to the number of chunks in tables.
- Example
-
Assume that you store multi-chunk tables and indexes in one data DB area as follows:
![[Figure]](GRAPHICS/F0000152.GIF)
-
The B-tree index IDX1 and the range index RIDX1 are defined for multi-chunk table T1. The maximum number of chunks specified for the multi-chunk table T1 is 1,000.
-
The B-tree index IDX2 is defined for multi-chunk table T2. The maximum number of chunks specified for multi-chunk table T2 is 500.
In this case, the maximum number of chunks to be created in T1, IDX1, and RIDX1 is 3,000. The maximum number of chunks to be created in T2 and IDX2 is 1,000.
![[Figure]](GRAPHICS/F0000153.GIF)
Therefore, the maximum number of chunks to be created in the data DB area is 4,000.
The total number of chunks cannot exceed 30,000.
-
A chunk is created for a stored table or index when background import is executed, enabling you to store multiple tables and indexes in a single data DB area. When storing multiple tables or indexes, do not exceed the maximum number of chunks that a single data DB area can manage.
- Note
-
For details about how to determine the maximum number of chunks, see 5.2.4 Points to consider in defining a multi-chunk table.
- ▪ For archivable multi-chunk tables
-
For archivable multi-chunk tables, also consider the following points:
-
Number of chunks in the range index that is automatically defined for the archive range column
Chunks are also created for the range index that is automatically defined for the archive range column. Therefore, you also need to calculate the number of chunks in this range index.
-
Number of chunks in a location table
An archivable multi-chunk table and its location table are stored in the same data DB area. Chunks are also created for this location table. Therefore, you also need to calculate the number of chunks in the location table. Use the following formula to determine the number of chunks in a location table:
Formula
![[Figure]](GRAPHICS/F0000154.GIF)
-