DETAILS:Question:What is NULLID.SYSSTAT and when is it invoked. We have an OEMmonitor product that showed it had over 2 minutes in TCB wait time fora stored procedure. I don't know if that is cumulative or one occurance.Answer:NULLID.SYSSTAT is a DB2...
显示全部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 . :)
收起