Share on Facebook Share on Twitter Share on Digg Share on Stumble Upon Share via e-mail Print

2010


To Rebind or Not to Rebind: Why Is That Even a Question?

IDUG Solutions Journal, Winter 2010.

DB2 and Storage Management.
IDUG Solutions Journal, Summer 2010 (September).

Performance Data - On the Cheap - Using Display.
IDUG Solutions Journal, Spring 2010 (May).

Assuring Data Integrity in DB2.
Quest ToadWorld Pipelines, April 2010.

2008

Things You've Probably Neglected.
IDUG Solutions Journal, November 2008.

DB2 Database Maintenance and Recovery: Getting Past the Common
Misconceptions
.
zJournal, October / November 2008.

Reoptimizing SQL.
zJournal, October / November 2008.

Change Control for DB2 Access Paths.
Database Trends and Applications, October 2008.

What Every Good CIO Needs to Know About Mainframe Database Auditing.
Mainframe Executive, September 2008.

DB2 9 Data Format "Stuff".
zJournal, August / September 2008.

On Recovery Service Levels.
IDUG Solutions Journal, Spring 2008.

Use Real Time Statistics to Automate Your Database Maintenance.
zJournal, April / May 2008.

Collecting Histogram Statistics With RUNSTATS.
DB2 Update, March 2008.

Much Ado About DB2 Locking.
zJournal, Feb / March 2008.


2007

Utility TEMPLATE Switching in DB2 9 for z/OS.
DB2 Update, December 2007.

New Data Types in DB2 9 for z/OS.
DB2 Update, November 2007.

DB2 Encryption Support Keeps Improving.
zJournal, October / November 2007.

DB2 9 for z/OS Improves LOB Support.
zJournal, Aug / Sept 2007.

Managing DB2 Access Paths.
DB2 Update, June 2007.

If You Ain't 8 You're Late.
zJournal, April / May 2007.

DB2 Database Performance Fundamentals.
IDUG Solutions Journal, Spring 2007.

DB2 9 for z/OS: No V for z.
zJournal, February / March 2007.

Why Haven't You Started Using Real-Time Statistics?
IDUG Solutions Journal, February 2007. (Vol. 13, No. 3)

Efficient SQL Coding Basics.
DB2 Update, February 2007.



2006

DB2 9 for z/OS Roars to Life.
DB2 Magazine, Quarter 4, 2006 Vol. 11, Issue 4

To Rebind or Not to Rebind: Is That a Question?
zJournal, October / November 2006.

Change Control for DB2 Access Paths.
IDUG Solutions Journal, October 2006.

The Basics of DB2 Buffering.
zJournal, June / July 2006.

A Few SQL Tips and Techniques.    (link no longer active)
Quest Pipelines, June 2006.

The Last Date of the Century.
DB2 Update, May 2006.

A Few SQL Tips and Techniques.
IDUG Solutions Journal, May 2006.

A Guide to DB2 Locking – Part 3.    (link no longer active)
dbazine.com, April 2006.

A Guide to DB2 Locking – Part 2.    (link no longer active)
dbazine.com, March 2006.

A View Review.
IDUG Solutions Journal, February 2006.

A Guide to DB2 Locking – Part 1.    (link no longer active)
dbazine.com, February 2006.

Do The Simple Things First.    (link no longer active)
Quest Pipelines, February 2006.

Assuring Data Integrity in DB2. (Part 2)
dbazine.com, January 2006.

Top Five DB2 V8 Transition Do’s and Don’ts.
zJournal, Dec 2005 / Jan 2006.



2004

Using Nulls in DB2.
IDUG Solutions Journal, December 2004.

High Speed Transaction Recovery.
Technical Support, November 2004

The Top Ten Features of DB2 for z/OS V8.
zJournal, October/November 2004.

Three Trusty Rules for DB2 Triggers.
DB2portal.com, October 2004.

A View Review.     (link no longer active)
dbazine.com, October 2004.

Using Dynamic SQL for Maximum Flexibility.
DB2 Update, October 2004.

An Irregular Sorting Requirement.   (link no longer active)
dbazine.com, September 2004.

