The effectiveness of the active versioning method in the DB2 pattern was increased by adding an additional approach to obtaining the path to the home directory of the user that owns a DB2 instance.
The active versioning method relies on setting up of the correct shell environment prior to the execution of the 'db2level' command which provides the version information. Prior to TKU July 2008 execution of the script that sets up the environment relied on directly accessing the script using shell tilde ('~') expansion. Since shell tilde expansion does not work across all shells (Bourne shell in particular), an additional approach has now been added which takes precedence over the use of shell tilde expansion. The pattern now attempts to parse '/etc/passwd' file for the user's home directory as described on the pattern description page.
The DB2 pattern was updated in the TKU February 2009 release to add additional attributes to the Software Instance which provide port and protocol information and a list of databases for a given DB2 instance.
Added copy_name attribute to SI (for Windows hosts), modified active versioning, changed versioning methods for Windows systems, added v9.7 as known version. Now, if extracted, installation path is also being used while creating key attribute.
In TKU January 2010 we amended the way revisions were shown. A revision of value zero is now shown as a blank field in the Software Instance. The service pack attribute is already shown in this way.
In TKU February 2010 we added edition and licensing support for both Windows and UNIX platforms. If the installation root is placed in the key on the Windows platform, such key has been changed slightly in having the installation root's final 'BIN' folder (if one) removed.
In TKU June 2010 the dependency between edition and licensing detail was removed, resulting in a licensing detail node now being created for each and every license returned by the db2licm -l command.
In TKU July 2010, duplicate database names are now removed from the SI's databases attribute. In addition, a DB2 Licensing detail node now has a name of "<Licensed_Product> License" rather than the default "IBM DB2 Database Server".
In TKU August 2010 there were some slight changes to prevent race conditions that could occur when the Software Instance was searched for before it was added to the datastore.
The 'db2licm -l' active command is now additionally executed at <user_homedir>/sqllib/adm.
The regular expression to get edition from nodelock file has been improved.
In TKU September 2010 the regular expression used to obtain service name that needed for getting the port was enhanced.
In TKU March 2011 licensing command was updated. Now it provides more details in its output. DB2 Feature Details are now modeled for respective DB2 editions.
In TKU October 2011 the pattern was updated to support all DB2 Features, which are licensed separately from the main product.
In TKU November 2011 the defect had been fixed, which caused all known Feature Details created if no licensing information for installed Features is received from licensing command.
In TKU August 2012 the extended discovery pattern was created which models Database, Schema and Table Details. "databases" attribute has been removed from now on. 'Install_dir' attribute extraction regex for Windows is now consistent to Unix one.
In TKU May 2013 list of known_version was updated
In TKU November 2013 Added additional method to obtain user home directory for Unix platform(RFE QM001806458).
In TKU December 2013 the core IBM DB2 RDBMS discovery pattern was refactored into two separate patterns (UNIX platforms and Windows platforms) to enable improved modelling of the product on the Windows platform (QM001810220). Furthermore, the extended IBM DB2 RDBMS discovery patterns were updated to improve the accuracy of the model created in environments where there are multiple aliases for each database instance. The extended discovery patterns were also updated to make the creation of nodes more efficient (QM001804697).
In TKU March 2014 the code in the IBM DB2 RDBMS pattern to obtain license information was improved. Error handling from db2licm command was improved and additionaly, db2licm command can now be run with elevated privileges on UNIX/Linux platforms (if configured by the user) to enable discovery of licensable options / products in environments where the ADDM login user does not have login permissions to run this command.
Furthermore, in the IBM DB2 RDBMS extended discovery pattern a retrieve_schemas setting (defaulting to true) was added to pattern the configuration block. Finally, the ';' characters were changed to '&&' in active commands within the extended pattern.
In TKU March 2014 fixed ECA error caused by absent cmdline attribute in DiscoveredService node
From TKU Sep 2014, the pattern includes the following updates:
In TKU Dec 2014, the pattern has been enhanced to retrieve extra information from active versioning.
In TKU February 2015 the pattern was updated with the following changes:
In TKU October 2015 the pattern was updated with the following changes:
In TKU February 2016 the DatabasesAndTables pattern in the IBM DB2 Extended Discovery pattern module was updated with the following changes:
In TKU March 2016 the DatabasesAndTables pattern in the IBM DB2 Extended Discovery pattern module was updated to fix key change issue related to Feb TKU SI_type change.
In TKU January 2017 the trigger was updated to additionally trigger on 'db2sysc 0' to dealt with strange listing of such command in ps output on Solaris.
In TKU January 2017 added support for installation on IBM PowerHA Cluster(DRDC1-7514)
IBM DB2 Extended Discovery pattern update (key change)
The DatabasesAndTables pattern in the IBM DB2 Extended Discovery pattern module comes with a key change on all DatabaseDetail nodes this pattern creates. This may impact your CMDB data. To avoid this issue (assuming you have not upgraded to TKU Feb yet), please wait until TKU March which is scheduled to be released during the last week of March 2016.
In TKU April 2019 the following changes were made: