We would like to know Data Archiving capabilities of standalone SAP HANA tables.
Currently we are on HANA 2.00.024.02.1525857514 (fa/hana2sp02)
We have auditing enabled in the system. The audit log table growth is huge(Around 350GB) which effects the backup size.
Schema Name : _SYS_AUDIT
Table Name : CS_AUDIT_LOG_
Table Size : 340GB
Few SAP notes saying to delete old data from the table but in our case the retention has to be 2 months. Even though we haven't completed 2 months, our database size is growing rapidly.
Also the schema(_SYS_AUDIT) is not visible under Catalog even with SYSTEM user. Is there a way to see the schema under catalog?
Also we would like to know if any standard archiving techniques in SAP HANA . preferably moving data from table level to filesystem level?
Thanks and Regards