Pavan Kristipati’s work experience includes database consulting engagements at Fortune Finance / Health care / Insurance clients. He currently works full time as a Sr. Database Engineer and is an IBM Certified Advanced Database Administrator – DB2 10.1 for Linux, UNIX and Windows. In his current role, he manages and supports a large multi-terabyte Enterprise Data Warehouse (EDW) on DB2 LUW DPF (Database Partitioning Feature) and Highly Available (24/7) OLTP (DB2 / HADR) databases. He was selected into “Top 10 User Speakers” at the 2014 IDUG Technical Conference in Phoenix, AZ.

Posts:

September 15, 2015 Uncategorized

Automatic Bufferpools in DB2 HADR

In this blog post, I will share what I learned about DB2 automatic bufferpools when using HADR.

Problem:

In a DB2 10.5 (fp3a) HADR environment, during heightened database activity on the primary database, there was delayed log replay on principal standby database.… Read the rest

January 20, 2015 Uncategorized

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.… Read the rest