aiaiDBA

加微信获取免费职业规划+学习资料,了解年薪50万的DBA是如何练成的

13718043309

010-86462881

SQL-02128: Sessions still exist, not logged off

SQL-02128: Sessions still exist, not logged off
Cause: A host was not removed ("logged off") from SQLLIB because XA still has sessions associated with that host.
Action: Before calling SQLXDH to drop a host, XA must either drop all sessions for that host or set the "doit_anyway" flag. *Note: This error *msg* is never actually used. The error *number* is used, given as a possible return value to the sqllib xa function sqlxdh.

请先 登录 后评论

1 个回答

小智
SQL-02128:会话仍然存在,不会注销,
.原因:主机没有从SQLLIB中删除(“注销”),因为XA仍然有与该主机关联的会话。,
.操作:在调用SQLXDH以删除主机之前,XA必须删除该主机的所有会话或设置“doit_anyway”标志。*注意:此错误* msg *从未实际使用。使用错误* number *,作为sqllib xa函数sqlxdh的可能返回值给出。,
.
请先 登录 后评论