BMC Software Inc. is adding online database reorganization capabilities to the Space Expert component of its SmartDBA database management tools suite, looking to improve "business availability" for users.
SmartDBA also is being integrated with BMC's Patrol systems management platform to enable information sharing between database administrators and systems administrators.
SmartDBA is a suite of Web-based management tools. Version 4.3 of Space Expert, being announced on Monday for Oracle databases, is intended to enable optimal database performance, reclaim space and proactively prevent outages while applying sophisticated analysis, according to Houston-based BMC. The built-in reorg feature allows database administrators to reorganize databases online while providing read and write access to database applications with no down time.
"This enables our customers to reorganize their table spaces, their Oracle databases, without having to take the database off-line," said Tim Muecing, BMC director of product management.
Also being announced on Monday is integration between the SmartDBA Cockpit, which is the SmartDBA management console, and Patrol. This provides database administrators with a view of all database instances across an enterprise and enables synchronized event monitoring with system administrators.
SmartDBA systems that are integrated with Patrol will be available in July, with pricing starting at $2,255.
A user of the integrated console stressed the monitoring capabilities enabled.
"What it allows us to do is we have online, continuous monitoring of critical database functions," and are notified of conditions through the Patrol console, said David Hadley, CTO at DeepGreenBank, an online home equity lender in Seven Hills, Ohio.
Space Expert 4.3 also is available in July, priced starting at $1,650.
"This is five times less than comparable solutions in place today," Muecing said.
Support of online reorg capabilities for IBM DB2 UDB databases on Unix and Windows NT is planned by BMC for later this year