In versions earlier than 15.0, Adaptive Server automatically maintained an affinity between partitions and devices when you created multiple partitions on a segment that was mapped to multiple database devices. This is no longer the case in Adaptive Server 15.0 and later; all partitions are created on the first device. To achieve affinity between partitions and devices:
Create a segment for a particular device.
Explicitly place a partition on that segment.
You can create as many as 29 user segments, and you must use the alter table syntax from Adaptive Server version 15.0 and later to create the segments, because the earlier syntax (alter table t partition 20) does not support explicit placement of partitions on segments.
Achieve the best I/O performance for parallel queries by matching the number of partitions to the number of devices in the segment.
You can partition tables that use the text, image, or Java off-row data types. However, the columns themselves are not partitioned—they remain on a single page chain.
