Kieran
Active Member
Hi all
The users have noticed very slow performance in the WPD7333 when inquiring on data (eg Supplier Ledger inquiry), which got worse a month or 2 ago. When I run the same query in PD7333 it returns the data about 10-20 times faster than WPD7333 env. Also if I run the same queries in WPY7333 on the same AS400, the performance is also good.
There are also other screens which are slow so I'm pretty sure its not limited to a index/app, and I checked the debug log and the SQL statements are running quickly.
I tried the tests all from the same citrix server and with the same JDE login. I ran the same queries on the test AS400 in WPY7333 and they ran fine there as well. Both AS400 have the same PTF levels.
I checked the OCMs for WPD and they match the WPY
Any sugggestions on what could it be or what i should check? SQL packages perhaps? I also dont know if they are rebuilding the indexes regularly.
Thanks
Kieran
We are on Xe SP23_U1 and the AS400 is on V5R4. The citrix servers are all Win2003 R2 SP2.
The users have noticed very slow performance in the WPD7333 when inquiring on data (eg Supplier Ledger inquiry), which got worse a month or 2 ago. When I run the same query in PD7333 it returns the data about 10-20 times faster than WPD7333 env. Also if I run the same queries in WPY7333 on the same AS400, the performance is also good.
There are also other screens which are slow so I'm pretty sure its not limited to a index/app, and I checked the debug log and the SQL statements are running quickly.
I tried the tests all from the same citrix server and with the same JDE login. I ran the same queries on the test AS400 in WPY7333 and they ran fine there as well. Both AS400 have the same PTF levels.
I checked the OCMs for WPD and they match the WPY
Any sugggestions on what could it be or what i should check? SQL packages perhaps? I also dont know if they are rebuilding the indexes regularly.
Thanks
Kieran
We are on Xe SP23_U1 and the AS400 is on V5R4. The citrix servers are all Win2003 R2 SP2.