|
Although there is not enough information to formulate a very accurate answer, here would be some suggestions:
1. Look at the system when there appears to be a real slowdown. Is one job or process consuming a lot of CPU performance? If so, is that job an SQL program?
2. Are you running SQL statements against very large physical files with very few logical files? (This would be where I would start.) The iSeries attempts to find the best logical file for a query process. If there are very few logical files, the iSeries may be reading a lot of unnecessary records. ==================================
MORE INFORMATION ON THIS TOPIC
==================================
The Best Web Links: Tips, tutorials and more.
Ask your systems management questions--or help out your peers by answering them--in our live discussion forums.
Read this Search400.com Featured Topic: Managing your iSeries.
Ask the Experts yourself: Our systems management gurus are waiting to answer your technical questions.
|
