Version française

DB2USA: DB2 for OS/390 links by a Frenchman in the United States

DB2 conferences focus on hot DB2 topics. Two main organizations are IDUG and IBM. I listed a selection of sessions available on line. Conference proceedings on CD-ROM and audiotape cassettes from most of the technical presentations can be ordered through IDUG.


Contents
DB2USA updates

Second year

Back issues
Headlines
Links about DB2
Technical papers
Bookmanager
Newsgroup and FAQ
Redbooks
Conferences
Versions

News
Documentation
Hints and tips
IBM
Users groups
Homepages
Books
Training
More DB2 links

Around DB2
MVS world (OS/390)
Databases theory
DBMS hall of the fame



















































































































































































DB2 conferences updated on 01/22/01

Upcoming conferences

Share 96 North American: Long Beach, CA (USA) 25 February - 2 March 2001.
IDUG 13th North American conference: presentations agenda: Orlando (USA) 13-17 May 2001.
Share 97 North American: Minneapolis, MN (USA) 22 - 27 July 2001.
DB2 and Business Intelligence: IBM technical conferences, Orlando (USA) 1-5 October 2001.
IDUG 10th European conference: Florence (Italy) 8-11 October 2001.

Presentations available on line

PDF format download Acrobat Reader from Adobe.
Freelance format download Freelance Mobile Screen Show Player from Lotus.
Powerpoint format download Powerpoint Viewer 97 from Microsoft.
Real Player format download Real Player from Real.
Winzip utility download evaluation version from
Winzip.

Optimization

Design
Programming for Performance by Gabrielle Wiorkowski (Gabrielle and Associates) PDF format
Design Guidelines for Large Scale Batch by Jürgen Glag, IDUG 11th North American PDF format

Access path
DB2 Access Paths by the Numbers - Part 1 by Chuck Hoover (Compuware) PDF format
DB2 Access Paths by the Numbers - Part 2 by Chuck Hoover (Compuware) PDF format
The eX-File: MVS Explain (the truth is out there) by Frank Ingrassia (IMSI) Powerpoint format

Index, prefetch and sort
Index Tuning by Rob Lenzie (Cognito) Powerpoint format
Sort and List Prefetch by Gabrielle Wiorkowski (Gabrielle and Associates) PDF format
Index Usage for Performance by Gabrielle Wiorkowski (Gabrielle and Associates) PDF format

Monitoring
Insert Performance Considerations in DB2 for OS/390, Part 1 by Akira Shibamiya (IBM SVL) PDF format
Insert Performance Considerations in DB2 for OS/390, Part 2 by Akira Shibamiya (IBM SVL) PDF format
DB2 Tracing as a Last Resort by Chuck Hoover (Compuware) PDF format
DB2 System Performance Metrics Revisited, by Joel Goldstein (Responsive System)
DB2 UDB for OS/390 Performance - The Basics by Joel Goldstein (Responsive System)
Activité et Performance DB2 by J. Prevot (Aerospatiale), French Guide DB2B

Utiltaires

DB2 Utilities - As Good As It Gets by Sandra Smith (Hewitt Associates) PDF format
Runstats and Reorganization by Gabrielle Wiorkowski (Gabrielle and Associates) PDF format
Lessons learned in Utility Management by Jürgen Glag, IDUG 8th European PDF format

Recovery and Restart

-DB2 V6 Disaster Recovery by the Book..and Then Some by Judy Ruby-Brown (IBM Dallas Center) PDF format

Data Sharing, Sysplex and System Availability

DB2 Data Sharing Performance from Soup to Nuts - Part 1 by Robert Catterall (Check Free Corporation) PDF format
DB2 Data Sharing Performance from Soup to Nuts - Part 2 by Robert Catterall (Check Free Corporation) PDF format
Data Sharing Implications of an Internal Coupling Facility (ICF) by Judy Ruby-Brown (IBM Dallas Center) PDF format
What's New for DB2 Data Sharing - A Technical Update by John Campbell (IBM SVL) PDF format
DB2 Data Sharing: Predictive Performance Methods by David Beulke (Pragmatic Solutions) PDF format
DB2 Data Sharing Performances issues by David Beulke (Pragmatic Solutions) PDF format

New features in Version 5

Les LOBs (Large OBjects) : premiers pas by Eric Amiel (Infotel) PDF format
Large Tablespace : paramètre Piecesize by Yasmine Monpou (GMF)

New features in Version 6

What's New in DB2 Version 6 - Recent Enhancements by Roger Miller (IBM SVL) PDF format
DB2 Universal Database Server for OS/390 Versions 5 & 6 by Roger Miller (IBM) PDF format
DB2 Universal Database Family Technology by Roger Miller (IBM) PDF format
DB2 UDB for OS/390 Technical Highlights and Trends by Roger Miller, IBM Silicon Valley Lab Real Player format
Are You having An Identity Crisis ? DB2 ID columns Can Help! by Julian Stuhler (Triton Consulting) Powerpoint format
DB2 for OS/390 V6 - Recent Enhancements by Sarah Ellis (IBM) Freelance format
Migration to DB2 for OS/390 V5 and V6 by Roger Miller (IBM) PDF format
DB2 für OS390: Präparieren Sie Ihre Anwendungen für Version 6 Datenzentrale Baden-Württemberg in German
DB2 for OS390 Version 6 IBM Korea, in Korean PDF format

New features in Version 7

Migration to DB2 for OS/390 Version 6 and Version 7 by Roger Miller (IBM SVL) PDF format
DB2 Version 7 - Migration considerations from V5 to V6 by Roger Miller and Thomas Beyer, December 2000
DB2 for OS/390 V7 by Sarah Ellis (IBM) Freelance format

