Washington Area Informix User Group meeting - January 27, 2005
Washington Area Informix and DB2 User Group meeting Date: Thursday, January 27, 2005 Time: 9:00-5:00 Location: IBM, Bethesda offices. Building 6710, Wing B Room 21B167. 6710 Rockledge Drive, Bethesda, MD 20817 (Directions are on our web site) Please sign up on our web site as we need to provide a list of attendees for building access. The meeting is open to all. http://www.iiug.org/waiug/ Agenda: ______________________________________________________________________ Morning 9:00-12:00 - Two Informix Presentations by John Miller III, Senior Technical Staff Member, IBM * Informix Dynamic Server Backup and Restore Utilizing the new backup and restore features that have come out in the recent releases, including an overview of Point In Time Table Level Restore to ensure a reliable recovery strategy. The session will conclude with a few hints on the "Best Practices" of backup and restore. * Unlocking the Mysteries Behind Update Statistics Understanding the mysteries behind update statistics will enable DBAs to drastically reduce the time spent running update statistics. Focusing on what and how the information is collected for the optimizer will allow DBAs to tune update statistics. The talk concludes with practical examples of how DBAs can get 2x, 3x and even 4x speeds by tuning update statistics. * The CopperEye DataBlade - improve data load performance The CopperEye DataBlade is a software product that dramatically improves data load performance for Informix Dynamic Server customers dealing with large data volumes. The CopperEye DataBlade replaces the standard Informix B-Tree index with CopperEye's patent-pending indexing technology that exhibits significantly improved index maintenance performance - up to 25X. Using CopperEye, it is possible to eliminate scheduled downtime for data loads and index rebuilds, while extending the life of existing hardware. ______________________________________________________________________ Afternoon: 1:00-4:00 - DB2 Presentations * How to do your own DB2 performance review by David Beulke This session will discuss the research, process and impact of doing a DB2 performance review of your environments. An overall system, architectural, database and performance tuning review can dramatically reduce costs and improve application availability. By analyzing many processing performance conditions and detailing recommendations your can quickly improve database application performance, throughput and response time. This presentation will detail my activities at an outsourced client where we evaluated their production environment. This presentation will detail the improvements made in their system configurations, database designs and mainframe and UNIX Websphere applications reducing daily CPU consumption by 26%, a projected savings of over $8.6 million dollars in the first year. * Best Practices for your DB2 UDB database system by Dwaine R. Snow, IBM Senior Product Manager for DB2 UDB for Linux, UNIX, and Windows Come and learn from other people experiences in how to setup, design, configure, monitor and tune your DB2 UDB database system. Benefit from the experiences of the IBM Toronto Lab based consultin team, and their customer work, and avoid making the same mistakes that other users have made. This presentation will discuss the "Best Practices" for your DB2 UDB database system. ______________________________________________________________________ The meeting is open to all. Please register at the WAIUG Web site. We will need a list of attendees for access to the building. http://www.iiug.org/waiug/ _____________________________________________________________________ Lester Knutsen lester@advancedatatools.com Advanced DataTools Corporation Voice: 703-256-0267 Visit our Web page: http://www.advancedatatools.com Washington Area IBM-Informix User Group: http://www.iiug.org/~waiug/ ______________________________________________________________________ sending to informix-list