Why is the IS_DYNAMIC attribute on CONFIGLEMENT table not working correctly?

Question & Answer

Question

Why is the IS_DYNAMIC attribute on CONFIGLEMENT table not working correctly? What steps need to be followed to get the changed value dynamically i.e without restarting the server and what is the product behavior around this attribute?

Cause

First define a custom configuration in CONFIGELEMENT table with IS_DYNAMIC value set to 1. Value of the CONFIGLEMENT is fetched in a service (custom composite transaction) call.

INSERT INTO DB2ADMIN.CONFIGELEMENT VALUES (100063,1006,'/CDIHub/Messaging/FilterResponseNotifications/enabled','true','false', null,CURRENT_TIMESTAMP, 'cdihub',1,null );

The value of this CONFIGLEMENT is changed at runtime from true to false, but the changed value is not reflecting in the service call without restarting the server. Only restarting is helping to reflect the changed value.

UPDATE DB2ADMIN.CONFIGELEMENT SET VALUE = 'false', last_update_dt = current timestamp where name = '/CDIHub/Messaging/FilterResponseNotifications/enabled'.

The IBM Documentation says the restart is not required in this context. "An indicator showing whether configuration changes made to this record take effect dynamically, i.e. without restarting the application server."

Also, it shows Char (1) but no example of valid entries.

https://www.ibm.com/docs/en/imdm/11.6?topic=tables-configelement

Answer

The IS_DYNAMIC attribute is not effective when a configelement item is updated using sql. Please use the Management Console as described in the following links. You need to start the Management Agent first.

https://www.ibm.com/docs/en/imdm/11.6?topic=agent-starting-management#t_Starting_the_Management_Agent

https://www.ibm.com/docs/en/imdm/11.6?topic=overview-starting-management-console

When the Management Console is started, select 2 in the menu to modify configuration items.

You need to provide the following information: the application and version in the table APPSOFTWARE, the deployment name in the table APPDEPLOYMENT and the instance name in the table APPINSTANCE. You can leave it blank if the APPINSTANCE table is empty.

After you update the value, you need to select 7 in the menu to save the change.

Below is an example of modifying the config item /IBM/DWLCommonServices/Notifications/enabled from false to true.

Configuration and Management Main Menu

1 - View configuration items

2 - Modify configuration items

3 - Report configuration change history

4 - List applications

5 - List deployments

6 - List instances

7 - Save changes

8 - Cancel changes

9 - Exit console

Make a selection or press the Enter key to accept the default selection.

[1]

Modify configuration

Specify the application whose configuration is to be modified.

:com.ibm.mdm.hub.server-MDM120Instance

Specify the application version whose configuration is to be modified.

:12.0.0

Specify the deployment whose configuration is to be modified.

:MDMServer

Specify the instance whose configuration is to be modified (or press Enter for none).

Specify the configuration item whose value is to be modified.

:/IBM/DWLCommonServices/Notifications/enabled

Current value of /IBM/DWLCommonServices/Notifications/enabled : true- Dynamic

Specify the new value for the configuration item

[false]

:true

WARN - [Warn_Configuration_UpdateItem:] CDKMA2008W:update Item /IBM/DWLCommonServices/Notifications/enabled

WARN - [Warn_Configuration_UpdateItemThoroughDeployment:] CDKMA2009W:update item through deployment

WARN - [Warn_Configuration_ItemValueBefore:] CDKMA2010W:item value before is true

WARN - [Warn_Configuration_Value:] CDKMA2011W:value is true

WARN - [Warn_Configuration_UpdateItemFinished:] CDKMA2012W:update item finished

Type y to enter another. Otherwise, type n.

Make a selection or press the Enter key to accept the default selection.

[1]

WARN - [Warn_Configuration_ChangesCommited:] CDKMA2006W: Commit Changes

WARN - [Warn_Configuration_changedDynamicItemName:] CDKMA2013W:changedDynamicItemName is /IBM/DWLCommonServices/Notifications/enabled

WARN - [Warn_Configuration_CommitChangeforconsoleSessionId:] CDKMA2007W:commit change for 6261688131245763

WARN - [Warn_Configuration_changedDynamicItemName:] CDKMA2013W:changedDynamicItemName is 1

WARN - [Warn_Configuration_RefreshMessageSuccessfullySent:] CDKMA2015W:Refresh message successfully sent to iiop://localhost:9809; for mbean DWL:deployment=MDMServer,cell=localhostCell01,J2EEApplication=MDMServer,type=com.dwl.management.config.client.mbean.ConfigurationClient,node=Node01,process=MDM120Instance

Application: com.ibm.mdm.hub.server-MDM120Instance

Version: 12.0.0

Deployment: MDMServer

Managed Application URL: iiop://localhost:9809

Message: Refresh message was successfully sent.

Effective Time: 2023/06/30 06:28:21.383

Result Status: SUCCESS

[{"Type":"MASTER","Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSGRQXQ","label":"IBM Master Data Management"},"ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Versions"}]

Historical Number

TS013348894

Product Synonym

MDM, Master Data Management, AE

Was this topic helpful?

Document Information

Modified date:
13 July 2023

UID

ibm17011913

Tips