Show TOC

Database-Specific Parameters for DB2 for Z/OSLocate this document in the navigation structure

Use

Range Partitioning

Use

Since tables grow in size, it is sometimes easier to manage their data by means of limited ranges rather than operate on all of their content.

Description

Specify the columns to be used in the key within the <keycols> element. For every partition, you must define an element <part> in the <parts> section where you define the limit keys.

Syntax

This key consists of two char columns, F1 and F2. It has three partitions with the limit keys defined by (HD, MM) , (KA, XX) and MAXVALUE .

                              <db2>
        <partitioning>
                <keycols>
                        <name>F1</name>
                        <name>F2</name>
                </keycols>
                <parts>
                        <part>
                                <keyvalues>
                                        <keyvalue>'HD'</keyvalue>
                                        <keyvalue>'MM'</keyvalue>
                                </keyvalues>
                        </part>
                        <part>
                                <keyvalues>
                                        <keyvalue>'KA'</keyvalue>
                                        <keyvalue>'XX'</keyvalue>
                                </keyvalues>
                        </part>
                        <part>
                                <keyvalues>
                                        <keyvalue>MAXVALUE</keyvalue>
                                </keyvalues>
                        </part>
                </parts>
        </partitioning>
</db2>