What does the PSA(Subsystem Analyzer) RIDPOOL 'Number Columns Bypassed' Field indicate?
Article ID: 209416
Updated On:
Products
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
Environment
Release : 20.0
Component : CA Subsystem Analyzer for Db2 for z/OS (PSA), Sysview for Db2 for Z/OS (IDB2)
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.
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
Feedback
