APAR status
Closed as new function.
Error description
ACCESS DB PERFORMANCE IMPROVEMENT
Local fix
N/A
Problem summary
**************************************************************** * USERS AFFECTED: All users of ACCESS DATABASE command on DB2 * * DB2 10 for zOS. * **************************************************************** * PROBLEM DESCRIPTION: -ACCESS DATABASE command processes * * work serially, causing long running * * times for this command. * **************************************************************** * RECOMMENDATION: * **************************************************************** -ACCESS DATABASE is used to open datasets for use by DB2 and to remove objects from group buffer pools. All this work is performed serially, causing long running time for this command. Running -ACCESS DATABASE work in parallel will improve the running time of the command.
Problem conclusion
Temporary fix
Comments
DB2 will use internal threads to execute -ACCESS DATABASE command in parallel.
APAR Information
APAR number
PM80779
Reported component name
DB2 OS/390 & Z/
Reported component ID
5740XYR00
Reported release
A10
Status
CLOSED UR1
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2013-01-16
Closed date
2013-06-24
Last modified date
2013-07-17
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UK95407
Modules/Macros
DSNIIEPL DSNILSTS DSNTSTRT
Fix information
Fixed component name
DB2 OS/390 & Z/
Fixed component ID
5740XYR00
Applicable component levels
[{"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:
17 July 2013