Skip to Content

FILTERPART

This option allows UNLOAD PLUS to filter out partitions that do not meet the WHERE clause criteria when you use the first column of the partitioning key in your WHERE clause.

Related topic

Basic processing options

 

FILTERPART.png

Specifying PART within a SELECT OPTIONS statement overrides the FILTERPART command option for the corresponding SELECT statement.

Restriction

UNLOAD PLUS ignores this option when DIRECT NO is in effect.

NO

FILTERPART NO is the default. When you specify FILTERPART NO, UNLOAD PLUS reads all partitions of the partitioned table space.

YES

When you specify FILTERPART YES, UNLOAD PLUS filters out partitions that do not meet the selection criteria. UNLOAD PLUS uses only the SYSREC data sets that are related to the unloaded partitions.

Information
Example

In the following example, COL1 is the column that causes the break of partitions. If you use COL1 in the WHERE clause, UNLOAD PLUS filters out partitions that do not meet the criteria of the WHERE clause. If you specify FILTERPART YES, UNLOAD PLUS reads only partitions 2 and 3.

Three-column partitioning key:

 

Partition number

COL1

COL2

COL3

Partition 1

199

xxx

005

Partition 2

299

xxx

010

Partition 3

399

xxx

020

Partition 4

499

xxx

030

SELECT statement:

SELECT * FROM <your.tableName>
     WHERE COL1 > '200'
       AND COL1 < '399'

Restrictions

FILTERPART YES has the following restrictions:

  • UNLOAD PLUS does not support this option for image copies. If you specify FILTERPART YES, UNLOAD PLUS issues message BMC50138I and functions as if you specified FILTERPART NO.
  • UNLOAD PLUS ignores this option when unloading partition-by-growth table spaces.

Additional consideration

For the predicate on your WHERE clause, if you specify a value that equals the limit key, UNLOAD PLUS might read an additional partition.

 

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

UNLOAD PLUS for DB2 13.1