as400 db2 锁表 如何解锁?
as400 db2 锁表 如何解锁? as400?db2??锁表??如何解锁?
[解决办法]
用管理员权限登录
1)查锁:
SELECT * FROM SYSIBMADM.SNAPLOCK where lock_mode like '%X%';
2)从agent_id查询相关进程:
list applications;
3)从application id查找Process ID of client application:
get snapshot FOR APPLICATION APPLID 190.2.224.1.56056.110510075430;
3)杀锁:
force application(17873);
4)查找由于两阶段提交错误造成的indout transaction:
list indoubt transactions with prompting