Aish Khare

Sr. Db2 DBA

Aish Khare is a Sr. Db2 DBA at XTIVIA in Colorado Springs, Colorado. He is responsible for managing, monitoring, tuning and troubleshooting db2 databases for a wide range of clients. Aish has over 11 years experience with Db2 LUW databases, and is an IBM Certified Database Administrator. He has a Masters in Engineering from City College, CUNY. Aish also publishes blogs for XTIVIA on the Virtual-DBA site to help customers understand Db2 better. He is a regular attendee at IDUG conferences and recently presented at IDUG EMEA in Malta.

Why You Should Attend IDUG: 2023 North America Db2 Tech Conference

IDUG is a hugely popular Db2 conference that Db2 enthusiasts look forward to attending every year. They have several of these around the world. This year, we have IDUG events in NA, EMEA, Australasia and India. Professionals from the US and Canada often attend the... read more

How to Navigate IBM Passport Advantage to Download Software and Licenses

IBM Passport Advantage is the offering that can be used by customers as a one-stop-shop to view their IBM licensing entitlements, purchase orders and a plethora of other information. Oftentimes, when you need to download the latest binaries for a product that you need... read more

Finding the Size of Individual Indexes

Recently I had a client ask me if there was a way to calculate the size of individual indexes on a table and how to interpret what is reported by the table function sysproc.admin_get_index_info. The client asked whether the value is reported as a sum per table or per... read more

How and When to Run the db2chgpath Utility

Recently while applying a fixpack, I encountered this error: ERROR: An error occurred while setting DB2 runtime path. Contact a technical service representative. Setting DB2 library path :…….Failure DB2 Fix Pack Update log file finished at: Sat Aug 1... read more

Setting Up HADR with Two Auxiliary Standbys

In my previous blog, I presented some of the issues you can run into when setting up one auxiliary HADR standby and a potential solution. This blog discusses setting up two auxiliary standby databases in detail. Let’s start with all the information we need to... read more

Investigating TSAMP Details in Already Setup Environment

There are several scenarios where you might need details to re-build TSAMP. If TSAMP did not start properly after an upgrade or even while troubleshooting, the option to open a case with IBM and get root cause analyzed takes time. In many of these scenarios,... read more