Reduce The Number of Entries Of Table SOFFCONT1

[ehelmihy-c]

The SAP HANA database table SOFFCONT1 is growing rapidly, reaching 900 GB in size as of this writing, which can further increase the size of the database and you have to apply Table Partitioning.

I opened a ticket with SAP, and they shared a solution by referring to KBA 1634908, which is as follows:

Resolution

There are 2 ways to have less entries in SOFFCONT1, using the SAPoffice reorganization report or relocating data from table SOFFCONT1 to a content server:

1. SAPoffice Reorganization Report:

Use the SAPoffice reorganization process (i.e. report RSBCS_REORG) to delete entries in SOFFCONT1 that are no longer referenced by any User/folder, etc. For more information on the reorganization process please see KBA 1641830. Please note that the reorganization report RSBCS_REORG will only delete the entries from the SOFFCONT1 table, the size in the DB should be reduced using the database tool.

2. Content Server:

1. To store documents in an content server instead of SOFFCONT1 table, set a new storage category for DocuClass SOFFPHIO in transaction SKPR08 which is pointing to the Storage Category in transaction OACT which is pointing to the content repository in OAC0 which resides in the external content server you want to use.
   For more info about the configuration read SAP Note 2571570 and 530792.
   Now new documents will be stored in the content server and existing documents in the system will remain in SOFFCONT1. Please review KBA 1975846 as to why some file extensions are still stored in old repository (SAP Database table).


2. You can then use the report RSIRPIRL or RSGOS_RELOCATE_ATTA to physically move the existing documents from SOFFCONT1 to a content server.
   
   
   
   • The report RSGOS_RELOCATE_ATTA (SAP Note 2293171) can relocate GOS attachments only, and it supports the scenarios where only GOS attachments (all or partly) should be relocated.
     The report RSGOS_RELOCATE_ATTA exist only as of SAP Basis Release 740. However, this is only an optional step as the Knowledge Provider still knows whether a document is stored in SOFFCONT1 or on the external content server and can access documents from both.
   
   
   • Report RSIRPIRL (SAP Note 389366) relocates all objects from SOFFCONT1 to a content server.
     Report RSGOS_RELOCATE_ATTA does NOT replace report RSIRPIRL.
     Regarding how to use report RSIRPIRL, consider KBA 2459712.
   
   
   
   

 

I understand that we could proceed with second choice (Content Server) as it the best suitable for our business needs. However, I have only configured Content Server for old data. New data is still stored in the database.

The procedure has been executed.

1- Download the Required Packages

2- Install CS then Install Max DB 

3- Install Max Db Studio

4- Create New Content Repository

5- Create New Maintain Category

6- Run Report RSIRPIRL 

7- Check the Size of Table SOFFCONT1 after Run Report by 24 Hours 

   ------------------------------------------------------------------------------------------------------------------------------

   Step 1- Download the Required Packages. 

  A-  SAPCS

             SAPCS_SP_1218-80004893.SAR

B- Host Agent 

            SAPHOSTAGENT61_61-80004822.SAR 

C- SWPM 1 (Linux OS)

SWPM10SP38_4-20009701.SAR

 D- Max DB 

       51054410_2.ZIP 

E- Database Studio MAX (windows OS)

MAXDBSTDDSK7910_9-20006288.SAR

--------------------------------------------------------------------------------------------------------------------------------------

Step 2- RUN SWPM to Install CS then Install Max DB

 

 

Once you have completed the CS, you can start the MaxDB database

 

 

 

---

3- Install Max DB Studio

Here are some helpful commands you can use to manage MaxDB.

To Start Max DB 

login to server as SIDadm

1- cd /sapdms/SDB/db/bin

2- ./dbmcli -d SDB -u SUPERDBA,MyPassword  db_online

3- cd /sapdms/programs/bin/   

4- run ./sdbgloballistener

5- ./dbmcli -d SDB -u SUPERDBA,MyPassword db_state

 

To Stop: ./dbmcli -d SDB -u SUPERDBA,MyPassword  db_offline

To perform administrative tasks   ./dbmcli -d SDB -u SUPERDBA,MyPassword db_admin

 

---

4- Create New Content Repository

T-Code   OAC0

Configure CS as database repository.

 

---

--------------------------------------------------------------------------------------------------------------------------------------

5- Create New Maintain Category

T-Code   OACT

 

---

6- Run Report RSIRPIRL 

Move the data from database to new DMS,

---

---

7- Check the Size of Table SOFFCONT1 after Run Report by 24 Hours. 

here the result after 24 Hours.