About DB PowerStudio Developer Edition for DB2

A multi-database toolset for database management professionals.

DB PowerStudio is an intuitive toolset that includes visual SQL optimization and tuning. It comes complete with support DB2. DB PowerStudio is the latest suite in a line of award-winning database tools for DBAs and database developers. DB PowerStudio simplifies daily administration, manages changes, tunes queries, and develops schemas for multiple relational database platforms.

DB PowerStudio Features

  • Connect to multiple, heterogeneous databases with no client required.
  • Automated SQL rewrites to quickly optimize queries.
  • Full-featured visual SQL tuning capabilities from inside the SQL editor.

Fast, Accurate, SQL Code with Rapid SQL
The rich visual environment found in Rapid SQL streamlines the task of creating SQL code. Rapid SQL includes visual tools for ad-hoc data editing and simple-to-complex query building. Prevent errors with scripting support features such as syntax checking and auto-complete. Quickly produce code with built-in hot keys, column lookup and code templates.

  • Support for all seven database platforms included in a single, affordable license.
  • Go global with full Unicode character and enhanced currency support.
  • Object filtering capabilities.
  • On-the-fly SQL syntax alerts, semantic validation, and SQL parsing.
  • Full object look-up through-out the SQL statement.
  • Code complete with dynamic walk-throughs.
  • Quick export and import of registered data source information.

Fast, Visual SQL Tuning with DB Optimizer
DB Optimizer takes SQL tuning beyond standard hint injections and SQL rewrites and offers innovative features for faster and more advanced SQL tuning and analysis. Graphical tools, like the Index Analysis feature, let DBAs and developers fully examine SQL execution paths to better understand which indexes are used, not used, or missing

  • Stream profiling data into a central repository.
  • Determine resource usage for stored procedures with visibility into underlying SQL usage for SQL Server and Sybase.
  • Visual SQL tuning diagram displaying indexes and constraints, now enhanced with table statistics.

Database Change Management Made Simple
DB Change Manager compare, synchronization and auditing capabilities let you track and report on changes, roll out new releases and pinpoint performance problems resulting from changes in data, schema and database configuration. By comparing a live database to a schema or configuration snapshot administrators can quickly identify changes and correct problems.

  • Work with multiple database brands and versions from a single toolset.
  • Compare your development and test servers to quickly identify changes and generate the synch scripts to correct any problems.
  • Mask test data in order to comply with privacy laws.

DB PowerStudio Developer Edition - Designed for Database Developers or Project DBAs in need of capabilities to monitor and manage database processes and to set up database work environments. The Developer Edition includes:

  • DB Optimizer - Visually profile key metrics inside the database and optimize SQL using the Visual SQL Tuner.
  • DB Change Manager - Simplify, automate, and report on database changes.
  • Rapid SQL - Quickly write quality SQL