[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 4406
  • Last Modified:

Slow Performance querying AS400 via iSeries Client Access / 64-bit ODBC

I'm creating an application in 64-bit Windows that extracts data from AS400 using IBM Client Access 64-bit ODBC.   Issue is when query is running on AS400, it is very slow compared to other executing queries, time waits and pulls records back to my server a few at a time.   Trouble must be with IBM Client Access 64-bit ODBC driver, which I am required to use to access AS400 directly, but need to improve performance significantly.

No help from IBM yet, and hoping to for suggestions on performance settings or alternative solutions.

Please let me know your thoughts.
0
QlikJim
Asked:
QlikJim
  • 2
1 Solution
 
JBart_17Commented:
If possible make logical files of the files you are accessing on the As400.
 
For example if you are doing a query on say the order header fire and the physical file is keyed by order#, but your selection criteria is by date range. Then you can speed up performance by creating a logical file of the order header file on the as400 keyed by order Date and using the new logical file in you query.  
 
Logical files are similar to Views in MS SQL  
 
 That should help a lot, if youre still having issues check out
 
http://www-03.ibm.com/systems/i/software/db2/sqlperffaq.html
0
 
JBart_17Commented:

 if you are joining files the keys are important for performance, so logical files can also help here.
if you test your SQL query in iSeries navigator, you can click the VisualExplian  menu and it will explain what is going on when the query executes this data should help you  optimize your query  
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now