IBM Support

JR24708: THE DEVELOPMENT CENTER DOES NOT CALL WLM_REFRESH() IF "WLM ENVIRONMENT" OPTION IS NOT SPECIFIED IN THE SQL SP SOURCE CODE

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • The Development Center (DC) does not call the WLM_REFRESH()
    function if the "WLM ENVIRONMENT" option is not specified in the
    SQL stored procedure source code. It is because the actual WLM
    environment name is not known to the DC.
    
    The DB2/zOS system can be configured to have a default WLM
    environment.  Currently the DC cannot find it so it does not
    call the WLM_REFRESH().  The DC needs to be fixed to retrieve
    the default WLM environment name from the system catalogs and
    call the WLM_REFRESH() allways.
    

Local fix

  • Specify "WLM ENVIRONEMNT" option in the SQL stored procedure
    source code
    

Problem summary

  • USERS AFFECTED:
    Users developing SQL routines for DB2/zOS in the DB2 Development
    Center
    
    PROBLEM DESCRIPTION:
    The Development Center (DC) does not call the WLM_REFRESH()
    function if the "WLM ENVIRONMENT" option is not specified in the
    SQL stored procedure source code.
    
    PROBLEM SUMMARY:
    The DC does not call the WLM_REFRESH() because the actual WLM
    environment name is not known to the DC.  This APAR addresses
    this problem by having the DC to query the DB2/zOS system
    catalogs to retrieve the default WLM environment name and call
    the WLM_REFRESH() allways.
    

Problem conclusion

  • First fixed in DB2 UDB Version 8, FixPak 14 (s061108).
    

Temporary fix

  • Specify "WLM ENVIRONEMNT" option in the SQL stored procedure
    source code
    

Comments

APAR Information

  • APAR number

    JR24708

  • Reported component name

    DB2 CPE WINDOWS

  • Reported component ID

    5724B5601

  • Reported release

    810

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2006-08-30

  • Closed date

    2006-11-28

  • Last modified date

    2006-11-28

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

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

Fix information

  • Fixed component name

    DB2 CPE WINDOWS

  • Fixed component ID

    5724B5601

Applicable component levels

  • R810 PSN

       UP

  • R820 PSN

       UP

  • R910 PSN

       UP

[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"DB2 for Linux- UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"810"}]

Document Information

Modified date:
06 October 2021