What is Large?
zJournal, August/September 2004.

The Hitchhiker's Guide to DB2.
IDUG Solutions Journal, August 2004.

Taming DB2 Performance Issues.
Database Trends and Applications, August 2004.

DB2 Behind the Scenes.
dbazine.com, June 2004.

Using Real Time Statistics (RTS).
DB2 Update, June 2004.

DB2 Advice Your Daddy Didn't Give You.   (link no longer active)
search390.com, June 2004.

Recursion in DB2 V8, V8, V8...
IDUG Solutions Journal, Vol. 11, No. 1

Materialized Query Tables and the Death of Denormalization.
zJournal, April/May 2004.

Database Change Management and Schema Evolution in DB2 for z/OS V8.
dbazine.com, April 2004.

A Look at the Modes of DB2 V8.
zJournal, February/March 2004.

Sequence Objects and Identity Columns.
DB2 Update, February 2004.

An Introduction to DB2 Indexing.
dbazine.com, February 2004.

DB2 or VSAM?
dbazine.com, February 2004.

zData Perspectives: Sequence Objects and Identity Columns.
zJournal, December 2003/January 2004.


2003

Get Your Business Where it Needs to Go.
DB2 Magazine, OnDemand supplement, Quarter 4, 2003 Vol. 8, Issue 4

Know Your Isolation Levels.  
IDUG Solutions Journal, Vol. 10, No. 3

DB2 V8 Online Schema Evolution.
zJournal, October/November 2003.

An Overview of DB2 for z/OS Version 8.     (link no longer active)
dbazine.com, August 2003.

zData Perspectives: DB2 V7 B4 V8.
zJournal, August/September 2003.

The Buffer Pool: Choose the Proper Data Type.  
IDUG Solutions Journal, Vol. 10, No. 2

No Black Boxes.
DB2 Update, July 2003.

zData Perspectives: DB2 and the Old Dipsy Doo.  
zJournal, June/July 2003.

Denormalization of DB2 Tables.    (link no longer active)
searchdatabase.com, June 2003.

A DBMS Architecture by Any Other Name Is Still Confusing.
Database Trends and Applications, June 2003.

Large Objects and DB2.  
dbazine.com, May 2003.

Basic DB2 Buffering and Memory Guidelines.
searchDataCenter.com, May 2003.

zData Perspectives: DB2 —Versions, Service and Such.
zJournal, April/May 2003.

The Buffer Pool: Dynamic Buffer Changes.
IDUG Solutions Journal, Vol. 10, No. 1

DB2 Utilities Through the Looking Glass.    (link no longer active)
dbazine.com, April 2003.

DB2 Table Space Options, Part 2.    (link no longer active)
Mainframe Week, April 2, 2003.

DB2 Table Space Options, Part 1.    (link no longer active)
Mainframe Week, March 26, 2003.

Understanding DB2 Messages.    (link no longer active)
dbazine.com, March 2003.

zData Perspectives: An Overview of DB2 for z/OS V8.
zJournal, February 2003.

Eight Breakthroughs That Changed DB2 Forever.    (link no longer active)
DB2 Magazine, Quarter 1, 2003.

Tuning DB2 SQL Access Paths.
DB2 Developer Domain, January 2003.

An Introduction to DB2 Table Spaces.
dbazine.com, January 2003.

DB2 Questions for the Experts - Parts 1 and 2.    (links no longer active)
dbazine.com, January 2003

A DB2 for z/OS Performance Road Map.
DB2 Update, January 2003.


2002

The Automated Future: Take 2.    (link no longer active)
DB2 Magazine Online, December 2002.

DB2 Everyplace: A Mobile DB2.
DB2 Update, December 2002.

Using Java With DB2,  Part 1  Part 2.   (link no longer active)
Mainframe Week, December 2002.

The Buffer Pool: Clarifying Some Common Misconceptions.
IDUG Solutions Journal, Vol. 9, No. 3

DB2 and the Procedural DBA, Part 1  Part 2.  (link no longer active)
Mainframe Week, November 2002.