Buffer Pool, I/O and Virtual Storage

The Lowdown on DB2 and Storage by Robert Catterall (Check Free Corporation) PDF format
DB2 UDB for OS/390: Virtual Storage Management (Y2G by John Campbell (IBM SVL) PDF format
Performance Miracles via DASD I/O Activity Tuning by Ivan Gelb (GIS) PDF format
Buffer Pools and DASD Analysis and Tuning by Joel Goldstein (Responsive Systems) PDF format
Disk Storage and DB2 for OS/390 by Robert Catterall and Charles Lewis (IBM) PDF format

Stored procedures, Java, JDBC, SQLJ and Web enabling

Getting Started with Java and DB2 for OS/390 by Christopher Farrar (IBM SVL) PDF format
Getting Connected to DB2 for OS/390 by Hugh Smith (IBM SVL) PDF format
Web Based Applications Using DB2 For OS/390 Version 6.1 - User Experiences by Robert Perih (Salomon Smith Barney's) PDF format
Understanding DB2 for OS/390 Stored Procedures Support (Long) by Hugh Smith (IBM SVL) PDF format
Update Web Enabling Your DB2 Data and Business Logic Using Net.Data by Mel Zimowski (IBM SVL) PDF format
Java, EJB and DB2 for OS/390 by Curt Cotner, IBM Silicon Valley Lab Real Player format
Java Stored Procedures for DB2 for OS/390 by Julian Stuhler (Triton Consulting) Powerpoint format
What's Exciting about Stored Procedures by Peggy Abelite (IBM).
DB2 and Internet by David Beulke (Pragmatic Solutions) PDF format
Accès Web to Host DB2 by P. Arne (GIE Loricam), French Guide DB2B
An Introduction to Web-Enabling DB2 for OS/390 by Robert Catterall and Charles Lewis (IBM) PDF format

Data Warehouse

Why use DB2 and S/390 for Data Warehouse by Robert Catterall and Charles Lewis (IBM) PDF format
Data Warehouse by Carrefour Promodès group, French Guide DB2A
DB2 Datawarehouse Performance by David Beulke (Pragmatic Solutions) PDF format
What is a Data Warehouse ? : conference on line sample.

ERP

Performance of DB2 UDB for OS/390 as a Database Server for SAP R/3 by John Campbell (IBM SVL) PDF format
ERP with DB2 for OS/390: SAP and Peoplesoft by Roger Miller (IBM) PDF format

Other subjects

Introduction to DB2 for OS/390 by Catherine Cox (IBM SVL) PDF format
44 DB2 Tips in 60 Minutes by Craig Mullins (BMC Software) PDF format
Introduction to TCP/IP for DB2 DBAs and DB2 System Administrators - A Tutorial by Hugh Smith (IBM SVL) PDF format
Using DB2 Control Center to Manage and Control Your DB2 Subsystems by Peggy Rader (IBM SVL) PDF format
What's New for DB2 UDB for OS/390 by Roger Miller (IBM SVL) PDF format
What's New in the DB2 Family by Roger Miller (IBM SVL) PDF format
What's New with IBM DB2 DataJoiner by Mike De Santis (IBM SVL) PDF format
DBA to eDBA: Internet-Age DBA Skills by Craig Mullins (BMC Software) PDF format
44 tips in 66 minutes by Craig Mullins Powerpoint format
Efficient Implementation of Historical Data in DB2, Revisited par Jürgen Glag, Guide Switzerland PDF format
IBM DB2 Developer Panel Discussion moderated by Roger Miller with developers:
Curt Cotner, Chris Munson, Judy Rudy-Brown, Jim Ruddy and Hong Tie from Silicon Valley Lab Real Player format
Presentations and technical material from DB2 Working group of UK guide. Winzip utility Powerpoint format Freelance format
DB2 technical conferences on line : sessions with voice and slides (subscription).

Previous conferences (presentation list)

IDUG 6th Asia Pacific conference: presentations : Melbourne (Australia) 15-17 November 2000.
Technical Symposium 5th IDUG presentations:Toronto (Canada) 6-7 November 2000.
IDUG 9th European conference presentations: Geneva (Switzerland) 23-26 October 2000.
DB2 and Business Intelligence: IBM technical conferences, Las Vegas (USA) 16-20 October 2000.
DB2/IMS and SQL/DS: Guide/Share Nordic conferences, Abo (Finlande) 23-25 May 2000.
IDUG 12th North American conference: Dallas (USA) 14-18 May 2000.
DB2 and IMS: IBM technical conferences, Barcelona (Spain) 20-24 March 2000.
IBM Technical Conference: Sydney (Australia) 13-15 March 2000.
IDUG 5th Asia Pacific conference: Sydney (Australia) 16-18 November 1999.
IDUG 8th European conference : Nice (France) 18-22 October 1999.
Technical Symposium 4th IDUG: Toronto (Canada) 23-24 September 1999.
DB2 and Data Warehouse: IBM technical conferences, New Orleans (USA) 13-17 September 1999.
IDUG 11th North American conference: Orlando (USA) 16-20 May 1999.
DB2 and IMS: IBM technical conferences, Disneyland Paris (France) 12-16 April 1999.
DB2 and Data Warehouse: IBM technical conferences, San Antonio,TX 5-9 October 1998.
IDUG 4th Asia Pacific conference: Sydney (Australia) 18-20 November 1998.
IDUG 7th European conference: Amsterdam (The Netherlands) 19-23 October 1998.
IDUG 10th North American conference: San Francisco (USA) 10-14 May 1998.


Your comments : db2usa@multimania.com
adaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa