软件开发数据库
sysstat包锁等待问题，哪位大侠遇到过
最近系统发生了一次严重的锁等待，从抓取的快照来看是有进程长时间的持有nullid.sysstat包的s锁，之后另一个进程申请了一个x锁，导致后面的应用申请s锁的时候全部锁等待。 哪位大侠能给讲一下什么情况下需要对sysstat包加s锁，并持续很长时间（超过10分钟...显示全部
查看其它 7 个回答weiruan85的回答
DETAILS:
Question:
What is NULLID.SYSSTAT and when is it invoked. We have an OEM
monitor product that showed it had over 2 minutes in TCB wait time for
a stored procedure. I don't know if that is cumulative or one occurance.
Answer:
NULLID.SYSSTAT is a DB2 Connect package. In particular, it is
used by Connect's Call Level Interface (CLI) layer when CLI needs
to do some static SQL (such as SQLGetLength). There are some internal
SQL statements that CLI does statically in order to improve performanc
used for cli application . :)
Question:
What is NULLID.SYSSTAT and when is it invoked. We have an OEM
monitor product that showed it had over 2 minutes in TCB wait time for
a stored procedure. I don't know if that is cumulative or one occurance.
Answer:
NULLID.SYSSTAT is a DB2 Connect package. In particular, it is
used by Connect's Call Level Interface (CLI) layer when CLI needs
to do some static SQL (such as SQLGetLength). There are some internal
SQL statements that CLI does statically in order to improve performanc
used for cli application . :)
浏览513