Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Forum Index
IBM Mainframe Forum 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

Active User

Joined: 13 Jun 2012
Posts: 147
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%
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.
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 IMS BMP Checkpoint Overhead Hooman24 IMS DB/DC 6 Sun Nov 25, 2018 10:19 pm
No new posts Regarding Cursor Overhead DavidatK DB2 20 Tue Jan 16, 2007 11:56 am

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