PI71350: DSQ21869 THE REPLACEMENT VALUE FOR CURRENT QUERY ACCELERATION ISINVALID

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Trying to SET special register Current Query Acceleration the
  following message is issued:
  
  QUERY MESSAGES:
  Invalid value for CURRENT QUERY ACCELERATION register.
  THE DESCRIBE STATEMENT DOES NOT SPECIFY A PREPARED STATEMENT
  
  Exiting from QMF panel the following message is displayed:
  
  DSQ21869 THE REPLACEMENT VALUE FOR CURRENT QUERY ACCELERATION IS
  INVALID
  
  There is no problem using the QMF v10 SDSQLOAD.
  
  DSQ21869 MSGDSQ21869
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All QMF for TSO/CICS V11.1 and V11.2 users   *
  *                 setting the CURRENT QUERY ACCELERATION       *
  *                 special register.                            *
  ****************************************************************
  * PROBLEM DESCRIPTION: After setting the CURRENT QUERY         *
  *                      ACCELERATION special register within a  *
  *                      QMF session, users may see error        *
  *                      DSQ10496 'THE REPLACEMENT VALUE FOR     *
  *                      CURRENT QUERY ACCELERATION IS INVALID.' *
  *                      during CONNECT, EXIT or other times     *
  *                      during the QMF session.  Users may also *
  *                      see a SQLCODE713 or DSQ21869 reflecting *
  *                      this error.                             *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  If users run a SQL query to set the CURRENT QUERY ACCELERATION
  that involves an equal sign like this:
  
  SET CURRENT QUERY ACCELERATION=ALL
  
  QMF will improperly evaluation the '=' equal sign as a value.
  

Problem conclusion

• QMF has been fixed to properly evaluate the '=' (equal sign)
  when processing the setting of the CURRENT QUERY ACCELERATION
  special register.
  

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:

  UI42833 UI42834

Modules/Macros

•    DSQCTOKN
  

Fix information

• Fixed component name

  QMF-QUERY MGMT

• Fixed component ID

  566872101

Applicable component levels

• RB10 PSY UI42833

     UP16/11/23 P F611

• RB20 PSY UI42834

     UP16/11/23 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.