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.
SAP Knowledge Base Article - Preview