在使用Teamcenter经常发现账号有异常,常规的方法是检查账号状态,删除日志文件,然后重新登录。以下是从数据库里删除被锁用户:
一、查询被锁用户状态
select count(*) from infodba.pom_m_lock where process in (select pm_process_id from infodba.pm_process_list t1 ,infodba.ppom_session t2
where t2.pprocess_id = t1.pm_process_id and puser_name='‘TC账号’);
二、删除被锁记录
delete from infodba.POM_M_LOCK where process in (select pm_process_id
from infodba.PM_PROCESS_LIST t1,infodba.ppom_session t2
where t2.pprocess_id = t1.PM_PROCESS_ID and puser_name=‘TC账号’);
-----------------------------------
一般在pool manager里结束用户会话
看表明就m_lock r_lock. 如果没锁查询该表是空的,