SQL Reference

SYSCAT.PARTITIONMAPS

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 76. 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 4 096 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.


[ Top of Page | Previous Page | Next Page ]