With visual SQL tuning, database administration and performance management capabilities in a single toolset, DB2 professionals can improve their speed and efficiency.

SAN FRANCISCO – March 15, 2011 – Embarcadero is equipping DB2 developers and DBAs with a toolset that brings greater functionality and efficiency to their development, database administration and performance tuning tasks. The new DB PowerStudio for DB2 combines several essential database tools into an aggresively priced suite that extends beyond the capabilities of IBM's database utilities. The toolset meets the overlapping needs of DB2 database developers and administrators, helping both improve the performance and availability of their databases.

Designed for DB2 database professionals, DB PowerStudio complements IBM Data Studio with critical capabilities such as database change management and performance optimization. A graphical Visual SQL Tuning feature allows developers to quickly understand the components of a SQL query, including potential schema flaws and best execution paths, and enables DBAs to make faster at-a-glance decisions.

“Database development and administration have never been more intertwined, so  tools that open up communication between the two groups can be a catalyst for massive productivity gains,” said Scott Walz, senior director of product management for Embarcadero. “If DB2 professionals are going to be tasked to do more, then they need a toolset like DB PowerStudio for DB2 that goes beyond baseline functionality so they can perform their jobs with the greatest efficiency.”

The DB PowerStudio for DB2 suite is available in a Developer Edition and a DBA Edition. The Developer Edition includes Rapid SQL, DB Optimizer and DB Change Manager. The DBA Edition also includes DB Optimizer and DB Change Manager, as well as DBArtisan for advanced database administration. All of the tools within the toolset support multiple versions of DB2 from a single interface.

Rapid SQL – An integrated development environment (IDE) that simplifies SQL scripting, query building, object management and version control in live databases or offline source code repositories.

DB Optimizer – A graphical SQL performance optimization tool that allows users to quickly discover, diagnose and optimize poor-performing SQL with an interactive Visual SQL Tuner.

DB Change Manager – A powerful tool that simplifies tasks such as tracking and reporting on database changes, rolling out new releases and pinpointing the cause of performance problems stemming from changes in data, schema and database configuration. It also allows test data to be masked to comply with privacy mandates.

DBArtisan – A database administration tool that enables DBAs to work with multiple DB2 databases, including various versions, from a single interface. DBArtisan provides graphical editors and wizards to streamline routine tasks and reduce errors so users can manage large, complex databases more efficiently. It also helps identify performance, capacity and storage management issues before they become problems.

In addition, DB PowerStudio comes with Embarcadero’s unique ToolCloud technology. ToolCloud enables users to access the latest version of DB PowerStudio from any Windows desktop instantly, without requiring a conventional install. It also allows larger organizations to track and manage license usage to minimize licensing costs and maximize team productivity. 

Availability and Pricing
DB PowerStudio for DB2 is available now. In North America, the Developer Edition is priced at $1,495 and the DBA Edition is priced at $3,995. With the optional Analyst Pack, the DBA Edition is priced at $4,790. These prices represent a cost savings of more than 70 percent when compared to purchasing each tool separately. DB PowerStudio for DB2 can also be expanded to support other major DBMS platforms. For more information and pricing, please visit: http://www.embarcadero.com/products/db-powerstudio-for-db2

###
 
Embarcadero, the Embarcadero Technologies logos and all other Embarcadero Technologies product or service names are trademarks or registered trademarks of Embarcadero Technologies, Inc. All other trademarks are property of their respective owners.