In my Subsystem Exceptions I see an exception being tripped for "High number of columns with invalid select". What does this mean, and where can I get more information on the invalid selects?

book

Article ID: 52506

calendar_today

Updated On:

Products

CA RC/Migrator CA Endevor SCM Interface DB2 Administration CA RC Compare for DB2 for z/OS CA RC Extract for DB2 for z/OS CA RC/Query CA RC Secure for DB2 for z/OS CA RC Update for DB2 for z/OS CA Bind Analyzer for DB2 for z/OS CA Detector CA SQL-Ease for DB2 for z/OS CA Sysview Performance Management Option for DB2 for z/OS CA Database Detector for DB2 for z/OS CA Plan Analyzer for DB2 for z/OS CA Subsystem Analyzer for DB2 for z/OS CA Database Analyzer for DB2 for z/OS CA Fast Unload for DB2 for z/OS CA Fast Check for DB2 for z/OS CA Fast Index for DB2 for z/OS CA Fast Load for DB2 for z/OS CA Rapid Reorg for DB2 for z/OS

Issue/Introduction

Description:

Under the Subsystem Exceptions I see a Critical exception with the message: High number of columns with invalid Select procedures.
This is related to upgrading the DB2 environment and not performing Rebinds on product plans and packages.
To see what plans and packages need to be rebound, navigate to the External/IQL Exceptions screen, option 9.5 from Insight main menu.
Look for an IQL exception that has tripped and has the name RBNDRQRD.
This will provide the Plan/Package associated with the Invalid Select exception, which needs to be rebound.

Solution:

Option 9.2 from Insight main menu, Subsystem Exceptions, displays following Critical exception:

....

CRIT 01:15:33-CURRENT High number of columns with invalid select
procedures that were bypassed: 59264

...

This may be caused by upgrading a DB2 subsystem to a new version of DB2 and not rebinding plans and packages.
When a bind occurs, DB2 will create an internal select procedure for performance reasons.
When you upgrade to a new version of DB2, these internal Select procedures are invalidated.
Expectation is that one would rebind, which would regenerate the internal select procedures for the new release.
But all you are told are the number of procedures that were bypassed.

To determine what plans and packages need to be rebound as a result of this invalidation, navigate to the External/IQL Exceptions in Alert screen.
This would be option 9.5 off the Insight main menu.
You should see the following exception tripped:

...

RBNDRQRD Rebind Required Pln xxxxxxxx Cn xxxxxxxx
P/P 12345678 Col 1234567890123456 Inv Selects 1234

...

Where PLN is PLAN name, CN is Connection, P/P is Plan/Package and COL is Collection id.
This exception will identify what packages need to be rebound because of invalid select procedures.

Environment

Release:
Component: IDB2