Page tree
Skip to end of metadata
Go to start of metadata

2008 & 2009

TKU July 2008

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.

TKU February 2009

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.

TKU October 2009

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.


TKU January 2010

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.

TKU February 2010

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.

TKU June 2010

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.

TKU July 2010

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".

TKU August 2010

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.

TKU September 2010

In TKU September 2010 the regular expression used to obtain service name that needed for getting the port was enhanced.


TKU March 2011

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.

TKU October 2011

In TKU October 2011 the pattern was updated to support all DB2 Features, which are licensed separately from the main product.

TKU November 2011

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.

2012 & 2013

TKU August 2012

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.

TKU May 2013

In TKU May 2013 list of known_version was updated

TKU November 2013

In TKU November 2013 an internal change was made to the way feature details are aged

TKU November 2013

In TKU November 2013 Added additional method to obtain user home directory for Unix platform(RFE QM001806458).

TKU December 2013

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).


TKU March 2014

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.

TKU May 2014

In TKU March 2014 fixed ECA error caused by absent cmdline attribute in DiscoveredService node

TKU September 2014

From TKU Sep 2014, the pattern includes the following updates:

  • The pattern was improved to parse a license file correctly (TKU-2349).

TKU December 2014

In TKU Dec 2014, the pattern has been enhanced to retrieve extra information from active versioning.


TKU February 2015

In TKU February 2015 the pattern was updated with the following changes:

  • Privilege command execution configuration using the pattern configuration block has been deprecated. A recommended method through the BMC Atrium Discovery platform configuration is described here.

TKU October 2015

In TKU October 2015 the pattern was updated with the following changes:

  • Added product_dir attribute.


TKU February 2016

In TKU February 2016 the DatabasesAndTables pattern in the IBM DB2 Extended Discovery pattern module was updated with the following changes:

  • si_type was changed into "DB2 Databse".
  • shema full_type was changed into "DB2 Database Schema".

TKU March 2016

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.



TKU January 2017

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.

TKU March 2017

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.


TKU April 2019

In TKU April 2019 the following changes were made:

  • Pattern runCommands updated.