WHAT:
WHEN: Friday,
May 9th 8:00 AM – 4:00 PM
WHERE:
Peter Kiewit Lodge
Interchange 426 from
Interstate 80
COST:
Registration fee is $200.00 per person.
Registrations must be
received by Wednesday, April 30th, 2008 to guarantee seating and class
materials.
NOTE:
AGENDA:
7:45 AM – Registration
8:15 AM – Announcements
8:20 AM – Seminar begins - V8/V9
Application/Database Challenges and Solutions
Noon – Break for lunch
4:00 PM –
Seminar adjourns
ATTIRE: Business casual
MESSAGES: During the meeting, messages may be left at
the Lodge main desk, (402) 944-2523.
Motels near
1.
Super 8, 14355
S. Hwy 31, Exit 432,
2.
Suburban Inn,
11023 Sapp
3.
Days Inn,
10560 Sapp
4.
Best Inn, Hwy
50 & I-80,
5.
Ben Franklin,
I-80 South 144 Street, Exit 440,
6.
Comfort Inn,
I-80 & Hwy 50, Exit 440,
7.
Ramada
Limited, I-80 & Hwy 50, Exit 440,
8.
Budget Inn,
Nebraska
Crossing Outlet phone number: (402) 332-5188
Web site: http://greatplainsdb2forum.org/
Future DB2 Forum Meeting Schedule:
·
Bonnie Baker, Wednesday,
October 22nd, 2008
·
Free IBM Data
Governance Road Show, Tuesday, June 17, 2008
Susan Lawson is an internationally
recognized consultant and lecturer with a strong background in system and
database administration. She currently works with several large clients to help
development, implement and tune some of the world’s largest and most complex
DB2 databases and applications. She also performs Performance Audits for many
clients to help reduce costs through proper performance tuning. Her other
activities have included authoring articles, presenting at user group meetings,
and authoring white papers. She is an IBM GOLD Consultant for DB2 and z/Series,
and has authored the IBM ‘DB2 for z/OS V8 DBA Certification Guide’, DB2 for
z/OS V7 Application Programming Certification Guide’ and ‘DB2 9 for z/OS DBA
Certification Guide’ - 2008. She is also the co-author of several DB2 books
including ‘DB2 High Performance Design and Tuning’ and ‘DB2 Answers’.
Seminar: V8/V9 Application/Database
Challenges and Solutions
In this seminar we will look at some of the performance features in V8
and how they have been successfully used in our applications and databases to
meet some of our current performance challenges. Those challenges, of course,
being performance and availability. We will discuss some of the things we still
desire in terms of application and database performance and take a look at V9
to see what features are available to further improve our performance and
availability of our applications. We will look at how we may take advantage of
those features.
V8
SQL/Application Performance Features
Multi-Row Fetch
Recursion
Common Table Expressions
INSERT within a SELECT
Scalar Fullselect
Distribution Statistics
XML Scalar Functions
Multiple Distinct
Matching Predicates
Parallelism and Sorting
V8 Database
Performance Features
Volatile Tables
Data Partitioned Secondary Indexes
V9
SQL/Application Features
UPDATE/DELETE with a SELECT
Optimistic Locking
Index on Expression
Histogram Statistics
Order By and Fetch First in Subselect
Instead of Triggers
INTERSECT and EXCEPT
Skip Locked Data
Caseless
Expressions
Native SQL Procedures
XML Support
Star Joins Performance
New Functions
V9 Database
Performance Features
Better Index Page Splitting
Index Compression and Large
Pages
DPSI Enhancements
Clone Tables
Append on Insert
Truncate Table
No Log Tables
Discuss the
importance of smart SQL and applications
Discuss V8
SQL and application features and show examples
Discuss V8
features for database performance
Discuss
challenges still remaining in V8 SQL/applications and databases
Look at
some new V9 SQL/application and database features and their benefits
Friday, May 9th, 2008
Registrations must be
received by Wednesday, April 30th, 2008
in order to ensure class materials. Seating is limited; registrations will be
considered on a first-come, first-served basis.
To
register on-line go to: http://www.greatplainsdb2forum.org/html/registration_0.html
Payment and registration is through a secure
connection using PayPal. A PayPal account is not required to utilize this
payment method. Visa, MasterCard, American Express, Discover and Electronic
Checks are accepted for payment in PayPal. If
registering through PayPal, no further action is required.
If
using Cash or Check, mail or fax registration forms to:
Carol Rosenow Fax: 402 422-2080
Qwest Communications Office: 402 422-4030
1299 Farnam
St, 7th floor Email: carol.rosenow@qwest.com
Company Name:
_______________________________________________
Contact Name: _______________________________________________
Contact E-mail: _______________________________________________
Contact Phone: _______________________________________________
Registration Fee: $200 per person
Registrant Names:
1. ______________________________ 2. ______________________________
3. ______________________________ 4. ______________________________
5. ______________________________ 6. ______________________________
7. ______________________________ 8. ______________________________
The Great Plains DB2 Forum
does not send bills, but a confirmation will be sent to the contact e-mail
address listed above within one week of receipt of the registration.
Receipts can be picked up
at the seminar. Do you want a Receipt? _________
If not using PayPal,
please make payment in one of the following ways: (please check one)
_____
Check* *Make check payable to
GREAT PLAINS DB2 FORUM, INC.
_____
Cash
_____
Paying Later (please
read and sign the following)
The registrants listed are authorized to
attend this event. I assume full
responsibility for the payment of the registration fees for these registrants;
payment will be received no later than the day of the event.
Signed
______________________________________________