Coding DB2 SQL for Performance: The Basics.
DB2 Developer Domain, October 2002.

Q&As on DB2 Dates.
dbazine.com, October 2002.

Reorganizing the DB2 Catalog & Directory, Part1 Part2 Part3. (link no longer active)
Mainframe Week, October 2002

DB2 User-Defined Functions.
dbazine.com, August 2002.

Temporary Tables -- Declared and Created.
DB2 Update, August 2002.

Using TIMESTAMP Columns vs. DATE & TIME Columns.  (link no longer active)
Mainframe Week, August 2002.

DB2 Data Type Usage Tips.
dbazine.com, July 2002.

Managing the Performance of DB2 for OS/390 and z/OS.  (link no longer active)
IT Tool Box, July 2002.

DB2 Performance Traces.
dbazine.com, June 2002.

A DB2 for z/OS Performance Road Map.
dbazine.com, May 2002.

The 'Top Ten' Problem.
DB2 Update, May 2002.

A DB2 for z/OS Performance Road Map.
eServer zSeries Magazine, April 2002.

Utility Lists and Templates in DB2 V7 Utilities.
DB2 Update, April 2002.

A View to a Kill.   PDF
dbazine.com, March 2002.

Select Database Utilities With Care: The DBA Corner.
Database Trends and Applications, March 2002.

Issuing SQL Statements in DB2 Utilities.
DB2 Update, March 2002.

Architectures for Clustering: Shared Nothing and Shared Disk.
DB2 Magazine, 1Q2002.

Forty Tips in 60 Minutes.
dbazine.com, February 2002.

An Introduction to Triggers in DB2 for OS/390.
dbazine.com, February 2002.

DRDA.
dbazine.com, February 2002.


2001

Using Check Constraints to Simulate Domains.
DB2 Update, December 2001.

COPYTOCOPY -- A New DB2 Utility for Version 7.
DB2 Update, November 2001.

An Overview of DB2 for OS/390, Version 7.
dbazine.com, August 2001.

Control Your DB2 Memory Usage Before It Controls You.   (link no longer active)
BMC TechNews, July 2001.

Intelligently Managing DB2 Memory Structures.
Database Trends, May 2001.

DB2 Table Space Options.
DB2 Update, May 2001.



2000

LOB Columns vs. VARCHAR and VARGRAPHIC.    (link no longer active)
Revealnet Pipeline Newsletter, December 2000.

Using TIMESTAMP Columns Versus DATE & TIME Columns.
DB2 Update, December 2000.

Using Java With DB2 for OS/390.
DB2 Update, November 2000.

DB2 Everyplace: You Can Take It With You.
DB2 Magazine, Fall 2000.

DB2 User Defined Functions.  (link no longer active)
Revealnet Pipeline Newsletter, July 2000.

Reorganizing the DB2 Catalog and Directory.
DB2 Update, July 2000.

High Speed Transaction Recovery.    (link no longer active)
Enterprise Systems Journal, May 2000.

Using DB2 Stored Procedures.  (link no longer active)
devx, May 2000.

DB2 Triggers.     (link no longer active)
Revealnet Pipeline Newsletter, March 2000.

DB2 and the Procedural DBA.
DB2 Update, February 2000.


1999

Profile of an eDBA.
DB2 Magazine, Fall 1999.

Mixing DB2 and Object Orientation?
IDUG Solutions Journal, Summer 1999.

Data Warehousing Guidelines for DB2.
DB2 Update, July 1999.


Triggers and DB2 Version 6.
DB2 Update, March 1999.

The Need for a Procedural DBA.     (link no longer active)
IDUG Solutions Journal, March 1999.

The Buffer Pool.
PLATINUM SYSJOURNAL, Winter 1999.


1998

Storage Impact of Type 2 Indexes.
DB2 Update, December 1998.

SQL Analysis and Review.
Computing News and Review, November 1998.

The Future of SQL.
IDUG Solutions Journal, October 1998.

Preparing for DB2 Version 6.
DB2 Update, October 1998.

Character Versus Numeric Data Types.
DB2 Update, October 1998.

Managing DB2 for OS/390 Performance - Really.
DB2 Magazine, Fall 1998.

