If a problem arises, which system-maintenance report is emailed to the administrator every Monday morning in a standard IBM Sterling B2B Integrator installation?
Sterling B2B Integrator runs a scheduled database maintenance check every Monday at 4:00 AM. The schedule is the default setting and can be changed. If the check finds a condition that needs attention, such as heavy database usage, rapid growth, or tables that require indexing, the system notifies the administrator by email, and the report that supports the notice is the Database Statistics report, commonly called DBStats. The report can also be run on demand from Operations > Reports by searching for DBStats. It summarises how the database is being used, including row counts for tables that are eligible for archiving and purging, the archive status of business processes, the most heavily executed processes, and rows without matching records in ARCHIVE_INFO. Administrators use it to answer the common question of why the database is large and to decide whether lifespans, purge schedules or indexes need adjustment. If the notice says indexes must be rebuilt, the db_optimization_tool script or the database administrator's own tools are used. Garbage collection data, index-and-table listings and performance statistics are separate diagnostics that are not what the weekly check sends.
Contribute your Thoughts:
Chosen Answer:
This is a voting comment (?). You can switch to a simple comment. It is better to Upvote an existing comment if you don't have anything to add.
Submit