SAP Knowledge Base Article - Preview

3157759 - HANA BACKUP Compression does not work

Symptom

To use this new feature "data backup compression", the configuration parameter "data_backup_compression_level" for TenantDB was set from default '0' to '2', but the compression does not make any effect when taking a data backup.

[6501]{200552}[23/34675106] 2021-12-16 08:54:31.547293 i TraceContext TraceContext.cpp(01347) : UserName=SYSTEM, ApplicationUserName=Patrick, ApplicationName=HDBStudio, ApplicationSource=csns.admin.commands.AdministrationHandler$1$1.call(AdministrationHandler.java:338);csns.admin.commands.AdministrationHandler$1$1.call(AdministrationHandler.java:1);java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264);java.base/java.util.concu, StatementHash=03fc3791ecd0e7d0ee0edd34f925635a, StatementExecutionID=1407383473493989
[6501]{200552}[23/34675106] 2021-12-16 08:54:31.547293 i SQLSessionCmd Statement.cc(06541) : INI configuration is changed by 200552, client ip=192.168.1.123, client port=13166, query=alter system alter configuration ('global.ini','DATABASE') set ('backup','data_backup_compression_level') = '2' with reconfigure
.
.
[6501]{200552}[23/34682425] 2021-12-16 11:03:08.446517 i TraceContext TraceContext.cpp(01347) : UserName=SYSTEM, ApplicationUserName=Patrick, ApplicationName=HDBStudio, ApplicationSource=csns.admin.commands.AdministrationHandler$1$1.call(AdministrationHandler.java:338);csns.admin.commands.AdministrationHandler$1$1.call(AdministrationHandler.java:1);java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264);java.base/java.util.concu, StatementHash=20c439d97894f35e5a6e023f2c69a817, StatementExecutionID=1407383473502138
[6501]{200552}[23/34682425] 2021-12-16 11:03:08.446517 i SQLSessionCmd Statement.cc(06541) : INI configuration is changed by 200552, client ip=192.168.1.123, client port=13166, query=alter system alter configuration ('global.ini','DATABASE') set ('backup','enable_log_backup_compression') = 'true' with reconfigure


Read more...

Environment

SAP HANA DB 2.0

Product

SAP HANA, platform edition 2.0

Keywords

KBA , HAN-DB-BAC , SAP HANA Backup & Recovery , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.