Is it possible to exclude partitions from action processing based on their status?

Document ID : KB000054047
Last Modified Date : 14/02/2018
Show Technical Document Details

Description:

For example. A customer may place certain partitions of a tablespace in "RO" status if they hold only historical data and as such will not be updated further.
They would not require reorg's, runstats, image copies etc for these partitions and would want to exclude them from PDA processing.

Solution:

It is possible to exclude these manually in the extract procedure by selecting the partition using "E" for exclude. Details can be found in the PDA Reference Guide.
This is not determined by status - just excluding manually by object name.

Alternatively, it is possible to exclude these objects using an action condition defined in the Action procedure. E.g.

  • CHECK FOR ONE OR MORE DB2 STATUSES

Action conditions are also documented in the Reference Guide and specific information can be found by entering "H" for help next to the actual condition within the creation of the Action procedure.