Washington (DC) Area Infomix 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) 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. John F. Miller III is a member of the Resolution Team for Informix Technical Support, responsible for handling critical customer situations and developing support tools used by the Technical Support Organization. Before joining Informix, John attended Santa Clara University where he graduated with a BS in Computer Engineering. While at Informix John has participated in several OnLine beta programs and many Elite Var Benchmarks including SAP and BAAN. ______________________________________________________________________ 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/ ______________________________________________________________________