Re: iseries navigator 7.1 slow to show tables

[Jim Oberholtzer <midrangel@xxxxxxxxxxxxxxxxx>]

Very likely this is the result of not enough memory in *BASE.  The 
assumption here is that all of the host servers are still running in 
QUSRWRK and/or QSYSWRK and no work management has been done to tune the 
memory pools, and push all activity out of *BASE except base system jobs.

You might want to check WRKSYSSTS to see if *BASE and *MACHINE pools are 
faulting and paging quite a bit.  Note that even if they are, normal 
character based application usually continue to run within reason.  Any 
remote SQL access regardless of the type is likely to be slow as well.

If the jobs have been moved out of QUSRWRK/QSYSWRK (a good thing!) then 
the memory pool they are running in is most likely in stress as well.

Jim Oberholtzer
Chief Technical Architect
Agile Technology Architects


On 7/17/2012 11:40 PM, Jason wrote:
> Hi,
>
> Is anyone else experiencing performance issues with iSeries Navigator 7.1 and
>   very slow performance to display database tables? Sometimes the tables won’t
> finish
> loading unless I constantly use the scroll bar and can take up to 20 mins to
> display.
> I’m running V7R1 with latest PTF’s installed and latest SP (SI45664) of
> navigator and have tried all the performance tips from IBM but still no luck.
> Any ideas on what could be the issue or where I should investigate further?
>
> Jason
>
> --