SQL Interfaces in chapter 3." />
Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Fri, 08 Feb 2008 @ 19:37:29 GMT

  <Prev Next>   <<First <Prev

Subj:   Re: PMON for Everyone...
From:   Dieter Noeth

frank.c.martinez wrote:

  Oh, Viewpoint, or whatever that very cool part of Teradata v12 looked so cool for letting users see all that we can't let them see, 'cause we can't let them use PMON. And we were going to beta it, but some sort of legal junk on our side stopped it. I was so looking forward to it. So is there anyone out there who's on the beta and would like to tell us about it?  

Hi Frank,

if you're looking for monitoring/PMon stuff then check those nice UDFs in the syslib database and the "Workload Management API" manual -> SQL Interfaces in chapter 3.

On TD12 you can simply create some macros/views for endusers to monitor their own sessions without PMon:

     SELECT *
     FROM TABLE (syslib.MonitorMySessions()) AS dt


  <Prev Next>   <<First <Prev
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020