Dave Beulke

Performance is elusive and difficult to achieve in any type of application system these days. With so many options, servers, databases, application coding techniques and configuration parameters, it is sometimes amazing that things get done at all.  The number of items to check and the number of items that affect performance continues to increase as [...]

DB2 Version 9 offers a new way to handle testing out a new version of a DB2 application through the Plan Stability enhancements. The Plan Stability enhancements offer a way to save a static DB2 access package for an application and then BIND a new one. If the access package is not as [...]

Index design is one of the most important items or maybe the most important item in database design. Sometimes it is better to enhance the database with more indexes instead of trying to fix the application SQL. Tuning SQL is always good but tuning many SQL statements takes too much time. When [...]

It seems that last week’s blog struck a chord with many readers. Many people commented on how their management is increasingly out of touch with the mainframe. Also, comments also stated that the System Z environment is really processing almost all of the transactions in their company and how all the Windows platform [...]