4
DB2: Find out current locks, long transactions etc. [snapshot]
source link: https://blog.jakubholy.net/2006/10/19/db2-find-out-current-locks-long-tr/
Go to the source link to view the article. You can view the picture content, updated content and better typesetting reading experience. If the link is broken, please click the button below to view the snapshot at that time.
DB2: Find out current locks, long transactions etc. [snapshot]
October 19, 2006
To find out current locks in a DB and other information about its current state, you need to take a "snapshot":
Look into the resulting mydatabase_snapshot.txt for "Application ID holding" (if there is a lock, this will read the ID of the aplication holding the lock). To find long queries [that are currently running], look for "Executing".
db2 "attach to user using "
db2 "get snapshot for applications on " > mydatabase_snapshot.txt
Look into the resulting mydatabase_snapshot.txt for "Application ID holding" (if there is a lock, this will read the ID of the aplication holding the lock). To find long queries [that are currently running], look for "Executing".
Are you benefitting from my writing? Consider buying me a coffee or supporting my work via GitHub Sponsors. Thank you! You can also book me for a mentoring / pair-programming session via Codementor or (cheaper) email.
Allow me to write to you!
Let's get in touch! I will occasionally send you a short email with a few links to interesting stuff I found and with summaries of my new blog posts. Max 1-2 emails per month. I read and answer to all replies.
Recommend
About Joyk
Aggregate valuable and interesting links.
Joyk means Joy of geeK