(FAQ)DB2 drop table非常慢

(FAQ)DB2 drop table非常慢
原因分析： 1.通过db2 update monitor switches using bufferpool on sort on lock on statement on table on uow on . db2 get snapshot for locks on DB_NAME 结果发现在系统表上有锁: Application handle = 115 l Application ID = l Sequence number = 0001 l Application name = l CONNECT Authorization ID = l Application status = Lock-wait l Status change time = l Application code page = 1386 l Locks held = 22 l Total wait time (ms) = 70945 l l ID of agent holding lock = 114 l Application ID holding lock = *LOCAL.DB2.070629111515 l Lock name = 0x00000500FF0100000000000052 l Lock attributes = 0x00000010 l Release flags = 0x40000000 l Lock