PDA

View Full Version : Co ai biet LOCK TIMEOUT DB2 giup voi !!!!



hoangthuong
07-10-2005, 18:11
Chao ban!

Khi toi viet mot procedure trong DB2 toi set tham so SET CURRENT LOCK TIMEOUT WAIT 5. Neu xay ra lock thi cho 5 giay roi thuc hien tiep procedure.

Nhung sau khi procedure cho 5 giay roi thi thoat ra ngoai luon, khong the thuc hien tiep duoc.

Mac du toi da co dat execption continue cho no, nhung van khong the tiep tuc duoc.

Sau khi wait la out lien.

Thanks.