All Forums

Discussion and support for Teradata Viewpoint and the Portlet Development Kit (PDK). For articles, blogs and more, see the Viewpoint section of the site.

You must login to post to the forums.
Canary Query Details Topic by andydoorey 01 Mar 2011 viewpoint, canary query

Can anyone give me details of how the canary query frequency works in viewpoint?

The issue I'm having is that we want to measure response times for all workloads using the canary queries in viewpoint. I can get it to work for short and medium queries, but our long workload can have very long delays, often over an hour (I know this isn't good for the users, but that's how it is!).

I want to run a canary query in this workload every 15 minutes. The problems I have are:

1) A new canary query doesn't start running whilst one is in progress (i.e. in the delay queue)

5675 views
8 replies, 2 weeks ago
SQL and Explain sometimes not visible in query monitor Topic by Duri83 1 month ago viewpoint; session monitor; explain; plan; collection; rates; rate;

Hello VP experts,
We have noticed a weird behaviour after VP and DB upgrade to version 14. Our VP is now V14.00.00.05-b49 and DBs are on 14.00.02.05 and 14.00.03.03.
The problem is that sql and explain texts are quite often not visible in VP (usually when you need to see they are not there ^_^)

352 views
6 replies, 1 week ago
Viewpoint initiation: creation of multiple users Topic by tgorner 1 week ago viewpoint, users, viewpoint users

Hi gurus,
I have a group of users who only need to monitor their queries via Viewpoint. They may see each other's queries, they would not have "abort session" rights anyway.
I see 2 possible solutions:

10 views
0 replies
Password Age Alerting via Viewpoint Portlet Topic by cpolikowsky 2 weeks ago viewpoint, password age

I don't see anything in viewpoint V14.00.00.05-b49 by default.  Has anybody created their own portlet to do something like that.  I would like to have a mechanism that emails an alert at X days to user, disables account after Y days and sends an alerting saying account is disabled.  Currently we are doing this through a ksh script and bteq.  Any ideas?

7 views
0 replies
SESDELAYED vs DELAYED Topic by kerrg 1 week ago

Okat so I'm running TD13.10 with Viewpoint 14.01.  I have setup 3 Utilitiy limit control's as below
Loads: which is all types of loads with limit of 5.
Exports: which is all types of exports with limit of 10.
All Utils: which is for loads and exports with a limit of 10.
This allows for the following to happen.
5 loads and 5 exports

11 views
0 replies
Workload Designer and Viewpoint 14 with RDBMS 13.10 error Topic by MarkYoung4 18 Apr 2012 viewpoint, tdwm, database version does not match

Hi, we have just upgraded our Teradata system from 13.0 to 13.10 and installed Viewpoint for the first time, running version 14.0. When we go to the Workload Designer, we are getting the following message, "TDWM database version does not match the Teradata version for this system." and from Workload Health, we get the following, "No active ruleset available".

2817 views
6 replies, 3 weeks ago
Disable Execution of the Data Mover Job from Viewpoint Topic by PatelSatish 3 weeks ago viewpoint, data mover

Hi,
 
Is there any setting in viewpoint or data mover that will prevent execution of data mover job from viewpoint portlet.
We want to create the data mover job from viewpoint  but execution must be done via command line on data mover.
 
Appreciate your input.
 
Satish Patel

1 view
0 replies
DATAMOVER Topic by Krupakaran 1 month ago

Please guide to resolve the below issue facing in datamover in viewpoint at the time of saving datamover job.
The command took longer than expected, please run the command again.
 

190 views
4 replies, 1 month ago
ControllerContext get PortletSession ID Topic by KontantinK 1 month ago

Hello,
how can I get over the ControllerContext the Portlet Session ID?

263 views
2 replies, 1 month ago
Log out action method Topic by KontantinK 2 months ago

Hello,

452 views
4 replies, 1 month ago
Viewpoint Compatability Topic by Greyghost 1 month ago

What is the minimum version of Viewpoint that is compatable with the Database 14.0?
 
Thanks!
 
Paul

309 views
1 reply, 1 month ago
Top Sessions Graph Topic by Denmark 1 month ago top, session, graph, metric, threshold

On Viewpoint Query Monitor's Top Sessions Graph of the Summary view, two metrics are represented:  one by the length of the bar and the other by the color or shading of the bar.  The user chooses a metric left of the graph.  How is that metric displayed (length of bar or color/shading)?  What is the other metric?

