Home > Ask the AS/400 Experts > iSeries i5/OS and OS/400 Questions & Answers > Will too many data paths cause poor performance?
Ask The iSeries 400 Expert: Questions & Answers
EMAIL THIS

Will too many data paths cause poor performance?

John Brandt EXPERT RESPONSE FROM: John Brandt

Pose a Question
Other iSeries 400 Categories
Meet all iSeries 400 Experts
Become an Expert for this site


Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us   


>
QUESTION POSED ON: 24 May 2001
We have one particular batch job on our system which runs with very poor performance. On examination the job has 2000+ open data paths mostly over the same files. Would this be causing the performance problems? If so, how can I cause data paths to be reused?

>

I'm certain that having 2000+ open data paths is causing the problem. The job was probably written to handle multiple calls to the same program recursively. If the calls are not recursive, then the program that is being called is not closing the file properly. If this is the case, and it is being called by a CL, you can use the RCLRSC *CALLER to close the path. I would start by researching the job looking at the programs that are using the file.


Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us   



RELATED CONTENT
iSeries i5/OS and OS/400
Will overloaded discs impact iSeries performance?
Error CWBCO1049 on AS/400
Recovering from DST QSECOFR password disablement on V5R4
Enrolling a user profile in the i5/OS system distribution directory
How to resolve a CPI93B8 error message: LIC problem data has been logged for #MSTRTNS
Checking if a local port is used by another job on AS/400
Restricting specific user command line access
Print private authorities (PRTPVTAUT) command for user objects in a library with *public exclude
Getting modules to adopt authorities from the main program
Copying a physical file back to a spool file

Past Releases
iSeries i5/OS: Top 10 Q&As
iSeries i5/OS: Top 10 Q&As
Error message within the printer file
How often are message queues cleared?
Connect the dots: Get your iSeries servers talking to one another
Embedding SQL into RPG LE programs
In search of a table that shows system & O/S release compatibility
V5R3 view disk IOA cache battery expiration
New option within the WRKSYSACT command
See the users with *change or *all authority

Upgrading
Learn the i: iSeries DevCon coming up in Orlando
System i blades not selling yet, it seems
ISV lures art company away from HP to iSeries
iSeries i5/OS: Top 10 Q&As
iSeries i5/OS: Top 10 Q&As
IBM cuts prices for System i Enterprise, HA servers
Readers respond to pending V5R4 release
SAP-friendly iSeries lowers ERP barriers
In search of a table that shows system & O/S release compatibility
New option within the WRKSYSACT command

RELATED GLOSSARY TERMS
Terms from Whatis.com − the technology online dictionary
AS/400  (Search400.com)
i5/OS  (Search400.com)
iSeries  (Search400.com)
OS/400  (Search400.com)

RELATED RESOURCES
2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems
Search Bitpipe.com for the latest white papers and business webcasts
Whatis.com, the online computer dictionary



Search and Browse the Expert Answer Center
Search and browse more than 25,000 question and answer pairs from more than 250 TechTarget industry experts.
Browse our Expert Advice



iSeries Networking - Printing, Remote Access, TCP/IP
HomeNewsTopicsITKnowledge ExchangeTipsBlogsAsk the ExpertsMultimediaWhite PapersProducts
About Us  |  Contact Us  |  For Advertisers  |  For Business Partners  |  Site Index  |  RSS
SEARCH 
TechTarget provides technology professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective purchase decisions and managing their organizations' technology projects - with its network of technology-specific websites, events and online magazines.

TechTarget Corporate Web Site  |  Media Kits  |  Site Map




All Rights Reserved, Copyright 1999 - 2009, TechTarget | Read our Privacy Policy
  TechTarget - The IT Media ROI Experts