Technical Blog Post
Abstract
IBM Control Center and IBM Sterling B2B Integrator.
Body
A lot of folks use IBM Control Center (ICC) to monitor IBM Sterling B2B Integrator (SBI). ICC is a tool which looks at a lot of things, but it does have some performance considerations. So I wanted to go over what the mechanics of the monitoring - Go over how the monitoring works and what it does and doesn't do. I also wanted to mention some of the "gotchas" you can run into with the monitoring.
Note: IBM Control Center used to be called Sterling Control Center (SCC) in earlier versions. What I'm talking about here covers both SCC and ICC up to version 6.X. The diagram I used below is one I created before the name change, so it talks about SCC, not ICC. But it still applies.
Overrides.
The SCCInteropService builds and runs queries against the database. It's fairly common to put overrides in to modify the queries to increase performance. Most of the overrides have to do with adding row limits to the queries to limit the amount of data that is returned to ICC on each run. There are a few things to watch out for when putting in the overrides.
1) The properties for the queries are included under the jdbcService properties. This means that when you override them you use the prefix "jdbcService." in the customer_overrides.properties file.
For example:
jdbcService.query.BPHistoryEnd.oracle= WFD.TYPE < 100 AND WFC.WFD_ID = WFD.WFD_ID AND WFC.WFD_VERSION = WFD.WFD_VERSION ORDER BY END_TIME, STEP_ID) WHERE ROWNUM < &recordLimit;
-
When overriding a property, make sure the entire property is on one line with no carriage returns or line feeds.
-
The properties are database specific. In the example above, the override is for someone using Oracle as the database. Make sure that you are overriding the correct database. If I am using DB2 and I put the override above in, it will not be used. In this case it won't hurt anything, it will just won't be used.
Some final thoughts.
-
A lot of the monitors in ICC query the SBI database. One thing this means is that it cannot not monitor information that isn't there. If the data expires and is purges from the SBI database before ICC asks for it, you won't see it. Also if you don't store the data to begin with, again ICC won't see it.
-
The monitoring queries themselves can have a performance impact on the database. If you have been running SBI and are adding monitoring in, you should do testing to make sure you don't see performance issues. You may want to talk to your sales representative to get a sizing engagement done to make sure you have the resources to both run and monitor your data.
The Flow
UID
ibm11121697