NOTE : Class size has been increased - up to 120 allowed.
You can still sign up right up to the day of the session
> WHO : Bonnie Baker in Harrisburg
> WHEN : November 29th, 8am - 4pm
> WHERE: Giant Super Food's store community room, Camphill, PA,
> 17011 - same location as RUG meeting November 28th (She will be doing
> a mini-session of this class at the RUG meeting as well).
> WHAT : New SQL and Program Design Rules under V8 & V9
> - ABSTRACT :
> If you learned how to design DB2 applications systems, code
> programs, and write SQL awhile ago, then you might be interested in
> how things have changed. This is not your father's DB2 anymore.
> Techniques that can be used to design for high performance have
> changed dramatically in the last few years. Many of yesterday's issues
> no longer exist, and new issues need to be addressed. Our old way of
> thinking needs to be examined and updated for today's version of DB2.
> This seminar is designed to do just that. We will look at old
> standards and learn why they needed to be eliminated or modified. And
> we will examine the newer features and functionality of today's DB2
> and create new standards. Included are new issues involving multi-row
> processing, data integrity, and commit frequency. Other topics are
> partitioning design, index revision, SQL tricks, and many other topics
> to help you maximize performance without compromising integrity and
> without increasing CPU overhead.
> * Bind / Rebind Input
> * Bind Vs. Rebind
> * Rebinds Before and in V8
> * Painless Rebinds
> * Minimal Effort Rebinds
> * Design Change Rebinds
> * Release Incompatibilities
> * VARCHAR Issues
> * SYSIBM.SYSDUMMY1 usage
> * Partitioning Methods (PI's, DPSI's, & NPSI's)
> * Insert Within Select
> * Multiple-Row Insert And Fetch Statements
> * Rowset-Positioned Updates And Deletes
> * Get Diagnostics Statement
> * Dynamic Scroll Cursors
> Plus lots of information about the new cursors and locking integrity
> issues. Also included is a review of V9 issues that will impact
> program design.
> Platform: z/OS
> WHO MUCH : The cost is $165. Checks payable to 'Bonnie Baker',
> cash or billing information from their company (she can send an
> invoice to them after the class for payment). Breakfast, Lunch and
> beverages will be graciously covered by Bonnie for the days event.
> HOW MANY : Moved to the large room in the community center - up
> to 120 allowed.
> HOW TO SIGN UP : Email, call or send check payable to 'Bonnie
> Baker' to 'Lori Galluzzo, MS:E80, 225 Grandview Avenue, Camphill, PA
> 17011'. If paying by cash that day or billing information, Email or
> call to be put on the attendee sheet.
> Any questions or concerns, let me know.
> Lori Ann Galluzzo
> IBM DB2 V8.1 Certified Specialist & Solutions Expert
> EDS - Healthcare - Metavance Product ADU
> ( phone: +01-717-975-5482 (8-428) )
> + mailto:[login to unmask email]
> cell : 717-215-0587
Welcome to the DB2 User Group - Central Pennsylvania list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/DB2-UG-Central-PA.html. From that page select "Join or Leave the list". The IDUG Listserv FAQ is at http://www.idugdb2-l.org. The DB2 User Group - Central PA List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm