DB2 Connect Unlimited Advanced Edition for System z

Optimize performance of new and existing applications

• DB2 Connect Unlimited Advanced Edition for System z includes the IBM Data Studio, which provides enterprise-class development tooling for web-enabled mainframe functionality. You can now speed data access development, optimize performance and diagnose performance bottlenecks.
• With the IBM InfoSphere Optim Query Tuner, you can capture and visualize potential query hotspots to identify which queries are executed most frequently or take the most time. InfoSphere Optim Query Tuner provides expert recommendations to help tune queries for optimal performance.
• The InfoSphere Optim pureQuery Runtime provides a runtime environment and application programming interface (API) that enhances the performance of existing in-house database client applications written using Java, C or .NET. This high-performance data access platform helps with rapid development and deployment of new applications, and optimizes database applications and services.
• You can manage large-scale environments with features such as mobility on demand, federated database support, server-based monitoring or connection concentrator, and associated load-balancing and fail-over support.

Boost SQL performance

• The pureQuery technology lets you capture, review, share, and optimize SQL. You can replace poorly performing SQL with optimized SQL without changing the application.
• By converting DB2 dynamic SQL to static SQL, pureQuery can help reduce CPU consumption, provide better manageability and enforce tighter security. You can use Static SQL without changes to the development environment.
• The pureQuery technology can prevent SQL injection by restricting the SQL executed by a specific application to an approved set of SQL statements.
• You can display performance metrics within IBM Data Studio to identify SQL hot spots. You can trace problem SQL back to its source code for faster problem isolation.
• You can use Data Studio to visualize the impact of database changes. In addition, key performance metrics and correlation metadata can be captured and displayed within Data Studio.

Control costs

• DB2 Connect Unlimited Advanced Edition license fees are based one host license for the DB2 for z/OS server, plus the size of the DB2 for z/OS server as measured in MSUs.
• License fees are not affected by the number of processors available to the DB2 Connect servers or the number of processors available on the machines where the application is running.
• This makes DB2 Connect Unlimited Advanced Edition a good choice for organizations where multiple applications are using DB2 Connect, or organizations with a mix of two-tier, multitier client/server, web-based and mobile applications.
• Time-saving features include non-administrator installation on Windows, response file installation enhancements, and support for coexistence of multiple copies of the DB2 database system. Now your IT staff can spend more time supporting your business needs instead of installing and deploying database systems.
• Autonomic features include adaptive self-tuning memory allocation and object maintenance policy wizards for DB2 for z/OS. They reduce the time required to administer and tune your database system.