Java: Hype or Hope?
IDUG Solutions Journal, August 1998.

Data Warehousing Guidelines for DB2.
Enterprise Systems Journal, August 1998.

Tools for a Comprehensive Database Environment — Part 1, Part 2.
The Data Administration Newsletter, June 1998, September 1998.

Finding DB2 Information Using the Internet.
DB2 Update, June 1998.

DB2 and the Year 2000.
DB2 Update, May 1998.

Changes to the System Catalog for DB2 Version 5.  (link no longer active)
DB2 Update, March 1998.


2011

Optimistic Locking in DB2 for z/OS.
SSWUG, December 2011

DB2 Security - A Common Language for a Common Goal.
IDUG Tech Library Blog, October 2011

Ten Breakthroughs That Changed DB2 Forever.
SSWUG, October 2011

Collecting Histogram Statistics With RUNSTATS.
SSWUG, September 2011

On The Need for Temporal Data.
zJournal, August/September 2011.

Partitioning Pros and Cons.
zJournal, June/July 2011.

A Basic Introduction to Coding DB2 SQL for Performance.
SSWUG, June 2011

Best Practices in DB2 Storage Management.
zJournal, Apr/May 2011.

Not Your Standard Sorting Requirement.
Quest ToadWorld Pipelines, April 2011.

Dynamic SQL Versus Static SQL.
zJournal, Feb/March 2011.

Rebinding for Optimal DB2 Access Paths.
zJournal, December 2010 / January 2011.



1996

Stored Procedure Guidelines for DB2.
DB2 Magazine, Winter 1996.

Optimizing DB2 Outer Joins.
DB2 Update, August 1996.

Security Enhancements in DB2 V4.
DB2 Update, June 1996.

Using Variable Character Data in DB2.
DB2 Update, June 1996.

Tools for a Comprehensive DB2 Environment.
IDUG Solutions Journal, Issue 2, 1996.

DB2 Version 4 Catalog Revisions.     (link no longer active)
DB2 Update, April 1996.

DB2 Version 4 Security and Authorization Enhancements.
PLATINUM Edge, March 1996.

DB2 Version 4 Check Constraints.     (link no longer active)
DB2 Update, January 1996.

Reorganizing the System Catalog in DB2 Version 4.
IDUG Solutions Journal, Winter 1996.

1994

Implementing DB2 in a Client/Server Environment.     (link no longer active)
Mainframe Client/Server, December 1994.

New Catalog Statistics in DB2 Version 3.     (link no longer active)
DB2 Update, December 1994.

DB2 V3 Buffer Pool Tuning Options.
Relational Database Journal, November/December 1994.

Views on Views.
DB2 Update, October 1994.

What's in a Name?     (link no longer active)
DB2 Update, September 1994.

DB2: IBM's Answer to Client/Server.     (link no longer active)
Data Management Review, June 1994.

QMF Performance Tuning (Parts 1, 2, & 3).     (links no longer active)
DB2 Update, Jun-Jul-Aug 1994.

DB2 for MVS: Triggers & Stored Procedures.
PLATINUM Edge, Summer 1994.

Dismissing Dynamic Dangers.
Database Programming & Design, May 94

The Wrapping: Package Implementation Considerations.      (link no longer active)
Relational Database Journal, May-Jun / Jul-Aug / Sept-Oct '94.

The Future of DB2.     (link no longer active)
DB2 Update, May 1994.

DB2 Dataset Placement.     (link no longer active)
DB2 Update, April 1994.

The Buffer Pool: DB2 Tips, Thoughts, and Rumors.
Relational Database Journal, Mar - April 1994.

Know Your Data.     (link no longer active)
DB2 Update, March 1994.

A Look at DB2 Version 3.     (link no longer active)
DB2 Update, February 1994.

1993

Preparing for DB2 Design Reviews.     (link no longer active)
DB2 Update, December 1993.

How DB2 V2.3 Impacts EDM Pool Size.     (link no longer active)
DB2 Update, September 1993.

The Buffer Pool: DB2 Tips, Thoughts, and Rumors.
Relational Database Journal, August - October 1993.

