RSBATCHDATA Archiving data

[nbsiva91]

Hi Team,

We have done the archiving for RSBATCHDATA in OBQ System but the disk size remains same but the no of entries in table is reduced , we have followed the Note 1942703 by running the job 2 times still the disk size is same ..As we are going to do the archiving for the same table in Production system .

Kindly advise us how to proceed .

Thanks 

[mamartins]

What's the database engine running the mentioned system? The disk size will never decrease, instead you will get an increase on the free space inside the database.

On most DB, you need to do a table reorganize to get the free space.

[Sandra_Rossi]

You ask: "the no of entries in table is reduced but the disk size remains same".

See the reply by @mamartins here: RSBATCHDATA Archiving data - SAP Community

On most DB, you need to do a table reorganize to get the free space.

See the answer to your question by AI. Gemini for instance:

• This is one of the most common gotchas in database administration. When you run a DELETE query, the database engine deletes the row references, but it does not return that physical disk space to the operating system.

  Instead, it marks those data pages as "free space" internally, keeping the allocated disk space reserved for future INSERT operations.

• Why Disk Size Doesn't Decrease
  (cut by me)

• How to Reclaim Space Back to the OS
  (cut by me)

[Certified]

Check this out: https://help.sap.com/docs/SUPPORT_CONTENT/bwdabc/3361383878.html