What are the advantages and disadvantages of using row-level locking in DB2?

Row-level locking in DB2 provides granular control over data access, allowing transactions to lock only specific rows rather than entire tables. This approach reduces contention and improves concurrency by allowing multiple transactions to access different rows simultaneously. However, row-level locking also introduces overhead due to the need to manage individual locks for each row, and it may lead to lock escalation in situations where a transaction locks too many rows, impacting performance. Additionally, managing row-level locks adds complexity to application development and may require more system resources compared to other locking mechanisms.