DB2 for z/OS optimizing INSERT performance

Barb Lidstrom

DB2 for z/OS optimizing INSERT performance
Barb Lidstrom
seattle db2 user group
[login to unmask email]
work 425 865 1584

-----Original Message-----
From: IDUG Regional Group Leaders [mailto:[login to unmask email] On Behalf Of Cuneyt Goksu (Gmail)
Sent: Tuesday, November 24, 2009 11:33 PM
To: [login to unmask email]
Subject: DB2 for z/OS optimizing INSERT performance

Please forward to your RUGs.


---


Broadcast date: December 1, 2009, 11 a.m., Eastern Standard Time, 4:00
UTC Developed for: IT managers, application architects, database
administrators, 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 DB2R for z/OSR. 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

Register Now

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

---------------------------------------------------------------------------------
Welcome to the IDUG DB2 User Group Leader list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-ug-ldrs.html. From that page select "Join or Leave the list". If you will be out of the office, send the SET DB2-UG-LDRS NOMAIL command to [login to unmask email] The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

---------------------------------------------------------------------------------
Welcome to the DB2 User Group - Seattle list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/DB2-UG-Seattle.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 - Seattle List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm