Modification Packs

The Db2® four part product signature is of the format VV.RR.MM.FF where:
  • VV Is the Version number.
  • RR Is the Release number.
  • MM Is the Modification number.
  • FF Is the Fix Pack number.
This product signature format follows the Maintenance Delivery Vehicle standard that is being implemented throughout the IBM® product lines. For more information, see Maintenance Stream Delivery Vehicle terminology. A Modification number, also referred to as a Mod Pack, is used to indicate new significant features. Subsequent updates for Db2 11.1 now follow this product signature standard.

The modification value was 0 for all past releases of Db2.

However, with the introduction of a nonzero Modification value, the product signature information that is returned by Db2 interfaces and commands is now changed to accurately reflect the current product signature information. The following list shows examples of the major types of changes that have been implemented:
  • Changes to command line processor CLP connect with command output:

    Starting Db2 Modification Pack 1, the output of a successful connect request that is issued through CLP is changed to return a 4-part product signature. Older versions of CLP continue to return a 3-part product signature, with the third part reflecting the modification number and not the fix pack number.

  • Changes to existing 3-part product signature output:

    Interfaces that return a 3-part signature now return version, release, and modification information when connected to a Db2 v11.1.1.1 (or higher) database rather than version, release, and fixpack information that they used to return on versions before Db2 These changes affect all versions and types of the Db2 client.

    These changes are seen in the following key areas:
  • Changes to JCC getDatabaseVersion output:

    The results of the JCC getDatabaseProductVersion method now return the full product signature in the form of SQLVVRRMF unless the includeModLevelInProductVersion property is explicitly set to NO.

To determine the full version of Db2, use the db2level command.