|
Click Here for my DB2 /
Mainframe Blog
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.
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.
The
Buffer Pool:
DB2 Database Performance Fundamentals.
IDUG
Solutions Journal,
Spring 2007.
DB2 9 for z/OS: No V for z.
zJournal,
February / March 2007.
The
Buffer Pool: 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.
DB2 z/OS Index Creation Guidelines.
Quest Pipelines,
February 2007.
Change
Control for DB2 Access Paths.
Quest Pipelines,
January 2007.
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.
The
Buffer Pool: Change Control for DB2 Access Paths.
IDUG
Solutions Journal,
October 2006.
z/Data Perspectives:
The Basics of DB2 Buffering.
zJournal,
June / July 2006.
A Few SQL Tips
and Techniques.
Quest Pipelines,
June 2006.
The Last Date of the Century.
DB2 Update, May 2006.
The
Buffer Pool: A Few SQL Tips and Techniques.
IDUG
Solutions Journal,
May 2006.
A Guide to DB2
Locking – Part
3.
dbazine.com,
April 2006.
A Guide to DB2
Locking – Part 2.
dbazine.com,
March 2006.
The
Buffer Pool: A View Review.
IDUG
Solutions Journal,
February 2006.
A Guide to DB2
Locking – Part 1.
dbazine.com,
February 2006.
Do
The Simple Things First.
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.
SQL Performance Tuning Basics.
zJournal,
October / November 2005.
The
Buffer Pool: 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.
The
Buffer Pool: On VSAM and DB2.
IDUG
Solutions Journal,
April 2005.
Planning for IDUG.
dbazine.com, March 2005.
DB2 Annoyances.
zJournal,
February/March 2005.
DB2 for z/OS Version 8 Adoption.
dbazine.com, March 2005.
The DB2 Utility
Conundrum.
zJournal,
December 2004/January 2005.
The Buffer Pool: 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.
dbazine.com, October 2004.
Using Dynamic SQL for Maximum Flexibility.
DB2 Update, October 2004.
An Irregular
Sorting Requirement.
dbazine.com, September 2004.
What is Large?
zJournal,
August/September 2004.
The Buffer Pool:
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.
The Buffer Pool: 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 Version 8.
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.
Get Your Business Where it Needs to Go.
DB2
Magazine, OnDemand supplement,
Quarter 4, 2003 Vol. 8, Issue 4
The Buffer Pool: Know Your Isolation Levels.
IDUG
Solutions Journal, Vol. 10, No. 3
zData
Perspectives: DB2
V8 Online Schema Evolution.
zJournal, October/November 2003.
An
Overview of DB2 for z/OS Version 8.
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.
searchdatabase.com,
June 2003.
A DBMS
Architecture by Any Other Name Is Still Confusing: The DBA Corner.
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.
dbazine.com,
April 2003.
DB2
Table Space Options, Part 2.
Mainframe
Week, April 2, 2003.
DB2
Table Space Options, Part 1.
Mainframe
Week, March 26, 2003.
Understanding
DB2 Messages.
dbazine.com,
March 2003.
zData
Perspectives: An Introduction to DB2 for z/OS V8.
zJournal, February 2003.
Eight
Breakthroughs That Changed DB2 Forever.
DB2 Magazine, Quarter 1, 2003.
Tuning
DB2 Access Paths.
DB2
Developer Domain, January 2003.
An
Introduction to DB2 Table Spaces.
dbazine.com,
January 2003.
DB2
Questions for the Experts - Part 2.
dbazine.com, January 2003
DB2
Questions for the Experts - Part 1.
dbazine.com, January 2003
A DB2 for z/OS Performance
Road Map.
DB2 Update, January 2003.
The
Automated Future: Take 2.
DB2 Magazine Online,
December 2002.
DB2 Everyplace: A Mobile DB2.
DB2 Update, December 2002.
Using Java
With DB2, Part
1 Part
2.
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.
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 and Directory, Part
1 Part
2 Part
3.
Mainframe
Week, October 2002
DB2
User-Defined Functions.
dbazine.com,
August 2002.
Temporary Tables -- Declared and
Created.
DB2 Update, August 2002.
Using TIMESTAMP Columns versus DATE and TIME
Columns, Part
1 and Part
2.
Mainframe Week, August
2002.
DB2
Data Type Usage Tips.
dbazine.com,
July 2002.
Managing
the Performance of DB2 for OS/390 and z/OS.
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.
Using Templates and Lists in DB2
Utilities.
DB2 Update, April 2002.
A
View to a Kill.
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.
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.
BMC TechNews,
July 2001.
Intelligently
Managing DB2 Memory Structures.
Database
Trends, May 2001.
DB2 Table Space Options.
DB2 Update, May 2001.
LOB
Columns vs. VARCHAR and VARGRAPHIC.
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.
Revealnet Pipeline Newsletter, July 2000.
Reorganizing the DB2 Catalog and Directory.
DB2 Update, July 2000.
High
Speed Transaction Recovery
Enterprise Systems Journal,
May 2000.
DB2 and the Procedural DBA
DB2 Update, February 2000.
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.
Enterprise Systems Journal, August 1998.
Triggers and DB2 Version 6
DB2 Update, March 1999.
DB2
Triggers.
Revealnet Pipeline Newsletter, March 2000.
The
Need for a Procedural DBA
IDUG
Solutions Journal, March 1999.
The Buffer
Pool
PLATINUM SYSJOURNAL, Winter 1999.
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.
Java:
Hype or Hope?
IDUG Solutions Journal, August 1998.
Tools for a Comprehensive Database Environment —
Part 1, Part 2
The Data Administration Newsletter, June 1998, September 1998.
DB2
and the Year 2000
DB2 Update, May 1998.
Large Partitioned Table Spaces
DB2 Update, November 1997.
Data
Definition Guidelines.
InformIT, October 1997.
DB2 Performance Planning and
Engineering.
IDUG Solutions Journal, August 1997.
Stored Procedure Guidelines for
DB2.
DB2 Magazine, Winter 1996.
Tools
for a Comprehensive DB2 Environment.
IDUG Solutions Journal, Issue 2, 1996.
DB2
Version 4 Security and Authorization Enhancements.
PLATINUM Edge, March 1996.
DB2
V4 Outer Join Basics.
DB2 Update, October 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.
Views
on Views.
DB2 Update, October 1994.
What's in a Name?
DB2 Update, September 1994.
DB2
for MVS: Triggers & Stored Procedures.
PLATINUM Edge, Summer 1994.
The Future of DB2.
DB2 Update, May 1994.
DB2 Dataset Placement.
DB2 Update, April 1994.
Know Your Data.
DB2 Update, March 1994.
A Look at DB2 Version 3.
DB2 Update, February 1994.
Preparing for DB2 Design
Reviews.
DB2 Update, December 1993.
How DB2 2.3 Impacts EDM Pool
Size.
DB2 Update, September 1993.
How DB2 V2.3 Will Affect Your
Standards.
DB2 Update, May 1993.
© 2007 Craig S. Mullins. All rights reserved.
Return to Home.
|
