PM42331: INTERNAL CHANGES TO SUPPORT PM35190. NO EXTERNAL SYMPTOM.

A fix is available

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as new function.

Error description

  • Internal changes to support PM35190. No external sympotms.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All DB2 users                                *
    ****************************************************************
    * PROBLEM DESCRIPTION: DB2 internal changes to support         *
    *                      PM35190.                                *
    *                                                              *
    *                      LOCK TABLE does not issue SQLCODE       *
    *                      -607 for a catalog table and            *
    *                      might incorrectly issue -607            *
    *                      for a user table.                       *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    This APAR contains changes to support PM35190. This APAR
    should be applied to all members of a data sharing group before
    PM35190.
    
    During testing it was discovered that because of un-initalized
    storage LOCK TABLE against a catalog table did not receive a
    -607 as it should. Also, because of this problem LOCK TABLE on a
    user table could get a -607 when it should not. Both of these
    problems have been corrected.
    
    ***Action for PM42331:
    
    See PM42331 APAR/PTF text for additional information.
    
    PM42331 is a pre-conditioning APAR that includes changes to
    support new function that will be enabled via APAR PM35190 at a
    later date.  At this time, all of the changes are transparent to
    the user.  In a data sharing group, this pre-conditioning APAR
    should be applied to all members before the later enabling APAR
    is applied to any member.  The new function is not enabled until
    the enabling APAR is applied.  The following APAR PM35190 adds a
    new feature to allow selects against some Directory objects.
    

Problem conclusion

Temporary fix

  • *********
    * HIPER *
    *********
    

Comments

  • The code logic has been added to support PM35190 and the
    problems with LOCK TABLE have been corrected.
    

APAR Information

  • APAR number

    PM42331

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    A10

  • Status

    CLOSED UR1

  • PE

    NoPE

  • HIPER

    YesHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2011-06-23

  • Closed date

    2011-09-13

  • Last modified date

    2011-10-03

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

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

    UK71875

Modules/Macros

  •    DSNDCAT  DSNGEDB1 DSNUECMJ DSNUECSE DSNXA02
    DSNXCATL DSNXCATP DSNXIAIX DSNXIATB DSNXIATS DSNXICIX DSNXICKK
    DSNXICTR DSNXIDIX DSNXIRIX DSNXIRTB DSNXI15  DSNXKFUN DSNXOMQT
    DSNXOTL
    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • RA10 PSY UK71875

       UP11/09/29 P F109

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

Add comments

Document information


More support for:

DB2 for z/OS

Software version:

A10

Reference #:

PM42331

Modified date:

2011-10-03

Translate my page

Machine Translation

Content navigation