Data Studio and InfoSphere Optim pureQuery Runtime

18 Apr 2013 — Show descriptions | Hide descriptions

• Managing and scheduling database jobs with the Data Studio Web Console

  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 console

  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 Edition

  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 Development Studio

  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 script

  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.