Filter
Top Products
Option Description
-t Date and time cutoff to look for expired data. Format:
yyyyMMdd-HH:mm:ss.SSS. Default is current date. This date and time
will be used as the starting point to check for expired tables. If the
table has expired since the last time it was rebuilt, that table is
added to a list for rebuild or index analyzing.
Must be used with -l or -r. Optional.
-o Specifies a file name to save output messages to. Provide a full
path to the file. If not used, output will be displayed only on the
screen. Must be used with -l or -r. Optional.
-d Check all tables. If not used, the check will only be done on tables
that were recorded on the database after the last rebuilds. Must be
used with -l or -r. Optional.
-p Print the stack trace if there is an exception.
If used with the -o option, the stack trace will print to a file.
Otherwise, it is displayed on the screen. Must be used with -l or -r.
Optional.
-h or -? View the help screen.
Command Examples
To view a list of table indexes that have to be rebuilt, and to save the output to a
file named myList, go to the install_dir/bin directory and run the following
command:
db_optimization_tool.sh -l -i -o myList
To rebuild the indexes for all the tables, run the following command:
db_optimization_tool.sh -r -i -d
Full Database Issues and Resolution
For a variety of reasons, you may find that your Sterling B2B Integrator database
has become full. This may cause performance issues that appear to be related to
memory or other resource usage.
If your database is set to auto extend, the database may attain 99 percent capacity
before extending automatically. In this situation, the 99 percent capacity does not
indicate a performance issue.
After you run Sterling B2B Integrator for some time and you take out from the
database approximately the same amount of data that you put into the database,
the database size becomes consistent.
If other applications are using the same database that Sterling B2B Integrator uses,
verify that the other applications are also experiencing slow database returns
before making any database adjustments.
If the other applications are not experiencing database issues, the performance
issue may be related to a cause other than the database.
218 Sterling B2B Integrator: Performance Management