April 07, 2009

A New Data Studio Option

IBM just released Data Studio pureQuery Runtime for z/OS 2.1. This  licensed Data Studio option is designed to deliver enterprise-ready applications with better performance, security and manageability.

Here's what’s new in pureQuery Runtime for z/OS 2.1.

For Java applications:

Static SQL

  • You can bind all static packages directly from .jar, .war or .ear files that are used in deployment.
  • There's improved error reporting for bind failures which directly identifies failing SQL statements and associated package information.
  • You can instruct the StaticBinder to only bind packages for applications that have changed since the last successful bind.
  • You can use the –grant option of the StaticBinder utility to grant the EXECUTE privilege on DB2 packages that you create.
  • You can use the –showDetails option to see a summary of the activity of the Configure and StaticBinder utilities.
  • You can directly control whether individual DDL statements run statically or dynamically.

Programming API enhancements

  • You can set timeouts for SQL queries, as well as limits on the maximum number of rows to return in result sets.
  • You can avoid problems with non-unique names in result sets for joins by using the table attribute of the @Column annotation for pureQuery beans.
  • You can create custom result handlers for applications that use annotated methods.
  • You can refine the content of stack traces that pureQuery records when capturing SQL statements.
  • You can control exactly which dynamic SQL statements are permitted to run for captured non-pureQuery API applications.
  • You can provide alternative, optimized SQL for captured non-pureQuery API applications without modifying the source code.

Go here to learn how to optimize your existing JDBC applications using IBM Data Studio pureQuery.

For .NET applications:

  • Improve quality of service for existing applications

            *Improve performance
            *Lock in access plans
            *Increase accuracy of capacity planning

  • Get more value from existing investments

            *Increase system throughput
            *Speed up problem resolution

  • Enhance security

            *Limit user access
            *Minimize attacks
            *Improve audit readiness

Go here to learn how to optimize your existing .NET applications using IBM Data Studio pureQuery.

If you've worked with Data Studio pureQuery for JDBC or .NET, tell us of your experiences in Comments.