IBM® Data Studio includes all the capabilities formerly in Optim™ Development Studio, Optim Database Administrator, and Data Studio Health Monitor and is available at no charge. Together with InfoSphere® Optim pureQuery Runtime, Data Studio provides an integrated development environment to speed data access design, development, and deployment.
Learn how to quickly transition from the soon-to-be deprecated IBM DB2 Control Center to IBM Data Studio 3.1, which was released in October 2011 with several enhancements to improve ease of use. More >
- Managing and scheduling database jobs with the Data Studio
Use the new job management capability in IBM Data Studio for a simple, flexible way to create and manage database jobs, and to schedule command scripts to run automatically.
- Managing database connections with the IBM Data Studio web
Learn how to use the web console to manage and share database connection information. This feature helps increase productivity among Data Studio users and reduce the overhead of tooling configuration.
- Use database catalog filtering in IBM Data Studio to view,
manage, and work with database object efficiently
Get an improved database experience with less information to process and manage, more relevant information, and better performance.
- Accelerate Hibernate and iBATIS applications using
pureQuery, Part 3: Auto-tune data fetch strategies in
Hibernate applications with pureQuery
Significantly improve Hibernate system performance by automatically optimizing database access patterns across all use cases of the application.
- Tuning SQL with Optim Query Tuner, Part 2
Learn the methodology for tuning single queries. It includes a sample query to help you understand how to analyze access plans, statistics, predicates, and indexes to ensure IBM DB2 optimizer performs well.
- Knowledge path beta: Introduction to Optim Development
Studio and pureQuery Runtime
Follow this knowledge path to learn how to design, develop, deploy, and manage database applications with optimal performance.
- An inside look at IBM DB2 Advanced Enterprise Server
Simplify the acquisition and use of core database features with AESE, a software bundle that packages IBM DB2 Enterprise Server Edition V9.7 with storage optimization and performance management tools.
- Update: Problem determination tools in Data Studio and Optim
Learn how information from traces and logs in Data Studio and Optim Development Studio can help you debug and improve the performance of your DB2 and Informix applications.
- Set up an SQL management repository using an ANT
Automate common administration tasks using Optim Development Studio to manage the repository so that other applications, such as the pureQuery Runtime, can retrieve and update stored information.