Hi,

Here is a non-profit website about DB2 for OS/390 (IBM mainframes):

- English : [url]http://db2usa.hypermart.net/eliendb2.htm[/url]
- Français: [url]http://db2usa.hypermart.net/liendb2.htm[/url]


Last update on Monday, September 22nd 2003
==========================================

* Technical papers about DB2:
[url]http://db2usa.hypermart.net/earticle.htm[/url]

October 2002 and May 2003 issues of IDUG journal are available on
line:
- Turbo Charge Your Application From 4 to 400 Transctions Per Second
by David Owen, IDUG journal, October 2002.
- You can Only Live Twice, Or, How to Un-termnate a DB2 Utility by
Mark MC Cormack, IDUG journal, October 2002.
- Storage Stew for DB2 (and What it Means to You) by Bill Cunningham,
IDUG journal, October 2002.
- The Buffer Pool Clarifying Some Common Misconceptions by Craig
Mullins, IDUG journal, October 2002.
- Overcoming SQL Limits in DB2 by Susan Lawson and Terry Purcell,
IDUG journal, October 2002.
- Materialized Query Tables - What are they Good For ? by Pat
Selinger, IDUG journal, October 2002.

- All the details on DB2 UDB for z/OS Version 8 by Beulke, Hubel,
Lyon, Nelson, IDUG journal, May 2003.
- Partitioning, Indexing and Clustering PICing on DB2 z/OS Version 8
by Susan Lawson, IDUG journal, May 2003.
- Dynamic Buffer Changes and Partionned Access by Craig Mullins, IDUG
journal, May 2003.

IDUG journal website contains:
- Details on DB2 UDB Server for z/OS Version 8 by L. Lyon, P. Nelson,
M. Hubel and D. Beulke, IDUG, January 2003

Spring 2003, Summer 2003 and Fall 2003 issues of DB2mag are available
on line:
- Seeing the DB2 Light by Robert Catterall, DB2mag, Spring 2003.
- More Joys of Commitment by Bonnie Baker, DB2mag, Spring 2003.
- Eight Breakthroughs that Changed DB2 Forever by Craig Mullins,
DB2mag, Spring 2003.
- Bound to Succeed by David Stodder, DB2mag, Spring 2003.
- Seeing the DB2 Light by Robert Catterall, DB2mag, Spring 2003.

- Programs vs Utilities by Jim Ruddy, DB2mag, Summer 2003.
- Just the Stats, Ma'am by Robert Caterall, DB2mag, Summer 2003.

- Old Dogs, New Tricks by Bonnie Baker, DB2mag, Fall 2003.
- Just the Stats, Ma'am (part 2) by Robert Caterall, DB2mag, Fall
2003.

IBM DB2 Developer Domain website is available on line:
- Meet the Experts:Stored Procedures in DB2 for z/OS and OS/390 with
Peggy Abelite, DB2 DD, February 2003.
- Ask the Experts: Stored Procedures in DB2 for z/OS and OS/390 with
Peggy Abelite, DB2 DD, February 2003.

Technical papers from dbazine.com are available on line:
- DB2 Subsystem Tuning in a ERP Environment (part 1) by Lockwood
Lyon, dbazine.com, 2003.
- DB2 Subsystem Tuning in a ERP Environment (part 2) by Lockwood
Lyon, dbazine.com, 2003.
- Larges Objects and DB2 by Craig Mullins, dbazine.com, 2003.
- A DB2 for z/Os Performance Roadmap by Craig Mullins, dbazine.com,
2003.
- A view to a Kill by Craig Mullins, dbazine.com, 2003.
- DRDA by Craig Mullins, dbazine.com, 2003.
- An Introduction to Trigger in DB2 for OS/390 by Craig Mullins,
dbazine.com, 2003.
- An Introduction to Table Spaces by Craig Mullins, dbazine.com, 2003.
- DB2 Utilities Through the Looking Glass by Craig Mullins,
dbazine.com, 2003.

Three technical papers from DB2Times are available on line:
- Saving CPU in your multiple counts SQL statements by Terry Purcell,
DB2Times, May 2003.
- V8 z/OS Materialized Query Tables by Susan Lawson, DB2Times, May
2003.
- Additional considerations for IN list performance by Terry Purcell,
DB2Times, December 2002.

