PM38938: PANEL ANLPFILE GENERATES CONTENTION WITH ONE USERID

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Executing Explain on Panel ANLPFILE processing SQL from a
  sequential data set or PDS member generates contention with
  one userid with messages:
  MIM1038I userid contention with userid OWNS EXCL on SYSG CN
  MIM1099I userid holds EDIDSN ...userid.ANLTERM.TMP EXCL CN
  MIM1039I userid needs EXCL EDIDSN ..userid.ANLTERM.TMP CN
  MIM1098I Contention with userid needs EXCL on SYSG CN
  FAILED CREATING PLAN_TABLE
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  *                 All users of SQL Performance Analyzer v4.1.  *
  *                                                              *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  *                      Executing Explain on Panel ANLPFILE     *
  *                      processing SQL from a sequential        *
  *                      data set or PDS member generates        *
  *                      contention with userid with messages:   *
  *                                                              *
  *                      MIM1038I userid contention with userid  *
  *                      OWNS EXCL on SYSG CN                    *
  *                                                              *
  *                      MIM1099I userid holds EDIDSN ...        *
  *                      userid.ANLTERM.TMP EXCL CN              *
  *                                                              *
  *                      MIM1039I userid needs EXCL EDIDSN ..    *
  *                      userid.ANLTERM.TMP CN                   *
  *                                                              *
  *                      MIM1098I Contention with userid needs   *
  *                      EXCL on SYSG CN FAILED CREATING         *
  *                      PLAN_TABLE                              *
  *                                                              *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  Code has been changed to correct this condition.
  

Problem conclusion

• Apply the PTF for problem resolution.
  

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:

  UK68586

Modules/Macros

• ANLCHECK ANLCKTBL ANLCNUX  ANLCRGID ANLCRNE1
  ANLCRNS1 ANLCRNS2 ANLCRNT1 ANLCRNT2 ANLCSQLI ANLCSTA1 ANLCSYST
  ANLCS2E  ANLCWIF1 ANLCWIF2
  

Fix information

• Fixed component name

  DB2 SQL PERF AN

• Fixed component ID

  5697F5701

Applicable component levels

• R410 PSY UK68586

     UP11/06/14 P F106

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.