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
|
|
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
|