New Features in SAP R/3 Release 4.6 
SAPDBA
DB System Check
The R/3 database systems can now use new parameters for the message types DBA, ORA and PROF to make even more detailed checks. Critical situations in the database can be detected early, and downtime can be avoided.
- The parameter FS_FULL of the message type DBA checks, for example, to see whether free memory is under the specified threshold in all
SAPDATA
directories, or in any directories you want to configure.
The parameters of the new message type DBO determine database operations (such as backups) that have caused errors since the last backup (return code > 1), or since a specified date (last success to old).
You can also set certain parameters for specific objects.
- To overwrite the definition of the parameter, you can set thresholds for individual objects.
- You can define negative lists for parameters to exclude individual objects from the check.
For more information, see
Database System Check.
Reorganizing Single Tables Online
With this new release you can reorganize single tables when the R/3 System is running (online). A shadow table registers all changes to the table (inserts, updates and deletes). After the reorganization, the table is locked briefly to copy the changes stored in the shadow table.
For more information, see
Database Reorganization.
Cost-Based Optimizer
The integration of the serial processes Check for old statistics (
sapdba -checkopt
) and
Update old statistics (
sapdba -analyze
) into one process simplifies and speeds up the creation of statistics for the cost-based optimizer on NT platforms.
The integration of the serial processes Check for old statistics and Update old statistics for Unix platforms is planned for later releases.
- The runtime when creating statistics for large tables has been reduced by extending the internal rules.
- Due to their special attributes, the tables of SAP New Dimension Products (such as SAP BW) are handled differently.
For more information, see
Support for the Cost-Based Optimizer.
New Patch Concept
Read the Notes:
- 126769 for corrections in SAPDBA and the BR programs (for all releases)
- 141999 for new SAPDBA features (for all releases)