Skip to Content
-1

Hana db sizing from non-unicode system

Feb 26 at 03:28 AM

48

avatar image

What is the difference in target hana db size when migration / conversion done from source system being unicode and non-unicode.

Generally for non-hana migration, source and target same databases, the db size increase after migration to unicode. So the above query.

Regards, Subhash

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Frank Schuler
Feb 26 at 09:27 AM
0

Hello Subhash,

There are 3 sizing factors to consider when migrating from a non Unicode database onto SAP HANA:

  • Unicode needs more space since one character is potentially coded as more than one byte.
  • The export and subsequent import reorganises the database which if not done lately can decrease the space it occupies considerably.
  • SAP HANA uses columnar storage for some table that can result in considerable compression.

I would therefore suggest that you run a Suite on HANA memory Sizing report.

Best regards

Frank

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Thanks,

This report was executed in the system. It shows more GB allotted to rows than column structure.

The db size earlier is 6TB, the column figure shows 200GB and rows figure shows 2.5TB.

This was the main reason behind my question. Why the rows size is so high after the report. Was it because of system is non unicode?

0