DB2 Basics: db2top

There are a lot of things I can cover on db2top, and probably more tips and tricks using db2top than many other tools out there. Searching the web on db2top gets more good results than on many other db2 topics. I thought I’d start with some of the basics.… Read the rest

Continue reading »

DB2 Basics: Aliases

My blog entries covering the DB2 Basics continue to be my most popular blog entries. This is probably because they appeal to a wider audience – even non-DBAs are interested in them and I continue to rank highly in Google search results.… Read the rest

Continue reading »

DB2 Basics: Capitalization

When does case matter in DB2? Well, it doesn’t unless it does. Nice and clear, huh?

When Text Must be in the Correct Case

Text must be in the correct case whenever it is part of a literal string. Things that you have to enclose in single quotes are case sensative.… Read the rest

Continue reading »

DB2 Basics: Quotation Marks

This blog entry may be a little on the basic side, but some of my most basic entries are some of my most popular ones.

DB2 has a number of special characters, for which there are rules of use. Both the single quotation mark and the double quotation marks are special characters.… Read the rest

Continue reading »

DB2 Basics: Triggers

As with the other entries in my DB2 Basics series, this entry does not cover everything about triggers. Instead, I’m covering the basics and a few important points.

DB2 triggers are sometimes over-used and over-complicated. Basically, triggers are actions(SQL) that take place when a triggering action occurs.… Read the rest

Continue reading »

DB2 Basics: What is an Index?

Don’t call them indices in the United States – most American DBAs agree that they are ‘indexes’, though either plural form is grammatically acceptable in American English. Indexes are arguably one of the most important aspects of database design. They’re also something that we can pretty easily change and add to over time.… Read the rest

Continue reading »