DB2USA
back issues updated on 01/22/01
| Wednesday,
December 20th 2000 |
 Links
about DB2
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.
Take a look at The Source
Net's DB2
resources page.
Technical
papers about DB2
Craig Mullins' article
published in DB2 Update is
available on line:
Using
Timestamp columns versus Date and Time columns
by Craig Mullins, DB2 Update, December 2000.
Read DB2
Standards for Indiana University.
DB2
newsgroups and FAQ
Take
a look at:
- DB2
FAQ of the University of Iowa.
- DB2
FAQ on SAS/Access from
SAS Technical Support.
DB2
redbooks
Join the team
to write a new redbook:
e-business
with DB2 for OS/390, SW-M413
A new redbook
is available on line:
SG24-5953-00 2000-09-06 Siebel 2000 Database Implementation
on OS/390 using NT Siebel Servers
and HTML.
Read redbooks available on CD-ROM right now on
the Web in HTML format:
- S/390
Redbooks Collections bookshelves Discs 1 and 2
- Dabatase
Redbooks bookshelf
Take a look at Light Year
Consulting's DB2
redbooks page.
DB2
conferences
Forty DB2 presentations
available on line are now
sorted by subject. 
A DB2 version 7 presentation is available on Light Year
Consulting website:
DB2 Version 7
- Migration considerations from V5 to V6
by Roger Miller and Thomas Beyer, December 2000
Audio version
available until December 21st 2000.
Session descriptions of IDUG
13th North American conference:
Orlando (USA) 13-17 May 2001 are available on
line.
You can plan your own DB2 for
OS/390 presentations agenda
preventing conflicting sessions.
Upcoming
Share conferences :
Share 96
North American: Long Beach, CA
(USA) 25 February - 2 March 2001.
Share 97
North American: Minneapolis, MN
(USA) 22 - 27 July 2001.
| Monday,
November 27th 2000 |
DB2USA's
second year
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.
Links
about DB2
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.
Technical
papers about DB2
Two articles published in DB2 Mag are
available on line:
- Group Buffer
Pool Tuning by
Robert Catterall, DB2 Mag, Winter 1997.
- Tuning ERPs
for DB2 by
Susan Lawson and Richard Yevich, DB2 Mag, Summer
1999.
Read list of DB2 articles of
Craig Mullins.
DB2
conferences
Take a look at
Craig Mullins' presentation
available on Reveal Net's website:
44
tips in 66 minutes by Craig Mullins 
Take a look at
a German presentation
available on Datenzentrale
Baden-Württemberg's website:
DB2
für OS390: Präparieren Sie Ihre Anwendungen
für Version 6
Take a look at a Korean presentation
available on
IBM Korea's website:
DB2
for OS390 Version 6
| Tuesday,
November 14th 2000 |
Technical
papers about DB2
Winter issue of DB2 Mag
is available on line:
- DDF vs CICS
by Robert Catterall, DB2 Mag, Winter 2000.
- Predicate
Evaluation: Part I
by Bonnie Baker, DB2 Mag, Winter 2000.
November issue
of Enterprise Systems Journal includes the
following articles:
- Proactive
Data: DB2 Triggers
by Willie Favero, ESJ, November 2000.
- Of Java and
DB2: Using Java Database Connectivity and SQLJ
by Lou Marco, ESJ, November 2000.
Craig Mullins' article published in DB2
Update is available on line:
- Using Java
with DB2 for OS/390
by Craig Mullins, DB2 Update, November 2000.
Two articles published in BMC's Tech
News are available on line:
- 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.
DB2
conferences
Upcoming DB2
conference:
- IDUG 10th
European conference:
Florence (Italy) 8-11 October 2001.
Take a look at
Jürgen Glag's DB2
presentations,
author of book "Efficient Software
Development with DB2 for OS/390"
- Efficient
Implementation of Historical Data in DB2,
Revisited
par Jürgen Glag, Guide Switzerland
- Lessons
learned in Utility Management by Jürgen Glag, IDUG
8th European
- Design
Guidelines for Large Scale Batch by Jürgen Glag, IDUG
11th North American
| Monday,
October 14th 2000 |
Links
about DB2
Online DB2
for OS/390 V6 Catalog poster is
available on Computer
Associates's website.
New poll: Do you 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 next year.
Technical
papers about DB2
Two articles written by
Martin Hubel are available on Responsive
Systems's website:
- It's Time to
Re-Think Your DB2 Buffer Pool Strategy
by Martin Hubel, Martin Hubel Consulting Inc.
- Tuning
PeopleSoft Applications for DB2 OS/390 by
Martin Hubel, Martin Hubel Consulting Inc.
Read Boscov's DB2 Stored
Procedures standards 
DB2
newsgroups and FAQ
Take
a look at Diskussions
Forum (in
German).
DB2
conferences
Upcoming DB2
conferences:
IDUG 9th
European conference presentations:
Geneva (Switzerland) 23-26 October 2000.
Technical
Symposium 5th IDUG presentations:Toronto
(Canada) 6-7 November 2000.
IDUG 6th Asia
Pacific conference presentations:
Melbourne (Australia) 15-17 November 2000.
IDUG
13th North American conference:
Orlando (USA) 13-17 May 2001.
DB2 and
Business Intelligence:
IBM technical conferences, Orlando (USA) 1-5
October 2001.
Read presentation list of IDUG previous
conferences between 1998
and 2000.
| Saturday,
October 7th 2000 |
Links
about DB2
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
Are you ready
? Try to answer 34 questions of
sample test from IBM Professional Certification
website.
Testing will
be available during the following conferences
(free registration):
- DB2 and
Business Intelligence:
IBM technical conferences, Las Vegas (USA) 16-20
October 2000.
- IDUG 9th
European conference:
Geneva (Switzerland) 23-26 October 2000.
DB2
Today, IBM's DB2
newsletter: September
2000
Technical
papers about DB2
Three articles written by
Bryan Smith, Kathryn Zeidenstein, Bill Bireley,
Ted Blank and Steve Turnbaugh published in IDUG journal
are available on line:
- 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.
Daniel Kitay's article published in IDUG journal
is available on line:
- Performance
enhancements for SAP R/3 and DB2 by
Daniel Kitay, IDUG Journal, August 1997.
DB2
redbooks
Redpiece
"DB2 UDB Server for OS/390 Version 6
Technical Update" became
a redbook.
It describes the
changes introduced in DB2 UDB for OS/390 Version
6 until May 2000 refresh:
SG24-6108-02 2000-06-19 DB2 UDB Server for OS/390 Version 6
Technical Update
and HTML.
Redbook
"DB2 Server for OS/390 Version 5 Recent
Enhancements" describes additional functions until
September 1999 refresh:
SG24-5421-00 1999-09-27 DB2 Server for OS/390 Version 5
Recent Enhancements
and HTML.
DB2
versions and announcements
Folowing
documents describe in a few pages new functions
with illustration:
- What's new in
Version 7 in five
pages
- What's new in
Version 6 in seven
pages
- What's new in
Version 5 in three
pages
To receive an
email notice from IBM when Version 7
books are
available.
| Monday,
September 25th 2000 |
Links
about DB2
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.
Technical
papers about DB2
DB2 Update
issues from January 1998 to September 1998 are
available on line in format .
August
2000 issue of IDUG Journal
is available :
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
Managing DB2
Application Performance by
Martin Hubel, IDUG journal, August 2000.
Migrating to
DB2 for OS/390 - Version 6 and Version 7 by
Roger Miller, IDUG journal, August 2000.
DB2
conferences
Take a look at
DB2
presentations
from IDUG 12th North American (May
2000) after free
registration:
DB2
UDB for OS/390 Technical Highlights and Trends by Roger Miller, IBM
Silicon Valley Lab
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
Java,
EJB and DB2 for OS/390 by Curt Cotner, IBM
Silicon Valley Lab
| Tuesday,
September 12th 2000 |
Links
about DB2
IBM changed
the policy. Now, you need to register to read
redbooks online. Click here.
DB2
Today, IBM's DB2
newsletter: August
2000.
Technical
papers about DB2
Craig Mullins' articles
published in TDAN
are available on line:
Using
constraints to simulate domains
by Craig Mullins, TDAN, December 1998.
What's in a
name ? by Craig Mullins, TDAN,
March 1998.
Denormalization
guidelines by Craig
Mullins, TDAN, June 1997.
An article of Ed Woods published in Candle
Computer Report is available on
line:
Expanding the
Reach of DB2 through TCP/IP
by Ed Woods, Candle Report, February 1999.
DB2
redbooks
Redpiece
"How to build Java Procedures: DB2 UDB Gets
Wired with SQLJ & JDBC" became a redbook
named:
SG24-5945-00 2000-09-06 DB2 Java Stored Procedures Learning
by Example
A redbook
about administering SAP BW databases is available
on line:
SG24-5681-00 2000-07-14 SAP Business Information Warehouse
on OS/390
Newsgroups
and FAQ about DB2
Take a look at
IBM
Korea DB2 for OS/390 newsgroup (in Korean).
Links
about DB2
Take a look at DB2
availability summary page
on IBM DB2 for OS/390
website.
Technical
papers about DB2
Fall
issue of DB2 Mag is available on line:
Ready
For Anything by Gary Mordini,
DB2 Mag, Fall 2000.
Seventh
Heaven by Richard Yevich, DB2
Mag, Fall 2000.
Tuning
Data Sharing Performance
by Robert Catterall, DB2 Mag, Fall 2000.
Spatial
Perception in DB2 for OS/390
by Bonnie Baker, DB2 Mag, Fall 2000.
Three articles published
in Technical
Support Magazine are
available on line:
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.
RACF
and DB2 by M. Nelson, M. Jordan
and R. Miller, Technical Support, June 1998.
DB2
conferences
Take
a look at DB2
presentations
from French DB2A Guide (in French):
Les
LOBs (Large OBjects) : premiers pas by
Eric Amiel (Infotel)
Large
Tablespace : paramètre Piecesize by
Yasmine Monpou (GMF)
| Thursday,
August 3rd 2000 |
Links
about DB2
Poll results :
Which DB2 version do you use in production (total
votes: 188).
We'll do it again in six months.
New poll: Do you use Data Sharing in production ?
Session descriptions of
DB2 technical conferences are available on IBM
site:
DB2
and Business Intelligence:
IBM technical conferences, Las Vegas (USA) 16-20
October 2000.
DB2
redbooks
Join
the team to write a new redbook:
DB2
UDB Server for OS/390 Version 7 Performance
Topics, SW-M403
DB2
conferences
Take
a look at DB2
presentations
from UK guide (May 2000 meeting):
DB2
for OS/390 V6 - Recent Enhancements by
Sarah Ellis (IBM) 
DB2
for OS/390 V7 by Sarah
Ellis (IBM)
Index
Tuning by Rob
Lenzie (Cognito)
Java
Stored Procedures for DB2 for OS/390 by
Julian Stuhler (Triton Consulting)
Are
You having An Identity Crisis ? DB2 ID columns
Can Help! by Julian
Stuhler (Triton Consulting)
| Wednesday,
July 12th 2000 |
Links
about DB2
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.
DB2
Performance Journal (YL&A,
Inc) contains
a new section: Hints
and Tips.
Technical
papers about DB2
March
2000 issue of IDUG Journal
is available :
New
features in Version 6 by
Richard Yevich, IDUG journal, March 2000.
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.
Compress
this by Robert Omerza, IDUG
journal, March 2000.
Stored
Procedure Version Control in DB2 Version 6
by Ramesh Bala, IDUG journal, March 2000.
A new article of DB2
Performance Journal (YL&A,
Inc)
is available on line after free registration:
SQL
Filter Factor Formulas by Michal
Hannan, DB2 Perf. Journal, July 2000
DB2
conferences
Take
a look at two new DB2
presentations
on Responsive
Systems's
website:
Performance
Miracles via DASD I/O Activity Tuning par
Ivan Gelb (GIS)
Buffer
Pools and DASD Analysis and Tuning par
Joel Goldstein (Responsive Systems)
Archives
: back issues before Wednesday, July 12th 2000
Your comments : db2usa@multimania.com
aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
|
