How To
Summary
How to find number of threads for a server from YFS_SERVER table in IBM Sterling Order Management System?
Objective
Number of threads when checked alongside the number of instances that are running can help in performing server consolidation. This article will help identify the number of threads for a server.
Steps
The YFS_SUB_FLOW table gives details of each service configuration apart from threads count. This would correspond to an 'agent criteria' for an agent. This also has details of the SERVER_KEY that the sub-service is attached to (which is the primary key from YFS_SERVER table). YFS_HEARTBEAT table is slightly different in fact that it doesn't hold configurations, rather statistics for instances of when such services run.
Steps to identify thread count:
- For a server key, get all subflow records configured.
- For each subflow, get threads configured.
- Post this, one can get the total threads configured for the server by adding them up.
Do note that there is a CONFIG_XML column in YFS_SUB_FLOW table. It has an attribute Threads in it.
For example:
<SubFlowConfig> ... <Properties DeliveryMode="" InitialContextFactory="weblogic.jndi.WLInitialContextFactory" MessageSelector="FlowName='INVENTORYPRG'" ProviderURL="t3://localhost:7001" QCFLookup="AGENT_QCF" QName="DefaultAgentQueue" ReceivingMode="" RunTimeId="INVENTORYPRG" Threads="1" TimeToLive=""> </Properties> ... </SubFlowConfig>
<SubFlowConfig> ... <Properties DeliveryMode="" InitialContextFactory="weblogic.jndi.WLInitialContextFactory" MessageSelector="FlowName='INVENTORYPRG'" ProviderURL="t3://localhost:7001" QCFLookup="AGENT_QCF" QName="DefaultAgentQueue" ReceivingMode="" RunTimeId="INVENTORYPRG" Threads="1" TimeToLive=""> </Properties> ... </SubFlowConfig>
This way user can find the total number of threads configured for the server from the YFS_SERVER table.
Document Location
Worldwide
[{"Type":"MASTER","Line of Business":{"code":"LOB77","label":"Automation Platform"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SS6PEW","label":"IBM Sterling Order Management"},"ARM Category":[{"code":"a8m0z000000cy0AAAQ","label":"Install and Deploy"}],"ARM Case Number":"TS017816000","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Versions"}]
Was this topic helpful?
Document Information
Modified date:
08 April 2025
UID
ibm17212675