343 views
1 reply, 1 month ago
Teradata DBS Version Info Topic by skd2day 1 month ago viewpoint

Is there a Viewpoint portlet that displays the equivalent of ctl screen version:  Running PDE, DBS, Gateway versions, etc.? 
Thank you!

270 views
1 reply, 1 month ago
Getting Viewpoint to work on TD Express 13.10 40Gb VM Topic by terrydata 2 months ago

Hi

I've downloaded the 40Gb VMWare instance of Teradata Express 13.10.

The Teradata database works fine, I can connect to it with BTEQ and from SQL Assistant and Teradata Administrator on the Windows machine.

I just can't get Viewpoint to work.

I've tried starting various services:

246 views
0 replies
Viewpoint alert for PJI on session Topic by bakster 2 months ago viewpoint, alert event

I am looking for a way to setup a sessions alert when a PJI threshold is exceeded.  Are there plans to include the PJI metric as part of a sessions alert?  Is there another way to setup such an alert?    Thanks! 

266 views
0 replies
Error while accessing Workload Designer Portal in Viewpoint Topic by tejas.dalvi@gmail.com 2 months ago viewpoint

Hi,

 

I am getting an error while accessing Workload Designer portlet

 

"You are not authorized to view rulesets on any system"

 

All the access related to portlet are given.

644 views
1 reply, 2 months ago
Penalty Box Topic by macktd 2 months ago

I'm Novice to Viewpoint,
When we need Penalty box in work load?
Regards,- mahesh

581 views
1 reply, 2 months ago
TVS Portlet Topic by VandeBergB 2 months ago tvs

The TVS portlet shows me the 'balance' of the cylinders allocated to each bucket, hot, fast, medium.... Is there a way to identify what data is where, i.e. by database or table?
Thanks!

375 views
1 reply, 2 months ago
690 views
2 replies, 3 months ago
Alert on DML Queries Topic by Waris 07 Feb 2013

 
Dear Member
is there any mechanism/utility by which we can trigger an ALERT immediately via email or anything whenever a DML query is fired on any specific databases
 
 

760 views
3 replies, 3 months ago
PDCR Viewpoint Alert Topic by oahmad1 19 Sep 2012

Hello,
      I started receiving this alert 2 days back from our viewpoint server and was wondering if anyone has seen this before and can point out where to start looking to see what's wrong.
Any help is greatly appreciated.
Thanks,
-Omer
 
Job PG2_PDCR_Daily Step 312 failed with status 8 
Description: PDCR JOB FAILURE

1168 views
2 replies, 3 months ago
Remote management of VP users and accessrights Topic by mv5492 30 Jan 2013

I need the ability to create and manage VP users from a remote UAM application. I do not want to to setup and manage an LDAP directory for our user population so I want a solution where I can manage the native VP security. I have pdk version 14. It looks like   there are methods (class IdentityManagerImpl) to support the idea.

747 views
1 reply, 3 months ago
Viewpoint - 14 - Query Monitor issue Topic by dtfcards 29 Nov 2012

We are experiencing issues with query monitor where we run a piece of SQL and it will run for close to 15 minutes but the SQL and Explain Tabs are not selectable.  Sometimes the Explain tab is selectable but it does not show us what step its currently running or have the times or rows filled in.   

1120 views
5 replies, 4 months ago
How to give only abort query rights to developers through portlet Query Monitor in Viewpoint 14.00? Topic by Sidhharth 07 Jan 2013 viewpoint 14.00

My client wants me to grant developers, through "Query Monitor" portlet in viewpoint, the right to abort queries which blocks other queries or ETL loading.

Below are the steps I did through Viewpoint 14.00:

1) Created user (same as Teradata database user) (Admin ---> User Manager ---> Add User)

1949 views
3 replies, 4 months ago
Workload management in a multi-client data warehouse Topic by hyma 20 Dec 2012

Hi,
In a multi-client data warehouse the clients insist on ensuring the percentage of CPU granted to them.
Put it simply: Client A has e.g. 60% CPU and Client B 40%.
Each client should have 2 WDs defined: one for tactical, one for non-tactical.
What is the best way to do this with viewpoint V14.00/SLES10?

1820 views
4 replies, 4 months ago

Pages