IBM DB2 RDBMS - Change History

TKU July 2008

The following improvements were made:

• Added a new active versioning approach.
• Added a new approach that takes precedence over the use of shell tilde expansion.
• Updated the way in which the pattern attempts to parse the /etc/passwd file for the user's home directory.

TKU February 2009

Added new attributes to the Software Instance which provide port and protocol information and a list of databases for a given DB2 instance.

TKU October 2009

The following improvements were made:

• Added a copy_name attribute to SI for Windows hosts.
• Modified active versioning.
• Changed versioning methods for Windows systems.
• Added v9.7 as a known version.
• If extracted, the installation path is also used while creating a key attribute.

TKU January 2010

Improved the way in which revisions are shown. A revision of value zero is now shown as a blank field in the Software Instance (similar to the service pack attribute).

TKU February 2010

The following improvements were made:

• Added edition and licensing support for the Windows and Unix platforms.
• If the installation root is located in the key on the Windows platform, the installation root's final bin folder (if it exists) has been removed.

TKU June 2010

Removed the dependency between the edition and licensing detail, which means that a licensing detail node is created for each license returned by the db2licm -l command.

TKU July 2010

The following improvements were made:

• Removed duplicate database names from the SI's databases attribute.
• Renamed a DB2 Licensing detail node to "<Licensed_Product> License" from the default "IBM DB2 Database Server".

TKU August 2010

The following improvements were made:

• Minor changes to prevent race conditions that might occur when the Software Instance is searched for before its addition to the datastore.
• The db2licm -l active command is now additionally executed at <user_homedir>/sqllib/adm.
• Improved the regular expression to obtain an edition from the nodelock file.

TKU September 2010

Enhanced the regular expression to obtain a service name used to retrieve a port number.

TKU March 2011

The following improvements were made:

• Updated the licensing command to provide more details in its output.
• DB2 Feature Details are now modeled for respective DB2 editions.

TKU October 2011

Updated the pattern to support all DB2 Features that are licensed separately from the main product.

TKU November 2011

Fixed an issue with creating of all known Feature Details if licensing information for installed Features is not retrieved from the licensing command.

TKU August 2012

The following improvements were made:

• Created an extended discovery pattern that models Database, Schema and Table Details.
• Removed the databases attribute.
• Made the install_dir attribute extraction regex for Windows consistent to the Unix one.

TKU May 2013

Updated the list of known_versions.

TKU November 2013

Made an internal change to the way Feature Details are aged.

TKU November 2013

Added a new method to obtain the user home directory for the Unix platform (RFE QM001806458).

TKU December 2013

The following improvements were made:

• Refactored the core IBM DB2 RDBMS discovery pattern into two separate patterns (Unix platforms and Windows platforms) to enable improved modelling of the product on the Windows platform (QM001810220).
• Updated the extended IBM DB2 RDBMS discovery patterns to improve the accuracy of the model created in environments with multiple aliases for each database instance.
• Updated the extended discovery patterns improve the creation of nodes (QM001804697).

TKU March 2014

The following improvements were made:

• Improved the way in which the pattern obtains license information.
• Improved error handling from the db2licm command.
• The db2licm command can now be run with elevated privileges on the Unix and Linux platforms (if configured by the user) to enable discovery of licensable options and products in environments where the ADDM login user does not have login permissions to run this command.
• Added a retrieve_schemas setting (by default, true) to the pattern configuration block.
• Changed the ";" characters to "&&" in active commands within the extended pattern.

TKU May 2014

Fixed an ECA error caused by the missing cmdline attribute in the DiscoveredService node.

TKU September 2014

Improved license file parsing (TKU-2349).

TKU December 2014

Enhanced the pattern to retrieve extra information from active versioning.

TKU February 2015

Deprecated privilege command execution configuration through the pattern configuration block. A recommended method is the BMC Atrium Discovery platform configuration.

TKU October 2015

Added a product_dir attribute.

TKU February 2016

The following improvements were made for the DatabasesAndTables pattern in the IBM DB2 Extended Discovery pattern module:

• Changed the si_type was changed to "DB2 Database".
• Changed the schema_full_type to "DB2 Database Schema".

TKU March 2016

Fixed a key change issue for the DatabasesAndTables pattern in the IBM DB2 Extended Discovery pattern module.

TKU January 2017

Updated the trigger to handle erroneous listing of the db2sysc 0 command in the ps output on the Solaris platform.

TKU March 2017

Added support for installation on the IBM PowerHA Cluster (DRDC1-7514).

TKU April 2019

Updated the pattern to use runCommand functions.

TKU March 2020

Added a secure_port attribute to the IBM DB2 SoftwareInstance node.

TKU September 2021

Updated the command for db2-schemas to comply with the most recent naming standards.

TKU December 2023

Added support for the Windows platform to the IBM DB2 HADR extended pattern (DRDC1-21839).