Hi, I am a little confused in how to setup a simple workload period and configure it for changes to allow different workloads to have different resource allocations at different times of the day. I have reviewed the Workload Designer section of the User guide but it just confuses me.

Our business users just started using the SQL Scratchpad in Viewpoint for their adhoc queries and I've noticed that their sessions remain in the responding state after they run a query. I am not sure why they don't go to the idle state but since they are in responding they never go away. Has anyone else run into this situation?

Thanks in advance for any help.

Hi

This might be very basic question but I have to ask as I am unable to configure Viewpoint :(

I am trying to setup Viepoint, the server is already installed.

I logged in using Admin and then created TERADATA SYSTEM using manual guide. I also created viewpoint user on Teradata side and granted access as explained in manual.

Teradata Developer Exchange is now hosting all the Teradata-related technical discussion forums. These forums are replacing the previous legacy Teradata discussion forums, but if you cannot find an answer to a topic here, please search the previous forums before posting.

Who can post here? Any registered user. But we have a few guidelines for you.

- Search the forums (using the sidebar at right) before posting a question.
- But don't be afraid to ask questions. We're friendly around here!

We are new to Viewpoint and have migrated all of the Alert Policies we had setup in Teradata Manager to Viewpoint.  We see that the email message alerts that we receive from Viewpoint are much different than what we received from TM. 

HI ALL,

I found there were a viewpoint copy in express 13.10. And there also are a ready db in 

postgresql. How can i light up viewpoint for 13.10 dbms? I follow following steps, but 

doesn't work:

1. start vmware

2. check the pdestate

3. /etc/init.d/postgresql start

4. /etc/init.d/dcs start

    /etc/init.d/tmsmonitor start

I want to publish the usage charts on our sharpoint site, just trying to see if any one did that and how.

Hi, Can someone advise if it is possible to remove the FICON Nodes from being analysed in the Metrics Analysis Portlet?

Hi everyone,

This may seem like a silly question, but I am still new to PDK and Viewpoint.
Can Teradata Development Porlet (Come with PDK) be setup for real Data Collection?
- If yes, how can we achieve it?
- If no, I believe we need to have the actual production Viewpoint that has DCS activated. Again, how can we integrate them into our developing system?

Query Groups are great for allowing BI Tool admins to monitor tool specific sessions that are currently active and rewind to go back in time. However, Query Spotlight is a great tool to spotlight sessions that may have been TASM aborted because of excessive Spool or CPU consumption.

hi all,

we are getting false alerts from VP as system health - Down, as per the article

http://developer.teradata.com/blog/stever/2011/08/understanding-the-system-health-equation

only in below situations system health should be down

Am looking for a basic example of how to configure and test email alerts in Viewpoint.  Have never used Viewpoint alerts of any kind before, though we did use some Teradata Manager alerts.

Hi,

I am trying to analyse the load on our box for comparison with pre and post upgrade but the query volumes I am extracting are no where near the volumes being reported in Viewpoint by an order of magnitude. The volumes are too low.

View point is reporting c.1M queries I am extracting from DBQL  c100k.

I am using DBC.DBQL_ALL and DBQLogTbl

Hello everyone,

I'm running ViewPoint V14.00.00.05 and it seems that Local Exception button does not work for me neither from Exceptions nor from the workload window. I have tried it with Chrome, IE and Firefox. Had anyone had a chance to run into the same issue? Any solutions (besides going back to tdwm)?

Thanks,

Hi,

I have experienced some difficulties when trying to change the priority of a session (Viewpoint 13.11 previously and now Viewpoint 14):

sometimes it works, most of the time it doesn't !

I can change the priority for a session, and the next attempt is not even possible, with a somewhat  "inactivated display", 

i mean no access at all to the next steps...

I've run:/var/opt/teradata/viewpoint-13.10.00.02/bin/viewpoint start

and successfully started viewpoint, but for some reason I don't have "localhost" nor do I have the developers created a bookmark on firefox to navigate to the viewpoint instance.

can anybody suggest a way to navigate to viewpoint please?

Is there's a way to customize the Mail alerts Generared by VP  14:

For Example SESSION alert [Blocked time] generates the following mail:

Hi,

i want to create a report with number of queries running in the different categories i.e adhoc short,long,tactical etc.

We find this classification in the 'Workload' column in the viewpoint.

which dbc table or viewpoint option can i use to create this report. I can get the query info from from

DBQLObjTbl

DBQLOGTbl

After recent upgrade to TD13.10 with viewpoint V13.11.00.04-b59, we have noticed the delay queue users getting released out of order where as they should have been getting release on first come first serve basis.

We have relocated one of our Viewpoint servers within our organisation.

Is there a quick way to wipe the previous set-up off the server?

we have seen numorous data collector alert like below and false alarm on DB restart because of read time out on VP version 13.12. is there any relief doe the same on VP version 14 ?

Data Collector Id=17

Data Collector Name=Canary Query

Error Occurred=true

Error Message= Read timed out

Thanks

Abhijit

Hi there,

I'm trying to delete some workloads that we have in our TASM ruleset. These workloads are not being used,have no classification criteria,and no exeption criteria.

When I try to delete them I'm getting an error message : You cannot delete a workload that is the target of an exception's "Change Workload" action.

Hi All.  We consistently receive 3192 (No utility partitions available) errors for some of our Data Collectors. 

        [Teradata Database] [TeraJDBC 13.10.00.18] [Error 3192] [SQLState HY000] No utility partitions available. Try later.

I've been told this is directly related to hung sessions in the DBCCONS partition.