DB2 Tips & Techniques: DB2 Data Set Placement.     (link no longer active)
PLATINUM SYSJOURNAL, Summer 1993.

DB2 Organizational Issues: It's Here, But Now What?
Data Management Review, July 1993.

The Buffer Pool: DB2 Tips, Thoughts, and Rumors.
Relational Database Journal, May - July 1993.

The Doors to DB2.
DB2 Today, May 1993.

How DB2 V2.3 Will Affect Your Standards.     (link no longer active)
DB2 Update, May 1993.

The Databases of our Lives.
PLATINUM Sysjournal, April 1993.

A Critical Look at the DB2 Catalog (Parts I and II).     (link no longer active)
Technical Support, January 1993 and February 1993.

How DB2 V2.3 Impacts EDM Pool Size.
IDUG Globe, January 1993.

2013

DSNZPARMs: DB2 Systems Configuration Parameters.
Toad World, December 18, 2013.

DB2 Performance Fundamentals.
SSWUG, December 9, 2013.

Thinking About Migrating to Version 11 of DB2 for z/OS?
Database Trends and Applications, December 2013.

Webinar: Building a Performance Centric Organization.
Datavail Blog, November 12, 2013.

Dynamic SQL Performance.
Toad World, October 23, 2013.

How to ORDER BY an Expression in DB2.
SSWUG, October 22, 2013.

Understanding the R4H Average to Control DB2 Costs.
Information on Demand 2013, October 21, 2013.

Selecting Every Other Row.
SSWUG, October 15, 2013.

An Interview With CA Technologies’ Troy Coleman.
Enterprise Executive, September/October 2013.

DB2 Developer’s Guide: Helping DB2 Pros for Over 20 Years.
Information on Demand 2013, September 25, 2013

Hunting Down Unused DB2 for z/OS Programs and Indexes.
Toad World, September 20, 2013.

Managing DB2 for z/OS Application Performance.
SSWUG, September 10, 2013.

What’s In a Name? On Database Naming Standards.
SSWUG, September 3, 2013.

High-Level Tips & Techniques for DB2 SQL Performance.
Toad World, August 27, 2013.

Coding DB2 SQL for Performance.
Toad World, July 29, 2013.

Issuing SQL Statements in DB2 Utilities.
SSWUG, July 2, 2013.

DB2 News from IDUG NA 2013.
Toad World, May 20, 2013.

General Guidelines for LOAD, REORG and REBUILD Utilities.
Enterprise Tech Journal, May 2013.

2012

The Scoop on “Dirty Read”
zJournal, December 2012 / January 2013.

Reading Things That Aren’t There & Missing Things That Are!
SSWUG, November 2012.

Materialized Query Tables…and the Death of Denormalization?
SSWUG, November 2012.

What Can You Do to Avoid DB2 Locking Problems?
Enterprise Tech Journal, October / November 2012.

SELECT from DELETE, UPDATE, and MERGE.
SSWUG, October 2012.

The Dirty Read (AKA Uncommitted Read).
SSWUG, September 2012.

DB2 Buffer Pool Essentials.
SSWUG, September 2012.

Using Nulls in DB2.
SSWUG
, August 2012.

Don't Forget DISPLAY as a Part of Your DB2 Tuning Efforts.
SSWUG, July 2012.

pureXML: Using XML in DB2 for z/OS.
InformIT, June 2012.

A Short History of DB2 for z/OS. (Link no longer active)
SSWUG, May 2012.

Making Static SQL More Dynamic...and Vice Versa.
SSWUG, April 2012.

DB2 Tips.
zJournal, February / March 2012.

2014

Minimizing Lock Contention Issues.
datAvail Blog, December 30, 2014

DB2 Compression: z/OS versus LUW.
datAvail Blog, December 16, 2014

Controlling the Rolling Four Hour Average & DB2 Costs.
Toad World, December 10, 2014

How to Assure Data Integrity in DB2 for z/OS.
Toad World, September 26, 2014.

A Short History of DB2 for z/OS.
Database Trends and Applications, September 2014.

