Verifying a database is protected by native encryption

Verify whether or not your database is encrypted by native encryption by verifying the value of the Encrypted database db configuration parameter. You can also use the ADMIN_GET_ENCRYPTION_INFO table function if you would like more information on your encryption settings.

Procedure

To verify that your database has been successfully encrypted by Db2® native encryption, ensure that the value of the Encrypted database db configuration parameter value is YES:

db2 get db cfg for <example_encrypted_database>
          Encrypted database                = YES