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"
There may be some useful tips also here:
================================== 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.
This was first published in July 2002