A fix is available
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