Explanation of Some Exceptions

Document ID : KB000008960
Last Modified Date : 14/02/2018
Show Technical Document Details
Issue:

The exceptions are as follows 

Menu Print Tools Help CA SYSVIEW for DB2 DT21 SYSV 12/22/17 11:47:28 

19.0 TDB2GRP TSOPCA2 

1 DB2 2 All 3 Exception 4 Utility 5 DB2 Command 

Messages Messages 

Date (MM/DD) . . 12/22 Time (HH.MM.SS) . . 11.28.02 

------------------------------------------------------------------------------ 

12/22 11.28.02 IDB2PCV DT21 - >>> CRIT: RBNDRQRD REBIND REQUIRED PLN PII4810P CN CICSDAQ3 P/P PII4810P COL UUAT_COL1 INV SELECTS 7 

What does this mean? Is this a recommendation ? what is meant by INV SELECT 7 

-----------------------------------------------------------------------------------------------------------------------------------------

Here is another exception : 

 

Menu Print Tools Help CA SYSVIEW for DB2 DT21 SYSV 12/22/17 11:56:42 

19.0 TDB2GRP TSOPCA2 

1 DB2 2 All 3 Exception 4 Utility 5 DB2 Command 

 

Messages Messages 

 

Date (MM/DD) . . 12/22 Time (HH.MM.SS) . . 01.04.05 

------------------------------------------------------------------------------ 

12/22 01.04.05 IDB2PCV DT21 - END INFO: INS003B DT21 HIGH % MAXIMUM BATCH THREADS IN USE DURING THE LAST EXCEPTION INTERVAL = 56% 

 

What does this mean? 

-----------------------------------------------------------------------------------------------------------------------------------------

Here is another exception : 

 

Menu Print Tools Help CA SYSVIEW for DB2 DT22 SYSX 12/22/17 11:58:45 

19.0 TDB2GRP TSOPCA2 

1 DB2 2 All 3 Exception 4 Utility 5 DB2 Command 

 

Messages Messages 

 

Date (MM/DD) . . 12/20 Time (HH.MM.SS) . . 10.48.05 

------------------------------------------------------------------------------ 

: HIGH NUMBER OF COLUMNS WITH INVALID SELECT PROCEDURES THAT WERE BYPASSED: 191 INVALID SELECT PROCEDURES THAT WERE BYPASSED: 191 

 

What does this mean? 

-----------------------------------------------------------------------------------------------------------------------------------------

Here is another exception : 

 

Menu Print Tools Help CA SYSVIEW for DB2 DT22 SYSX 12/22/17 12:00:58 

19.0 TDB2GRP TSOPCA2 

1 DB2 2 All 3 Exception 4 Utility 5 DB2 Command 

 

Messages Messages 

 

Date (MM/DD) . . 12/20 Time (HH.MM.SS) . . 10.48.05 

------------------------------------------------------------------------------ 

12/22 11.18.31 IDB2PCX DT22 - >>> CRIT: HIGH TOTAL NUMBER OF TIMEOUTS ENCOUNT FOR SUBSYSTEM = 5 

 

What does this mean? 

Resolution:

For the RBNDRQRD IQL exception, you should get the specific information when you hit PF1 on the exception monitoring screen 

+IQL Application Exception:%RBNDRQRD 

%Rebind needed due to invalid select procedure 

+Explanation: 

+This exception identifies the plan containing columns (actually, rows times columns) for which an invalid select procedure was encountered. Invalid select procedures are bypassed by DB2, and this can cause some performance degradation but not any runtime failures. 

+A select procedure can be made invalid when DB2 maintenance is applied that directly affects the select procedure. Plans and packages with invalid select procedures continue to function correctly but with a small performance degradation. 

+Prescription: 

+To eliminate this degradation, rebind any plan or package that causes a nonzero value to appear. Rebinding a plan or package reenables its select procedures. We recommend that the plans with the highest column count be rebound first. Note that only the plan is identified, so all packages in a plan should rebound as well as the plan itself. 

 

For the other exceptions, you can just use B(browse) in the exception monitor and look at the definition. it's usually the value a single field, or the ratio of two fields exceeding the defined limit. If you don't like the exception, you can disable it.