Blog

Don’t Forget DISPLAY as a Part of Your DB2 Tuning Efforts

The DB2 DISPLAY command is a powerful tool that gathers details about your DB2 subsystems and databases. DBAs should know how to use DISPLAY to simplify their job.

VOLATILE: A Useful Little Keyword

A reminder about the VOLATILE keyword. It was added in DB2 Version 8 and can be specified on a table using CREATE TABLE and/or ALTER TABLE statements

Using INTERSECT and EXCEPT in DB2

They both are similar to UNION in the way in which they work and are coded. But there a differences, this blog explores the differences.

DB2 Performance Monitoring Overview

In today’s blog entry we will discuss the basics monitoring and DB2 performance monitors.

When Not to Index

Every now and then I take the opportunity to blog about a question I get through e-mail. This time the question was: When does it make more sense not to build an index for a DB2 table?

Sequence Objects and Identity Columns

When designing DB2 databases a frequently heard request is for a column that contains sequentially generated numbers. Learn more in this post.

The Two Biggest DB2 Performance Things

Learn why the performance of applications is one of the bigger issues that end users complain about and how to fix DB2 performance.

A Quick Intro to DB2 SQL Functions

Want to go over DB2 SQL functions at a basic level? This is a review for those who might not have used them before.

DB2 Database Table Naming Conventions

What’s in a name? The establishment and enforcing of naming conventions is often one of the first duties to be tackled when implementing new software.