db2 backup fails after 12.1.1.0-cn1 upgrade
Condition
After you upgrade to 12.1.1.0-cn1 with enableBackupCompression set to YES,
db2 backup fails with the following
error:
SQL2071N An error occurred while accessing the shared library
"/opt/ibm/db2/V11.5.0.0/lib64/libdb2compr_encr.so.1". Reason code: "1".
Workaround
Set the ENCRLIB database configuration parameter to the correct path.
Procedure
Run the following command:
db2 connect to $DBNAME
db2 'update db cfg for $DBNAME using ENCRLIB /mnt/blumeta0/home/db2inst1/sqllib/lib/libdb2compr_encr.so.1'
db2 terminate