Bonnie Baker's New Class to Central PA - 'New SQL and Program Design Rules under V8 & V9' - November 29th

Lori A Galluzzo

Bonnie Baker's New Class to Central PA - 'New SQL and Program Design Rules under V8 & V9' - November 29th

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.
Topics:
* 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 : Class is limited to 36 to attend. Sign up soon!
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. Sign up soon!
Thanks!

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