Make host data available to desktop and web applications
IBM Db2® Connect connects the different applications in your enterprise to your mainframe. It provides application enablement and a communication infrastructure that lets you connect web, Microsoft Windows, UNIX, Linux and mobile applications to IBM z/OS®, AS/400, iSeries and System i™ data. The software offers data integration, a secure application environment and centralized management for data servers and clients. It is available in six editions to meet different application, development and scalability needs. In each case, license charges are not affected by number of users, Db2 Connect server size, or size of IBM System z® or i database servers.
Benefits
Optimize application performance
Use query tuning to improve web-enabled mainframe functionality and accelerate performance of Java™ and .NET applications.
Control costs
Benefit from cost-effective licensing terms that address your usage needs, whether your organization is small or large. Reduce costs with autonomic administration features and performance advances.
Boost SQL performance
Capture, review, share, optimize and replace poorly performing SQL without changing applications. Mitigate the risk of SQL injection by restricting the SQL executed by a specific application.
Connect data across the enterprise
Connect a variety of desktop systems including workgroup, departmental and LAN-based systems to mainframes and iSeries database servers.
Centralize management
Manage clients remotely for migration efforts, enforce best practices for configurations, and administer mainframe resources, such as load balancing and failover, to avoid outages.
Features
IBM Data Studio
Offers an Eclipse-based environment for building database objects, queries and database logic — including stored procedures and user-defined functions for Db2, IBM Informix® and Oracle databases. Use Data Studio to display performance metrics and identify SQL hot spots, and visualize the impact of database changes. In addition, key performance metrics and correlation metadata can be captured and displayed.
Query tuner
Includes IBM InfoSphere® Optim™ Query Tuner, which enables you to capture and visualize potential query hotspots to identify queries that are executed most frequently or take the most time. The tool then provides expert recommendations to help tune queries for optimal performance.
Runtime environment
Includes InfoSphere Optim pureQuery® Runtime, which offers a runtime environment and API that enhances the performance of existing database client applications written in Java, C or .NET. Helps you quickly develop new applications, and optimize database applications and services.
Configuration manager
Includes InfoSphere Optim Configuration Manager , which provides centralized configuration management for z/OS servers and client applications. Enhances client management efficiency and helps you plan upgrades, meet performance availability objectives and enable faster problem-solving. Enables you to remotely enforce best practice configurations including workload management, Db2 application profiles and location aliases.
Scalability
For large-scale environments, provides features such as mobility on demand, federated database support, server-based monitoring or connection concentrator, and associated load-balancing and failover support.
Simpler application development
Provides a unified debugger, rapid application deployment with a lightweight runtime client, and other features that allow you to save time and develop applications that work across different Db2 data servers. Includes support for two-phase commit capabilities for multi-vendor data sources.
Time-saving features
Includes capabilities to save time and improve efficiency such as non-administrator installation on Windows, response file installation enhancements and support for coexistence of multiple copies of the Db2 database system.
Autonomic capabilities
Autonomic features help to reduce the time required to administer and tune your database system. They include adaptive self-tuning memory allocation and object maintenance policy wizards for Db2 for z/OS.
SQL technology
Includes pureQuery technology to help you replace poorly performing SQL with optimized SQL. Converting Db2 dynamic SQL to static SQL helps reduce CPU consumption, improve manageability and enforce tighter security. You can use static SQL without making changes to the development environment, and prevent SQL injection by restricting the SQL executed by a specific application to an approved set of SQL statements.