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
 
Why variation in exception count while accessing DB2 data

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
sandeep1dimri

New User


Joined: 30 Oct 2006
Posts: 76

PostPosted: Mon Apr 09, 2007 6:14 pm    Post subject: Why variation in exception count while accessing DB2 data
Reply with quote

Why exception count is not increasing when my program accessing the DB2 tables and it increses when i uses downloaded version of table-i.e simple read from file.

Thanks in Advance
Back to top
View user's profile Send private message

dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Tue Apr 10, 2007 4:14 am    Post subject:
Reply with quote

Hello,

First - the term you want is probably not "exception count" - i believe the term you want is EXecute Channel Program count.

To read from (or write to) a "flat" or vsam file, your program issues a read or write and the EXCPs increase.

When you read from a database table, you issue a request to DB2 and the read is issued by DB2. The EXCPs for DB2 will increase as your program runs.

Please let us know if you'd like additional info icon_smile.gif
Back to top
View user's profile Send private message
sandeep1dimri

New User


Joined: 30 Oct 2006
Posts: 76

PostPosted: Wed Apr 11, 2007 11:41 am    Post subject:
Reply with quote

Thanks scherrer

please explain differenec between EXecute Channel Program count and exception count wrt DB2 access.

One more query:
If we change our approach from accessing data from DB2 to accessing data from file then how to conclude that we are saving CPU?

Thanks
Sandeep
Back to top
View user's profile Send private message
sandeep1dimri

New User


Joined: 30 Oct 2006
Posts: 76

PostPosted: Fri Apr 20, 2007 12:58 pm    Post subject:
Reply with quote

Ple can anyone put some views on it
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Fri Apr 20, 2007 7:19 pm    Post subject:
Reply with quote

Hello,

The difference is resources directly used by your task and only your task versus resources that are used in common. For example - if your job uses a PS file all of the i/o is directly related to your job. If your job uses database some of the i/o is related to your job, but not all of it. In a database, tables may be used by several jobs concurrently, so the resources are not directly related to one job.

My suggestion is that you re-focus. Typically, cpu time is not the only thing considered. If you want to determine if one alternative is more cost-effective than another, you need to compare all of the (machine) resources used. To find resources used, you might talk with your performance monitoring people - almost everywhere keeps stats on how many resources are used by various processes.

Usually, switching between a database and some external file structure is not a choice. Also, usually, the choice is not made on the basis of performance.
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 -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts How to write Rexx program to size and... sreejeshcs CLIST & REXX 14 Thu Oct 12, 2017 7:26 am
No new posts Copy 4 byte of data from the last rec... arunsoods DFSORT/ICETOOL 9 Fri Oct 06, 2017 12:15 pm
No new posts opening a dataset after reading it fr... arunsoods DFSORT/ICETOOL 5 Wed Oct 04, 2017 3:54 pm
No new posts Accessing CICS tran with map from JCL... navdeepaggarwal CICS 5 Tue Oct 03, 2017 6:15 pm
This topic is locked: you cannot edit posts or make replies. PS file data should be passed as symb... d_sarlie JCL & VSAM 15 Tue Oct 03, 2017 5:18 am

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