Joined: 13 Jun 2012 Posts: 180 Location: United States
I'm seeing serious APA overhead for an intense DB2 application and I don't know if this is normal, or if there is anything that can be done to reduce it. Here's a sample:
Name Description Percent of CPU Time * 10.00%
DSNIDM Data Manager 27.93 **************
CAZ00681 APA DB2 Services 20.71 **********
DSNXGRDS Relational Data 8.50 ****
1BCFDxxx Unresolved 5.34 ***
Application 4.65 **
CAZ00670 APA DB2 Services 4.19 **
DSNGD001 Data Manager 3.99 **
1B736xxx Unresolved 3.96 **
CAZ00681 and CAZ00670 are the APA modules. There were 1m opens, 2m fetches and 1m closes done in this sample.
Joined: 28 Aug 2007 Posts: 1691 Location: Tiruppur, India
Turning off the plus collectors should be the heavy hitter, Also I think we should pay attention to the "Measurement Significance" value in S01 report which says how good of a measurement it is based on the sampling rate and time.
Also the "S01: Measurement profile" has the APAs overhead CPU time in seconds. With that we could determine if overhead is large or a very small value whose % value is exaggerated in comparison.