LimitKey
The LimitKey parameter corresponds to the LIMITKEY column in the SYSIBM.SYSTABLEPART table of the Db2 catalog. If you know this value, you can define the partition key by specifying the LimitKey parameter (instead of specifying a set of Value parameters for each set of columns).
Attributes
This parameter has the following attributes:
Attribute | Value |
---|---|
Section | [ObjectPartition] |
Abbreviation | None |
DBMS | Db2 |
Required? | No |
Valid values | A hexadecimal limit key that represents the column and value of the partition key |
Default value | None |
Usage
The LimitKey parameter follows the Partition parameter in the [ObjectPartition] section. The value of the LimitKey parameter is an aggregate hexadecimal notation of the values for the Column set. The High-speed Apply Engine converts the value that you specify to an internal format and uses it as the upper limit for the partition key.