Free Webinar ! DB2 for z/OS optimizing INSERT performance

Surekha Parekh

Free Webinar ! DB2 for z/OS optimizing INSERT performance
Hi

Just a quick reminder that John Campbell - IBM DE will be presenting on 1st
Dec 2009. Here are event details & URL to register

http://www-01.ibm.com/software/os/systemz/telecon/dec1/index.html?
S_TACT=109AY53M&S_CMP=SurekhaIDUG

Broadcast date: December 1, 2009, 11 a.m., Eastern Standard Time, 4:00
UTC
Developed for: IT managers, application architects, DBAs, system
administrators, systems programmers and system architects

For database professionals, performance issues can be the source of many
unwanted trade-offs. With the constant pressure to increase application
throughput, and minimize CPU resource consumption, you can apply an
endless number of optimization techniques. Put your energy on the most
common tasks – such as INSERT processing – to realize major
improvements, and keep the trade-offs under control.
Join us for this complimentary teleconference and learn how to design and
tune applications to achieve aggressive application throughput
requirements, while minimizing CPU resource consumption. High-volume
concurrent INSERT processing is critical for many applications to be able to
meet business and technical throughput requirements. It is the ultimate
performance challenge for any DBMS and for the application designer. This
teleconference will introduce and discuss typical performance issues and
concerns, design considerations, tuning recommendations, and capacity
planning for data INSERT operations in DB2® for z/OS®.
There are also some significant new features in DB2 9 for z/OS that can help
you. We’ll introduce these new features, and how to best apply and use
them.

We’ll discuss some options for optimizing INSERT performance and their
effectiveness, including:
Moving as much processing as possible outside of the array/batch loop
Avoiding data type conversions between client and database
Reserving an appropriate amount of free space on data pages

Speaker: John Campbell, Distinguished Engineer, DB2 for z/OS
Development

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
_____________________________________________________________________

http://www.IDUG.org membership is now free.
Do you have people in your office who are not an IDUG member?
Show them how to access the information and help train the next generation of DB2 Users!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's DB2-L