Chunk Management in a Directory-Based Distributed Database
As with user-defined data distribution, tablespaces created for directory-based data distribution are assigned to chunks.
The total number of chunks is defined by the number of partitions specified in the
sharded table. The number of chunks for a given shardspace is the number of partitions
assigned to it. The ALTER TABLE ADD
, DROP
, and
SPLIT PARTITION
commands on
the sharded table increases or decrease the number of chunks.
The GDSCTL SPLIT CHUNK
command, which is used to split a
chunk in the middle of the hash range for system-managed data distribution, is not
supported for directory-based data distribution. You must use the ALTER TABLE
SPLIT PARTITION
statement to split a chunk.
Also, just like user-defined data distribution, no chunk migration is
automatically started when a shard is added to the distributed database. You must run the GDSCTL MOVE CHUNK
command for each chunk that
needs to be moved to another shard.