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

A fix is available

Subscribe

You can track all active APARs for this component.

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 number

    PM76084

  • Reported component name

    QMF-QUERY MGMT

  • Reported component ID

    566872101

  • Reported release

    A10

  • Status

    CLOSED PER

  • PE

    YesPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2012-10-29

  • Closed date

    2012-12-05

  • Last modified date

    2013-01-02

  • 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.



Rate this page:

(0 users)Average rating

Document information


More support for:

DB2 Query Management Facility
QMF for TSO/CICS

Software version:

10.1.0

Reference #:

PM76084

Modified date:

2013-01-02

Translate my page

Machine Translation

Content navigation