HANA PERSISTENCE encryption - how to check the progress?

[andreapancotti]

Hi everyone
yesterday I executed, on the TENANTDB of a HANA system, the command for the encryption of the PERSISTENCE layer:

ALTER DATABASE <tid> PERSISTENCE ENCRYPTION ON;

After approximately 18 hours, the encryption is still in progress:

I also run the following query:

SELECT
HOST
, DATABASE_NAME
, PORT
, ENCRYPTION_ACTIVE
, DATA_CONVERSION_ACTIVE
FROM
SYS_DATABASES.M_PERSISTENCE_ENCRYPTION_STATUS;

So it would appear that the process is still ongoing.

I was wondering if there was a trace where I could check the status of the activity to understand if it's stuck or even estimate the total duration time.

Thank you all !

p.s. this tenant is approximately 4TB large

[Laszlo_Thoma · Accepted solution]

Can you please check if this helps?

2400005 - FAQ: SAP HANA Persistence - - > 9. Is it possible to encrypt the persistence level?

...
You can use SQL: "HANA_Security_PersistenceEncryption_Status" (SAP Note 1969700) to check for the current persistence encryption state. REENCRYPTION_ACTIVE = TRUE indicates that the re-encryption of data is still in progress.
...

Regards,
Laszlo