I am proud to announce that I will be speaking at three DB2 Users Group meetings in September. If you’re in the area, come see me, and introduce yourself. Maybe we can find time for a coffee/tea or a meal. I’m up against Leon Katsnelson in at least one of my time slots at some locations, so I need all the support I can get! Also, there will be other good speakers (like Leon Katsnelson) available at these meetings – some of them may require membership or nominal meeting fees.
Dates, Times, and Locations
Minnesota DB2 Users Group
Date: Tuesday, September 10th
650 Third Avenue South
Minneapolis, MN 55402
Contact: Brian Mealman – bamealm @ us.ibm.com
Wisconsin DB2 Users Group
Date: Wednesday, September 11th
Time: 8:30 – 4:00
West Bend Mutual Insurance
1900 South 18th Ave.
West Bend, Wisconsin
Contact: Shelley Mizerak – smizerak @ us.ibm.com
Midwest Database User Group
Date: Thursday, September 12th
Time: 8:30 – 3:45
71 South Wacker Drive
Chicago, IL 60606
Contact: Sheryl M. Larsen – smlarsen @ us.ibm.com
In Minneapolis and Wisconsin, I’ll be doing the same three presentations. In Chicago, I’ll be doing only the first two.
The 10 Commandments of Supporting E-Commerce and OLTP Databases
When you are a new DBA, it is as hard to know what you should be doing as it is to know how to do it. If you have been a DBA for a while, you can forget or neglect some of the things you should be doing. Come learn 10 things that you should be doing to successfully support high-performing e-commerce or OLTP databases. While the focus is on e-commerce and OLTP databases, many of the tenets apply to other databases as well.
Why Low-Cardinality Indexes Negatively Impact Performance
Tuning SQL via indexes is one skill any DBA must learn. Any DBA or developer will hear recommendations on indexing in DB2 databases for Linux, Unix and Windows; what to index, what not to index, how to analyze existing indexes, etcetera. One principle taught is that low cardinality indexes are bad. But why is that so? In this session, we will take a deep dive into why low-cardinality indexes are bad for performance.
Tips and Tricks for HADR and Automating Failover with TSA
Setting up DB2 to handle high availability or disaster recovery is not an everyday task for a DBA. HADR is simple for the HADR veteran; TSA can be a bit more difficult. Planning is key, and with the proper bag of tricks, any DBA can get through implementing and supporting HADR and TSA successfully. Come and learn some tips and tricks learned the hard way.