Filter
Top Products
For more information about the Optim Performance Manager Extended Edition,
refer to:
http://www-01.ibm.com/software/data/optim/performance-manager-extended-
edition
DB2 Index and Table Statistics
DB2 uses catalog statistics to determine the most efficient access plan for a query.
Out-of-date or incomplete statistics for a table or an index may slowdown query
execution.
Manual statistics management can be time-consuming. Automatic statistics
collection can run the RUNSTATS utility in the background to collect and maintain
the statistics you require.
To configure your database for automatic statistics collection, set each of the
following parameters to ON:
v AUTO_MAINT
v AUTO_TBL_MAINT
v AUTO_RUNSTATS
Volatile Tables
In some cases, the content of the WORKFLOW_CONTEXT, TRANS_DATA, and
other tables can fluctuate significantly during the day. The resulting statistics,
which represent a table at a single point in time, can be misleading. In such
situations, mark the table as volatile with the following command:
alter table <table name> volatile cardinality
For information about regular tuning and best practices for DB2, refer to the
corresponding IBM documentation.
Update Table Statistics Manually
In rare cases you may need to update statistics for a table manually. Run the
following command for the table in the Sterling B2B Integrator schema:
db2 runstats on table <table name> on key columns with distribution on key
columns and sampled detailed indexes all allow read access
Microsoft SQL Server Configuration and Monitoring
This section provides information about configuring and monitoring Microsoft
®
SQL Server
®
2005, Microsoft
®
SQL Server
®
2008, and Microsoft
®
SQL Server
®
2012.
It describes the recommended instance-specific settings, database-specific settings,
maintenance plan, and system monitoring. It also provides information about
Address Windowing Extensions (AWE), storage subsystem, dynamic management
views, and index and table statistics.
Mandatory settings for Microsoft SQL Server
The default collation of Microsoft SQL Server must match the collation for the
Sterling B2B Integrator database to prevent collation conversions.
Performance Management 51