Washington Area Informix User Group meeting - January 27, 2005
Happy New Year! The next Washington (DC) Area IBM-Informix User Group meeting is: Next Quarterly Meeting is: 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. _____________________________________________________________________ Afternoon: 1:00-4:00 - DB2 Presentations * How to do your own DB2 performance review by David Beulke * Best Practices for your DB2 UDB database system by Dwaine R. Snow, IBM Senior Product Manager for DB2 UDB for Linux, UNIX, and Windows ______________________________________________________________________ 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/ ______________________________________________________________________ Advanced Informix IDS Performance Tuning and Optimization Course February 7-10, 2005 in Annandale, VA USA This course is for experienced Informix database administrators and application developers who will be responsible for managing, optimizing, and tuning IDS database servers. The focus is on practical skills, procedures, and scripts for improving the performance of your database server. In addition to new skills, the course will provide a toolkit of scripts and utilities to start monitoring and optimizing your Informix IDS database server. The course is taught by Lester Knutsen, Database Consultant and President, Advanced DataTools. Lester has been developing databases with Informix software since 1983. He specializes in data warehouse development, database design, performance tuning, and Informix DBA training and support, and is an IBM Gold Consultant. For more information about this course please visit our web site at: http://www.advancedatatools.com/Training/InformixCourseSchedule.html -- ______________________________________________________________________ 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
Lester Knutsen schrieb: > Happy New Year! > > The next Washington (DC) Area IBM-Informix User Group meeting is: > > Next Quarterly Meeting is: > > 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. [ ... snip ... ] Format of value for DBUPSPACE: May I ask you to do me the favor to ask Mr. John Miller III why this is, that in his fine pfd file about tuning update statistics the format for the environment variable has changed from "a:b:c" to "a:b", and why "c", valued 1 or 2 for w or w/o index scan is no longer there. I stll have a local copy of the original version of 2002.... And it still work nicely for me on V9.40.FC4W4 in its 3 valued format. Thank you dic_k -- Richard Kofler SOLID STATE EDV Dienstleistungen GmbH Vienna/Austria/Europe