Explanation of Some Exceptions
Article ID: 8960
Updated On:
Products
Issue/Introduction
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?
Environment
Component: CIDB
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.
Feedback
