IBM Data Studio 3.2 Information Roadmap

These resources provide an overview of IBM Data Studio.

• IBM Data Studio product page: Get an overview of Data Studio and its features and benefits from this web page.

• IBM Data Studio features: by component and data server: View this web page for a list of the features of Data Studio supported for various data servers.

• What's new and changed in IBM Data Studio: Learn about the new enhanced capabilities of Data Studio from this web page. You can also view details about changed or deprecated features.

• Getting started with IBM Data Studio for DB2: This free ebook explains how to install the Data Studio components, how to get started, and how to do key administration and application development tasks with Data Studio.

• Getting started in IBM Data Studio: This topic explains how the Data Studio client and web console components work together, and how to set up Data Studio in a team environment.

• Overview of IBM Data Studio: Read this topic to learn about IBM Data Studio, which consists of the client and web console. Use the client for database and database instance administration, application development, and query tuning tasks. Use the web console to monitor health and availability and to create and manage jobs.

• IBM Data Studio information center: The information center contains overview, conceptual, and task information for Data Studio.

Back to top

Before you install Data Studio, consult the following resources.

• System requirements for IBM Data Studio: This web page lists the hardware and software requirements for installing and running Data Studio.

• Mapping between Control Center and Data Studio capabilities: If you are familiar with the DB2 Control Center, this topic provides a mapping between the tasks that you did in the Control Center to the features of Data Studio and other tools you can use for those tasks.

• Migrating from DB2 Control Center to IBM Data Studio: Learn how DB2 users can transition from the deprecated DB2 Control Center to Data Studio to perform the same administration tasks and more.

• Limitations for sharing a common environment between IBM products based on Eclipse: See this web page to learn about the problems that might occur when you use Installation Manager to install certain Eclipse-based products, including Data Studio, into a shell-shared group.

• Virtualizing InfoSphere Optim database tools with Citrix XenApp: Learn how to provide virtualized access to Data Studio and other Optim tools on a Citrix XenApp server so that users can perform application development tasks.

Back to top

The following resources will help you to install the Data Studio components.

• Quick start guides for IBM Data Studio: View or print the quick start guide, which provides the basic steps to install the Data Studio components.

• Download IBM Data Studio: You can download the product from this web page.

• Installing IBM Data Studio client: Use this topic as the starting point for installing the Data Studio client.

• Installing and configuring Data Studio web console: Use this topic as the starting point for installing the Data Studio web console.

Back to top

The following information center topics will help you configure the Data Studio components.

• Setting up your work environment for database tasks: Learn how to connect to databases, create data development and design projects, and configure a team environment for your Data Studio work environment.

• Configuring DB2 databases and subsystems for use with no-charge tuning features in IBM Data Studio: Learn about the facilities and objects you must enable on a DB2 data server before you can use Data Studio to tune single SQL statements that run on the data server.

• Configuring the web console: Learn how you can enable access to the Data Studio web console by performing important security tasks, including resetting the default password and updating secure login certificates.

Back to top

Consult these resources to understand how logical design and database modeling help to create an effective data management system.

• Working with data diagrams: Use this topic to learn how you can use data diagrams in Data Studio to visualize and edit your data projects.

• Modifying physical data models: This topic explains how to modify database-specific models that represent your relational data objects and their relationships. You can use these models to generate DDL statements and deploy them to a data server.

• InfoSphere Data Architect information roadmap: For more robust data modeling and data integration capabilities, you can use InfoSphere Data Architect. This information roadmap provides links to key resources for that product.

Back to top

Use these resources to learn how to best use Data Studio to develop database applications.

• Creating scripts more efficiently in the SQL and XQuery editor: Read this article to learn how to use the features of this editor to enhance the capabilities of your database applications. The editor also gives you access to tools that help analyze and tune the performance of SQL queries.

• Create, test, and deploy a DB2 SQL stored procedure: This tutorial explains how to create, test, deploy, and debug stored procedures on your data servers with Data Studio.

• Developing web services with the workbench: Use this topic to learn how to use the Data Studio client to create and deploy web services that expose your database operations to client applications.

• Developing Database Applications with IBM Data Studio and pureQuery: This intensive three-day course will teach you how to use Data Studio and InfoSphere® Optim™ pureQuery™ Runtime tools to develop database applications.

• InfoSphere Optim pureQuery Runtime information roadmap: Data Studio includes a copy of IBM InfoSphere Optim pureQuery Runtime for use on the same computer as the Data Studio client, which you can use to build high-quality, better-performing database applications. This information roadmap provides links to key resources for that product.

Back to top

Use these resources to help you administer and manage databases with Data Studio.

• Administering databases with task assistants: This topic provides the main steps and illustrations to show how to use any task assistant in Data Studio. You use task assistants to create and run database administration commands.

• Managing and scheduling database jobs with the Data Studio Web Console: This tutorial describes how to schedule and automate database operations with the job manager in the Data Studio web console.

• Creating and managing jobs: Read this topic to learn how to create, schedule, and manage jobs with the Data Studio web console job manager. You can also perform some job-related tasks with the Data Studio client components if you configure them to work with the web console.

• Use database catalog filtering in IBM Data Studio to view, manage, and work with database objects efficiently: This article describes a new Data Studio capability that filters a vast amount of cached metadata to significantly enhance the network and tool performance for object management tasks.

• Scenario: Making basic database object changes with a change plan: This topic provides steps and illustrations for a scenario in which you make a change to the sample GSDB database. In the scenario, you use the change plan feature to contain the changes, identify impacted objects, and generate the command to apply the change.

• Configure automatic maintenance in DB2 for Linux, UNIX, and Windows using IBM Data Studio: This article explains how to use Data Studio to perform database backups, keep statistics current, and reorganize tables and indices as necessary on a DB2 data server.

Back to top

These resources can help you tune SQL statements to improve query and workload performance.

• Tuning single SQL statements: This topic provides an overview of the steps that are involved in tuning single SQL statements with Data Studio.

• Formatting SQL statements: This topic explains how to use the workflow assistant for query tuning in Data Studio to format an SQL statement so that you can better understand the structure of that statement.

• Generating visual representations of access plans: This topic explains how the workflow assistant for query tuning in Data Studio can display the access plan for a statement as a diagram.

• InfoSphere Optim Query Tuner and InfoSphere Optim Workload Query Tuner information roadmap: For a more in-depth set of solutions to improve the performance of queries and query workloads, you can use InfoSphere Optim Query Tuner and InfoSphere Optim Query Workload Tuner. This information roadmap provides links to key resources for those product.

Back to top

These resources explain how you can analyze database activity and performance.

• Monitoring database health and availability: Use this topic to learn how to keep track of the health information of your databases with the Data Studio web console.

• Optim Performance Manager information roadmap: For a more comprehensive set of tools to identify, diagnose, solve, and prevent database performance problems, you can use Optim Performance Manager. This information roadmap provides links to key resources for that product.

Back to top

These resources provide you with information about identifying and resolving problems with Data Studio.

• IBM Data Studio developerWorks forum: From this forum, you can access discussions about using Data Studio.

• IBM Data Studio software support: Consult this web page for general support information regarding Data Studio.

• Troubleshooting and support: Use these topics for troubleshooting database administration tasks and for details about contacting and gathering information for IBM Support.

Back to top

Trial software offers