The Danger of Dirty Reads.
Database Trends and Applications, August 2014.

DB2 Optimization and Access Paths: Understanding the Basics [Pt 2].
SSWUG, July 28, 2014.

DB2 Optimization and Access Paths: Understanding the Basics [Pt 1].
SSWUG, July 21, 2014.

Database Auditing on DB2 for z/OS.
Enterprise Tech Journal, June / July 2014.

Avoid Black Boxes to Optimize DB2 Application Efficiency.
Toad World, May 28, 2014.

Using REOPT to Control SQL Dynamism in DB2 for z/OS.
Enterprise Tech Journal, May / June 2014.

Introduction to Recursive SQL.
Database Trends and Applications, May 2014.

Required Types of Performance Monitoring and Tuning for DB2 Applications.
Toad World, March 24, 2014.

Top Ten Steps to Building the Right Indexes.
Toad World, February 28, 2014.

Compression Improvements Ease Big Data Burdens.
Toad World, January 22, 2014.

2009

Collecting Histogram Statistics With RUNSTATS.
zJournal, October / November 2009.

Just the Facts About Mainframe Specialty Processors.
The Data Administration Newsletter, November 2009.

Making Static SQL More Dynamic...and Vice Versa.
IDUG Solutions Journal, Fall 2009 (November).

DISPLAY Your Way Out of DB2 Problems.
zJournal, August / September 2009.

An Overview of Mainframe Specialty Processors.
IDUG Solutions Journal, Summer 2009 (August).

DB2 System Configuration and Performance.
zJournal, April / May 2009.

Utility Improvements in DB2 9 for z/OS.
IDUG Solutions Journal, Spring 2009..



2005

What SQL Can Be Used in a Compound SQL Statement?
SearchDataCenter.com, November 2005

SQL Performance Tuning Basics.
zJournal, October / November 2005.

Simple Things First.
IDUG Solutions Journal, October 2005.

Evaluating DB2 Tool Vendors.
zJournal, August / September 2005.

Assuring Data Integrity in DB2. (Part 1)
dbazine.com, August 2005.

Twenty-Two Years of DB2.
zJournal, June / July 2005.

Some SQL Tricks for the DB2 Developer.
DB2 Update, June 2005.

A Short Introduction to Lock Avoidance in DB2 for z/OS.
dbazine.com, May 2005.

Changing Table Space Partitioning Specifications.
zJournal, April / May 2005.

On VSAM and DB2.
IDUG Solutions Journal, April 2005.

Planning for IDUG.   (link no longer active)
dbazine.com, March 2005.

DB2 Annoyances.
zJournal, February/March 2005.

DB2 for z/OS Version 8 Adoption.    (link no longer active)
dbazine.com, March 2005.

An Introduction to DB2 Indexing.
DBAzine, January 2005.

The DB2 Utility Conundrum.
zJournal, December 2004/January 2005.


2021

What is Db2?
TechTarget, June 23, 2021.

2019

DevOps and Db2 for z/OS: Mixing Db2 Database Administration with DevOps.
IDUG, October 8, 2019

Db2 – The AI Database … and more!
Database Trends and Applications, July 10, 2019.

It’s Time for Db2 SQL Performance Testing to Shift Left.
Compuware Blog, May 7, 2019.

Improving Db2 Performance: Q&A with Craig S. Mullins.
Big Data Quarterly, February 26, 2019.

2018

TIMESTAMP versus DATE/TIME.
datAvail Blog, March 28, 2018.

Db2 Nulls and the IS [NOT] DISTINCT FROM Clause.
datAvail Blog, March 15, 2018.

Null Troubles.
datAvail Blog, February 28, 2018.

Db2 Best Practices.
datAvail Blog, February 13, 2018.

2017

Which is better? “BETWEEN” vs. “<=” and “>=”.
datAvail Blog, December 20, 2017.

Replacing UNION with CASE.
datAvail Blog, November 22, 2017.

Quick Thoughts on Db2 Performance.
datAvail Blog, November 9, 2017.

Reading Things That Aren’t There… and Missing Things That Are!
datAvail Blog, October 26, 2017.

