Query execution plans play a crucial role in identifying performance bottlenecks within an IBM Db2 database. When a query is executed, the d...

  Mainframe application development has changed dramatically during the lifetime of Db2. Way back in the beginning, and even for a long time...

 As most Db2 developers and DBAs know, when you modify a Db2 program you have to prepare the program to enable it to be executed. This progr...

There seems to be a LOT of confusion out there in DB2-land about the CURRENTDATA parameter, so I thought it might be helpful to blog about ...

Do you know about the VOLATILE keyword? This keyword was added to DB2 for z/OS back in Version 8. It can be specified on a table using eith...

BIND and REBIND are crucially important components as you attempt to assure efficient DB2 applications. Because the BIND/REBIND process d...

Assuring optimal performance for database applications can be a tricky thing. In today's blog I ruminate on the high-level issues invol...

We’re all busy. Frequently it can seem like you just got in to the office and already it is  past quitting time! There is so much to do and ...

There are many different types of development mistakes that can be made when you are coding a complex application system. But probably the ...

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

It can be potentially troublesome when DB2 lock promotion and escalation occur. These situations can greatly reduce the availability of conc...

You can shoot yourself in the foot using DB2 if you are not careful. There are options that you can specify that may cause you to read data ...

BIND and REBIND are important components in assuring efficient DB2 applications. Because the BIND/REBIND process determines exactly how your...