search cancel

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

book

Article ID: 54047

calendar_today

Updated On:

Products

RC Compare for DB2 for z/OS Database Analyzer for DB2 for z/OS Fast Unload for DB2 for z/OS Fast Check for DB2 for z/OS Fast Index for DB2 for z/OS Rapid Reorg for DB2 for z/OS CA Distributed Database Management CA Database Analyzer for DB2 for Oracle Database Analyzer (IMS Tools) Mainframe Configuration Manager for IMS for z/OS IMS TOOLS - MISC Compress Data Compression (IMS Tools) Database Analyzer for IMS for z/OS Database Copier for IMS for z/OS Database Organizer for IMS for z/OS Mainframe Extended Terminal Manager (IMS Tools) High Performance Recovery for IMS for z/OS Database Organizer (IMS Tools) Mainframe Program Restart Manager for IMS for z/OS Secondary Index Builder for IMS for z/OS Secondary Index for IMS for z/OS

Issue/Introduction

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.

Environment

Release:
Component: DBA