AIX > Administrator > DB2

DB2 Stinger for Linux on POWER: A Powerful Combination

There's a lot of buzz around DB2* Stinger, the upcoming release of IBM* DB2 Universal Database* (DB2 UDB).

DB2 Stinger contains many new features including optimization and native 64-bit support for Linux* on POWER*.

The DB2 UDB v8.1 server has been available as a 32-bit relational database management system (RDBMS) for more than two years for Linux on pSeries* and iSeries* platforms for developers. In 2003, DB2 was the first commercial relational database for Linux on POWER ready for production server environments. Stinger builds on the deep RDBMS research and success of DB2 across many platforms. The Linux on POWER platform provides scalability and availability advantages for DB2 servers.

DB2 Stinger

DB2 Stinger aims to lower total cost of ownership for customers so they can gain competitive advantage in managing their information assets using a scalable and reliable RDBMS architecture.

Some of DB2 Stinger's key focus areas include:

  • Linux enhancements
  • Developer productivity
  • Advanced security
  • Business intelligence
  • Autonomic computing
  • High availability

In this article, we'll focus on Linux-specific enhancements for DB2 UDB and touch on some of Stinger's other features.

Why 64-Bit DB2 for Linux?

The physical memory limitation of 32-bit operating environments is 4 GB. Typically, the available shared memory for DB2 is between 2 and 3 GB per partition. For applications that have a high ratio of read versus update activity, this memory limitation can affect query response time. A 64-bit architecture such as POWER provides DB2 servers with access to vast amounts of memory because DB2 can be configured to cache frequently read data and avoid unnecessary disk operations. DB2 will cache recently accessed data in shared memory areas known as buffer pools, which are associated with tables in the database and can be easily configured to take advantage of the memory available on a 64-bit server.

DB2 on Linux is continually tested on the latest enterprise distributions from Novell/SUSE LINUX and Red Hat. The DB2 Linux validation Web site is updated frequently with the latest information regarding platform and distribution support for DB2.

Grant Hutchinson manages the DB2 UDB Linux Solutions Center within the DB2 development lab. Grant can be reached at

Rav Ahuja is the worldwide product manager for DB2 on Linux and is based out of the IBM Toronto lab. Rav can be reached at

comments powered by Disqus



2019 Solutions Edition

A Comprehensive Online Buyer's Guide to Solutions, Services and Education.

Data Basics, Part 2

More tips for avoiding common DB2 performance mistakes

IBM Systems Magazine Subscribe Box Read Now Link Subscribe Now Link iPad App Google Play Store
IBMi News Sign Up Today! Past News Letters