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