When thinking about the performance characteristics of your Db2 databases and applications keep in mind the routine maintenance that can hel...

The Db2 for z/OS log sometimes referred to as the transaction log, is a fundamental component of Db2 that is central to all data activity i...

Assuring optimal performance is one of the most frequently occurring tasks for DB2 DBAs. Being able to assess the effectiveness and perform...

In the first part of this series on DB2 health checks, DB2 Health Checks - Part One , I discussed the general concept of a health check and...

Left to their own devices, DB2 databases and applications will accumulate problems over time. Things that used to work, stop working. This ...

As a user of DB2, which I'm guessing you are since you are reading this blog, you should always be on the lookout for useful tools that...

Why should you do it by hand if you can automate DBA processes ? Anything you can do probably can be done better by the computer – if it is...

Many DBAs reading this blog will probably think I'm wrong, at least initially. They'll claim that managing performance is the most i...

Business availability is more than just having a reliable hardware and database platform in place. Even the best high availability environme...

Database administration is a very technical discipline, but it is also a discipline in which the practitioner is very visible politically wi...

Availability requires much more than just having a reliable hardware and database platform. Most companies cannot afford significant downtim...

Another IBM DB2 utility that has received some attention under Version 9 is MODIFY RECOVERY. For those not sure what this utility is, MODIFY...