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.

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

SQL0443N After Db2 Fixpack Upgrade

After applying a Db2 fixpack, you can get SQL0443N when calling the get_dbsize_info() stored procedure. Cause and resolving the problem: get_dbsize_info() uses the system catalogs internally which do not get updated as part of a fix pack update, and should be updated... read more