Articles & Content

Archives

50 Fabulous ways for forecasting failures, flaws, & finding flubber in DB2 LUW (D12)

Topic: DB2 for LUW

Subtopic: 2011



Are you the database magician in your shop? Did it take 3 years to build the latest performance mess from the mom & pop cots low bidder thrown over the wall from that irkle design? Are you asked to fix it in 30 minutes or less? Has the regular dba just put in another 70 hour week and is now on catatonic r&r? Here are real sql's and techniques from live customer experiences that will help you see short term bottlenecks and help predict long term failures from poor data type selection, physical/logical design flubs, and strategic storage implementation snags. We'll see the “pick of the litter” performance sql and commands for filtering thru mountains of monitoring parameters/tuning knobs. Learn about quick techniques for viewing the various logs. See simple methods for predicting constraint issues & juggernauts, see index/log bottlenecks, “lack of preparation” issues, rollback/commit snags, and how to look for the “common/unnecessary” application SQL miscodes.



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.