What does the PSA(Subsystem Analyzer) RIDPOOL 'Number Columns Bypassed' Field indicate?

book

Article ID: 209416

calendar_today

Updated On:

Products

CA Database Management for DB2 for z/OS - Performance Suite

Issue/Introduction

In the PSA/ RIDPOOL screen there is a field "DB2 Maintenance Issues" and then under Row Failures a field "Number Columns Bypassed".  What is this number indicating, and its impact?  

Partial screen shot:

Rid Pool Use Processing Failures     
--------------------------------     
RDS Rid Limit Reached              0 
DM Rid Limit Reached               0 
DB2 Maintenance Issues         10491 

...

Row Failures                                                                   
---------------                                                                
Current Committed Inserts          0      Current Comitted Deletes           0 
Current Committed Updates          0      Number Columns Bypassed        10491 



 

Cause

The 'Help Panel' for this field states the following: 

Description:  The number of columns for which a DB2 internal 
procedure related to SELECT(SPROC) is bypassed because it was
invalid.                                                     
                                                             
The SELECT Procedure was invalidated because DB2 maintenance 
has been applied and the current SELECT procedure is down-   
leveled.

Environment

Release : 20.0

Component : CA Subsystem Analyzer for Db2 for z/OS (PSA), Sysview for Db2 for Z/OS (IDB2)

Resolution

This field means there are Db2 applications that need to have their plans/packages rebound.  IFCID 224 has pertinent information concerning the plans/packages that need to be rebound.  Please review the following IDB2 (Sysview for Db2) for more information on IFCID 224 along with the pertinent IDB2 batch reports. 

https://techdocs.broadcom.com/us/en/ca-mainframe-software/database-management/ca-sysview-performance-management-option-for-db2/20-0/reference/ifcid-records/records-and-fields-201-300/224-bypassed-procedure.html