Modification Packs
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.
The modification value was 0 for all past releases of Db2.
- 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 11.1.1.1. These changes affect all versions and types of the Db2 client.
These changes are seen in the following key areas:- The SQLERRP field in the SQL communication area.
- The SQL_DBMS_VER field in the CLI SQLGetInfo function.
- 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.