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

Obtain the fix for this APAR.

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