on 04-23-2014 10:13 AM
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
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;
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
hi Ahmed,
Try to update statistics at OS level.
it will work
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
90 | |
10 | |
10 | |
10 | |
7 | |
7 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.