Planning the features to install

You can customize your software product by selecting which features to install.
When you install IBM® Data Studio by using IBM Installation Manager, the installation wizard displays the available features in the product package. From the features list, you can select which to install. A default set of features is selected for you (including any required features). Installation Manager automatically enforces any dependencies between features and prevents you from clearing any required features.
Tip: After you install the package, you can also add or remove features from your software product at a later time by running the Modify Packages wizard in Installation Manager.

This table 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.

Feature Description
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.


Feedback