Clean Up SAP Knowledge Warehouse to Improve Performance for SAP Solution Manager

  • by D. Russell Sloan, Implementation and Governance Specialist — SAP Solution Manager, IBM Global Business Services
  • January 6, 2011
Manager
As you take advantage of all the utilities of SAP Knowledge Warehouse (SAP KW) in SAP Solution Manager, numerous versions of documents and high index counts can rob it of performance and use up valuable storage space. Learn how to quickly reclaim storage and improve the performance of SAP KW by removing obsolete versions of documents.
Key Concept
Support Package 25 for SAP Solution Manager 7.0 enhancement package 1 now provides utilities to clear out unwanted versions of documents. It reduces total storage requirements and improves the performance of SAP Knowledge Warehouse (SAP KW). Transactions KW_IO_DEL and KW_IO_DEL_TR can help keep SAP KW clean and running well.

Each time you save a document in SAP Solution Manager — whether creating a new document or saving after editing — the system generates and stores a version of the document. Over time, this can result in many copies of the same document being stored in the version history, consuming a large volume of data and slowing down your system.

The utilities I discuss delete the obsolete versions of your documents, saving space and reducing the index sizes in SAP Knowledge Warehouse (SAP KW). This quick tip applies to projects using the Solution Manager Knowledge Warehouse (SAP KW) without the Test Workbench. For options to manage the SAP KW using the Test Workbench see https://service.sap.com/~sapidb/011000358700000362852009E/SolOpsGuide_EHP1_20090812.pdf.  

Note that the utilities I describe are powerful and should be used only by people who thoroughly understand them. You should take the following precautions to safeguard SAP Solution Manager before proceeding:

D. Russell Sloan

D. Russell Sloan is a specialist in project and program governance for IBM. He focuses on the use of SAP Solution Manager for global rollout projects for IBM’s largest customers, having worked with SAP software since 1996. Russell has degrees in accounting and information systems and has been a team and project leader for SAP projects for more than 14 years. He has been developing and deploying software systems for over 30 years.

See more by this author


Comments

No comments have been submitted on this article. 


Please log in to post a comment.

To learn more about subscription access to premium content, click here.