Articles & Content

Archives

Terror by Design (F04)

Topic: 2011 EMEA

Subtopic: Cross Platform DB2 for z/OS & LUW



I am rushing through LaGuardia airport my intestines threatening to gave way to the parasites inside. I need to find a bathroom but I also need to eat to settle my stomach. I pass a chili dog stand and things quickly become worse. This event was one of the many caused by terrible design. This presentation will talk about the types of design problems a DBA is likely to encounter, the reasons these designs get chosen and all the horrible consequences along with some remedies. The general topics covered will include normalization, clustering, bufferpools, parallel processing, performance versus availability, hierarchical models in relational tables and the importance of understanding the application. In addition the presentation will touch on how new features can be used for good and evil, these include partition by growth, RRF, index compression, adding and rotating partitions. To top it off you'll see real numbers before and after the designs of terror.



Click Here to Download

NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.