Most of the DB2 deadlocks happen with the contention of DB2 locks. Am I correct ?
Can a developer specify locks and control them at program level ?
I mean, Developers usually specify the locks in the form of ISOLATION LEVEL at the BIND parameter. Depends on the usage of the table data in the program, the isolation level will be specified. I feel that, the lock escalation happen automatically by DB2 sub-system
What are the various other scenarios DB2 deadlocks happen ? Please list out ... Please tell me, How do you approach DB2 deadlock issue in production and possible solutions to avoid them in future.