Database administration is the process of managing
and maintaining your database systems.
During the manage phase of the data management life cycle, some
of the more important tasks that a DBA can perform with
Optim™ Database
Administrator are:
- Manage instances or databases to perform database maintenance
- Configure instance or database parameters to improve performance
and allocate storage more efficiently
- Back up databases or table spaces to ensure the database or table
space can be recovered if the database becomes unusable because of
hardware failures, software failures, or both
- Reorganize tables and indexes to reclaim wasted space and improve
performance.
Database administration management software can make the process
of database administration easier because it increases reliability
and reduces human error of entering commands and utilities manually.