Verifying the database backup image is encrypted

By default, backups of encrypted databases are also encrypted. However, if you would still like to ensure that your backup image is encrypted, you can run the db2ckbkp command and verify that it returns valid values for compression.

Procedure

To verify that the database backup image is encrypted, run the db2ckbkp command:

db2ckbkp -h <backup_image> | grep Compression

If the image has been successfully encrypted by Db2® native encryption, the compression parameter should return 2 if the backup image is encrypted, or 3 if it is both encrypted and compressed.