Skip to Content
Unleashing DB2 10 for Linux, UNIX, and Windows
book

Unleashing DB2 10 for Linux, UNIX, and Windows

by Danny Arnold, Steve Diniro, Vivian Lee, Stan Musker, Jo-Ann Woods
August 2012
Intermediate to advanced content levelIntermediate to advanced
162 pages
4h 25m
English
IBM Redbooks

Overview

This IBM® Redbooks® publication provides a broad understanding of the key features in IBM DB2® 10 and how to use these features to get more value from business applications. It includes information about the following features:

  • Time Travel Query, which you use to store and retrieve time-based data by using capability built into DB2 10, without needing to build your own solution

  • Adaptive compression, an enhanced compression technology that adapts to changing data patterns, yielding extremely high compression ratios

  • Multi-temperature storage, which you may use to optimize storage costs by identifying and managing data based on its “temperature” or access requirements

  • Row and column access control, which offers security access enforcement on your data, at the row or column level, or both

  • Availability enhancements, which provide different DB2 availability features for different enterprise needs; high availability disaster recovery (HADR) multiple-standby databases provide availability and data recovery in one technology, and the IBM DB2 pureScale® Feature provides continuous availability and scalability that is transparent to applications

  • Oracle compatibility, which allows many applications written for Oracle to run on DB2, virtually unchanged

  • Ingest utility, a feature-rich data movement utility that allows queries to run concurrently with minimal impact on data availability


  • This book is for database administrators and application developers who are considering DB2 10 for a new installation, an upgrade from a previous version of DB2, or a migration from a vendor product. It explains key features and illustrates concepts with real-world examples to provide a clear idea of how powerful these features are.
    Together, these features provide functionality that lower operational costs, ease development, and provide greater reliability.

    Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
    and much more.
    Start your free trial

    You might also like

    High Availability and Disaster Recovery Options for DB2 for Linux, UNIX, and Windows

    High Availability and Disaster Recovery Options for DB2 for Linux, UNIX, and Windows

    Stanislaw Bartkowski, Ciaran De Buitlear, Adrian Kalicki, Michael Loster, Marcin Marczewski, Anas Mosaad, Jan Nelken, Mohamed Soliman, Klaus Subtil, Marko Vrhovnik, Karol Zimnol
    SQL Procedures, Triggers, and Functions on IBM DB2 for i

    SQL Procedures, Triggers, and Functions on IBM DB2 for i

    Jim Bainbridge, Hernando Bedoya, Rob Bestgen, Mike Cain, Dan Cruikshank, Jim Denton, Doug Mack, Tom Mckinley, Simona Pacchiarini
    DB2® SQL PL: Essential Guide for DB2® UDB on Linux™, UNIX®, Windows®, i5/OS™, and z/OS®, Second Edition

    DB2® SQL PL: Essential Guide for DB2® UDB on Linux™, UNIX®, Windows®, i5/OS™, and z/OS®, Second Edition

    Zamil Janmohamed, Clara Liu, Drew Bradstock, Raul Chong, Michael Gao, Fraser McArthur, Paul Yip
    IBM Db2 11.1 Certification Guide

    IBM Db2 11.1 Certification Guide

    Robert (Kent) Collins, Mohankumar Saraswatipura

    Publisher Resources

    ISBN: 0738437107Purchase book