Presenting at International DB2 Users Group (IDUG) North America 2015

I am delighted to share that I will be one of the speakers at International DB2 Users Group (IDUG) in Philadelphia, PA. This is going to be my 2nd IDUG and I am eagerly looking forward to not only share an important and challenging topic but also to meet and learn from DB2 gurus like Scott Hayes, Ember Crooks, Mike Krafick and many more.

Continue reading

Advertisements

My first guest blog post on db2commerce.com !!

I am thrilled and pumped up to share that I will be guest blogging on IBM Gold Consultant and IBM Champion Ember Crooks’ DB2 blog http://www.db2commerce.com. I will continue to blog on a regular basis on db2talk.

My first guest blog post on db2commerce got published today. The title of this post is: “Choosing the right distribution keys in a DB2 DPF database”. I am hoping that you will take few minutes to read the blog post. Please leave your comments. Thank you.

DB2 and Transparent LDAP in DB2 DPF – Misleading error SQL30082N

In this blog post, I will quickly cover my recent experience in troubleshooting a DB2/LDAP authentication problem in a DB2 DPF database.

Problem:

In a DB2 (9.7 FixPack 7) DPF data-warehouse database, a connection attempt by Datastage to any node other than the coordinator node was failing. Connection attempt to coordinator node succeeds. The same user id and password were being used in both the attempts.

Continue reading

Quick primer on DB2 Tables and Tablespaces in a multi-partitioned (DPF) database

When I was starting out to work in a DB2 DPF database, I had many questions related to database objects. Some of them were related to gaining understanding of how tables and tablespaces were created in a DPF database, how to spread out (hash distribution) a table across partitions etc.

In this blog post, I will cover how tables and tablespaces are created, how these objects are spread out across multiple partitions in a DPF database. My goal is to be such that “friend” of that DBA who is experienced in a single partitioned DB2 environment but is just getting started in a DPF database. Here we go..

Continue reading