Monitor Partition


Monitor Partition

We are getting alert- Check for a system hang on the monitor partition.  VP was unable to collect data for SQL Explain info.

Is there any query to identify system is hung due to a particular session and corresponding partition?

Tags (1)
Teradata Employee

Re: Monitor Partition

You can query DBC.SessionInfoV to see which sessions are currently logged on to the Monitor partition. There is a limit to the number of Monitor sessions allowed per PE (IFPNo in SessionInfoV).