Changes to Db2 commands in version 11.5.6

To improve performance and enhance usability in Db2 11.5.6, select Db2 commands have been modified.

Details

Commands
The following commands are changed in 11.5.6:
Enhancement Description

LOAD command

 With the release of Db2 11.5.6, if a table does not include any user-defined constraints, application-period and bitemporal tables are not placed in SET INTEGRITY pending state by the LOAD command. This change removes the need to run the SET INTEGRITY command after a LOAD operation.

Improved db2cm -disable/-enable options to have functionality to disable and enable resources specific to an instance
  • Improved the db2cm -disable/-enable options to have functionality to disable and enable resources specific to an instance. As a result of this change, the db2cm commands: db2cm -enable and db2cm -disable will need the -all option to be included in the command to indicate that the intention is to enable or disable all Pacemaker resources of all Db2 instances in the Pacemaker domain.
  • Db2 resources specific to an instance can be disabled via the new db2cm -disable -instance command and can be enabled via the db2cm -enable -instance command.
  • If the user runs the db2stop command before or after the db2cm -disable –all command, a subsequent db2cm -enable -all command will not enable that instance’s resources. An explicit db2start command is required to enable the resource. The Same behavior also applies to running the db2cm -disable/-enable –instance -host command.
New standard location for the db2cm utility The db2cm utility is now included as part of the Db2 install image and will be installed under the /sqllib/bin directory consistent with existing utilities. Previously, users would obtain the db2cm utility separately and were suggested to install it under /sqllib/adm/.
Updated db2fmtlog command

The db2fmtlog command has been updated to format and display the details of the log records contained in the database log files. Previously, this command only displayed the log file header information.

With the update, there are new parameters that include:
  • the ability to filter the output based on various criteria
  • the ability to produce a summary report of the log records

For more information, refer to db2fmtlog – Format and display log file information command.