Filter
Top Products
Viewing the Database Usage Statistics
Database usage statistics show how your database is performing, including
database insert information, database capacity, and environment pool usage.
Sterling B2B Integrator uses pools to store database connections. To change pool
settings, you must manually edit the configuration files and restart the system.
Note: Database usage statistics are not available for DB2.
To view database usage statistics:
1. From the Administration menu, select Operations > System > Troubleshooter.
2. In the System Troubleshooting page, in the System Status area, click Database
Usage.
Note: If you have the displayGraphics property, which is located in the
install_dir/properties/ui.properties file, set to true, the Database Usage page is
displayed in graphic format. Otherwise, the Database Usage page is displayed
in text format. The default is true for Linux
®
, Sun
™
, HP, and Microsoft
Windows
®
operating systems. The default is false for IBM AIX
®
and IBM
iSeries
®
operating systems.
The Database Usage report is displayed with the following information for each
unit test of the database:
v Average time taken to perform a given number of database inserts in a unit
test
v Number of inserts performed to the database in a unit test
Note: You can change the value of the dbAccessLoopCnt property in the
install_dir/properties/ui.properties.in file. After making the changes, in the
install_dir/bin directory, run the setupfiles script.
v Size of the inserts performed to the database in the unit test.
Note: You can change the value of the dbAccessDataSize property in the
install_dir/properties/ui.properties.in file. After making the changes, in the
install_dir/bin directory, run the setupfiles script.
v Size of the database and the amount of the database used (in megabytes):
– Green – Normal range
– Yellow – Warning range
– Red – Critical range
v Number of business processes that are waiting to be archived, indexed, or
purged
v Size (in megabytes) of the following pools and the number of requests that
had to wait for the following pools:
– gentranTPPool
– databaseArchivePool
– databasePool
– databasePool_local
– databasePool_NoTrans
– databasePool_Select
– databaseUIPool
102 Sterling B2B Integrator: Performance Management