Change tablespace of Wf tables URGENT!!
we have a problem with the tablespace the workflow tables are stored on. The problem is, that it is nearing max size at rapid pase.
The question is; What happens, if we change the table space of the workflow tables? Will running workflows be corruptet, if yes can they be restartet? What other problems will we face?
Any help will be highly appreciatet.
Mike Pokraka replied
I would strongly recommend NOT to change tablespaces, for a few reasons.
They are optimized by SAP to provide the best performance. E.g. log tables are on different tablespaces to transaction tables - thus different disks, thus can be written in parallel. It goes far deeper than that, there are many DB parameters associated with a tablspace.
Also, you will have to restrict access or disable WF or possibly even shut down your system (you didn't mention - MS-SQL, Oracle, MaxDB, DB2..., Version? SAP Version?)
Why not extend the tablespace? This is really something your Basis guys should be able to cope with! Alternatively look at Archiving (Huh?) in a great big hurry - Tx. SARA.
Another quick-fix not really recommended is SWWL - use it on some high-volume flows e.g. some useless IDOC error tasks that people keep switching on and redirecting to dummy users on many systems. BUT aside from big notes advising against productive use, be aware that auditors may not approve of WI deletion logs in your system....