TST03 Table space issue

[#1]

Hello all,

We have reached disk space utilization to 80%, when identifying we found TST03 table consumes more space. We have deleted some old spool requests then the table space is reduced by 25GB; however the disk utilization is reduced by only 1GB.

How can we reclaim the remaining 24GB space to minimize disk space utilization?

[simon25]

Hi , 

TST03 is a File LOB table. These require their own cleanup operations post archiving too.

See KBA 3195436  - Analyze high disk utilization in HANA Database

Kind Regards
Simon

[Laszlo_Thoma]

Hi @SAPTest 

SAP Community - Collected information about reclaim / shrink / defragmentation topic in context of SAP HANA persiste...

Regards,
Laszlo

[RaymondGiuseppi]

Read KBA 2400024 - How-To: SAP HANA Administration and Monitoring 

• KBA 2910857 - Increase Data Volume free space 

[sravan_aleshwaram]

Hello

The remaining 24 GB is still allocated in DB/internal segments.
Run table reorg + data volume reclaim (HANA) or tablespace shrink (other DB).

Thanks,
Sravan

[sravan_aleshwaram]

Hello @SAPTest 

The remaining 24 GB is still allocated in DB/internal segments.
Run table reorg + data volume reclaim (HANA) or tablespace shrink (other DB).

Thanks,
Sravan