Can we create bteq monitor partition session with defined PE number?
The Teradata Database channel includes discussions around advanced Teradata features such as high-performance parallel database technology, the optimizer, mixed workload management solutions, and other related technologies.
Re: Can we create bteq monitor partition session with defined PE number?
128 monitor sessions on the system. (I think it is a max of four on a PE - not sure).
No, you cannot logon to Monitor partition using Bteq. You have to write your own program to use monitor partition. note that most monitor partition data is available using the syslib functions (MonitorPhysicalResouce etc.). They return some data in slightly different formats etc. but all/most of the data is there.
Ward Analytics Ltd - information in motion www: http://www.ward-analytics.com