Code Place

Lock wait analysis: using db2pd 

Aug 08, 2011 05:03 AM

A sample Unix shell script (korn shell) for analysis of lock waits in DB2 LUW. The script is based on information gathered from db2pd.

Side note: the script will run properly and without producing any errors if you run it under korn shell.

Also make sure that you adapt the script to run db2pd against your own database. Or simply replace "-d sample " by "-d ${1} " so that you can pass the database name as a parameter.


txt file
lock_wait.txt   1 KB   1 version
Uploaded - Jun 05, 2020


Mar 17, 2014 09:28 AM

Thanks for thsi script !!!


Script is nice. Is it possible to get the information of Lock Owner in this script ?


Apr 04, 2012 06:37 PM

Script does not work

Hi I have tried running the script it failed with following error.

test.lock[7]: 0403-057 Syntax error at line 9 : `;' is not expected.

Please fix the error.




Related Entries and Links

No Related Resource entered.