450
links about DB2 (Relational DBMS for IBM
mainframes) updated on 12/20/00
IBM broadcasts an
e-seminar named Siebel
eBusiness Solutions and DB2 for OS/390  (free registration)  
with Ken Llacera, Director Product marketing, IBM
products. 
Read IBM DB2 Tools
manuals available on
IBM website.
DB2USA celebrates its second year online. 400+
links about DB2 for OS/390 available and 50,000+
hits from 48 different countries. French Forum
DB2 pour OS/390 started on February 2000
contains 200+ messages written by 50 different
users and was accessed 2,500+ times.
Take a look at
DB2 messages
and from others products on Chicago Soft's
website.
Read a French description
of DB2 for OS/390 on
Host on Line's
website.
Online DB2
for OS/390 V6 Catalog poster is
available on Computer
Associates website.
New poll available on Headlines
page: Do you use DB2 packages in
production ?
Poll results: Do
you use Data Sharing in production ? (total
votes: 169).
Poll results:
Which DB2 version do you use in production ?
(total votes: 188).
We'll ask again this question in 2001.
DB2 for
OS/390 Version 7 Database Administration
Certification is
available.
To be certified Solution Expert Database
Adminstration for OS/390, you have to succeed two
exams:
- DB2 UDB
Fundamentals (version 5 or version 6 or version 7) :
DB2 family
- DB2 UDB V7 Database Administration for OS/390
Try to answer
34 questions of
sample test from IBM Professional Certification
website.
Testing will
be available (free registration) during IDUG 9th
European conference:
Geneva (Switzerland) 23-26 October 2000.
IBM
broadcasted an e-seminar named New DB2
OS/390 Data Management Tools
(free registration) on Friday,
September 27th 2000 with Dan Wardman and David Schwartz
of IBM.
IBM
changed the policy. Now, you need to register to
read redbooks online. Click here.
Without
access to Internet, you can search the DB2-L
newsgroup archives and the Web.
DB2-L newsgroup: send an email to listserv@ryci.com
with a command in the body of your message.
Search the archives: SEARCH xxxx in DB2-L (xxxx
is your criteria). You will receive a list of
messages matching your criteria. Order individual
message: GETPOST DB2-L nnnn (nnnn is the message
number requested). For more information, read
DB2-L FAQ.
DB2USA or other website: send an email to www@web2mail.com
with the web page you want as the subject of the
message. You will receive the HTML page requested
as an attached file.
Click on the following examples: Headlines or IBM
DB2 OS/390 homepage .
For more information, read Using
web2mail by email.
Wintercorp launches the Database
Scalability Program 2000. Take a look at previous
winners of the world's largest databases in 1997 and 1998.
A new Webpage
provides information about Stored
Procedures on IBM's
site.
Former DB2 announcements are located in page DB2
version and anouncements.
DB2 Today,
IBM's DB2 newsletter: August 2000, September
2000 
Central
Canada DB2 Users group's DB2 news
and announcements
IBM's
DB2 news
IBM's
data management news
NewsNow's
DB2 news search engine
Info World
Electric's DB2 news
search engine
Tech Web de
CMPnet's DB2 news
search engine
Database
Programming and Design : find DB2
Redbooks are
designed and published by IBM's International
Technical Support Organization (ITSO).
This is the result of intensive work efforts from
IBMers, business partners and customers. The
website redbooks.ibm.com
gives you the opportunity to view the books on
line (PDF format) or to order CD-Roms and
hardcopies.
SAS/ACCESS
with DB2: on line documentation.
Chapter one
(The Magic Words) and appendix
from Craig Mullins's book: DB2 Developer's Guide,
Third Edition, table
of contents.
DB2 Migration: technical
papers and presentations
(IBM).
Migrating an
application from Oracle to DB2 for MVS/ESA
by Marina Greenstein.
Migrating a
DB2/6000 database application to DB2/MVS from
redbook GG24-4473-00
Porting an
AIX DB2 application to OS/390 by
Donohue/Clarke/Keegan/Nugent
Gabrielle Wiorkowski: Index usage , Programming , Runstats and
Reorg
DB2 : version 6 version 5 version 4 ( and
Bookmanager formats)
DB2 Redbooks
from IBM's International Technical Support
Organisation
IBM
documentation on line (Bookmanager)
DB2 version 4
course by Chuck Anesi
Some
technical papers and tips from sites :
Xephon, DB2 Mag, IDUG, CITL, UK Guide, IBM, PLATINUM, BMC .
Don't forget to browse IBM DB2 V5
documentation including
chapters from Administration Guide :
- "Tuning
your queries", "Maintaining
Statistics in the Catalog", "Using
EXPLAIN to improve SQL performance"
Data Sharing
: Hints and tips: IBM page.
Advice and
technical tips from CITL.
Hints and
tips from DB2 Working group of UK Guide
Platinum
database tips: choose DB2
OS/390
DB2 Tip of
the Month: RevealNet.
Hints and
Tips: DB2
Performance Journal.
A few
newsgroups about DB2 exist on the Web (see
below). I didn't find any French forum dedicated
to DB2. This is the reason why I give you the
opportunity to access Forum DB2.
Available only through Internet, no registration
is required. Everything about DB2 for OS/390 in
French is welcome.
IBM : DB2 Universal
database for OS/390
Find an
IBM employee's email address
Find
products and tools for DB2 listed by IBM.
DB2
conferences focus on hot DB2 topics. Two main
organizations are IDUG and IBM. I listed a
selection of sessions from 10th annual North
American IDUG conference. Conference proceedings
on CD-ROM and audiotape cassettes from most of
the technical presentations can be ordered
through IDUG.
IDUG: Regional User
Groups
Guide: United States, Europe, United
Kingdom, France (DB2A
group , DB2B
group)
Share: United States
QDUG:
Québec DB2 Users Guide from Canada.
Ron Rabe
Joe Geller
Craig Mullins
Arnoud
Morsink
Gernot Ruban
Sharad Pande
Michel Lerma
DB2usa
IBM updates
DB2 software several times a year and adds new
functions. I listed DB2 announcements from IBM in
this page. IBM Canada translated abstracts in French .
Gernot Ruban displays new features
of every DB2 version (in German)
on his website. More information available in
"Release Guide" Version 5 (format: HTML.)
and Version 6 (format: PDF and
HTML.).
Books
recommended by Capedug,
South Africa's Users group
IBM's
selection on Computer Literacy website
IBM : United States, France
IBM DB2 UDB V5 certification samples : Fundamentals , Development, DBA , DRDA
Dunham
Software's links
dbLinks 's
links
Database
Central 's links
dbazine: an
online portal for different DBMS including a page
about DB2.
The Source
Net's DB2
resources page
MVS
world (OS/390)
IBM
documentation about OS/390
IBM documentation about COBOL
Thierry
Falissard's MVS
homepage
Cheryl Watson 's
MVS website (Watsonwalker)
A few OS/390
tools and toys :
programs and tools written by Doug Nadel.
Databases
theory
Analyse de
l'incorporation de l'objet-relationnel dans DB2 by
Hendrickx and Ketelslegers.
Joe Celko
wrote the SQL for
Smarties column in
DBMS magazine.
Teradata
review : magazine
about Teradata RDBMS and Data Warehouse: archives
Chapter one
(Day1 - What Can DB2 Do For You?) and appendix
from Susan Visser's book: Teach Yourself DB2
Universal Database in 21 days, table of
contents .
TDAN :
Data Admistration newsletter and archives .
ACM
Transactions on Database Systems publications
William Kent 's
articles about relational databases
PRISM
INRIA's Rodin
project was canceled and replaced by Caravel
Relational
Model course by Chris Date at UCLA
System R
Database Jump
site : websites
of DBMS.
VLDB :
Largest Database size in the World.
The Case of
the surrogate key by Mike
Lonigro, DPBD
May 1998.
DBMS
hall of the fame
Georges
Gardarin
Patrick
Valduriez
Your comments : db2usa@multimania.com
|
