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

I update DB2USA website several times a month. I listed here the last modifications. You can find new DB2USA pages and new links available after every update.

If you use other links, just let me know: db2usa@multimania.com

Links about DB2
IBM announced software withdrawal: DB2 Version 4, DB2 Admininistration Tool Version 2 (that replaces Version 1.2) and DB2 OS/390 certification.

DB2 Today, IBM's DB2 newsletter: May 2000 and June 2000.

Technical papers about DB2
An article about XML published in DB2 Mag is available on line:
Plugging in XML by Harold Treat, DB2 Mag, Winter 1999

DB2 redbooks
Join the team to write a new redbook:
DB2 XML Extender, SW-L301

A new redpiece is available on line:
SG24-5945-00 2000-06-14 How to build Java Procedures: DB2 UDB Gets Wired with SQLJ & JDBC

DB2 conferences
Take a look at DB2 presentations of 1999 S390 North American Tour (IBM Roadmap):
DB2 Universal Database Server for OS/390 Versions 5 & 6 by Roger Miller (IBM)
DB2 Universal Database Family Technology by Roger Miller (IBM)
Migration to DB2 for OS/390 V5 and V6 by Roger Miller (IBM)
ERP with DB2 for OS/390: SAP and Peoplesoft by Roger Miller (IBM)
Why use DB2 and S/390 for Data Warehouse by Robert Catterall and Charles Lewis (IBM)
An Introduction to Web-Enabling DB2 for OS/390 by Robert Catterall and Charles Lewis (IBM)
Disk Storage and DB2 for OS/390 by Robert Catterall and Charles Lewis (IBM)

Links about DB2
Take a look at JDBC, SQLJ and APAR II2343 pages on IBM DB2 for OS/390 website.

Technical papers about DB2
Summer issue of DB2 Mag is available on line:
Demystifying "Optimizing for N Rows" by Bonnie Baker, DB2 Mag, Summer 2000.
Prefetch and Deferred Write in OS/390 by Robert Catterall, DB2 Mag, Summer 2000.

Two articles published in IBM Systems Journal are available on line:
Object persistence in object-oriented applications by Srinivasan/..., IBM Systems Journal, 1997
A Method for Online Reorganization of a Database by Sockut/..., IBM Systems Journal, 1997.

DB2 redbooks
A few tips in order to improve the reading of documents.

Two new redbooks are available on line:
SG24-5486-00 2000-05-16 DB2 UDB for OS/390 and Continuous Availability
SG24-5648-00 2000-05-26 Planning for a Migration of PeopleSoft 7.5 from Oracle/Unix to DB2 OS/390

Links about DB2
DB2USA website offers a search engine for DB2 information.
Specify a keyword and you will search on DB2USA website, IBM's DB2 Version 6, Version 5 and Version 4 books (Bookmanager format), IBM's redbooks, IBM's OS/390 APAR database and on DB2-L newsgroup.

Books (Bookmanager format) of last refresh of DB2 UDB for OS/390, Version 6 are available on IBM's website.

Wintercorp launches the Database Scalability Program 2000. Take a look at previous winners of the world's largest databases in 1997 and 1998.

Technical papers about DB2
Sharad Pande's article published in Enterprise Systems Journal is available on line:
DB2 V4: Recovery with level-ids by Sharad Pande, ESJ, March 1998.

Two articles of Linda Claussen (Claussen & Associates, Inc) about DB2 migration:
DB2 for OS/390 Version 5 Migration
DB2 for OS/390 Version 6 Migration

DB2 redbooks
A redbook about migration from Oracle to DB2 is available:
SG24-5478-00 1999-12-22 Converting from Oracle AIX to DB2 for OS/390

Links about DB2
RevealNet added a DB2 Tip of the Month page on his website.
BMC launched dbazine, an online portal for different DBMS including a page about DB2.
DB2 Migration's IBM website : technical papers and presentations.

Technical papers about DB2
Craig Mullins' articles published in Enterprise Systems Journal are available on line:
Data Warehousing Guidelines for DB2 by Craig Mullins, ESJ, May 2000.
High-Speed Transaction Recovery by Craig Mullins, ESJ, August 1998.

DB2 redbooks
A redpiece about Refresh of DB2 Version 6 is available on line:
SG24-6108-00 2000-05-11 DB2 UDB Server for OS/390 Version 6 Technical Update (redpiece)

DB2 conferences
Peggy Abelite's presentation about Stored Procedures:
What's Exciting about Stored Procedures by Peggy Abelite (IBM).

DB2/IMS et SQL/DS : Guide/Share Nordic conferences, Abo (Finlande) 23-25 May 2000.

Links about DB2
IBM announced a refresh of DB2 UDB for OS/390, Version 6 (French) with new functions and recommended maintenance level.

Technical papers about DB2
Yevich, Lawson and Associates (YL&A, Inc) launched DB2 Performance Journal in format .
First issue is available for free on line (registration)

Getting the most out of DB2 Parallelism by Susan Lawson, DB2 Perf. Journal, 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
New ways to influence SQL Access Paths by Michael Hannan, DB2 Perf. Journal, May 2000

DB2 redbooks
Join the team to write a new redbook:
VLDB Warehouse Scalability and Capacity Planning, LS-N200

An old redbook is still available on line:
SG24-4536-00 1995-09-29 CICS/ESA-DB2 Interface Guide

A new redpiece is available on line:
SG24-5759-00 2000-05-01 DB2 UDB for OS/390 Version 6 Management Tools Package

DB2 versions and announcements
Former DB2 announcements are now located in this page. IBM Canada translated abstracts in French.

Gernot Ruban displays new features of every DB2 version (in German) on his website.

Links about DB2
IBM announced DB2 UDB Server for OS/390, version 7.
PDF document : What's new in version 7 is available on IBM's site.

DB2 Today, IBM's DB2 newsletter: April 2000.

Technical papers about DB2
Sheryl Larsen's articles published in DB2 Mag are available on line:
Powerful SQL: Beyond the Basics by Sheryl Larsen, DB2 Mag, Winter 1996.
A Hidden Secret of DB2 version 4 by Sheryl Larsen, DB2 Mag, Spring 1997.

DB2 conferences
Four sections of Gabrielle Wiorkowski's courses (Gabrielle and Associates) are available:
Index Usage for Performance
Programming for Performance
Sort and List Prefetch
Runstats and Reorganization

Links about DB2
A new Webpage provides information about Stored Procedures on IBM's site.

Technical papers about DB2
Bonnie Baker's articles published in DB2 Mag are available on line:
The Woes of Commitment by Bonnie Baker, DB2 Mag, Fall 1998.
Leveraging the SQLCA by Bonnie Baker, DB2 Mag, Summer 1998.
The Myths of the Clusterratio by Bonnie Baker, DB2 Mag, Winter 1997.

Two articles published in BMC's Tech News about hidden Optimizer tables:
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.

State of Utah 's DB2 standards are available on line.

DB2 conferences
Frank Ingrassia's presentation (with speaker notes) about hidden Optimizer tables (IMSI) :
The eX-File: MVS Explain (the truth is out there)


Archives : back issues before Tuesday, April 4th 2000


Your comments : db2usa@multimania.com
aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa