DB2 & Data Management

Free white papers and technical articles on DB2 solutions. Including new database versions and data warehousing for z/OS


  • DB2 CLP on z/OS
    Have you ever wanted to be able to drive a stored procedure from and see the results without having to write an application? Or describe a table like you can in DB2 LUW?

  • zTune Reduce Mainframe Costs (117kb)
    You could be paying too much for your enterprise software licences. Most mainframe software charges are based on peak CPU usage.

  • Managing Mainframe Costs in the Financial Services Sector (255kb)
    Managing workload peaks in the Financial Services sector can be a major challenge with workload suddenly spiking at key times of the year. It is vital that retail organisations are able to protect themselves against large spikes in usage.

  • Managing Mainframe Costs in the Retail Sector (254kb)
    Managing workload peaks in the retail sector can be a major challenge with workload suddenly spiking at key times of the year. It is vital that retail organisations are able to protect themselves against large spikes in usage.

  • How to Have a Happy DB2 11 CM Day (108kb)
    This white paper outlines the major opportunities for preparation in advance of the moveto DB2 11 Conversion Mode.

  • Top Five Reasons for Choosing Remote Database Support (121kb)

  • DB2 10 for z/OS Business Benefits (3384kb)
    DB2 10 for z/OS is the latest release of IBM's flagship database. This paper provides a high-level overview of the major new features from an IT Executive's perspective, with the emphasis on the underlying business value that DB2 10 can deliver.

  • Happy DB2 10 CM Day (160kb)
    This article outlines the major opportunities for preparation in advance of the move to DB2 10 Conversion Mode.

  • The trials and tribulations of 24/7 database management (16kb)
    James Cockayne, Principal DBA at Camelot Group gives us his views on key issues for DBAs, the newest active-active availability solutions and how a DBA can ensure they get their all important beauty sleep!

  • Position Power - DB2 9 for z/OS Spatial Features (1293kb)
    When combined with conventional data (customer information, sales data, etc) it can be surprisingly useful in a whole variety of different applications, across virtually any industry.

  • DBI Software Solution Brief (751kb)

  • Remote DBA - Meeting The Challenges of Database Management (203kb)
    This paper aims to highlight the key challenges faced by IT organisations in maintaining their information management systems and the solutions to these challenges. In particular it focuses on the management of DB2 databases.

  • What are the top new features of DB2 10? (1185kb)

  • DBI Software - Powering Remote DBA (138kb)

  • DB2 10 - Secrets of Scalability (791kb)
    DB2 10 delivers some very significant enhancements for increasing throughput, supporting more users and reducing planned downtime. This document looks at how organisations can directly benefit from the scalability enhancements in DB2 10.

  • DB2 10 - Justifying the Upgrade (996kb)
    There are many reasons to upgrade to DB2 10 and they fit broadly into two categories; Financial and Non/Financial. This paper will concentrate mainly on the financial reasons which include CPU Savings, Productivity Savings and Ava

  • Top 10 DB2 Support Nightmares & How to Avoid Them (157kb)
    Over many years of providing DB2 support and consultancy services we have come across a huge array of support �nightmares� and difficult scenarios. In this document we share will you our top 10 and give you some advice on how to avoid such

  • DB2DART - Hints & Tips for the DBA (469kb)
    The DB2 Analysis & Reporting tool or DB2DART is one of the lesser used performance tools and has traditionally been used with IBM support. However, DB2DART can be one of the most powerful tools in the DBA�s kit bag. It can help increase DBA prod

  • Time Travel Query Gotchas (139kb)

  • RCAC Hints & Tips (157kb)

  • DB2 Shadow Tables: Bringing Analytics to Data - pdf (3815kb)
    IBM has introduced the concept of shadow tables in DB2 V10.5 Fixpack 4 (also known as the "Cancun Release") to avoid separate OLTP and OLAP databases and to improve analytic query performance in a single OLTP database

  • Mobile Workload and Mainframe Cost Reduction (150kb)

  • Top Five Reasons for Choosing Remote Database Support in the Public Sector (557kb)
    This paper specifically focuses on DB2 support. It includes the top five reasons we see from our public sector customers for choosing to outsource all or part of their DB2 database support function.

  • DBI DB2 LUW Introduction Overview (2105kb)

  • Business Benefits of DB2 9 for z/OS (54kb)
    This article gives an overview of the business benefits of DB2 9 for z/OS and a look forward to DB2 X