DB2 Version Information


Version 9

Roger Miller Introduces DB2 for z/OS V9 (webcast replay)

Top New Features of DB2 Version 8 For Developer's Only by Craig S. Mullins


DB2: Versions, Service, and Such
by Craig S. Mullins
Every 18 to 24 months IBM announces a new version of DB2 with more features and functionality than ever before. How can a DBA keep up?

Version 8

DB2 UDB for z/OS Version 8 Performance Topics

Fetching New Features by Willie Favero

For those already on DB2 Version 8: check this out this fix by Willie Favero

Top Five DB2 V8 Transition Do's and Don'ts by Craig S. Mullins

A Look at the Modes of DB2 V8 by Craig S. Mullins

DB2 for z/OS V8 Statistics and Diagnostics by Susan Lawson

DB2 V8 z/OS Stored Procedures and Workload Manager: Realizing the Synergy and Planning for Migration
by Susan Lawson and Dan Luksetich

The Most Important Feature in DB2 Version 8 by Tom Moulder

Good Migrations by Jeanne Kays and Roger Miller

IBM To Provide Multilevel Security on the zSeries by Mary E. Moore

DB2 UDB for z/OS Version 8: Backup System and Restore System Utilities by Bryan Paulsen


Top Ten Dos and Don'ts for DB2 V8 Migration by Craig S. Mullins

DB2 Version 8 Links

DB2 for z/OS Version 8 migration pre-planning by Willie Favero

Migrating to DB2 for z/OS Version 8 by Willie Favero

DB2 for z/OS Version 8 use of DFSORT by Willie Favero

Top Ten Features of DB2 Version 8 by Craig S. Mullins

Multilevel Security and DB2 Row-Level Security Revealed

Performance Considerations in Migrating to DB2 UDB for z/OS V8 by Akira Shibamiya

DB2 V8 Early Customer Experiences by John Campbell

DB2 V8 Migration Planning by Roger Miller

Tune SQL like an expert in DB2 UDB for z/OS V8 by Terry Purcell

DB2 Version 8 Reference Card

An Overview of DB2 for z/OS Version 8
by Craig S. Mullins

Raising The Bar
by Julian Stuhler, DB2Times
With the new DB2 for z/OS V.8 and its fundamental architectural changes in the product including 64-bit support and Unicode, what impact are these architectural changes going to have?

Meet the Experts: Curt Cotner on SQL and Networking Enhancements to DB2 for OS/390 and z/OS
An interview with IBM's Curt Cotner, lead architect for DB2 for z/OS™.

Details on DB2 UDB Server for z/OS Version 8
A look at the many different areas in which DB2 is being enhanced to extend performance, continuous availability and scalabiity.

What's New in the DB2 Family (pdf)
by Roger Miller
The leading strategist on DB2 for z/OS discusses new
technology that IBM has for this family including
advances in transaction processing, data warehousing,
e-business, and more.

DB2 Version 8: A virtual conversation with Roger Miller
From the developer's perspective, how DB2v8 will make life easier for DBAs and CFOs.

A Database Disconnect
by C. J. Date
Is the new DB2 V8 really intelligent enough to run as automatically as a refrigerator, without bothering its human DBA?

An Overview of DB2 for z/OS Version 8
by Craig S. Mullins
A concise overview of some of the features and functions of the new DB2 for z/OS.

DB2 V8 Online Schema Evolution
by Craig S. Mullins, zJournal
The process of making more types of database change possible without requiring objects to be dropped and re-created is known as online schema evolution.

Database Change Management and Schema Evolution in DB2 for z/OS Version 8

by Craig S. Mullins

IBM Fellow on DB2 V8 for zSeries
by Edward Hurley, search390.com
Although upgrading to DB2 Version 8 for the zSeries is no trivial task and requires much planning and thought, IBM technical whiz Curt Cotner explains why you may just want to do so anyway.

IBM Announces Version 8 of DB2 for z/OS
by IBM Corporation
Information about the reengineered DB2 for z/OS V8.

Version 7

DB2 for z/OS and OS/390 Version 7 Selected Performance Topics

