Skip to Content
0

Index FR2 - Table FRET

Jul 21, 2017 at 08:47 AM

65

avatar image
Former Member

Dear Experts,

we are facing a performance and locking problem on our IS-Retail system and more specific when we are running WA08 to create subsequent documents through Allocation Tables.

In many cases when two ore more users execute this transaction we are facing locking problem - ENQUEUE Excl(Cumulative) AUKO 200$$$$$$$$$$ -

We found that there is the index FR2 on table FRET which is not activated in Database and we also show that the locking is last so much time exactly at the point of select on this table.

Does anyone faced this situation in the past ?

Is it safe to activate this index?

Thank you in advance.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

avatar image
Former Member Jul 21, 2017 at 02:14 PM
1

Hello, George.

We have the same behavior. We were able to reduce the times by ejecting the process in the background and / or with parallel processes.

FMD

Show 2 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Hello Francisco,

thank you for your answer. We already did the same regarding background processing. How can we do the parallel process?

Best Regards.

0
Former Member
Former Member

Francisco , i just found how to use parallel process?

thank you very much.

0
Prithviraj Rajpurohit Jul 24, 2017 at 08:38 AM
1

Hi George,

You can also look at activating the index as this will improve performance while querying the table.

Please do this off business hours.

  1. Call transaction SE14.
  2. Enter the name of the table and choose "Edit".
  3. Choose "Indexes".
  4. Select the index and choose "Choose (F2)".
  5. If you choose "Activate and adjust", the system creates the index again and it is consistent.
  6. Check the object log of this activation.
  7. If an error occurs, eliminate the cause and reactivate the index.

Regards,

Prithviraj.

Share
10 |10000 characters needed characters left characters exceeded