An article from The Mainstream newletter is available on line:
- DB2 Version 8: A virtual conversation with Roger Miller , The
Mainstream, Issue 2, December 2002.

A technical paper about Statistics is available on IBM DB2 for z/OS
and OS/390 website:
- Filter factor statistics strategies by IBM, 2003

Five technical papers from z/journal are available on line:
- An Overview of DB2 for z/Os Version 8 by Craig Mullins, z/journal,
February 2003.
- DB2: Versions, Service and Such by Craig Mullins, z/journal, April
2003.
- The Buffer Pool Hit Ratio is Dead by Joel Goldstein, z/journal,
April 2003
- DB2 and the Old Dipsy Doo by Craig Mullins, z/journal, June 2003.
- DB2 V7 B4 V8 by Craig Mullins, z/journal, August 2003.


* DB2 redbooks
[url]http://db2usa.hypermart.net/eredbook.htm[/url]

A new Tip is available on line:
- TIP0145 2003-04-11 Substring notation support in TEMPLATE is
introduced with APAR PQ54608

Seven new redbooks are available on line:
- SG24-6952-00 2003-06-30 Distributed Functions of DB2 for DB2 for
z/OS and OS/390
- SG24-6871-00 2003-04-13 DB2 UDB for z/OS Version 8 Technical
Preview
- SG24-6868-00 2003-03-18 Siebel 7 with DB2 for z/OS: Database
Implementation and Administration Guide
- SG24-6914-00 2003-02-19 SAP on DB2 UDB for OS/390 and z/OS:
Multiple Components in One Database (MCOD)
- SG24-6905-00 2003-02-14 Moving Data Across the DB2 Family
- SG24-6867-00 2003-01-31 DB2 Performance Expert for z/OS
- SG24-6836-00 2002-09-13 SAP on DB2 UDB for OS/390 and z/OS: Hign
Availability Solution Using System Administration


* DB2 conferences
[url]http://db2usa.hypermart.net/econference.htm[/url]

DB2 presentations from Share 99 (San Francisco, August 2002) are
available on line:
- DB2 V5 to V7 Skip Migration: An User Experience by Joanne Horowitz
(MetLife)
- DB2 for z/OS, Storage Technology Overview by Jeff Berger (IBM SVL)
- Implementing Siebel 7 with DB2 for z/OS by Svetlana Sicular (Siebel
Systems)

A DB2 presentation from Share 100 (Dallas, Februay 2003) is available
on line:
- DB2 Performance Expert for z/OS by Norbert Jenninger (IBM) and
Richard Schaufuss (IBM SVL), February 2003

A DB2 presentation of David Cohn from Themis, Inc. is available on
line:
- Testing & Debugging Stored Procedures by David Cohn (Themis Inc.),
May 2002

IBM presentations from previous conferences are available on IBM DB2
for z/OS and OS/390 website:
- Major Optimization Enhancements in DB2 Version 8 by Gene Fuh (IBM
SVL), May 2003
- Achieving Higher Availability through Use of DB2 for z/OS Advanced
Features by Jeff Josten (IBM SVL), May 2003
- Sequential Value Generators in DB2 for z/OS Version 8 by Ramani
Croisettier (IBM SVL), May 2003
- DB2 Version 8 Schema Evolution Support by Craig Friske (IBM SVL),
May 2003
- DB2 UDB for z/OS Version 8 and Beyond by Fiona Gleeson (IBM SVL),
May 2003
- DB2-Java Performance ysis & Tuning Considerations by Maryela
Weihrauch (IBM SVL), May 2003
- Top 10 SQL Performance Myths by Terry Purcell (IBM SVL), mai 2003
- New Optimizer Performance Enhancements by James Guo (IBM SVL), May
2003
- ERP Performance & Availability Tips by Wiliam Favero (IBM SVL), May
2003
- DB2 Version 8 Major Indexing Enhancements by Mike Shadduck (IBM
SVL), May 2003
- DB2 Version 8 Major Migration Considerations by Jay Yothers (IBM
SVL), May 2003
- Using Websphere MQ from DB2 Applications by Connie Nelin (IBM SVL),
May 2003
- DB2 Verson 8: SQL & Networking Enhancements by Curt Cotner (IBM
SVL), May 2003
- DB2 Verson 8: Performance, Availability & Data Sharing by John
Campbell (IBM SVL), May 2003
- DB2 Version 8 SQL/XML & Materialized Query Tables by Guogen Zhang
(IBM SVL), May 2003
- DB2 Version 7 & 8 Unicode Support by Chris Crone (IBM SVL), May
2003
- DB2: Ready to Scroll with Cursors by Kalpana Shyam (IBM SVL), May
2003
- What does the Future for EDM Pool by Frank Bower (IBM SVL), May
2003
- DB2 Version 8 & Beyond tion by Jaime Anaya (IBM SVL), May
2003
- DB2 for z/OS is getting SMARTer (Past, Present, Future) by Jim Teng
(IBM SVL), May 2003

