Category: Posts-By-Category

select2 2

DB2 Administrative SQL Cookbook: Finding Problem SQL in the Package Cache

I wrote a developerWorks article on finding problem SQL in your package cache. But I refine and play with my SQL over time, so I thought I’d share the version I’ve been using recently. Purpose To find problem SQL in the Package Cache across several importance performance categories. Computes how bad a particular statement is in comparison to other statements...

ibm-blu 1

A Deeper Dive into DB2 BLU

I started out with a DB2 Basics entry on BLU. That starts with the most basic concepts. In this post, I’d like to delve into some of the details of BLU and talk about when BLU is beneficial and when it may be detrimental and why. BLU Workloads If you’re considering BLU consider first that it is not for all...

select2 0

DB2 Administrative SQL Cookbook: Listing Row-Organized Tables

The DB2 Administrative SQL Cookbook is a series of blog entries that are short. Each focuses on one or a few SQL statements that may be useful when administering DB2 databases. They usually address system catalog views, snapshot tables/views, or snapshot table functions that are standard in all DB2 LUW implementations. The version the SQL has been tested on is...

BLU_2 7

Loading Data into DB2 BLU Tables

Working with BLU has been a glorious learning experience for me. I say that both truly with excitement and with frustration. Whenever I have a DBA-character building experience, I’m bound to share it with my readers. The Scenario A client has a small (1.7 TB) DPF data warehouse/ODS than I’m helping them move from 9.5 to 10.5 using BLU. Only...

pavanBlog1_image2 2

Choosing the right distribution keys in a DB2 DPF database

In a DB2 DPF (Database Partitioning Feature) database, the choice of the right distribution keys is an important decision that DBAs have to make. An incorrect distribution key (also called hash key) could skew the data distribution for one or more tables between the database partitions. This could result in a subset of database partitions becoming the bottleneck for query...