|
|
Archives of the TeradataForum
Message Posted: Fri, 08 Feb 2008 @ 19:37:29 GMT
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
Dieter
| |