DB2 Database Administration


Thanks for the Memory by Robert Catterall

A Guide to DB2 Locking, part 3 by Craig S. Mullins

DB2 for z/OS database design: Principles of peak performance by Fred Whitlark

Disk storage access with DB2 for z/OS

Data Integrity with DB2 for z/OS


A Guide to DB2 Locking, part 1 by Craig S. Mullins

A Guide to DB2 Locking, part 2 by Craig S. Mullins

Staying Power, Part 2 by Robert Catterall

Conserving Disk Space by Robert Catterall

Assuring Data Integrity in DB2 by Craig S. Mullins

A View Review by Craig S. Mullins

Using Real Time Statistics (RTS) by Craig S. Mullins

Conserving Disk Space on the Mainframe? by Robert Catterall

Large Objects Get Bigger by Roger Miller

Ms. Fix-It by Kim Moutsos

Using Nulls in DB2 by Craig S. Mullins

by Robert Catterall
How do you decide between these two viable alternatives in a DB2 for OS/390 environment? You may not have to.

A Data Strategy for the Enterprise
by Michael L. Gonzales
Tired of data integration problems? This article looks at what it takes to create an enterprise data strategy.

DB2 and the Procedural DBA
by Craig Mullins
This article discusses these new code-based objects from a DB2 for OS/390 perspective and suggests a useful re-definition of the role of a DBA in this changing environment.

Materialized Query Tables and the Death of Denormalization
by Craig S. Mullins, craigmullins.com
DB2 V8 offers a very useful new feature known as Materialized Query Tables (MQTs). Though not exclusively for data warehousing, MQTs can improve the elegance and efficiency of DB2-based data warehouses.

A Short Introduction to Lock Avoidance in DB2 for z/OS by Craig S. Mullins

An Introduction to DB2 Table Spaces by Craig S. Mullins

Large Objects and DB2 by Craig. S. Mullins

Q&As on Dates and DB2 by Craig S. Mullins

DRDA by Craig Mullins

DB2 Data Type Usage Tips by Craig S. Mullins

An Introduction to Database Design: From Logical to Physical by Craig S. Mullins

A View to a Kill by Craig Mullins

A View Review by Craig S. Mullins

DB2 Behind the Scenes by Craig S. Mullins

Database Change Management and Schema Evolution in DB2 for z/OS Version 8 by Craig S. Mullins

Maximize Access to Relational Data
by Fred Whitlark
With concurrency, multiple database users can access data at the same time while maintaining the integrity and consistency of the data. This article provides some general guidelines and recommendations for improving concurrency in DB2 for z/OS environments.

An Introduction to DB2 Indexing by Craig S. Mullins

LOBs Performance with DB2 for z/OS Version 7 IBM Corp.
Some recommendations on how to choose the best options when inserting or loading relatively small LOBs.

Choose the Proper Data Type by Craig S. Mullins
The most fundamental integrity constraints applied to data in a database are data type and length. The DBA must choose the data type and length of each column wisely.

Pros and Cons of Defining Tablespaces as Locksize Row in DB2
by ITtoolbox
What DB2 users have to say about the pros and cons to defining all the tablespaces with Locksize Row.

Compliance’s Bright Side
by David Beulke, DB2 Magazine
The latest versions of both DB2 for z/OS and DB2 for Linux, Unix, and Windows offer enhancements that help organizations comply with regulatory requirements such as the United States' Health Insurance Portability and Accountability Act (HIPAA) and Sarbanes-Oxley Act of 2002.

Unleashing the Power of Data
by Howard Goldberg, DB2 Magazine
With its flexible, extensible data warehousing model, Merrill Lynch shows how IT investments can pay off with cost efficiency and support for Sarbanes-Oxley compliance efforts and other emerging priorities.

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.

Where Do You Want to Go Next?
by Kim Moutsos
Automating the DBA: What IBM's SMART DB2 will mean to the DBA of the future.

Can I Use SMS for the DB2 Catalog and Directory Data Sets?
by Robert Catterall
Author Robert Catterall responds.

Pros and Cons of Defining Tablespaces as Locksize Row In DB2
by ITtoolbox FAQ Team
When defining a new major system in DB2 V7.1 on Z/OS, what are the pros and cons to defining all the tablespaces with Locksize Row?

DB2 DBA: Virtual Realities
by Robert Catterall
Remember the days wehn 2GB of virtual storage was excessive? Today, it's a precious resource, to be managed carefully.

Just the Stats, Ma'am
by Robert Catterall
About statistics reports: they can deliver more than just a little knowledge.

Just the Stats, Ma'am (Part 2)
by Robert Catterall
More about the importance of statistics reports, including logging, rids, locking activity, and more. (See part 2.)

Using LOBs and Extenders in DB2
by Susan Lawson
Author Susan Lawson offers information on how DB2 DBAs can deal effectively with LOBs and extenders.

Time to Reconsider SMS
by Robert Catterall
Recent advances in DASD technology are making even the staunchest critics of DB2's Systems Managed Storage take another look.

DB2 UDB Problem Determination in WebSphere

by IBM Corporation
Basic information for problem determination from IBM.

The Automated Future – An Interview with Craig S. Mullins
Even with the advent of "robo-DBAs," DB2 expert Craig Mullins thinks the DBAs of tomorrow will have plenty to keep them busy.

Architectures for Clustering: Shared Nothing and Shared Disk
by Craig S. Mullins
Clustering can bring extra computing power and improved availability. Choosing the architecture that makes sense with your hardware and software makes all the difference.

Dealing with Non Partitioning Indexes
by Rob Catterall
What to do when INSERTING into a very large table becomes time consuming and complex

Using DB2 Incremental Backup
by Miro Flasza
Discusses one of the most powerful backup improvements for data warehouses: incremental backup. It provides additional flexibility in designing a backup strategy for some types of databases environments.

Using TIMESTAMP Columns Versus DATE and TIME Columns
by Craig S. Mullins
Methods for storing this information in each format and a look at the differences.

DB2 or VSAM?
by Craig S. Mullins

Making DB2 Case-Insensitive
by Brian Adamache
Case insensitivity is important if you can’t control the data coming into the database -- basically, in any circumstance in which users enter data for themselves or when you are loading outside data.

A Report on DB2 UDB for OS/390 Catalog Migration Performance by Ching Lee, John Lyle, Mai Nguyen, and Akira Shibamiya
This team responded to a customer's problem by significantly reducing the time required for a catalog migration and providing a technique to estimate how long a given migration job would take as a function of the catalog size.

What is the Architecture of DB2?
by Craig S. Mullins
An overview of the DB2 architecture by DB2 expert Craig Mullins.



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.