Contains a row for each partitioning map that is used to distribute the
rows of tables among the partitions in a nodegroup, based on hashing the tables partitioning
key.
Table 81. SYSCAT.PARTITIONMAPS Catalog View
Column Name | Data Type | Nullable | Description |
---|---|---|---|
PMAP_ID | SMALLINT |
| Identifier of the partitioning map. |
PARTITIONMAP | LONG VARCHAR FOR BIT DATA |
| The actual partitioning map, a vector of 4096 two-byte integers for a multiple node nodegroup. For a single node nodegroup, there is one entry denoting the partition (or node) number of the single node. |