Seven SQL Performance-Killers to Avoid in Db2

Seven SQL Performance-Killers to Avoid in Db2

How DB2 Handles SQL SQL is a powerful language in the hands of the right RDBMS. One of SQL’s strengths is that you specify what data you want returned without specifying what file, disk, san, or sector that data is stored on. Because we describe the result set...
Dropping Indexes to Improve Db2 Performance

Dropping Indexes to Improve Db2 Performance

Indexes are Good for Performance Generally speaking, DBAs and developers spend a fair amount of their performance time trying to find which indexes to add to a database to improve performance. If a specific query is having performance problems, one of the strongest...
Runstats Best Practices for Db2 on LUW

Runstats Best Practices for Db2 on LUW

What is Runstats? Runstats is a utility in Db2 that is used to collect statistics about the data in Db2 tables and indexes. This statistical information is critical to Db2 database performance. Runstats is executed on a table by table basis, so scripting it is quite...
Enterprise Database Software for Free – IBM Db2

Enterprise Database Software for Free – IBM Db2

Personally, I am biased. As the team lead for Db2 services here at XTIVIA, I think Db2 and other enterprise database software have significant advantages over some of the open source or free options out there. Decades of time invested and spent solving the problems of...
Why are there Question Marks in my Db2 Queries?

Why are there Question Marks in my Db2 Queries?

Sometimes when you’re looking at Db2 Queries, you may notice question marks in your queries, like this: SELECT partnum, sum(quantity) as QUANTITY FROM orderitems oi INNER JOIN orders o ON oi.orders_id = o.orders_id where o.field3 is null and o.timeplaced is not...