A well-designed database schema forms the foundation of a high-performing and efficient IBM Db2 database... and therefore, also serves as th...

Recently, I was reading an article written by Ben Brumm on using Boolean data in SQL and it got me thinking about Db2 and Boolean data. You...

PEBCAK  The number one cause of DB2 performance problems today, as always, is  Problem Exists Between Chair And Keyboard !   Poorly coded...

One of the more troubling aspects of DB2 database design and creation is the non-partitioning index (NPI). Creating NPIs on tables in a par...

As is so often the case with my blog, today's topic came about as the result of an e-mail question I received from a DBA I know. His q...

Defining the job of DBA is getting to be increasingly difficult. Oh, most people know the rudimentary aspects of the job, namely keeping you...

The term "data integrity" can mean different things to different people and at different times. But at a high level, there really ...

Here is a follow-up question and answer based on my previous blog post : Q: My format does not fit into any of the formats listed in the DB...

Recently I was reading through some posts in a database-related newsgroup or mailing list (actually, right now I can't remember which on...