Skip to main content

IBM Power Systems Software > IBM i > Software >

IBM DB2 for i

OverviewKey BenefitsGetting StartedProductsSupport

Enable applications for the Web with DB2

Whether you are modernizing existing applications for the Web, or developing new e-Business on demand applications using Web Services or other technologies, DB2 can help you get there faster.

DB2 for i' offerings include simple programming interfaces, such as Net.Data, to products like DB2 Extenders that enable mapping and interchange of data between XML and DB2 formats, to support for the emerging Web Services standards with the recently delivered Web Services Object Framework (WORF) support. Websphere's WORF component enables easy delivery of DB2-based web services.

With IBM's Websphere suite of products, you can easily enable your DB2 databases and applications to the web through web-facing, portal, or other development offerings.

Discover the options available for using Java™ to access and process the business data stored on your iSeries or AS/400.

Leverage DB2 for Business Intelligence (BI) Applications
Business Intelligence is a broad term referring to applications designed to gather, cleanse, consolidate, and analyze data for purposes of understanding and acting on key business metrics, be it corporate performance measurements or customer/product profitability. Critical to the success of these applications is the ability of the database engine to process potentially very large volumes of data.

DB2 for i contains many enablers for BI applications, including:

  • DB2's sophisticated cost-based optimizer, based on over twenty years of IBM research and development efforts. Recent enhancements include the built-in SQL Query Engine and new Statistics Engine, resulting in 2-5 times performance improvements in large, complex queries.
  • IBM's patented Encoded Vector Indexing supplements its traditional Binary Radix Tree indexing implementation to significantly improve performance when querying large star-schema, or other database designs commonly used in data warehousing applications.

PDF Why System i for BI (163KB)
PDF See how Shell Canada leverages SQE for its DB2 based Data Warehouse (275KB)

Manage non-traditional forms of data with DB2
Companies maintain over 80% of their corporate information in non-traditional forms, such as hardcopy documents, printed output, or in complex formats such as images, video or audio. Maintaining, securing, and integrating these types of content into applications are critical to today's on demand businesses.

IBM's Content Manager solutions for iSeries provide robust document imaging and workflow solutions for the iSeries customer. Content Manager On-Demand for iSeries offers high performance online document capture, storage, and retrieval of computer output.

DB2 for i' large object support, data links, and a text search engine are just some of the features available to integrate these forms of data with line of business applications.

Integrate DB2 or Heterogeneous Data into DB2 Applications
In today's complex heterogeneous environments, data is spread across numerous databases, often from several vendors with non-standardized implementations. The ability to provide consistent, accurate, and timely access to these multiple data sources can be very complex and programmer intensive.

DB2's Information Integrator simplifies the ability to integrate data from many different sources into applications, providing seamless access from applications to any number of relational databases. DB2 Information Integrator even enhances the access by optimizing the query to the specific database target, caching data where applicable, and providing cross database join support.

Replicate data across the DB2 family with DB2 Data Propagator. Combine Data Propagator with DB2 for i remote journaling support for OS/400 to OS/400 replication, or combine with DB2 Information Integrator for a heterogeneous replication solution.

IBM's Business Partners offer a variety of tools and applications for DB2.
Learn More

 

 
Announcing

DB2 Web Query
Web based query and reporting

fw

Learn more


Live demo of DB2 Web Query for i

Get a first hand look at out how the new DB2 Web Query can save you time.

fw Register now

Additonal info
PDF Download a Summary of the DB2 for i 6.1 (i5/OS V6R1) Enhancements (109 KB)
PDF Download a Summary of the DB2 for i 5.4 (i5/OS V5R4) Enhancements (69.1 KB)
fw DB2 Family Common SQL Reference Document