Limiting the Number of Rows Fetched.
datAvail Blog, September 27, 2017.

The “Dirty Read” (AKA Uncommitted Read).
datAvail Blog, September 13, 2017.

Know Your ISOLATION Levels.
datAvail Blog, August 30, 2017.

Approaches to Access Path Management… or The Five R’s.
datAvail Blog, July 25, 2017.

Basic DB2 Buffering and Memory Guidelines.
datAvail Blog, July 11, 2017.

Cost vs. Advantage of Moving From IMS DB to Db2.
datAvail Blog, June 28, 2017.

A Short Introduction to Lock Avoidance.
datAvail Blog, May 29, 2017.

Understanding DB2 Performance.
LogicalRead Blog, April 25, 2017.

Don’t Forget DISPLAY as a Part of Your DB2 Tuning Efforts.
datAvail Blog, March 16, 2017.

VOLATILE: A Useful Little Keyword.
datAvail Blog, March 2, 2017.

Using INTERSECT and EXCEPT in DB2.
datAvail Blog, February 9, 2017.

Sorting Out a Solution in DB2.
datAvail Blog, January 26, 2017.

2016

DB2 Performance Monitoring Overview.
datAvail Blog, November 17, 2016.

Using Extended Indicator Variables in DB2 for z/OS.
Toad World, October 20, 2016.

Use a Little SQL Magic to Clean Up Your Data.
Toad World, September 26, 2016.

Hashing and Hash-Organized Tables in DB2.
Toad World, July 19, 2016.

When Not to Index.
datAvail Blog, July 19, 2016.

It’s Not Your Daddy’s DB2! - Part 6 (Autonomics).
BMC Blog, June 24, 2016

Using SQL Functions to Count Number of Character Occurrences.
Toad World, June 22, 2016.

Sequence Objects and Identity Columns.
datAvail Blog, June 14, 2016.

It’s Not Your Daddy’s DB2! - Part 5 (SQL & Development Trends).
BMC Blog, June 9, 2016

The Two Biggest DB2 Performance “Things”.
datAvail Blog, June 7, 2016.

A Quick Intro to DB2 SQL Functions.
datAvail Blog, May 18, 2016.

DB2 – What’s in a Name?
Toad World, May 18, 2016.

On DB2 Naming Conventions.
datAvail Blog, May 12, 2016.

To REBIND or Not to REBIND.
datAvail Blog, May 11, 2016.

It’s Not Your Daddy’s DB2! - Part 4 (Data Structures and DDL).
BMC Blog, April 29, 2016.

Dynamic SQL and Performance.
datAvail Blog, April 21, 2016.

An Education in DB2.
Toad World, April 20, 2016.

Intelligent Automatic Reoptimization?
datAvail Blog, April 12, 2016.

It’s Not Your Daddy’s DB2! - Part 3 (Unstructured Data and LOBs).
BMC Blog, March 16, 2016

Selecting Every Other Row in DB2.
datAvail Blog, March 15, 2016.

It’s Not Your Daddy’s DB2! - Part 2 (Universal Table Spaces).
BMC Blog, February 26, 2016

DB2 Performance Advisor: SQL Tuning Basics.
DirectionIT Magazine, February 25, 2016.

The History of DB2 for z/OS.
Toad World, February 23, 2016.

On Date Formats in DB2 - Part 2.
datAvail Blog, February 18, 2016.

On Date Formats in DB2 - Part 1.
datAvail Blog, February 9, 2016.

DB2 Data and Time Data.
datAvail Blog, January 26, 2016.

It’s Not Your Daddy’s DB2! - Part 1 (Industry and DBA Trends).
BMC Blog, January 19, 2016

DB2-L: The DB2 Mailing List.
Toad World, January 19, 2016

2015

Q+A: Locking.
datAvail Blog, December 24, 2015.

Consider Table Expressions to Improve Performance.
datAvail Blog, December 23, 2015.

Database Performance and Row Size for DB2.
datAvail Blog, December 18, 2015.

DB2 Optimization and Access Paths: Part 3 Optimization Class.
Toad World, December 14, 2015

