Which statement about the DB2_BCKP_COMPRESSION registry variable is TRUE?
Which statement about the DB2_BCKP_COMPRESSION registry variable is TRUE?
The DB2_BCKP_COMPRESSION registry variable, when set, ensures that backup images created with the BACKUP command are automatically compressed. This variable controls whether backups will be compressed, either using the default Db2 compression or hardware-accelerated methods if specified.
The answer D is correct, How to use this as backup To start a backup using the hardware compression, it is necessary to specify the library: backup database databasename compress comprlib libdb2nx842.a The backups can be compressed by default with NX842. To achieve this the registry variable DB2_BCKP_COMPRESSION has to be set to NX842. Afterwards, issue the command: backup database databasename compress. The image will then be compressed using the NX842 hardware compression. Using the solution for log archive compression The NX842 hardware compression can also be used for log archive compression. To activate this, change the database configuration parameter LOGARCHCOMPR1 or LOGARCHCOMPR2 to NX842 using this command: update database configuration for databasename using LOGARCHCOMPR1 NX842 REFERENCE : https://www.ibm.com/support/knowledgecenter/SSEPGG_11.1.0/com.ibm.db2.luw.admin.ha.doc/doc/c0062003.html
The correct answer is B "DB2_BCKP_COMPRESSION Operating system: All Default: COMPRESS, Values: COMPRESS, NX842 Specifies whether backups are compressed with the common Db2 compression or with NX842 compression. NX842 compression is only available on AIX (see Hardware accelerated backup and log file compression for details)." Reference: https://www.ibm.com/support/knowledgecenter/SSEPGG_11.1.0/com.ibm.db2.luw.admin.regvars.doc/doc/r0005669.html