A fix is available
APAR status
Closed as program error.
Error description
CDC or Qrep read DB2 log through IFI 306, it may need to access to quiesced member's log and BSDS even there is no need to do so.
Local fix
N/A
Problem summary
**************************************************************** * USERS AFFECTED: All data sharing users of DB2 that run * * applications that read the DB2 logs with * * the IFI READS facility for IFCID 306. * **************************************************************** * PROBLEM DESCRIPTION: Increased CPU usage can be seen for * * the DB2 MSTR address space when * * another member of the data sharing * * group is shut down while running an * * application that is reading the DB2 * * logs with the IFI READS facility * * for IFCID 306. Repeated * * disposition messages for the peer * * member BSDS and active log can be * * seen in the DB2 MSTR job log after * * the peer member is stopped. * **************************************************************** * RECOMMENDATION: * **************************************************************** When the IFI application is using the prior QW0306ES LRSN value on the subsequent F-call, DB2 does not correctly detect that the logs are no longer needed for a quiesced member of the data sharing group even though the LRSN value specified on the F-call is higher than the quiesce LRSN for the quiesced member. This results in DB2 allocating, opening, reading, closing, and deallocating the quiesced member's BSDS and active log on each subsequent F-call which will increase the CPU usage for the DB2 MSTR address space.
Problem conclusion
DB2 will now bypass accessing the quiesced member's BSDS and active log when the LRSN range is higher than the quiesce LRSN for the quiesced member, and the IFI application is using the QW0306ES LRSN value on subsequent F-calls.
Temporary fix
Comments
APAR Information
APAR number
PI06261
Reported component name
DB2 OS/390 & Z/
Reported component ID
5740XYR00
Reported release
A10
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2013-11-17
Closed date
2013-12-16
Last modified date
2014-02-05
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI13581 UI13582 UI13586
Modules/Macros
DSNIDLGR DSNJR001
Fix information
Fixed component name
DB2 OS/390 & Z/
Fixed component ID
5740XYR00
Applicable component levels
RA10 PSY UI13581
UP14/01/03 P F401
RB10 PSY UI13582
UP14/01/03 P F401
R910 PSY UI13586
UP14/01/03 P F401
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:
05 February 2014