Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
APA overhead

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> IBM Tools
View previous topic :: :: View next topic  
Author Message
John Poulakos

New User


Joined: 13 Jun 2012
Posts: 49
Location: United States

PostPosted: Thu Apr 03, 2014 7:15 pm    Post subject: APA overhead
Reply with quote

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%
*....1....2....3....4....5
DSNIDM Data Manager 27.93 **************
CAZ00681 APA DB2 Services 20.71 **********
DSNXGRDS Relational Data 8.50 ****
System
1BCFDxxx Unresolved 5.34 ***
Address
Application 4.65 **
Program
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.
Back to top
View user's profile Send private message

View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> IBM Tools All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Regarding Cursor Overhead DavidatK DB2 20 Tue Jan 16, 2007 11:56 am

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us