(Lockwood Lyon) Assigning tasks to DBAs is based upon task complexity, schedules and service level agreements, and the DBA’s expertise. Some DBAs tend to be generalists. New DBAs start out this way, and only develop specialized in-depth knowledge later in their careers.

(Harald Smith) With the substantial growth in data volume, velocity, and variety comes a corresponding need to govern and manage the risk, quality, and cost of that data and provide higher confidence for its use.

(Troy L Coleman) IBM continues to focus on improving index management, with a goal of reducing the overall cost of storing and retrieving data from DB2 by helping customers avoid I/Os.

(Pavan Kristipati) In this blog post, I will share a quick UNIX script that I frequently use to find column names that have a string in them. This came out of a need a while ago when I had to frequently type a long SQL that would generate matching column names.

(Shang-Min (Allen) Wei, Jon Lind, Jessica Rockwood, Rahul Agarwal, Doug Petteway and Ajay Dholakia) Enterprise data warehouses (EDWs) store data that is used primarily for business intelligence, analytics, and other reporting requirements. Today’s business analytics demands higher performance from d

(Ashok Iyengar and Peter Van Sickel) This tutorial shows you how to deploy the basic IBM Integration Bus Pattern using PureApplication Service on SoftLayer. Patterns automate and simplify the provisioning, monitoring, and maintenance of workloads, enabling you to focus on your applications, and move

(Kent Milligan) IBM first improved the debugging of SQL stored procedures, functions, and triggers way back in the V5R2 release when it introduced the *SOURCE debug view. This debug view allowed IBM i developers to debug their original SQL source code instead of having to debug the ugly C code that

(Lockwood Lyon) The most important goal for a tech support team is to give management the data they need to prioritize the team’s work.

(DB2 Geek) Well, it’s been another busy year for the DB2 Geeks. We take a look at some of our favourite DB2 experiences and blogs over the past 12 months.

(Lockwood Lyon) This report allows the DBA to drill down into plan/package details. It gives extremely detailed information about Plans and Packages. It is typically used after the DBA has referenced the Accounting Short Report and determined that there may be a performance issue.