才开始学习DB2需要一个问题请教大大们直接连接数据库执行select count(*) from a where plag = '1';报锁表... Physical database connection acquired for: 48.1015:14:37 [SELECT - 0 row(s), 0.000 secs] [Error Code: -911, SQL State: 40001]...
显示全部才开始学习DB2
需要一个问题请教大大们
直接连接数据库执行
select count(*) from a where plag = '1';
报锁表
... Physical database connection acquired for: 48.10
15:14:37 [SELECT - 0 row(s), 0.000 secs] [Error Code: -911, SQL State: 40001] The current transaction has been rolled back because of a deadlock or timeout. Reason code "68".
... 1 statement(s) executed, 0 row(s) affected, exec/fetch time: 0.000/0.000 sec [0 successful, 0 warnings, 1 errors]
但是执行
select count(*) from a where plag = '-1';
或者
select count(*) from a where plag is null;
就没问题
表a的数据量很大,
请问这个如何解决,
谢谢!
收起