|
NEW:
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
ARCHIVED:
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
DB2
UDB for z/OS V8 AND UNICODE: IT'S NO TOWER OF BABEL
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
by IDUG
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
by 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.
|
