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.
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.
In this blog post, I will quickly cover my recent experience in troubleshooting a DB2/LDAP authentication problem in a DB2 DPF database.
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.
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..
Last week, I spent few hours analyzing Index related data in DB2 LUW’s catalog table syscat.indexes and I found something very interesting. In a nut shell, what I learnt is that catalog data that relates to an index’s cardinality in a DPF database is misleading!! Seems like a bold statement..Please read on…