You can adjust the number of data segments by changing the configuration option “Total No. of Data Segments.” This option is set, by default, at 50 segments, the optimal value based on stress testing of 500 concurrent data loads of 20,000 records. At this high level of concurrent batch loads, 50 segments provided good throughput and no deadlocking.
After a CIM relational repository is used to load data, the “Total No. of Data Segments” configuration options can only be increased. To decrease the data-segment count, all segment tables must be dropped and recreated. This process results in the loss of all segment data.