Dr. Michael Stonebraker's 10 fears about the future of the DBMS field Introduction The performance of Db2 depends on many things. It spreads from the application and the SQL, through the Db2 itself, down to the underlying system configuration. We can even expand it a bit more, I mean a...
Investigating performance problems doesn’t have to be hard. There are some basic steps you can take to find common bottlenecks in your system – ‘performance first aid’ if you will. We’re going to look at some of these basic problems and how to find them, using just DB2’s built-in capabilities....
DATE: 2010-5-14 (08:30 AM - 09:30 AM) SPEAKERS: Paul Pendle (EMC) Nowadays, DBAs are presented with multiple different storage options upon which to deploy DB2 systems. The options offer varying performance, availability and economics. The optimal selection for a given DB2 for z/OS system may...
NA10G13.pdf
DATE: 2010-5-14 (08:30 AM - 09:30 AM) SPEAKERS: Mark Wilkinson (AMICA Mutual Insurance Company) Come to this session to experience the value of building and maintaining a performance database (PDB). You will learn the critical steps you need to take for creating, loading and running reports...
NA10F13.pdf
DATE: 2010-5-14 (08:30 AM - 09:30 AM) SPEAKERS: Kevin Beck (IBM) This session provides a step by step approach to creating a complete workload management solution for your enterprise. Learn how you can employ best practices on your Version 9.5 or 9.7 DB2 data server in order to meet business...
NA10C13.pdf
DATE: 2010-5-14 (11:00 AM - 12:00 PM) SPEAKERS: Sigen Chen (Lockheed Martin) This presentation will cover some practical aspects of improving DB2 application performance while keeping the cost low. The focus will be on choosing proper language and APIs for a given job; optimizing query and...
NA10F15.pdf
DATE: 2010-5-14 (09:45 AM - 10:45 AM) SPEAKERS: Alexander Kopac (Home Depot) Do you as a customer wait 15 seconds for a web application to fail to respond and then move on to the next competitor? Timeouts, Lock Waits, Deadlocks, Lock Escalations & Application & Database ?Design Flaws?...
NA10E14.pdf
DATE: 2010-5-13 (08:30 AM - 09:30 AM) SPEAKERS: Steen Rasmussen (CA) Not logged tablespaces in DB2 9 looks very interesting, but there are a number of issues which need to be considered prior to exploiting this feature. We will look into the syntax changes, where this new feature can / should...
NA10A09.pdf
DATE: 2010-5-13 (01:30 PM - 02:30 PM) SPEAKERS: Frank Petersen (Bankdata) At the 25'th anniversary of DB2 IBM made a contest in different categories where a judging panel would try to find the best solution submitted. In the categori of DB2 for z/OS Bankdata won the award with a solution used...
NA10F11.pdf
DATE: 2010-5-13 (02:45 PM - 03:45 PM) SPEAKERS: Guy Lohman (IBM) The IBM Smart Analytics Optimizer for DB2 for z/OS, V1.1 is a revolutionary special-purpose, main-memory database engine that was invented by IBM Research for accelerating Business Intelligence queries to a portion of a data...
NA10G12.pdf