Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups 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 Data replication from multiple Db2 ta... kishpra DB2 5 Mon Mar 27, 2017 9:58 pm
No new posts Count the length of the record & ... sreekusr DFSORT/ICETOOL 4 Thu Mar 23, 2017 7:52 pm
No new posts Export flat file data into excel sheet murali.andaluri DFSORT/ICETOOL 2 Mon Mar 20, 2017 5:39 pm
No new posts Append data from two files into a sin... Praveen04 DFSORT/ICETOOL 5 Thu Mar 16, 2017 7:29 pm
No new posts Display FTP Session Count within TSO Yolanda Harvey TSO/ISPF 3 Fri Mar 10, 2017 10:31 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us