Tag: Craig Mullins

This post includes a series of 14 links, each one taking you to the TechTarget web site for a different DBMS product overview.

Read More

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?

Read More

When designing DB2 databases a frequently heard request is for a column that contains sequentially generated numbers. For example, each row has a counter associated with it.

Read More

DB2 performance is one of those perennial topics that people just can't seem to get enough of. I guess that is because the performance of applications is one of the bigger issues that end users complain about

Read More

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

Read More

There are two basic mindsets on when to REBIND your DB2 programs. The first -- which I believe is the best approach -- is to REBIND regularly after running RUNSTATS.

Read More

Most DBAs have faced the situation where one of their applications requires a four-byte code that is used to identify products, accounts, or some other business object, and all of the codes are numeric and will stay that way.

Read More

The performance of dynamic SQL is one of the most widely debated DB2 issues. Some shops try to avoid it, but in this day and age of ERP/CRM systems, Java/JDBC programming, and web applications, all of which heavily rely on dynamic SQL, its use is becoming more ubiquitous.

Read More

Most seasoned SQL programmers know that when you use host variables, DB2 may not always come up with the absolutely most optimal access path at bind time.

Read More

I know that many readers will question the title of this blog posting. But it is true. Many DBAs think that managing performance is the most important thing they do, but they are confusing frequency with importance.

Read More