Database Analyzer for DB2 for z/OS - Capture Threshold Values (CTV) usage

Products

• Database Analyzer for DB2 for z/OS

Issue/Introduction

Maintenance was applied and the following new PDA options for Capture Threshold Value CTV were introduced  as below (With their default values):

COLLECT_CTV (00013)   
PRINT_CTV (Y)  

With these new parameters every run of an Extract Procedure that is using Name based extract (MODE ==> N ) is causing extensive number of rows to be inserted to the PTI.RAOS_CTVAP_2000 table. 
 
This functionality is tightly related with RTOS Extract Procedures that was not used in the Extract Procedure.
  
How the extensive number of inserts over the PTI.RAOS_CTVAP_2000 table can be suppressed?. 

Environment

Release : 20.0

Component : Database Analyzer for DB2 for z/OS

Resolution

The Capture Threshold Value CTV was released in two parts, the latter included the CTV for Action Procedures. On this way objects were selected when either RTOS Conditions or Action Conditions are used. 

If the CTV result updating the PTI.RAOS_CTVAP_2000 table is not need, the collection procedure can be turned off by updating the R200.CDBAPARM(PDA) member with the value for COLLECT_CTV to X as shown below: 

COLLECT_CTV (X)