How to troubleshoot DB2 lock waits

Monitoring lock waits is a great way of measuring query performance slowdown. Lock waits are a normal part query processing but when the lock waits start taking longer than normal , it’s a sign of trouble. According to the DB2 LUW documentation a lock wait is defined as “A lock wait occurs when one transaction (composed of one or more SQL statements) tries to acquire a lock whose mode conflicts with a lock held by another transaction” Common symptoms of lock waits taking longer than normal are: Applications are not completing tasks SQL query performance slowdown Lock escalations. A small... Read more →

TSAMP command - lsrg and awk

Question: How can I list out information in a tabular format using the TSAMP lsrg command ? I’d like to parse the information. This is part of setting up a monitoring tool Answer: The lsrg command is useful for listing information about resource groups in IBM Tivoli System Automation for Multiplatforms (TSAMP). There are different ways of using lsrg command. Combining lsrg and awk will list out the member resource information. With columns : Class:Resource:Node[ManagedResource] Mandatory MemberOf OpState WinSource Location AutomationDetails[CompoundState] [ObservedState] [BindingState] lsrg -m -D, -V | awk -F, '{print $1,$2,$3,$4,$5,$6,$7,$9,$10}' Read more →