search cancel

Looking for detailed information on Actions needed to fix BIF compatibility issues

book

Article ID: 189227

calendar_today

Updated On:

Products

SYSVIEW Performance Management Option for DB2 for z/OS Database Management for DB2 for z/OS - Performance Suite Database Management for DB2 for z/OS - SQL Performance Suite Insight Performance Monitor for DB2 UDB for z/OS

Issue/Introduction

Checking the compatibility for V12 NFM migration, the following situations were identified. What needs to be done?

(DBGSINCO)


Menu  Print  Tools  Help    CA SYSVIEW for DB2  DBP2 AFW2     04/16/20 09:56:38
                                19.0            HRO_DSN                GAM0038
   1 Summary  2 Detail                                                          (DBGSINCO)                                                                     
R/INCOMPTS      SQL Incompatibility Summary (IFCID 376)              Item 1-6/6
                                                                              
                          Rsn  SQL      Last executed                         
Incompatibility reason    Code Count    Stmt ID (HEX)    Last exec            
                                                                              
CHAR(dec) Format          1    14       000000000000EB7A 04/16/20 07:42:34    
VARCHAR/CAST(dec) Format  2    1        00000000003B2BCC 04/16/20 09:08:47    
Long CLIENT_ACCTNG SR     1104 3        000000000000B7E8 04/13/20 11:51:30    
Long CLIENT_APPLNAME SR   1105 3        000000000000B7E8 04/13/20 11:51:30    
Long CLIENT_USERID SR     1106 3        000000000000B7E8 04/13/20 11:51:30    
Long CLIENT_WRKSTNNAME    1107 3        000000000000B7E8 04/13/20 11:51:30    



Environment

Release : 19.0

Component : CA Insight Database Performance Monitor for DB for z/OS

Resolution

This request(R/INCOMPTS) displays a summary of SQL statements executed that could have potentially incompatible
changes after switching to the new application compatibility behavior.
The request give the incompatibility reason which should assist you in determining  the number of statements affected by the particular application compatibility behavior change.
The first column of the display gives you the incompatibility reason which should help in dealing with this report.