PI15861: SQLCODE=-4742 FOR SOME QUERIES THAT REFERENCE MULTIPLE TABLES WITH DIFFERENT SUPPORTLEVELS ENABLED ON TWO ACCELERATORS

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• SQLCODE=-4742 can occur for some queries that reference multiple
  tables with different supportlevels enabled on two
  accelerators.                                          (d171554)
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: All users of DB2 10 for z/OS or DB2 11 for   *
  *                 z/OS who use IBM DB2 Analytics Accelerator.  *
  ****************************************************************
  * PROBLEM DESCRIPTION: SQLCODE=-4742, SQLERRP=DSNXONZB might   *
  *                      occur when a statement contains tables  *
  *                      that are of different support levels.   *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  When a statement contains tables that are on different
  support levels, SQLCODE=-4742, SQLERRP=DSNXONZB might occur.
  For example, if a query to be accelerated is
         SELECT * FROM T1, T2 FETCH FIRST 5 ROWS;
  and the accelerated table T1 on the accelerator is on support
  level 3, while T2 on the same accelerator is on support level
  2, then SQLCODE=-4742, SQLERRP=DSNXONZB might occur.
  
  Additional Keywords:
  IDAAV4R1/K
  

Problem conclusion

• This APAR fix will prepare/bind the query correctly with
  consideration of possible different table support levels
  on the same accelerator, which eliminates the issuing of
  SQLCODE=-4742 from SQLERRP=DSNXONZB.
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

  UI18782 UI18783

Modules/Macros

•    DSNXONZA
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RA10 PSY UI18782

     UP14/07/01 P F406

• RB10 PSY UI18783

     UP14/07/01 P F406

Fix is available

• Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.