(Neil Tardy) The loyalty of IBM i clients is easy to understand. Some of the key technology found on current IBM Power Systems* servers running IBM i—including the integrated database and object-based security—was developed 30 or more years ago.

(Craig S. Mullins) Coding and tuning SQL is one of the most time consuming tasks for those involved in coding, managing and administering relational databases and applications. There can be literally thousands of individual SQL statements across hundreds of applications that access your many product

(Lockwood Lyon) Large IT shops typically integrate their big data applications with the enterprise data warehouse. There are many good reasons for this: typical dimension tables for aggregation and subsetting already exist in the warehouse, and many of the transactional tables in your big data datas

(Troy L Coleman) You don’t hear much about data compression these days, but recently I encountered a customer who was curious about it. He said his company never used compression due to the belief that because the CPU overhead was too high, but he was wondering if the feature has improved, and if so

(Denis Tronin) System profiles are available as of Db2 for z/OS version 9, but they are still not widely used and known. However they represent quite a strong Db2 capability that can help you with a variety of needs such as managing and monitoring Db2 connections, modelling production environment, t

(Lockwood Lyon) Query performance, and therefore transaction performance, greatly depends upon data access paths. The Db2 optimizer analyzes query syntax and existing data distribution statistics to determine the ‘lowest cost’ access paths. Cost in this case refers to the costs of CPU, I/Os and any

(Paul Bartak and Tim Willging) IBM Db2 for z/OS is well known as the gold-standard information steward. Deep synergy with the z/OS operating system and System Z platform provides support for the highest transaction volumes with the ultimate levels of availability. Just like any high-performance engi

(Troy L Coleman) As I’ve noted a few times, I maintain a PDF library of Db2 for z/OS documentation. I just find it easier to search PDF docs as opposed to looking up information online.

(Kim Clark and Mark Ketteman) When you create a process application, you want to focus on business value, not on the complexity of the underlying technology. With integration, you often must learn details that you’d rather not know about. However, modern cloud-based applications, such as Salesforce,

(Craig S. Mullins) The ability to monitor Db2 using profile tables is a newer, though by no means brand new capability for Db2 DBAs. You can use profile tables to monitor and control various aspects of Db2 performance such as remote connections and certain DSNZPARMs.