SAP Note 737598 - New BRSPACE options for control of Reorg and Rebuild

Component : Database Administration with Oracle -

Solution : https://service.sap.com/sap/support/notes/737598 (SAP Service marketplace login required)

Summary :
BRSPACE version 6.40 patch 8 introduces several new options for the "tbreorg" and "idrebuild" functions. For table reorganization (tbreorg), users can now leverage actions like reorg, check, cleanup, stop, suspend, and resume, facilitating more flexible management of table processing. The "reorg" action is the standard process for online table reorganization. The "check" action identifies tables unsuitable for online reorganization, particularly those containing LONG columns. The "cleanup" option performs clean-up post-process interruptions. Additionally, the index rebuild function (idrebuild) now supports actions such as rebuild, stop, suspend, and resume. These enhancements allow detailed control over database maintenance processes.

Key words :
rebuild - rebuild indexes    stop - stop rebuild    suspend - suspend rebuild    resume - resume rebuild    default, failure     stop - stop reorganization    suspend - suspend reorganization     resume - resume reorganization     default, reorg - reorganize tables    check - check tables, reorganization    cleanup - cleanup tables, index rebuild, -action rebuild, rebuilding indexes online, actual reorganization starts, include long columns, terms br tools

Related Notes :

680046Corrections in BR*Tools Version 6.40