Technical
papers about DB2 updated on 01/22/01
SQL: Building
Block #1 by Sheryl
Larsen, IDUG journal, December 2000. 
Using
Timestamp columns versus Date and Time columns
by Craig Mullins, DB2 Update, December 2000.
Outer joins:
No More Worries by Richard
Yevich, IDUG Journal, November 1999.
The SQL
Double Double by Sheryl
Larsen, DB2 Mag, Spring 1998.
Powerful SQL:
Beyond the Basics by Sheryl
Larsen, DB2 Mag, Winter 1996.
Denormalization
Denormalization
guidelines by Craig
Mullins, TDAN, June 1997.
Access path
Mining the
DB2 catalog with SQL by Suresh
Sane, IDUG journal, December 2000.
DB2 for
OS/390: Version 5 vs Version 6 Outer Join
Performance by Maryela
Weihrauch, IDUG journal, December 2000.
The Seedy
Underworld of DB2 UDB for OS/390 by Chad
Reiber, IDUG journal, December 2000.
Demystifying
"Optimizing for N Rows"
by Bonnie Baker, DB2 Mag, Summer 2000.
New ways to
influence SQL Access Paths by
Michael Hannan, DB2 Perf. Journal, May 2000 
Responsible
SQL by Bonnie Baker, DB2 Mag,
Summer 1999.
Tales of the
DB2 Optimizer by Bonnie Baker,
DB2 Mag, Spring 1999.
Hot on the
Tuning Trail by Michael
Hannan, DB2 Mag, Fall 1997.
A Hidden
Secret of DB2 version 4
by Sheryl Larsen, DB2 Mag, Spring 1997.
Explain
across the Enterprise I by
Dave Fox and Nicholette Ross, BMC Tech News,
January 1997
Explain
across the Enterprise II by
Dave Fox and Nicholette Ross, BMC Tech News,
April 1997
How to Tune
DB2 Access Paths by Sheryl
Larsen, DB2 Mag, Winter 1996.
Predicates
Predicate
Evaluation: Part I
by Bonnie Baker, DB2 Mag, Winter 2000.
SQL Filter
Factor Formulas by Michal
Hannan, DB2 Perf. Journal, July 2000
Improving
stage 2 predicates
by Sharad Pande, DB2 Mag, Summer 1999.
Non-correlated
subquery using the IN predicate
by Hong Tie, IDUG journal, March 1999.
Statistics
Performance
Basics Redux by Casey
Young, IDUG journal, December 2000.
Tuning SQL
with Statistics by Patrick
Bossman, IDUG journal, August 1999.
Improving DB2
query performance with DSTATS
by Steve Bower, IDUG journal, March 1999.
Sort, cluster index and prefetch
Prefetch and
Deferred Write in OS/390
by Robert Catterall, DB2 Mag, Summer 2000.
Looking for a
Little Order by
Bonnie Baker, DB2 Mag, Winter 1999.
One brick at
a time by Bonnie Baker, DB2 Mag,
Fall 1999.
The Myths of
the Clusterratio by Bonnie Baker,
DB2 Mag, Winter 1997.
Programming
for recovery by Steve
Carriero, DB2 Mag, Fall 1999.
The Woes of
Commitment by Bonnie Baker,
DB2 Mag, Fall 1998.
Tuning Data
Sharing Performance
by Robert Catterall, DB2 Mag, Fall 2000.
Data Sharing
Performance Enhancements
by Susan Lawson, IDUG journal, August 1999.
DB2 for
OS/390 Data Sharing Locking
by Robert Catterall, DB2 Mag, Spring 1999.
Database
Recovery when Data Sharing by
Sharad Pande, Entreprise Systems Journal,
February 1998.
DB2's use of
the coupling facility by
Josten/Mohan/..., IBM Systems Journal volume 36
No. 2 1997.
DB2 Data
Sharing : a performance perspective
by Robert Catterall, DB2 Mag, Fall 1997.
Getting the
most out of DB2 Parallelism by Susan
Lawson, DB2 Perf. Journal, May 2000
Peak Parallel
Performance: Secrets that a DBA should know
by Smith/..., IDUG journal, August 1997.
Peak Parallel
Performance: Principally programming
by Smith/..., IDUG journal, November 1997.
Peak Parallel
Performance: Savvy
by Smith/Zeidenstein/Turnbaugh, IDUG journal,
March 1998 .
Implementing
Online Reorg in a Production Environment by
Craig Friske, IBM, November 1999.
On line
Reorganization by Craig Friske
and Jim Ruddy, DB2 Mag, Fall 1998.
Reoptimizing
SQL statements by Sharad Pande,
DB2 Mag, Summer 1998
A Method for
Online Reorganization of a Database
by Sockut/..., IBM Systems Journal, 1997.
Proactive
Data: DB2 Triggers
by Willie Favero, ESJ, November 2000.
Migrating to
DB2 for OS/390 - Version 6 and Version 7 by
Roger Miller, IDUG journal, August 2000.
New features
in Version 6 by
Richard Yevich, IDUG journal, March 2000.
The Trigger
Effect by Willie Favero, DB2
Mag, Spring 2000.
Introduction
Object-Relational OS/390
by S. Lawson and R. Yevich, DB2 Mag, Spring 2000.
Everything
you want to know about query processing...
by Pat Selinger, IDUG Journal, November 1999.
DB2 UDB for
OS/390 Version 6 : arriving soon
by R.Yevich and S.Lawson, IDUG Journal, March
1999
Triggers and
DB2 Version 6 by Craig
Mullins, DB2 Update, March 1999.
Preparing for
DB2 Version 6 by Craig
Mullins, DB2 Update, October 1998.
Ready For
Anything by Gary Mordini, DB2 Mag,
Fall 2000.
Seventh
Heaven by Richard Yevich, DB2
Mag, Fall 2000.
DB2 UDB V7:
the Database Solution for e-business by
Lawson/Hubel/Mordini, IDUG journal, August 2000.
DB2 UDB V7:
the Database Solution for e-business
DB2 UDB for
OS/390 Storage Management
by J. Campbell et M. Petras, IDUG journal, March
2000
DB2 UDB
Version 6 Buffer Pools: Making waves by
Susan Lawson, IDUG journal, March 2000.
It's Time to
Re-think Your DB2 Buffer Pool Strategy
by Martin Hubel, Martin Hubel Consulting Inc.
Group Buffer
Pool Tuning by
Robert Catterall, DB2 Mag, Winter 1997.
Identify and
solve DB2 Buffer problems Part I
by Daniel Kitay, Technical Support, November
1996.
Identify and
solve DB2 Buffer problems Part II by
Daniel Kitay, Technical Support, December 1996.
Stored
Procedure Version Control in DB2 Version 6
by Ramesh Bala, IDUG journal, March 2000
Using CICS
EXCI and DB2 Stored Procedures
by Donofrio/Anzmann/Rettman, DB2 Mag, Winter
1999.
Using
DB2 stored procedures
by Valarie Watson/Andrea Reid, The QMF reporter,
January 1999
A new issue in DB2 performance management
by Ed Woods, Candle Report, September 1996.
Using Java
with DB2 for OS/390
by Craig Mullins, DB2 Update, November 2000.
Of Java and
DB2: Using Java Database Connectivity and SQLJ
by Lou Marco, ESJ, November 2000.
Gettting
Started with Java and DB2 for OS/390
by P. Abelite et M. Cathcart, ESJ, February 2000
Gettting
Started with Java and DB2 for OS/390
Goodbye
Deadlocks and Timeouts
by Indra Bishop/ Paul Kenney, Candle Report,
February 1996.
Storage
impact of type 2 indexes
by Craig Mullins, RevealNet DB2 Pipeline, August
1999.
Using
constraints to simulate domains
by Craig Mullins, TDAN, December 1998.
What's in a
name ? by Craig Mullins, TDAN,
March 1998.
Tuning ERPs
for DB2 by
Susan Lawson and Richard Yevich, DB2 Mag, Summer
1999.
Tuning
PeopleSoft Applications for DB2 OS/390 by
Martin Hubel, Martin Hubel Consulting Inc.
Performance
enhancements for SAP R/3 and DB2 by
Daniel Kitay, IDUG Journal, August 1997.
DDF vs CICS
by Robert Catterall, DB2 Mag, Winter 2000.
To Defer or
Define: That is the Question by
Denise Tabor, BMC Tech News, November 2000.
Transaction
Recovery, Step by step, Part I by
Mike Rizzo, BMC Tech News, November 2000.
Spatial
Perception in DB2 for OS/390
by Bonnie Baker, DB2 Mag, Fall 2000.
Managing DB2
Application Performance by
Martin Hubel, IDUG journal, August 2000.
Compress this
by Robert Omerza, IDUG journal, March 2000.
Data
Warehousing Guidelines for DB2
by Craig Mullins, ESJ, May 2000.
Application
Performance: An Oxymoron by Richard
Yevich, DB2 Perf. Journal, May 2000
Emulating
Recursive and Dynamic SQL by Sheryl
Larsen, DB2 Perf. Journal, May 2000
DASD
Performance Issues for DB2 applications by Joel
Goldstein, DB2 Perf. Journal, May 2000
Much Ado
about Nulls by Bonnie Baker,
DB2 Mag, Spring 2000.
Time to
Reconsider SMS by Robert
Catterall, DB2 Mag, Spring 2000.
Plugging in
XML by Harold Treat, DB2 Mag,
Winter 1999
CICS-DB2 news
you can use by Robert
Catterall, DB2 Mag, Fall 1999.
Expanding the
Reach of DB2 through TCP/IP
by Ed Woods, Candle Report, February 1999.
High-Speed
Transaction Recovery
by Craig Mullins, ESJ, August 1998.
Leveraging
the SQLCA by Bonnie Baker,
DB2 Mag, Summer 1998.
RACF and DB2
by M. Nelson, M. Jordan and R. Miller, Technical
Support, June 1998.
DB2 V4:
Recovery with level-ids by
Sharad Pande, ESJ, March 1998.
Object
persistence in object-oriented applications
by Srinivasan/..., IBM Systems Journal, 1997
| Others
Websites featuring technical papers |
download
Acrobat Reader from Adobe.
Your comments : db2usa@multimania.com
aaaaaaaaaaaaaaAAaaaaaaaaaaaaAaaaaaaaaaaaaaaaaaaAaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
|
