|
Officers
Meeting Schedule
Meeting Minutes
Membership
Links of interest
DB2 Trivia
Hot Tips
Home |
Meeting at State Auto (Map)
| 1:00-1:15 |
Business Meeting. Meeting dates for 2000. Treasurer Report. |
| 1:15-2:45 |
Presentation: New Function APARs for Application DBAs and Developers.
by Gabrielle Wiorkowski of Gabrielle & Associates
Abstract |
| 2:45-3:00 |
Break - Coffee, cookies, and pop will be served. |
| 3:00-4:15 |
Presentation: DB2 Recovery Scenarios
by Randy Ebersole of Computer Associates (formerly Platinum)
Abstract |
| 4:15-4:30 |
What's new at IBM
by Phyllis Groezinger of IBM Santa Teresa |
|
|
Many new features and facilities have been introduced into DB2 for OS/390 V5 through
new function APARs from V6. This presentation will concentrate on those functions
particularly useful for application design and development including:
- Outer Joins and Local Predicates
- SQL Data Manipulation Enhancements
- Subselects That Can Return a Few of Many Rows
- SQL Data Definition Enhancements
- REBUILD and RECOVER INDEX
- REORG Unload External and REORG Discard
- Deleting Rows During a Reorganization
- Executing Utilities from a Stored Procedure
- Overall Enhancements with V5 APAR
About the Speaker - Gabrielle Wiorkowski
Gabrielle Wiorkowski is a senior DB2 consultant, founder of Gabrielle & Associates and
affiliated with Codd & Date International. She has worked for IBM as an Advisory
Systems Engineer specializing in DB2 and has contributed significantly to the design and
development of over 25 application systems on DB2 since 1984. She has consulted for a
number of companies including EDS, AT&T, Exxon, US LIFE Systems, Corp., Hogan Systems,
Morgan Guarantee Trust, Citibank, and is an IBM Gold Consultant. She has been the
president of DB2 Forum since 1988, the Southwest users group with a membership of over 100
DB2 professionals. She has lectured widely on DB2 to over 14,000 professionals in 27
countries on 6 continents, authored a 985 page book "DB2 for OS/390 Development for
Performance" (ISBN 0-9668460-0-1), the book "DB2: Design and Development
Guide" published by Addison-Wesley in three editions, over two dozen articles, and
1700 pages of seminar material available on the Web site http://www.GabrielleDB2.com.
With the growing amount of business data being stored on the mainframe, DB2 recovery
planning is becoming a significant challenge. Business requirements need to be
considered when implementing an effective recovery plan. From a single tablespace or index
to an entire DB2 subsystem, a comprehensive plan must be in place for all recovery
scenarios. This presentation will discuss the technical issues of DB2 recovery, and
provide suggestions to properly prepare for different recovery scenarios.
About the Speaker - Randy Ebersole
Randy Ebersole has more than 14 years in the Information Systems area. His extensive
experience in DB2 began in 1985 and includes such roles as Lead Database Designer,
Senior Database Administrator and DB2 Performance Specialist. Randy has been in
involved in the design of more than 100 DB2 applications. Supporting large
production environments has provided opportunities to deal with many performance and
recovery issues. As a DB2 Technical Specialist with Computer Associates, Randy
has gained an additional wealth of knowledge working with more than 1000 DB2 sites around
the world. Contact information Computer Associates International, Inc.
(800)-442-6861, e-mail ebersole@platinum.com
|
