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
 

 

How to speed up Batch process

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> Java & MQSeries
View previous topic :: :: View next topic  
Author Message
atulbagewadikar

New User


Joined: 15 Jun 2006
Posts: 26

PostPosted: Tue Feb 03, 2009 5:41 am    Post subject: How to speed up Batch process
Reply with quote

Hi,

What should one go for, for speeding up batch Natural process if dealing with multiple ADABAS files. PREFETCH/MULTIFETCH is the way, but is there any other way to achieve the same?
Back to top
View user's profile Send private message

beruoist

New User


Joined: 14 Nov 2007
Posts: 70
Location: mumbai

PostPosted: Tue Feb 03, 2009 1:44 pm    Post subject:
Reply with quote

Hi Atul

What is PREFETCH/MULTIFETCH ?...can you please share

Thanks in advance

Regards
Beruoist
Back to top
View user's profile Send private message
monasu1998

Active User


Joined: 23 Dec 2005
Posts: 176
Location: India

PostPosted: Sun May 24, 2009 3:32 pm    Post subject:
Reply with quote

Hi Atul,

The PRE-FETCH and MULTI-FETCH are used with database access statements to improve performance and reduce I/O process.

The records fetched will be kept in a buffer area, so that the repeatative access to same data will be read from the buffer not from the database.

Thanks,
Back to top
View user's profile Send private message
Ralph Zbrog

New User


Joined: 21 Nov 2009
Posts: 58
Location: California

PostPosted: Fri Dec 11, 2009 1:55 pm    Post subject: Reply to: How to speed up Batch process
Reply with quote

To clarify, Prefetch & Multi-fetch do not reduce I/O, and do not deal with "repeatable access to same data."

They are methods by which Adabas will read-ahead for sequential commands. For each physical call to Adabas, multiple records are returned to Natural, thereby reducing inter-region communication between Adabas and Natural. Adabas and Natural do essentially the same amount of work as without Prefetch/Multi-fetch. It's the overhead that is reduced.

When applied properly, Prefetch/Multi-fetch can reduce elapsed time by as much as 80%. When applied improperly, elapsed times can increase by an order of magnitude.

The best scenario is a single, long file access; for example, a data extract or report.

If multiple file accesses are nested, the benefits of Prefetch/Multi-fetch will be reduced or even eliminated.
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 -> Java & MQSeries All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Issue with NDM process to transmit ES... chetanambi All Other Mainframe Topics 6 Wed May 03, 2017 10:52 am
No new posts HLIST Utility In Batch Virendra Shambharkar TSO/ISPF 4 Fri Apr 07, 2017 3:38 pm
No new posts Batch job tuning sgandhla Testing & Performance analysis 5 Fri Mar 24, 2017 9:41 pm
No new posts MIPS/CPU consumption reduction in Batch vishwakotin DFSORT/ICETOOL 4 Sat Mar 18, 2017 5:46 pm
No new posts Storing huge volume of data, compare ... Pradeep K M All Other Mainframe Topics 3 Mon Jan 16, 2017 5:08 pm


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