Application development |
The application development tools help you speed up application
design, development, and deployment. Advanced development tools are
also provided for developing and testing of SQL, PL/SQL, and Java database routines, and for
analyzing SQL performance. Other advanced tools provide support for
generating and deploying database web services, creating and running
SQL and XQuery scripts, creating XML documents and XSL, XSD and DTD
files, and developing Java database
applications, and SQLJ applications. You can also perform standard
database object management tasks, such as creating, copying, and altering
database objects and managing database access privileges. Non-IBM
databases are also supported. - Basic development features
- These features provide core support for database access, catalog
browsing, object management, and creation and execution of SQL and
XML Query scripts.
- Advanced development features
- These features provide advanced support for routine development,
pureQuery, data web services, and XML.
- pureQuery features
- Provides tools for Java application
development that make it easy to develop, manage, and optimize Java applications that access relational
data. This feature includes basic tools for generating Java code from database tables or SQL statements,
and enhancements to the Java editor
that include complete assistance for building, validating, and running
SQL statements. Advanced tools for Java application
development are provided, including insight into SQL within Java applications, SQL execution
metrics for problem determination and impact analysis, static SQL
support, JPA applications enhanced with static SQL, and advanced code
generation support. A separate license for InfoSphere® Optim™ pureQuery™ Runtime is required
to deploy Java applications
that are built by using pureQuery.
- SQL routines and PL/SQL development
- Provides tools for developing, testing, and deploying SQL stored
procedures and user-defined functions, including wizards, editors,
and an integrated stored procedure debugger.
- Java development
- Provides tools for developing Java database
applications and Java stored
procedures.
- Java routine development
- Provides tools for developing, testing, and deploying Java stored procedures, including wizards, editors,
and an integrated stored procedure debugger.
- SQLJ development
- Provides tools for building SQLJ applications, including an SQLJ
editor with built-in syntax highlighting, an SQLJ translator that
translates SQLJ files to pure Java files
and produces SQLJ serialized profiles, and an SQLJ debugger that you
can use to debug SQLJ files. Built-in customization features are available
when you are developing SQLJ applications for DB2®.
- SQL performance support
- The SQL Outline view provides tools to show performance data of
SQL statements. This data can be generated from the Data Studio client. This
data can also be imported from the InfoSphere Optim Performance Manager repository
database. Performance data for monitored SQL statements is matched
with the SQL statements that are listed in the SQL Outline view.
The SQL and XQuery editor provides tools to run SQL statements on
a database and view database performance data that is captured by InfoSphere Optim Performance Manager Extended
Insight.
- XML development
- Provides tools for XML application development, including wizards
for creating and registering XML schema documents and inserting XML
data into XML columns, editors for XML, XSD, and DTD files, and a
graphical mapping editor that you can use to annotate XML schemas
for shredding. Advanced tools for XML development are provided, including:
an XSL editor with an XPath expression wizard, an XML mapping editor
to generate deployable transformation documents, and advanced document
generation tools.
- Data object copy
- Provides the capability to copy database objects and their associated
data between databases within the same server or between two different
servers.
- Extended database support
- These features extend support to non-IBM databases.
- Oracle support
- Provides support for database objects and storage management,
access control for Oracle databases, and support for SQL scripts and
PL/SQL development.
- Sybase support
- Provides tools for database access, catalog browsing, object management,
and provides support for creating and running SQL scripts and stored
procedures for Sybase databases and Sybase-compatible DB2 databases with ANTs support.
- Data web services
- Provides support for creating and deploying web services that
allow client applications to access data in DB2 databases by means of database operations,
such as SQL SELECT and DML statements and stored procedures.
- Database change management for DB2 for Linux, UNIX, and Windows
- Provides integrated object management and complex change management
that uses edit-in-place and change plan organization.
- Rational® ClearCase® SCM Adapter
- Provides support for sharing data projects by using Rational ClearCase.
After installation, you must enable this feature on the Capabilities
page of the Preferences window. This feature can be used only if you
have a ClearCase client
and a configured ClearCase server.
- Modeled privacy integration
- Provides support for integrating physical and domain data models
with databases. This feature also provides the ability to assign data
privacy policies to modeled database columns and apply those privacy
policies to object management tasks, such as copying data between
databases.
- Deployment management
- Provides tools for managing the deployment of artifacts, such
as SQL scripts and stored procedures to one or more test database
servers.
|
Database administration |
The database administration tools help you manage your databases
and increase your productivity as a DBA. This feature includes task
assistants that guide you through common database administration tasks
for DB2 for Linux, UNIX,
and Windows database servers.
For example, commands are automatically generated for starting and
stopping instances, backing up and recovering databases, reorganizing
tables, plus much more. For DB2 for Linux, UNIX, and Windows databases,
this feature also includes support for making complex structural changes
to streamline change-in-place and database migration scenarios that
require changes to multiple objects. You can ensure that the automatically
generated commands preserve data for any objects that must be dropped
and re-created, you can include maintenance utility commands, and
you can create scripts for undoing database changes. For DB2 for z/OS®, Informix®, and non-IBM databases,
you can make changes to single objects.- Administration features
- Provides DB2 for Linux, UNIX, and Windows database
navigation, basic DDL Generation, SQL and XQuery editor, database
change management, physical data modeling, impact analysis, database
object comparison, and database administration task assistants.
- Rational ClearCase SCM Adapter
- Provides support for sharing data projects by using Rational ClearCase.
After installation, you must enable this function on the Capabilities
page of the Preferences window. This feature can be used only if you
have a ClearCase client
installed on the same computer and a configured ClearCase server.
|
Query tuning |
Provides basic tools for analyzing and tuning the performance
of queries that run on DB2 for Linux, UNIX, and Windows or
on DB2 for z/OS database servers. You can run the Statistics
Advisor to generate RUNSTATS commands for fixing problems with statistics
and enabling the DB2 optimizer
to create improved access paths. Use these tools to format SQL statements
so that they are easier to read and analyze. You can generate access
plan graphs like those that you can generate with Visual Explain.
Reports are available that summarize information about the access
paths for SQL statements and recommendations from the Statistics Advisor. Upgrade
to InfoSphere Optim Query Workload Tuner. If you upgrade, you can
use additional features in the IBM Data Studio full client to tune
SQL statements, and you can also tune query workloads, which are groups
of related SQL statements. For a list of the full set of features,
see Features for tuning: by product.
|