Category: Posts-By-Category

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 6

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 1

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...

IBMExtract-Use-Pipe 2

The IBM Data Movement Tool

We DBAs are lazy in some ways. Our favorite way of moving large amounts of data is the backup utility. It’s so easy to move data, structure, objects, permissions, etc. But as quick, easy, and efficient as it is, it cannot handle some situations – like skip-level upgrades, data movement between different operating systems, and of course between different RDBMSes....

BLU_2 3

DB2 Basics: What is BLU?

BLU has been all the hype for DB2 for the past year or more. What exactly is DB2 BLU? How does it work? What do you need to consider before jumping on the bandwagon? What is DB2 BLU BLU leverages the DB2 engine but is a significantly different animal in many ways from DB2 without BLU. BLU combines a number...

1

db2commerce.com Year in Review – 2014

Blog Stats As I contemplated the blog at the end of last year, I wondered at the fact that in 2013, I had more than 100,000 page views. Well, in 2014, as of last week, I have had over 250,000 page views on the blog! Wow. Just Wow. I passed new plateaus on daily page views with nearly every weekday...

0

HADR Tools: HADR Calculator

The HADR Calculator is one of three HADR tools provided by IBM on developerWorks. For more details on the other(s), see: HADR Tools: the HADR Simulator For the full technical specifications and details on using the HADR tools, see: https://www.ibm.com/developerworks/community/wikis/home?lang=en#!/wiki/DB2HADR/ What are the HADR Tools? IBM provides three major HADR tools on a devloperWorks wiki site. The HADR Simulator is...

0

HADR Tools: the DB2 Log Scanner

The DB2 Log Scanner is one of three HADR tools provided by IBM on developerWorks. For more details on the other(s), see: HADR Tools: the HADR Simulator For the full technical specifications and details on using the HADR tools, see: https://www.ibm.com/developerworks/community/wikis/home?lang=en#!/wiki/DB2HADR/ What are the HADR Tools? IBM provides three major HADR tools on a devloperWorks wiki site. The HADR Simulator...