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
 

 

What is EXCP in VSAM

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL
View previous topic :: :: View next topic  
Author Message
muthuvel

Active User


Joined: 29 Nov 2005
Posts: 217
Location: Chennai

PostPosted: Wed Mar 01, 2006 2:57 pm    Post subject: What is EXCP in VSAM
Reply with quote

What is an EXCP?in what way it is related to the performance of a VSAM file?
Back to top
View user's profile Send private message

DavidatK

Active Member


Joined: 22 Nov 2005
Posts: 700
Location: Troy, Michigan USA

PostPosted: Wed Mar 01, 2006 8:46 pm    Post subject: Re: EXCP in VSAM
Reply with quote

muthuvel,

EXCP is 'EXecute Channel Program' and gives an indication of the number of I/Os that are happening.

The lower the EXCP count, the lower the number of I/Os and the faster the program will run. For the same amount of data being processed a lower EXCP count means that larger buffers arer being read/written, and for VSAM, maybe the fewer times the program is having to go to DASD to access indexes, The more index space the fewer I/Os.

Dave
Back to top
View user's profile Send private message
muthuvel

Active User


Joined: 29 Nov 2005
Posts: 217
Location: Chennai

PostPosted: Thu Mar 02, 2006 3:07 pm    Post subject: Re: What is EXCP in VSAM
Reply with quote

Hi,

Thanks for the information.

And may i know how to write an effective code so that the EXCP's are minimal in an VSAM operation.
Back to top
View user's profile Send private message
DavidatK

Active Member


Joined: 22 Nov 2005
Posts: 700
Location: Troy, Michigan USA

PostPosted: Fri Mar 03, 2006 1:10 am    Post subject: Re: What is EXCP in VSAM
Reply with quote

There are a couple of programming considerations when accessing VSAM files depending upon how large the VSAM file is and how many accesses are anticipated.

First, you should random access the VSAM file in Key Order, if possible. This means that you should sort, say, an input file in the Key Order of the VSAM file. This means, that when you read a record from the VSAM file, chances are better that the Key you?re accessing will still be in the index stored in memory.

Second, if you?re accessing a large % of the VSAM file, you may find it more effective to sequentially access the file.

This is about the only things I can think of right off that you can do inside the program.

There are a couple of things you can do about the environment your running in.

In the JCL, you can use:

Code:

//FDNAME DD  SUBSYS=(BLSR,'DDNAME=BLSRXX','MSG=I') 
//BLSRXX DD  DSN=YOUR.VSAM.FILE,                 
//             DISP=SHR                                 


Using the BLSR subsystem, effectively copies the entire VSAM file into memory, so that after the initial load, there will be minimal I/Os. This should only be used when you anticipate a large number of accesses.

Also having your Systems Programmer do some tuning will also help.


Dave
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 -> DFSORT/ICETOOL All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Fail to change physical VSAM filename... jacobdng CICS 6 Fri Jan 20, 2017 12:36 pm
No new posts how to recover an uncataloged VSAM da... archanamuthukrishnan All Other Mainframe Topics 3 Wed Jan 11, 2017 6:18 pm
No new posts Underlying DB2 VSAM LDS - SMF recording vasanthz All Other Mainframe Topics 6 Thu Jan 05, 2017 4:20 am
No new posts BWO option in VSAM blayek CICS 3 Sat Nov 05, 2016 10:47 am
No new posts VSAM define for large file jerryte JCL & VSAM 9 Wed Oct 05, 2016 1:51 am


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