PI64733: SQLCODE84 DURING PREPARE OF A STATEMENT WHICH USES CONCENTRATE WITH LITERALS AND STATEMENT GETS INVALI

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• SQLCODE84 during PREPARE of a statement which used concentrate
  with literals and statement gets invalidated
  
  Additional symptoms and search keywords
  SQLCODE84 SQLPREPARE
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: DB2 10 and DB2 11 for z/OS users of the      *
  *                 dynamic statement cache with CONCENTRATE     *
  *                 STATEMENTS WITH LITERALS clause              *
  ****************************************************************
  * PROBLEM DESCRIPTION: SQLCODE -084 is incorrectly issued by   *
  *                      module DSNXODDL during a FULL PREPARE   *
  *                      of a statement which uses CONCENTRATE   *
  *                      STATEMENTS WITH LITERALS; the           *
  *                      statement also gets invalidated.        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  SQLCODE -084 may be incorrectly issued by module DSNXODDL when
  the following three conditions happen concurrently:
  1. A Full PREPARE of a statement which uses CONCENTRATE
  STATEMENTS WITH LITERALS.
  2. Another Full PREPARE of that same statement which uses
  CONCENTRATE STATEMENTS WITH LITERALS.
  3. A utility job such as RUNSTATS, or a DDL statement such as
  DROP, invalidates the statement.
  
  In the above situation, #1 and #2 are in a race condition to
  get inserted into the cache. #3 invalidates the winner before
  the loser grabs the winner's information.
  

Problem conclusion

• DB2 code has been changed to pass the correct control block to
  module DSNXODDL when processing CONCENTRATE STATEMENTS WITH
  LITERALS.
  
  ADDITIONAL KEYWORDS:
  SQLCODE084 SQLDYNSTMTCACHE
  

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:

  UI42183 UI42184

Modules/Macros

• DSNXEDS1
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RA10 PSY UI42183

     UP16/11/16 P F611

• RB10 PSY UI42184

     UP16/11/16 P F611

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.