The following tables shows the features of the product that you can install. Default selections of features to install might vary. If a feature exists in your shared resources directory, it will not be selected by default and will not be installed again.
You can choose to install features for the full product or a simplified version:
| Full Product Features | Description |
|---|---|
| Install full product options for support for an integrated development environment, job management and health monitoring in the web console, and integration with other products. You can install all of the tools or a particular set of tools for application development, administration, and query tuning. | |
| 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. To see which features are supported by each data server, see Features by data server and component on the support site.
|
| Administration | The administration tools help you manage your databases and database instances. 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 recreated, 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. To see which features are supported by each data server, see Features by data server and component on the support site.
|
| Query tuning | Provides basic tools for analyzing and tuning the performance of queries that run on DB2 for Linux, UNIX, and Windows or DB2 for z/OS database
servers and the full set of tuning tools for DB2 databases or subsystems on which a license for IBM
InfoSphere Optim Query Workload Tuner is active. 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 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. To see which features are supported by each data server, see Features by data server and component on the support site. |
| Simplified Product Feature | Description |
|---|---|
| The simplified version of Data Studio is designed to help you efficiently perform a task and include only a limited set of tools and features. | |
| SQL execution | Select this feature alone to install a simplified version of Data Studio that includes tools for writing and running SQL and XQuery statements. The SQL and XQuery editor and SQL results view are included in the default layout, and most of the unrelated Data Studio features are not installed. |