ADM5500W  DB2 is performing lock escalation.  The total number of locks
currently held is "1034", and the target number of locks to hold is "517".

I am getting above warning in notification file...how i can remove this??

related parameters are..

 Database heap (4KB)                            (DBHEAP) = 1200
 Size of database shared memory (4KB)  (DATABASE_MEMORY) = AUTOMATIC
 Catalog cache size (4KB)              (CATALOGCACHE_SZ) = 363
 Log buffer size (4KB)                        (LOGBUFSZ) = 179
 Utilities heap size (4KB)                (UTIL_HEAP_SZ) = 66568
 Buffer pool size (pages)                     (BUFFPAGE) = 1000
 Extended storage segments size (4KB)    (ESTORE_SEG_SZ) = 16000
 Number of extended storage segments   (NUM_ESTORE_SEGS) = 0
 Max storage for lock list (4KB)              (LOCKLIST) = 100
Interval for checking deadlock (ms)         (DLCHKTIME) = 10000
 Percent. of lock lists per application       (MAXLOCKS) = 60
 Lock timeout (sec)                        (LOCKTIMEOUT) = -1

Thanks

Pawan

You need to kill the application that is holding locks!

Please view the document below:

http://www.dbatodba.com/db2/problem-resolution/locks/lock-wait-and-lock-timeout