DB2 Version 9.7 for Linux, UNIX, and Windows

SYSCAT.PARTITIONMAPS catalog view

Each row represents a distribution map that is used to distribute the rows of a table among the database partitions in a database partition group, based on hashing the table's distribution

Table 1. SYSCAT.PARTITIONMAPS Catalog View
Column Name Data Type Nullable Description
PMAP_ID SMALLINT   Identifier for the distribution map.
PARTITIONMAP BLOB (65536)   Distribution map, a vector of 32768 two-byte integers for a multiple partition database partition group. For a single partition database partition group, there is one entry denoting the partition number of the single partition.