How To Enhance The performance of the STMS import Queue ?

[Former Member]

Dear Experts,

We have ERP system SAP NW 7,31 SP 05. Our Platform is AS/400 and The Database Is DB2.

We are facing performance issues with the STMS transaction it takes 5Min to refresh and alot time to import, and even more in the busy hours of the system.

My Questions are :

1- is there any tips to fine tune the performance of the STMS ?

2- Our Dev system have over 400 requests that already have been imported in the PRO system, if i delete them from DEV queue

will it effect the PRO system ?

And if you know any tips or tricks please share with me

Many Thanks In Advance..

Regards,

Ahmed Salam

[Former Member]

Hi Ahmed.

If you TMS are using different Transport Group for each system (check in STMS > System Overview > Communication > Transport Group container) you may have experiences low performance when open the enqueue. Every time you access the enqueue the system check all requests in all systems to sync them.

If is this case, try to put all systems in same Transport Group and check the table statistics of TMS tables.

Is a good practice to remove transported orders. If you schedule or setup automatic transport this is done automatically. This only removes/cleans the buffer area. The data and cofile files still remains in 'trans' folder.

You can check the logs in STMS > Import Overview > [select system] > Goto > History > Import History.

I hope this helps you.

Mauricio;

[ACE-SAP]

Hello

Are you using a centralized transport directory ?

If so the import queue (buffer file) is located on a shared drive and it can take some time to read it.

A good option is to cleanup the queues from already imported orders using tp option "clearold".

Deleting already imported orders from the queue won't have any impact on the system where they were imported.

Check note 1223360 for various options that can speed up CTS orders import.

Best regard

312843 - tp CHECK/CLEAROLD latest News

1223360 - Composite SAP Note: Performance optimization during import

[Former Member]

Dear Yves,

I want to ask , is it ok to delete already imported requests from DEV system ?? does it disturb the work flow ?  if yes can yo advice for some ways to do so ?

Thanks in advance

Regards,

Ahmed Salam.

[ACE-SAP]

Hello

You can delete import orders without impact... if you need to import them again you can still manually insert them again in the queue.

You can do the cleanup manually by removing entry in STMS (and then data & cofiles won't be deleted and no space gain on transport dir.) or using the tp clear old.

Regards

[Former Member]

hi Ahmed,

Try to update statistics at OS level.

it will work

[Former Member]

please explain more.