Category: Explains

5

IDUG NA 2013 Brain Dump

Wait, don’t avoid reading this because you didn’t go to the conference. There is still valuable stuff here. In fact, it is even more valuable for those who did not go. Last year, I posted my brain dump by basically re-writing all of my paper notes. This year, I’m going to try to make it a bit more organized. It...

7

DB2 Table Scans

What is a table scan? DB2 has a number of ways of accessing the data it needs, but the most basic one – the one that will always work to get what it needs – is the table scan. A Table scan means that DB2 will read through every single row in a table to get the data it needs....

0

DB2′s Got Talent – March 16 – db2caem: The Untold Story

This post ties in directly to my Friday presentation on the DB2Night Show’s DB2’s Got Talent Competition. Listen to the replay here: http://www.dbisoftware.com/blog/db2nightshow.php?id=341. My presentation is at the 52 minute mark.. Most importantly, please vote for me at https://www.surveymonkey.com/s/DB2TALENT16MAR I have just recently reached the point where 50% of my work is on db2 9.7. Due to WebSphere Commerce still providing...

0

The basics of Index Design for DB2

The keyword in the title of this post is “basics”. I spend some time training SQL Server or Oracle DBAs on DB2, and so this is the answer on the most basic level to how to identify indexes to add. There are certainly greater experts on this topic than me, so I don’t claim to have a comprehensive view on...

7

Identifying Problem SQL

Many DBAs have their own methods and approaches in this area,  but there are some basic sources and methods that I use. I’ll cover at least the basics of SQL  analysis in one or more future posts Get SQL from Developers So the optimum situation is that your developers give you the SQL they’re planning to use in custom code...