BMC Software, Inc. made SmartDBA Recovery Management 5.0 available on Monday of this week. SmartDBA, a product geared towards the over-worked DBA, consists of performance monitoring and tuning tools, database administration tools and backup and recovery utilities, all integrated into a common GUI web-based interface.
SmartDBA Recovery Management is an extension of BMC's SQL-BackTrack, building on its solid foundation, to include a backup/recovery utility that allows users to do point in time recoveries, dry-run recoveries, etc., against Oracle, UDB DB2, SQL Server and Sybase databases.
BMC re-defines enterprise database backup and recovery with the addition of policy compliance reporting capabilities and centralized management.
While BackTrack technology gave users the ability to recover only the data that is required, the new functionality in SmartDBA gives them the capability to take all of the information that is typically gathered during a backup or recovery, analyze that data and set realistic policies to meet Service Level Agreements with their customers. This information is available through the same GUI used in all of the other SmartDBA products.
SmartDBA contains the same feature set as SQL-BackTrack along with additional functionalities. SmartDBA provides centralized management to monitor backup and recovery processes from a single screen. Tailored views allow IT Executives to monitor at the enterprise level while DBAs are able to monitor from the system or database level. If pre-determined SLAs are not being met, the policy management feature triggers an alarm. . Backup and recovery trends can be followed with reports generated by proactive resource management, while backup and recovery information is provided in enterprise level reports. Archive log management and automated database duplication to local and remote hosts is also provided. Key features in BackTrack include automated recovery, test recoveries, high performance backups, integration with VEREITAS NetBackup, Legato NetWorker and Tivoli Storage Manager.
While the official announcement will not go out until next week, the Oracle and Sybase versions of the product were made available on Monday of this week, the UDB DB2 version will be available in September and in November the Microsoft SQL Server version will come out. Informix is not included in the 5.0 releases; however, SQL-BackTrack will continue to be available for Informix users.
Additional information can be found at the BMC website:
System Recover for DB2
Another BMC product, soon to be joining the BMC lineup, is 'System Recover for DB2.' Aimed at the mainframe DB2 environment, it is particularly useful for those large-scale applications such as SAP, Siebel or PeopleSoft. System Recover for DB2 uses batch processes, allowing customers to easily backup and recover entire DB2 applications.
Quite often, when a DBA wants to back up the DB2 application environment he will back up everything. System Recover for DB2 has built in intelligence that allows the user to do an analysis and only back up those objects that have actually changed, thus reducing the cost of backup. At time of recovery, only objects that require recovery are actually recovered. System Recover for DB2 also supports DB2 Disaster Recovery, with complete automation for the preparation and execution of the DB2 recovery process.
System Recover for DB2 is an existing product that has been re-named to more clearly indicate its power as a recovery tool. The updated product will include support for DB2 v. 8 on the mainframe as well as support for intelligent storage.