Symptom
During an R3load-based migration to SAP HANA Revision 85.02, more
disk space is required than for the same migration to SAP HANA Revision
85.00. This may lead to a disk full event.
Other Terms
SAP HANA database, migration, persistence, DeltaLog
Reason and Prerequisites
Cause:
Due to a program change, more information is stored in the DeltaLog and therefore in the persistence for the ADD PRIMARY KEY CONSTRAINT in SAP HANA Revision 85.02.
Prerequisite:
You migrate to a SAP HANA database Revision 85.02.
Due to a program change, more information is stored in the DeltaLog and therefore in the persistence for the ADD PRIMARY KEY CONSTRAINT in SAP HANA Revision 85.02.
Prerequisite:
You migrate to a SAP HANA database Revision 85.02.
Solution
Carry out the migration with SAP HANA database Revision 85.00 and
then upgrade to 85.02. This behavior occurs only if primary keys are
created in new tables.
Alternatively, merging with the FORCE REBUILD option has the result that the DeltaLog is immediately cleaned up:
MERGE DELTA of <tablename> FORCE REBUILD;
You can also use this statement to test which tables have an unusually high delta and then specifically clean them up using the above merge command.
select
VT.*
from "PUBLIC"."M_TABLE_VIRTUAL_FILES" as VT
left join "PUBLIC"."M_CS_TABLES" AS CT ON VT.schema_name=CT.schema_name
and VT.table_name=CT.table_name
and VT.part_id=CT.part_id
where VT.name='$delta$'
and CT.raw_record_count_in_delta=0
and VT.schema_name='SAPMOR'
order by physical_size desc;
Remarks
A correction is provided in SAP HANA database Revision 85.03.
Alternatively, merging with the FORCE REBUILD option has the result that the DeltaLog is immediately cleaned up:
MERGE DELTA of <tablename> FORCE REBUILD;
You can also use this statement to test which tables have an unusually high delta and then specifically clean them up using the above merge command.
select
VT.*
from "PUBLIC"."M_TABLE_VIRTUAL_FILES" as VT
left join "PUBLIC"."M_CS_TABLES" AS CT ON VT.schema_name=CT.schema_name
and VT.table_name=CT.table_name
and VT.part_id=CT.part_id
where VT.name='$delta$'
and CT.raw_record_count_in_delta=0
and VT.schema_name='SAPMOR'
order by physical_size desc;
Remarks
A correction is provided in SAP HANA database Revision 85.03.
Header Data
| Released On | 18.03.2015 16:11:37 | ||
| Release Status | Released for Customer | ||
| Component | HAN-DB SAP HANA Database | ||
| Other Components |
| ||
| Priority | Correction with medium priority | ||
| Category | Program error |
No comments:
Post a Comment