IBM Support


Custom database sharding does not work based on ShipNode.

Question & Answer


Question

What configurations are required to make custom database sharding to work  based on ShipNode?

Cause

Sharding details are present in colonyLookup.xml but the custom class
to determine the colonyId is not being used to determine the correct
colonyId and it moves the data to colony which is assigned to seller
organization.

Answer

Extend template/resource/apifactlookup.xml for newly added colony lookup configuration.

<ColonyLookup FactName="ShipNodeShardIdentifierImpl"
Class="com.CustomerNamedClass.services.shards.ShipNodeShardIdentifierImpl"/>

[{"Product":{"code":"SS6PEW","label":"IBM Sterling Order Management"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Distributed Order Management","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"9.2.1;9.2;9.1;9.0;8.5","Edition":"All Editions","Line of Business":{"code":"LOB59","label":"Sustainability Software"}},{"Product":{"code":"SS6PEW","label":"Sterling Order Management"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":" ","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}},{"Product":{"code":"SS6PEW","label":"Sterling Order Management"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Installation","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF018","label":"Mobile OS"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"9.4;9.3","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]

Document Information

Modified date:
16 June 2018

UID

swg21959347