Resources

Lock wait analysis: using db2pd

Topic: Code Place

Subtopic: DB2 for LUW



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.

 



Click Here to Download

NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.