In Db2 v11.5.7 on Linux x86_64 I have configured keystore, updated dbm cfg and created database with "encrypt" command:

db2 "create database dbenc encrypt"

Database created successfully.

Now lets say I have two databases encrypted and non-encrypted database. How to check if database is encrypted and what encryption algorithms are used.

1 Answer 1


To get info if current database is encrypted:

db2 get db cfg for <db_name> | grep Encrypted

It returns: Encrypted database = YES if it is encrypted and Encrypted database = No it it is not.

  • 1
    You should accept your answer. It will inform readers that the answer solves the question Commented Mar 3, 2023 at 18:24

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.