DB2 LUW Locking Troubleshooting: How to Find the Blocker and Waiter
Locking is one of the most common causes of application slowness in a production database environment. From the application side, the symptom may simply appear as: "The application is hanging." or: "The transaction is taking too long." But from a Db2 DBA perspective, the real question is: Who is waiting, who is holding the lock, and why? In this article, I will walk through a practical DB2 LUW locking investigation using db2pd and Db2 monitoring table functions. The examples
Jha Chandan
2 days ago
Key Features Every Modern DBA Should Master
In today’s digital world, data is the new oil and Database Administrators (DBAs) are the guardians who keep it secure, available, and...
Jha Chandan
Sep 2, 2025
Orphaned Users in SQL Server
In SQL Server, an orphaned user is a database user that is not mapped to a valid SQL Server login at the instance level. It is a user...
Jha Chandan
Aug 30, 2025
MSSQL DBA Responsibilities
A Database Administrator (DBA) is responsible for designing, implementing, and maintaining the database system, as well as establishing...
Jha Chandan
Aug 24, 2024
DBT5521N The db2ckupgrade utility failed because the utility was not invoked on the instance being upgraded.
Sometime you've encountered with below error/issue during version upgrade check in DB2. Well, while executing db2ckupgrade sometime gives...
Jha Chandan
Jun 1, 2024
