Q
Problem solve Get help with specific problems with your technologies, process and projects.

ASP pages to connect to distant iSeries database

We've been trying to find help on the Internet and stumbled across your pages. We're using ASP pages to connect to a distant iSeries database via Client Access and an ODBC layer on Windows Server 2000. The response time makes it difficult to use the pages we developed. Have you any info on how we could better set the parameters in the connection layer, or any further pages we could go to. What other info do you need on this problem?
I do ASP to iSeries with configuration similar to yours and have no performance problem. This is probably an SQL tuning issue (for example selecting rows without relevant index). In order to resolve the issue of SQL tuning I recommend you to use OpsNav. Please refer to the following page and download the PDF file for "database"

Using iSeries Navigator.

There may be some useful tips also here:

iSeries Access

==================================
MORE INFORMATION ON THIS TOPIC
==================================

Ask your systems management questions--or help out your peers by answering them--in our live discussion forums.

The Best Web Links: Tips, tutorials and more.


Dig Deeper on iSeries Access (Client Access)

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataCenter

Close