What is the meaning of the different REJECT-* statements generated by Database Analyzer for Db2 Action processing

Products

• Database Analyzer for DB2 for z/OS

Issue/Introduction

What is the meaning of the different REJECT-* statements generated by Database Analyzer for Db2 for z/OS (PDA) Action processing?

Resolution

Three different REJECT-* statements can be displayed in PTIMSG output during PDA action processing which disqualifies an object/object partition from action processing selection.

REJECT-1: Wrong type of object for condition. For example, PDA is processing a tablespace and the action condition is index specific.

REJECT-1C: Wrong type of object for cross-condition. For example, if using (IX) Clustered Percent as a cross condition, and if the index clustered percent is below the action condition threshold,
PDA would issue REJECT-1C when processing the index/index partition, but SELECT when processing its corresponding tablespace/tablespace partition. Cross Conditions use statistics from one object
type, to determine if its corresponding counterpart object type gets selected for action processing.

REJECT-2: Object failed the condition test. Statistics for the object did not exceed the action condition threshold set for that condition. Object/object partition does not get selected for action processing.