- 论坛徽章:
- 0
|
我对aix和db2都不熟,用etl抽取数据的时候半天没结果,这时用select 语句查询发现其中两个表有下面类似的提示:select * from ptt
[IBM][CLI Driver][DB2/AIX64] SQL0911N 因为死锁或超时,当前事务已被回滚。原因代码为 "68"。 SQLSTATE=40001
500 rows selected because of ERROR.
论坛里的精华文章也看了,但是还是没底~
试这个命令也报错,对于报错的原因也十分迷惑。。。数据库名一定没错的。
db2 update monitor switches using lock on
[测试110:**]> db2 get snapshot for locks on db mydbname
SQL0104N An unexpected token "mydbname" was found following "DB". Expected
tokens may include: "GLOBAL". SQLSTATE=42601
[测试110:**db2 get db cfg for mydbname有以下结果:
Max storage for lock list (4KB) (LOCKLIST) = 200000
Interval for checking deadlock (ms) (DLCHKTIME) = 10000
Percent. of lock lists per application (MAXLOCKS) = 100
Lock timeout (sec) (LOCKTIMEOUT) = 30
求高人指点啊,比较急!先谢了
[ 本帖最后由 jiangli1984 于 2007-10-27 17:17 编辑 ] |
|