DB2 for z/OS and OS/390 Version 7 Performance Topics

DB2 for z/OS and OS/390 Version 7 Using the Utilities Suite

An Introduction to DB2 for OS/390 Version 7 by Craig S. Mullins

A Quick Look at What’s Coming in V {Next} on z/OS
by Susan Lawson
What's ahead for DB2 for z/OS? Author Susan Lawson takes a look.

LOBs Performance with DB2 for z/OS Version 7
by IBM Corporation
Some recommendations from IBM on choosing the best options when inserting or loading relatively small LOBs.

Getting Started with DB2 for z/OS and OS/390 Version 7 for DB2 Distributed Platform Users
by Raul Chong
If you know DB2® for Linux, UNIX®, and Windows®, you can learn DB2 on OS/390™ and z/OS™. The basics of mainframe concepts and installing and administering DB2 on the S/390® platform.

DB2 UDB V7: The Database Solution for E-business
by Susan Lawson, Martin Hubel, & Gary Mordini
A look at DB2 Universal Database Version 7 as well as an overview of the enhancements for all DB2 platforms.

Unique and Primary Key Constraints in DB2 for OS/390
Version 7

by Cathy Lappe

It's late ... it's cold outside ... and you are trying run a DDL that does not execute successfully in DB2 Version 7 -- in fact, a negative SQLCODE may be about to display on your screen just when you think you are ready to logoff. A simple change to the DDL will quickly get you on your way to a full set of zero return codes and a full night's sleep.

Seventh Heaven
Richard Yevich
Get ready for the latest version of DB2 Universal Database—Version 7! The focus: Features that should make the DBA's life easier and more productive.

V6 and earlier

A Closer Look at DB2 UDB Version 6
by Kathy Komer
What's new in Version 6.1 and its value to businesses today. A look at some significant improvements in DB2's support of business intelligence and e-business requirements.

Preparing for DB2 Version 6
by Craig S. Mullins
The item that is most important for every DB2 shop to understand is what is not in DB2 V6. For the first time IBM is removing features from DB2 and you will need to prepare your DB2 subsystems for V6 by removing the soon-to-be-unsupported features from your installation.

DB2 Version 6 Stored Procedures Migration Issues,
Part 1
and Part 2
by Antonio L Salcedo
A list of issues related to the implementation of DB2 V6 stored procedures for those migrating to DB2 Version 6.

DB2 for OS/390 Version 6 Migration
by Linda Claussen
How to build a migration plan and stay aware of some of the potential problems that can arise when migration is performed without proper planning.

Introducing Object-Relational OS/390
by Richard Yevich and Susan Lawson
With the new object-relational capabilities in DB2 UDB version 6, you can query against practically any kind of data, including images, video, and text.

Version 5 Case Expressions: Beyond the SQL Reference
by Jan Henderyckx
Covers the performance characteristics of CASE and indicates the SQL problems that may benefit from the use of CASE as well as those that may not.

The Storage Impact of Type 2 Indexes
by Craig S. Mullins
Type 2 indexes provide numerous benefits to a DB2 subsystem. The primary benefit is the elimination of index locking. Many newer DB2 features such as row level locking and uncommitted reads require Type 2 indexes. With DB2 Version 6, Type 1 indexes are eliminated altogether, so you will be forced to move to Type 2 indexes. Before implementing Type 2 indexes it would be wise to investigate the storage impact of migrating from Type 1 to Type 2 indexes.

Converting Type 1 Indexes to Type 2
by Bernard Zver
DB2 Version 6 will not support Type 1 indexes, so all Type 1 indexes must be converted to Type 2 before migrating to Version 6. IBM has provided the CATMAINT utility, which converts catalog and directory indexes from Type 1 to Type 2; however, it only converts IBM-defined catalog indexes. The author offers an REXX procedure for user-defined indexes.



Roger Miller
DB2® for z/OS® Version 9


Craig Mullins' DB2 BLOG >>


Soccer Blog

(c) 2005, Double Loop Marketing LLC and Mullins Consulting, Inc.
All Right Reserved

DB2 is a registered trademark of IBM Corporation.