A fix is available
APAR status
Closed as new function.
Error description
Aggregate Accounting Statistics IFCID003
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: All users of DB2 10 for z/OS. * **************************************************************** * PROBLEM DESCRIPTION: Performance analysis often requires * * the aggregation of accounting data * * over an interval. Aggregating * * accounting data for analysis is a * * manual, time consuming process. * **************************************************************** * RECOMMENDATION: * **************************************************************** Automated aggregation of accounting data is desired.
Problem conclusion
Temporary fix
Comments
New accounting aggregation functionality is introduced in this APAR giving DB2 the ability to aggregate accounting data into an IFC statistics record. To enable the new function, IFCID3 and IFCID369 must be enabled on the system. When both of these IFCIDs are ON, DB2 will aggregate QWAC and QWAX data for each transaction grouped by connection type. This statistics information will then be externalized in an IFCID369 at the statistics interval or via an IFCID READS call. It should be noted that the statistics interval for IFCID369 is fixed at 1 minute. A new statistics class 9 is created to encapsulate IFCID369. See DSNDQW05 macro for the mapping of IFCID369.
APAR Information
APAR number
PM62797
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
2012-04-18
Closed date
2012-08-10
Last modified date
2012-09-05
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UK81047
Modules/Macros
DSNDQWAC DSNDQWAX DSNDQW05 DSNTXSTA DSNTXSTB DSNWARDS DSNWVCSP DSNWVCST DSNWVINT DSNWVZCK DSNWVZIT DSNWVZPS DSNWVZSA
Fix information
Fixed component name
DB2 OS/390 & Z/
Fixed component ID
5740XYR00
Applicable component levels
RA10 PSY UK81047
UP12/08/29 P F208
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 September 2012