A fix is available
APAR status
Closed as program error.
Error description
Customer added following rows into RLST, but the query still running in parallelism in SPUFI. AUTHID PLANNAME ASUTIME LUNAME RLFFUNC * * * * * ------ -------- ----------- -------- ------- DSNESPCS ? 4 DSNESPCS ? 3 DSNESPCS ? 5 Additional keywords and symptoms: DB2PARALL/K
Local fix
Set CURRENT DEGREE = '1' to disable query parallelism
Problem summary
**************************************************************** * USERS AFFECTED: All DB2 V8 and 9 (for z/OS) users of * * Resource Limit Facility (RLF) * * parallelism disablement * **************************************************************** * PROBLEM DESCRIPTION: When RLF governing for parallelism is * * enabled, DB2 does not correctly disable * * parallelism exploitation for qualified * * dynamic statements. * **************************************************************** * RECOMMENDATION: * **************************************************************** RLF Governing can be used to disable parallelism exploitation when a qualified dynamic statement is being executed. However, this parallelism restriction by RLF does not always correctly disable parallelism due to an uninitialized internal variable, causing an unpredicted behavior in RLF parallelism disablement.
Problem conclusion
DB2 code has been modified to ensure proper setting of the internal variable to correctly contain the information for parallelism disablement using RLF governor. . Additional Keywords predictive reactive sqlparallelism
Temporary fix
Comments
APAR Information
APAR number
PM06735
Reported component name
DB2 OS/390 & Z/
Reported component ID
5740XYR00
Reported release
810
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2010-02-04
Closed date
2010-05-25
Last modified date
2011-04-27
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UK57228 UK57229
Modules/Macros
DSNTBBP DSNTBBP2 DSNTRLPD DSNXEDP DSNXEDS1
Fix information
Fixed component name
DB2 OS/390 & Z/
Fixed component ID
5740XYR00
Applicable component levels
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.
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSEPEK","label":"Db2 for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG19M","label":"APARs - z\/OS environment"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.1","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
27 April 2011