IBM Support

75 ways to demystify DB2 #67: Techtip : Role of ENCRLIB and ENCROPTS in Backup Encryption

Technical Blog Post


Abstract

75 ways to demystify DB2 #67: Techtip : Role of ENCRLIB and ENCROPTS in Backup Encryption

Body

One of the common question DBAs ask related to their mission critical task of Database Backup using DB2 native encryption is - How does setting of ENCRLIB and ENCROPTS impact the database backup?


The following chart summarizes the combination of settings of ENCRLIB and ENCROPTS that result in encrypted backups:

 

– If ENCRLIB is set, backups will always be encrypted
– DBAs can only override the level of backup encryption if ENCROPTS is set to NULL
– A backup will be decrypted when ENCRLIB and ENCROPTS are NULL

 

image
 

[{"Business Unit":{"code":"BU029","label":"Data and AI"}, "Product":{"code":"SSEPGG","label":"DB2 for Linux, UNIX and Windows"},"Component":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"","Edition":""}]

UID

ibm13286857