Archives of the TeradataForum

Message Posted: Mon, 19 Dec 2005 @ 15:58:56 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

We received a mini cylpack(mcp)message on two of our 4 nodes late last week. I have the following general questions:

Can I identify the database/user causing the mcp by looking at active sessions when the mcp initiated?

Can a Select statement initiate a mcp?

Can skewed spool initiate a mcp?

Can moving space with a modify db imitate a mcp?

Can collect statistics initiate a mcp?

What utility is best to review details on the mcp? ie involved AMP, length of time for mcp process, possibility of another mcp occurring?

Thanks

Bill H

	<Prev	Next>		<<First	<Prev	Next>	Last>>