PI94067: QMF / CICS DOES NOT HONOR SET CURRENT QUERY ACCELERATION

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• QMF / CICS DOES NOT HONOR SET CURRENT QUERY ACCELERATION
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Db2 11 and 12 for z/OS users of                          *
  * QMF for CICS or other applications                           *
  * that uses attachments that may reuse                         *
  * threads.                                                     *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * QMF for CICS does not honor result                           *
  * of SET Special Register for the                              *
  * following special registers after                            *
  * a COMMIT statement.                                          *
  * - CURRENT QUERY ACCELERATION                                 *
  * - CURRENT GET_ACCEL_ARCHIVE                                  *
  * - CURRENT APPLICATION COMPATIBILITY                          *
  * - CURRENT ACCELERATOR                                        *
  * - CURRENT QUERY ACCELERATION                                 *
  * WAITFORDATA                                                  *
  * The SQL statements after COMMIT                              *
  * do not reflect the value(s) being                            *
  * SET for the special register(s).                             *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply corrective PTF when available                          *
  ****************************************************************
  During COMMIT (or ROLLBACK), Db2 code does not set the
  flag to mark that the Special Registers listed above
  have been set previously. This causes applications like
  QMF for CICS to not remember the values and lose them
  when it is reusing the thread.
  

Problem conclusion

• Db2 code is corrected to properly mark if the Special
  Registers listed above have been set on the thread prior
  to COMMIT or ROLLBACK.
  
  Additional Keywords: IDAAV4R1/K IDAAV5R1/K IDAAV7R1/K
  

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:

  UI54825 UI54826

Modules/Macros

• DSNXECW  DSNXECWA DSNXECWU
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RC10 PSY UI54825

     UP18/04/13 P F804

• RB10 PSY UI54826

     UP18/04/13 P F804

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.