急问个关于INFORMIX锁的问题

gzhu

我这里是 informix 9.4  HDR, AIX5.3的环境.
前几天online.log 中报

06:29:38  dr_idx_send: can't lock 0x801985, iserrno 154

06:29:38
06:29:38  IBM Informix Dynamic Server Version 9.40.FC7     Software Serial Number AAA#B000000

06:29:38  Assert Warning: Cannot send index 'master_dms:"root".catalog#catalog_idx2' to Secondary
06:29:38   Who: Session(1020481, root@baly, 0, 7000000c64f077
                Thread(1079183, dr_idx_send, 7000000b1733bb8, 6)
                File: rshdr.c Line: 7310
06:29:38   Results: Index will be unusable on Secondary
06:29:38   Action: Drop and recreate on Primary
06:29:38  Stack for thread: 1079183 dr_idx_send

现在想删除表catalog,
执行如下操作,
et isolation dirty read;
set lock mode to wait 20;
drop table catalog;

结果报如下错误,表删除不了,而且删除表中记录也不行.
242: Could not open database table (root.catalog).
154: ISAM error: Lock Timeout Expired


各位帮忙看看.

gzhu

113:isam error: the file is locked
242:could not open database table(×××××)
用select partnum from systables where tabname = 'locked table' 可以找到partnum,转换到16进制后，用onstat -k |grep partnum后可以找出ADDRESS，
用onstat -u |grep ADDRESS 就什么都看不到，
但用onstat -x, 然后用onlog -n 可以看到这个进程是在DRSYNC.
不知怎样处理才好.