SIDBMonitor is one of the essential monitoring tools for Sterling B2B Integrator. This is an external standalone Java program that generates monitoring reports from an IBM Sterling B2B Integrator Database. The tool can generate two kinds of reports: the detailed report and the lightweight daily report. This program works with Oracle, DB2 and MS SQL Server.
SIDBMonitor is a safe open source tool used by many users on production to save time. The tool source code is shared on GITHUB.
Lightweight LW daily report :
The Light Weight LW report contains important monitoring KPIs from the Sterling Integrator Database such as important tables count, housekeeping counts and Database size*. You can also add any other table to the list of monitored tables. These KPIs will be collected daily and will help detecting Database growth and large housekeeping backlogs.
Note: *The Database size collected only for Oracle and DB2.
The LW report is generated in both HTML and JSON formats.
HTML LW Report Example:
SIDBMonitor LW HTML report
JSON LW Report example:
The LW report can be used then to generate graphs in MS Excel.
The JSON LW report analyzer, under construction, works only with reports generated from SIDBMonitor 180 and later.
JSON Report Analyzer:
SIDBMonitor JSON output parsed with DataBricks Spark:
The LW report output can also be fed into a Data Lake, BI tools etc …
Full SIDBMonitor report:
The full report contains various detailed SQL reports generated from the Sterling B2B Integrator Database. To activate the full report you need to change the property: jdbc.fullReport=true in SIDBMonitor.properties. This full report should be run only when needed for example, during troubleshooting or routine health checks of the system.
The full report include:
- TOP long running services.
- Business processes executions per hour.
- Top database tables.
- Cluster statistics: BP executions per node.
- Tablespace statistics (Oracle only).
- Purge distribution per hour.
- Purge statistic per removal method.
- Purge statistics by month.
- …
Screenshots from full SIDBMonitor report:
How to run SIDBMonitor?
Download the latest SIDBMonitor version from Github.
The SIDBMonitor package contains:
- SIDBMonitor.jar : the application executable jar.
- SIDBMonitor.properties : property file.
- SIDBMonitor.sh: launch script for SIDBMonitor on Unix and Linux.
- SIDBMonitor.cmd: launch script for SIDBMonitor on Windows.
- SIDBMonitor180.pdf: the documentation.
- jackson-core-2.8.1.jar : Java library used.
- JDBC driver : use the same JDBC driver file used by Sterling Integrator.
To run the tool:
- Copy the files into a folder either on the ISBI server or on any other computer that can access the ISBI database through JDBC driver.
- Edit the SIDBMonitor.properties to point to your ISBI database.
- Open a command window or shell.
- Go to the SIDBMonitor folder where the files were copied.
- Copy the JDBC driver to the SIDBMonitor folder or adjust the launch script to point to the ISBI install directory where the driver can also be found:
- Run: chmod u+x *.sh to make the launch script executable on Unix and Linux.
- Edit SIDBMonitor.sh and uncomment the launching command depending on your Database type. There is a command for each of the supported database.
- Run the launch script SIDBMonitor.sh for Unix and Linux or SIDBMonitor.cmd for Windows.
Important notes:
- The SIDBMonitor tool needs ONLY one of the following JDBC drivers:
- For Oracle the ojdbc6.jar Oracle driver or higher.
- For DB2 the db2jcc.jar, db2jcc4.jar driver or higher.
- For MSSQL Server sqljdbc4,jar driver or higher.
- The application works with java 1.6 and higher.
How to encrypt the database user password:
After running the tool, for the first time, with jdbc.encrypt=false, the encrypted password will be displayed:
Copy the encrypted password string from the output of SIDBMonitor.properties in the jdbc.password property and then change the jdbc.entrypt to true:
Once this is done, you can schedule the LW report to run daily (or nightly).
How to schedule SIDBMonitor to run daily on Linux/Unix?
- Change fullReport=false in the SIDBMonitor.properties.
- To edit your crontab list run crontab –e
- To run the application daily at 3.00 am daily, add the line to the crontab list:
0 3 * * * /path/SIDBMonitor.sh >/dev/null 2>&1
Download the latest SIDBMonitor version and documentation here.
SIDBMonitor source code available in GITHub here.
Useful SQL queries for Sterling B2B Integrator here.
Danilo Nunes Vieira
I would like to know more about this product. I got some questions. Is this software is a product developed by your? Does this product is under the security pattern? Is this a software well known by IBM as a softaware analyze tool? I’m asking you about this questions because I work in a company that make use of B2B sterling Integrator as one of the most important tools in the company. I’m just an analyst but i can suggest this tool to my team. But before, I need you answer this few questions above.
Editor
SIDBMonitor is open source now available on github, low risk, creates only one DB connection and runs once in the early hours. This tools is used for years, on production, by many large customers.
Edwin Collins
Hello, does the log4j vulnerability affect this? I see this javaj jar file.
jackson-core-2.8.1.jar : Java library used. DOes it have the log4j 2.8.1?
I would like to use this, but would need it to be 2.17.1 that my company requires for the log4j jar file. If it doesn’t apply to this then I would use.
Regards,
Editor
Hello,
No the Jackson jar does not use log4j.