Slow Running UBE R42995

Hi

R42995 UBE (Repost Active Sales Order) is run on a daily basis through the Scheduler on RS6000 server. On B7331 this UBE used to take about 6 hours to complete. In late August we purged the data from few tables and the UBE completion time dropped to 1.5 hours.

On 16th Sep we upgraded the system to XE Upgrade 3 and SP17.1. Since the upgrade the time to complete this UBE has gone up again to 6 hours.

We are wondering as there is no change to the data and still the time taken is more than what it used to be 3 days before the upgrade.

Any suggestions and thoughts will be appreciated.

XE Update 3 SP 17.1 Oracle 8.1.7.4 RS6000 AIX


Dalip

Hi Dalip,

We run the R42995 three times in less than 10 minutes every morning. (we have a small sales order detail F4211, 16500 lines)
The first one is used to repost active sales order for the stocked lines, the second for the un-stocked lines.
The third version is used to re-calculate the stocks with a dummy sales order.
There is a SAR, on the KG, which we applied unvolontarily, who force the R42995 to exit when a line of the F4211 doesn't match to the data selection. So, you have to sort your data finely for each version. With this SAR, the R42995 is very faster because it doesn't need to read all the F4211 table.
Hope this will help you.

Regards

I would suggest getting the JDEDEBUG log and passing it through JDE's
Performance Workbench (it is a free download from the Knowledge Garden). It
summarizes the log and also does timing checks on SQL stmts within the log.
You get it by going to KG and Support/Support Tools/ Performance Workbench.
It downloads to your C:\ drive, you unzip it and you are good to go.
Documentation on it is great! I would recommend this to everyone.


It sound to me like there might be a missing index on one of your tables.

Hi,

Have a look at TIPS and TRAPS.
I've found the following message.
----------------------------------------------
(Suggested by Larry Jones and Libbi Fletcher)
To speed up UBE performance

In the JDE.INI file (oneworld/b7333/ini/) find the [LOCK MANAGER]section and make sure that the RequestedService parameter is set to NONE, per oti-99-0024. This has the effect of speeding up transaction processing for some UBEs (this should only be changed on the server's JDE.INI file).

You may want to change the jde.INI file in the Lock Manager section to
Requested Service = *none. It took us from 20 hours for a repost to 1 hour.
----------------------------------------------

Regards.

have you ever run a purge job for that table? if i remember correctly we did win back time with that.

We run it every night on workdays to keep it as small as possible
its report R42996 Purge so lines

Hi

I have the same issue with this UBE (R42995).
Does anyone in the list find a definitive solution for this problem?

Nab.
XE SP22T1 Oracle 8.1.7 RS6000 AIX

Please can you tell me what was the SAR number for this fix?