PM76084: SQL CODE -525 QMF APAR/PTF PM55683/UK77499 IS APPLIED BEFORE DB2 Z/OS APAR/PTF PM50435/UK76104

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• DSQISDBQ was added to QMF V10 via APAR/PTF PM55683/UK77499
  adding support for the current query acceleration special
  register which was introduced with DB2 z/OS APAR/PTF
  PM55683/UK76104.
  
  - If QMF APAR/PTF PM55683/UK77499 is applied before
    DB2 z/OS APAR/PTF PM50435/UK76104,
    then QMF will require the QMF packages be bound after
    the DB2 maintenance gets applied.
  - If DB2 z/OS APAR/PTF PM50435/UK76104 is already applied
    or is applied with QMF APAR/PTF PM55683/UK77499
    there is no problem or additional action required.
  
  For example, a customer reports QMF batch job failed with
  DSQ10496 DSN00525 -525.
  The QMF trace showed the following msgs:
  
  ----------      ****** 12/10/22  09.00.44 ******  --------
  USERID: uuuuuu
  AUTHORIZATION-ID:
  MESSAGE NUMBER: DSQ10496
  MESSAGE TEXT:
  THE SQL STATEMENT CANNOT BE EXECUTED BECAUSE IT WAS
  IN ERROR AT BIND TIME FOR
  SECTION = 1 PACKAGE = cccccccc.Q.DSQGSDBQ
  CONSISTENCY TOKEN = X'0E4D2F7F08F2F8F8'.
   &O1:  ..DSN00525
   &O2:  THE SQL STATEMENT CANNOT BE EXECUTED BECAUSE
         IT WAS IN ERROR AT BIND TIME FOR
         SECTION = 1 PACKAGE = GFNADAIA.Q.DSQGSDBQ
         CONSISTENCY TOKEN = X'0E4D2F7F08F2F8F8'
   &O3:  0
   &O4:  FFFFFF1A 00000000 00000000
   &O5:  FFFFFFFF 00000000 00000000
   &O6:  DSN10015
   &O9:  -525 (51015)
  
  DSN00525 SQL code -525  SQLCODE525
  

Local fix

• Run QMF1010.SDSQSAPE(DSQ1BPKG).
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: All QMF for TSO/CICS V10.1 users running     *
  *                 with a combination of QMF APAR PM55683 and   *
  *                 the DB2 for z/OS query accelerator APARs     *
  *                 PM45482 (V9) and/or PM50435 (V10).           *
  ****************************************************************
  * PROBLEM DESCRIPTION: Users who apply QMF V10 APAR PM55683    *
  *                      can run into error SQL Code -525 when   *
  *                      starting QMF if the PTF for the DB2     *
  *                      z/OS APAR PM50435 (V10) or PM45482 (V9) *
  *                      has been applied after the PTF for the  *
  *                      QMF APAR PM55683 was applied and the    *
  *                      QMF1010.SDSQSAPE(DSQ1BPKG) bind job     *
  *                      was not rerun.                          *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  If the QMF APAR PM55683 PTF is applied to a system where DB2
  for z/OS PTFs for PM45482 (V9) and PM50435 (V10) already exist,
  QMF1010.SDSQSAPE(DSQ1BPKG) needs to be run one time for every
  local and remote DB2 for z/OS database accessed by QMF V10. If
  QMF PM55683 PTF is applied before the DB2 for z/OS PTFs,
  QMF1010.SDSQSAPE(DSQ1BPKG) must be run after the QMF V10
  PM55683 PTF is applied and again after the DB2 for z/OS PTFs
  are applied.
  

Problem conclusion

• Messages generated by the DSQ1BPKB job have been updated to
  explain the reason for the generation of the warning message
  DSNX200I and the circumstances under which the job DSQ1BPKG
  must be rerun to avoid SQL CODE -525.
  

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:

  UK90042

Modules/Macros

• DSQ1BPKB
  

Fix information

• Fixed component name

  QMF-QUERY MGMT

• Fixed component ID

  566872101

Applicable component levels

• RA10 PSY UK90042

     UP12/12/06 P F212

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.