Q+A: Nulls and DASD.
datAvail Blog, December 14, 2015.

DB2 Optimization & Access Paths: Part 2 Join Methods.
Toad World, November 20, 2015

The DB2 Performance Advisor: What is Performance?
DirectionIT, November 2015.

DB2 Optimization & Access Paths: Part 1 Scans vs Indexed Access
Toad World, October 29, 2015

VARCHAR versus Compression.
datAvail Blog, October 27, 2015.

Understanding DB2 for LUW Messages.
Toad World, September 17, 2015

Evaluating DB2 Tool Vendors.
datAvail Blog, September 1, 2015.

Using Date and Time Arithmetic in DB2.
Toad World, August 20, 2015

Adding Column Names to an Unload File.
datAvail Blog, August 19, 2015.

Advice on Using Variable Character Columns in DB2.
datAvail Blog, August 4, 2015.

DB2 Compression: z/OS versus LUW.
Toad World, July 28, 2015

IBM DB2 relational DBMS overview.
SearchDataManagement, June 19, 2015.

Returning Only Numeric Data.
datAvail Blog, May 26, 2015.

How and When to Use DB2 Scrollable Cursors.
datAvail Blog, May 19, 2015.

Accessing Partitioned Data in DB2 for z/OS.
datAvail Blog, May 1, 2015.

A High Level Overview of DB2 for z/OS.
Toad World, April 21, 2015.

Using Nulls in DB2.
datAvail Blog, April 6, 2015.

A Short Overview of DB2 Connect.
Toad World, February 24, 2015.

DSNTEP2 a.k.a Batch SPUFI.
datAvail Blog, February 19, 2015.

VSAM Demystified.
datAvail Blog, February 2, 2015.

DB2 SQL Query Tweaking.
Toad World, January 24, 2015.

Know Your Isolation Levels.
Toad World, January 5, 2015.



Click here for Craig’s DB2Portal Blog

1997

Large Partitioned Table Spaces.
DB2 Update, November 1997.

Data Definition Guidelines.  (link no longer active)
InformIT, October 1997.

DB2 Performance Planning and Engineering.
IDUG Solutions Journal, August 1997.

To Partition or Not to Partition, That is the Question.
DB2 Magazine, Spring 1997.

1995

Gathering DB2 Information in Cyberspace.
Enterprise Systems Journal, December 1995.

The Procedural DBA.
Database Programming & Design, December 1995.

DB2 V4 Outer Join Basics.
DB2 Update, October 1995.

DB2 V4 In-Line Views.
DB2 Update September 1995.

An Introduction to the Architecture of DB2 for OS/2.
PLATINUM Edge, September 1995.

An Introduction to the Architecture of DB2 for MVS.
PLATINUM Edge, Spring 1995.

Stored Procedures in DB2 Version 4.     (link no longer active)
IDUG Solutions Journal, April 1995.

DB2 SQL Analysis Tools.     (link no longer active)
DB2 Update, February 1995.

Lock Avoidance in DB2 Version 3.
DB2 Update, January 1995.

Data Set Closing.
Relational Database Journal, January/February 1995.

1992

Technical Tips for Users of DB2 V2.3.     (link no longer active)
PLATINUM SYSJOURNAL, September 1992.

The Future of DB2 Security (Part I and Part II).
Data Management Review, July 1992 and August 1992.

1991

Dynamic SQL For DB2.
Enterprise Systems Journal, December 1991.

Problem Too Complicated for Simple Arithmetic.
Database Management, November 1991.

One View Per Base Table... Don’t Do It!
Database Programming & Design, February 1991.

Mastering Disaster Recovery.
Database Programming & Design, January 1991.

1990

Dusting Off The Database.
Database Programming & Design, August 90.


DB2 V2.2 A Few More Bells & Whistles.
Database Programming & Design, June 1990.


Effective DB2 Object Monitoring Using The DB2 Catalog.
Mainframe Journal, May 1990.

DB2 Developer's Guide, published by IBM Press, delivers over 1600 pages of in-depth technical information on Db2 for z/OS. The best selling Db2 book over 20 years and 6 editions.