A fix is available
APAR status
Closed as new function.
Error description
Qrep users may notice excessive storage use of below the bar storage. Blocks are with eyecatcher "UZB" and the allocator is DSNIZREP (UK60956 offset x'2BA'). AI has been added to UI19147 (2014/08/01): This PTF additionally fixes problem with serialisation between CREATE / ALTER index and other concurrent DML operations, which may lead to data inconsistency between data and index. For example for UPDATE operations may not see a new key column being added into the existing index and miss the key inserts. DB2INCORR/K DATALOSS
Local fix
decrease MAXKEEPD or reduce number of Qrep agents
Problem summary
**************************************************************** * USERS AFFECTED: DB2 10 for z/OS users run UPDATE statements * **************************************************************** * PROBLEM DESCRIPTION: DB2 run into a storage shortage issue * * when multiple UPDATE statements are * * executed concurretly under dynamic * * cache environment. * **************************************************************** * RECOMMENDATION: * **************************************************************** Under dynamic cache environment, after UPDATE statements are run, DB2 may not free its associated UPROC storage due to performance reason. The storage for UPROCs may therefore be accumulated and cause a storage shortage in DB2.
Problem conclusion
Temporary fix
********* * HIPER * *********
Comments
DB2 code is modified to provide a relief of storage leak due to the accumulated UPROCs. DB2 will use a UPROC built at dynamic cache prepare time and avoid to create another UPROC at runtime. DB2 will invalidate dynamic cache packages and quiesce the use count at CREATE and ALTER INDEX time to ensure the UPROC's consistent state. The logic change may cause potential SQLCODE -904 for CREATE and ALTER INDEX. ž**** PE15/02/18 PTF IN ERROR. SEE APAR PI32317 FOR DESCRIPTION
APAR Information
APAR number
PI15854
Reported component name
DB2 OS/390 & Z/
Reported component ID
5740XYR00
Reported release
A10
Status
CLOSED UR1
PE
NoPE
HIPER
YesHIPER
Special Attention
NoSpecatt
Submitted date
2014-04-11
Closed date
2014-06-25
Last modified date
2015-02-18
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI19147
Modules/Macros
DSNILREP DSNXICIX DSNXICX2 DSNXODML
Fix information
Fixed component name
DB2 OS/390 & Z/
Fixed component ID
5740XYR00
Applicable component levels
RA10 PSY UI19147
UP14/07/11 P F407
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":"10.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":"10.1","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
18 February 2015