- DB2 for z/OS: Enabling eBusiness On Demand by Tom Rosamilia (IBM
SVL), March 2003

- DB2 UDB for z/OS, Version 8: Key points by IBM, 2003

- Real Time Statistics - Real Time Use! by Bruce Fuller (EBSCO) and
Randy Ebersole (IBM SVL), October 2002
- DB2 for z/OS: Technology Highlights by Roger Miller (IBM SVL),
October 2002
- Hot Topics in Network Computing in DB2 for z/OS by Peggy Abelite
(IBM SVL), October 2002

- DB2 UDB for z/OS Utility Work Ahead by Jim Ruddy (IBM SVL),
September 2002
- Optimization Service Center by Gene Fuh (IBM SVL), septembre 2002
- New Enhancements for DB2 Star Join Optimization by Gene Fuh (IBM
SVL), September 2002
- Monitoring and Tuning DB2 for z/OS for Improved Performance (Part 1
& 2) by Gopal Krishan (IBM SVL), September 2002
- Getting Started with DB2 XML Extender by Susan Malaika (IBM SVL),
September 2002
- Challenging Complex Join: Solutions by DB2 for z/OS and OS/390 par
Yoichi Tsuji (IBM SVL), September 2002
- Designing Star Schema Data Warehouses in DB2 for z/OS and OS/390 V7
by Guogen Zhang (IBM SVL), September 2002
- Intoduction to DB2 for z/OS and OS390 Capacity Planning for Basic
SQL by Akira Shibamiya (IBM SVL), September 2002
- Understanding DB2 OS/390 Query Parallelism - Current Architecture
and Future Directions by Fen-Ling Lin (IBM SVL), September 2002
- Real Time Statistics to Assist a DBA managing DB2 by Jim Teng (IBM
SVL), September 2002
- DB2 for z/OS and OS/390 - Capacity Planning for Utility and
Advanced SQL by Akira Shibamiya (IBM SVL), September 2002
- DB2 for z/OS and OS/390 & Siebel - Happy Together by Casey Young
and Randy Ebersole (IBM SVL), September 2002
- How to Update Your DBA Skills to DB2 Version 7 by Casey Young (IBM
SVL), September 2002
- Archiving: Techniques and Considerations by Bryan Smith (IBM SVL),
September 2002
- The Good, the Bad and the Really Ugly - DSNZPARM by Willie Favero
(IBM SVL), September 2002
- Data Warehouse/BI Topics on DB2 for z/OS by Bryan Smith (IBM SVL),
September 2002

- DB2 for OS/390 Optimizer Statistics by Pat Bossman (IBM SVL),
October 2001

- Recent Availability Enhancements in DB2 for OS/390 by Jim Teng (IBM
SVL), March 2001



* DB2 versions and announcements
[url]http://db2usa.hypermart.net/eversion.htm[/url]

IBM announces DB2 UDB Server for z/OS Version 8:
01/28/03: DB2 UDB Server for z/OS, Version 8
01/28/03: DB2 Utilities for DB2 UDB Server for z/OS, Version 8

Take a look at Version 8 page on IBM's website.

Following doents describe Version 8 functions:
- What's new in version 8 (second edition) 46 pages
- DB2 Verson 8: SQL & Networking Enhancements by Curt Cotner (IBM
SVL), May 2003
- DB2 Verson 8: Performance, Availability & Data Sharing by John
Campbell (IBM SVL), May 2003



Regards,

DB2usa.


..