Is it possible to exclude partitions from Database Analyzer for Db2 Action processing based on status
search cancel

Is it possible to exclude partitions from Database Analyzer for Db2 Action processing based on status

book

Article ID: 54047

calendar_today

Updated On:

Products

Database Analyzer for DB2 for z/OS

Issue/Introduction

Db2 tablespaces placed 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
Database Analyzer for Db2 for z/OS (PDA) processing.

Resolution

It is possible to exclude these manually in the PDA Extract procedure by selecting the partition using "E" for exclude. Details can be found in the PDA documentation.
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 PDA Action procedure. E.g.

  • CHECK FOR ONE OR MORE DB2 STATUSES