PM93260: ALTER SQL EXTERNAL PROCEDURE WLM, ADB26COV CANNOT TELL THE DIFFERENCE BETWEEN WLMENV4 VS (WLMENV4, *)

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Alter sql external procedure WLM, ADB26COV cannot tell the
  difference between WLMENV4 vs (WLMENV4, *), DDL works, AL
  doesn't recognize the difference.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS that call nested stored procedures      *
  *                 or user-defined functions, and wish to       *
  *                 specify the correct WLM environment in       *
  *                 which those routines are run.                *
  ****************************************************************
  * PROBLEM DESCRIPTION: There is a WLM_ENV_FOR_NESTED column    *
  *                      in the SYSIBM.SYSROUTINES tables that   *
  *                      indicates whether the address space     *
  *                      of the calling stored procedure or      *
  *                      user-defined function is used to run    *
  *                      the nested stored procedure or user-    *
  *                      defined function.  Currently, DB2       *
  *                      Admin does not provide the support      *
  *                      to display the WLM_ENV_FOR_NESTED       *
  *                      column on CREATE/ALTER procedures       *
  *                      panels ADB26COV 'Create Stored          *
  *                      Procedure Options' and ADBP7O           *
  *                      'Redefine Procedure'.  As a result,     *
  *                      the value of this column is ignored     *
  *                      and the user can not specify or alter   *
  *                      the correct WLM environment.            *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  A new field 'WLM ENV FOR NESTED' is added on the ADB26COV and
  ADBP7O panels, which will reflect the corresponding column
  value of the SYSIBM.SYSROUTINES table. Depending on whether its
  value is changed to YES/NO, non-nested (eg. "DSNAWLRP" for WLM
  Environment) or nested  eg. "(DSNAWLRP,*)"  is used in the
  CREATE/ALTER statement.  In the nested scenario, the WLM ENV
  FOR NESTED field will have value 'YES' (otherwise 'NO').
  

Problem conclusion

• Problem has been resolved.
  

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:

  UK96655

Modules/Macros

• ADBH6COV ADBH7O   ADBP7O   ADB26COV
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA20 PSY UK96655

     UP13/08/20 P F308

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.