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).

Related topics

ObjectPartition-parameters

Configurations-for-specific-tasks

Attributes

This parameter has the following attributes:

Attribute

Value

Section

[ObjectPartition]

Abbreviation

None

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.

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*