PI96982: EXPAND PARM ANLWLMEV "NAME OF WLM APPLENV FOR STORED PROCEDURE" TO 32

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• * SQLPA v4.2 correctly set the DSN8WLMR (WLM environment
  for sample stored procs) parm length to 32.
  
  * But SQLPA v5.1 changed this parm name to ANLWLMEV
   (Name of WLM APPLENV for stored procedure) and
   inappropriately set the parm length to 8.
  
  This fix will correct the SQLPA v5.1 ANLWLMEV (Name of WLM
  APPLENV for stored procedure) length to 32.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of IBM Db2 SQL Performance Analyzer    *
  *                 z/OS.                                        *
  ****************************************************************
  * PROBLEM DESCRIPTION: * SQLPA v4.2 correctly set the DSN8WLMR *
  *                      (WLM environment for sample stored      *
  *                      procs) parm length to 32.               *
  *                                                              *
  *                      * But SQLPA v5.1 changed this parm      *
  *                      name to ANLWLMEV (Name of WLM APPLENV   *
  *                      for stored procedure) and               *
  *                      inappropriately set the parm length to  *
  *                      8.                                      *
  *                                                              *
  *                      This fix will correct the SQLPA v5.1    *
  *                      ANLWLMEV (Name of WLM APPLENV for       *
  *                      stored procedure) length to 32.         *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  Code has been changed to correct this condition.
  

Problem conclusion

• APPLY the PTF.
  

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:

Modules/Macros

• ANL$$PRM
  

Fix information

• Fixed component name

  DB2 SQL PERF AN

• Fixed component ID

  5697F5701

Applicable component levels

• R510 PSY UI57237

     UP18/07/17 P F807

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.