OWXer
Active Member
We have been having a serious degraded performance issue with the P4210 in particular since last Tuesday in our Production environment, the whole application also comes to a halt all in a sudden, users used the parent and item as the search key to look for orders and it took over 7 - 10 minutes to return the result, we have no clue what went wrong so far.
We took the recommendations from Oracle to reorg the F4211 and F42119, we ipl our iSeries, it has almost no improvement. Interesting thing is it seems that it doesn't occur in our Test environment, I compared the records between Test and Production environments, they don't have too much difference. We have only about 1.8 M records in F42119 and 47 K in F4211 in Production and 1.7 M records in F42119 and 32 K in F4211 in Test.
We also took the SQL statement generated from the JDE log to run it on our iSeries interactive SQL session, it turns out fine.
Could anyone shed some lights on my issue? It would be greatly appreciated.
We took the recommendations from Oracle to reorg the F4211 and F42119, we ipl our iSeries, it has almost no improvement. Interesting thing is it seems that it doesn't occur in our Test environment, I compared the records between Test and Production environments, they don't have too much difference. We have only about 1.8 M records in F42119 and 47 K in F4211 in Production and 1.7 M records in F42119 and 32 K in F4211 in Test.
We also took the SQL statement generated from the JDE log to run it on our iSeries interactive SQL session, it turns out fine.
Could anyone shed some lights on my issue? It would be greatly appreciated.