cancel
Showing results for 
Search instead for 
Did you mean: 

How to check status of decryption process on SAP HANA Database

phi_d_dang
Explorer
0 Kudos
353

Hi all,

We enabled encryption for our SAP HANA DB. after that, we disable the encryption for testing. It takes a very longtime to decrypt all the services. Is there a way for us to check the process status of the decryption process via HANA Studio or OS terminal? microsoftteams-image-12.png

The service in red box has been running for more than 2 days now and DB is about 150 GB

Sorry. i have to cover the host and port due to company policy

Thanks for the input.

Accepted Solutions (0)

Answers (1)

Answers (1)

yogananda
Product and Topic Expert
Product and Topic Expert
0 Kudos

kemosabe

Yes, you can view the decryption process status in the HANA Studio or the OS terminal. To do so, you will need to use the SQL console and enter the following command to query the encryption status in the HANA database:

SELECT ENCRYPTION_STATUS FROM M_ENCRYPTION_STATUS;


This command will return the encryption status for the entire database: either Encrypted or Decrypted. You can then monitor the progress of the decryption process.

phi_d_dang
Explorer
0 Kudos

Thank you so much. Let me try it now