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.

Two business people collaborating using a tablet

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

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 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.

Which option is right for you?

Application Server Edition


Ideal for small application server environments with a large number of users accessing multiple or large Db2 data servers on host systems

Unlimited Edition for System z


Ideal for organizations that have multiple application servers and/or many users that connect to Db2 data servers on System z host systems

Enterprise Edition


Ideal for organizations that have limited users that connect to Db2 servers on System z and System i host systems

Application Server Advanced Edition


Ideal for applying pureQuery Runtime technology to small application server environments with a large number of users accessing multiple or large Db2 data servers

Unlimited Edition for System i


Ideal for organizations with multiple application servers and/or users that access a Db2 data server on a System i host system

You may also be interested in

Db2 Data Management Console

IBM Db2® Data Management Console is a new browser-based console that helps you administer, monitor, manage and optimize the performance of IBM Db2 for Linux, UNIX and Windows databases. For IBM’s cloud-based systems and appliances, the consoles come set up out of the box. Db2 Data Management Console is packaged with all IBM Db2 editions at no extra charge.

IBM Db2 Advanced Recovery Feature

IBM Db2® Advanced Recovery Feature combines three Db2 tools for advanced database backup, recovery and data extraction: IBM Db2 Merge Backup for Linux, UNIX and Windows; IBM Db2 Recovery Expert for Linux, UNIX and Windows; and IBM InfoSphere® Optim™ High Performance Unload for Db2 for Linux, UNIX and Windows. These tools help improve data availability, mitigate risk and accelerate crucial administrative tasks. Db2 Advanced Recovery Feature can be purchased separately and used with various Db2 editions.

IBM Db2 Performance Management Offering

IBM Db2® Performance Management Offering is a suite of tools that helps businesses monitor, manage and improve database and application performance. It provides database administrators (DBAs) and other IT staff with the information they need to manage performance proactively and help prevent problems before they impact the business. The Db2 Performance Management Offering is available for Db2 database, Db2 Workgroup Server Edition and Db2 Express Server Edition environments.