IBM Support

PM44047: AE FIX COMPLETION PM39682

A fix is available

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • AE FIX COMPLETION PM39682
    .
    VARIOUS ABENDS CAN OCCUR WHEN USING AN INDEX ON EXPRESSION.
    Here is a query for any any IOE:
    SELECT A.NAME, A.TBNAME, A.DBNAME, A.IX_EXTENSION_TYPE,
           A.VERSION, A.CURRENT_VERSION, B.TYPE, B.DLOCATION,
           B.DCOLLID, B.DNAME
        FROM  SYSIBM.SYSINDEXES A,
              SYSIBM.SYSPACKDEP B
        WHERE A.IX_EXTENSION_TYPE ='S'
          AND B.TYPE = 'I'
          AND A.NAME = B.BNAME
       ORDER BY B.DNAME, A.DBNAME, A.VERSION  ;
    .
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: AE PM39682 fix completion                    *
    ****************************************************************
    * PROBLEM DESCRIPTION: AE PM39682 fix completion               *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    AE PM39682 fix completion
    

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    PM44047

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    910

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2011-07-19

  • Closed date

    2011-07-26

  • Last modified date

    2011-09-01

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

Modules/Macros

  •    DSNIZAZ2 DSNURWBF
    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • R910 PSY UK69768

       UP11/08/19 P F108

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.



Document information

More support for: DB2 for z/OS

Software version: 910

Reference #: PM44047

Modified date: 01 September 2011


Translate this page: