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 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

Hard-Coding Ports for HADR When Setting up Multiple Standbys

While implementing HADR for multiple standbys, there could be potential issues if the HADR ports are not hard-coded on the HADR settings. Here’s what the issue looks like: The primary is The standbys are: 1st – 2nd –... read more