Filter
Top Products
Important: The reports and tools described in this section are not a replacement
for standard database tools and maintenance scripts, and should be used only if
your DBA is not involved with regular maintenance on the Sterling B2B Integrator
database.
View the Database Statistics Report
To view information about business processes in the database:
1. From the Administration menu, select Operations > Reports.
2. In the Reports page, under Search, enter DBStats in the Name box and click
Go!.
Note: The DBStats report can also be found under List. However, it cannot be
found using the Type "list" under Search.
3. Click source manager.
4. Select the appropriate report format from the drop-down list and click execute.
Database Statistics Report
The Database Statistics Report provides statistical information about business
processes in the database. You should review the Database Statistics Report if you
experience full database or failed database connection problems, or if you receive
automated notification that the database's health needs to be checked.
The Database Statistics Report is divided into the following sections:
Report Section Description and Fields
Business Process Runs in
Active System
Lists all the business process definitions that have had at
least one instance executed. Fields are:
v Business Process Name – Name of the business process
instance.
v Number of Runs – Number of times the instance has
run.
v Number of Persisted Steps – Number of steps persisted
per business process definition.
v Average Number of Persisted Steps – Average number
of steps persisted.
Business Process Runs in
Active System - Last 24 Hours
Lists all the business process definitions that have had at
least one instance executed in the last 24 hours.
Business Process Runs in
Active System - Interval of
Last 48 to 24 Hours
Lists all the business process definitions that have had at
least one instance executed during the previous day (24-48
hours before the current time).
Performance Management 215