#DateForumTypeThreadPost
12430 Jul 2014 @ 06:40 PDTViewpointReplySession CPU,IO SkewIn Query Monitor, the CPU and I/O skew is calculated based on the last sample period only.  On the Skew tab, all these data points are also for the last sample period.  Skew is calculated...
12330 Jun 2014 @ 07:35 PDTViewpointReplySpool Alert on Viewpoint 14.10There is a known bug with the session spool alert calculation in Viewpoint 14.10.  Even though the screen where you enter the alert indicates the data should be entered in MB, it's actuall...
12227 Jan 2014 @ 07:02 PSTViewpointReplyWriting queries on the tables in the viewpoint serverNo, there is no way to query the Viewpoint server's database directly.  All access to the data today is through Java APIs that are part of the PDK. Thanks, Steve
12102 Jan 2014 @ 08:09 PSTViewpointReplyDBCCONS partition sessionsDBCCONS partition sessions are sessions opened to run console utilities on the database.  Viewpoint used a variety of these connections for monitoring 13.10 and earlier versions of the databas...
12022 Nov 2013 @ 03:00 PSTViewpointReplyclear text passwords to Viewpoint SSL ConfigurationThere are improvements coming for this process in the next Viewpoint release.  For now, this is the only feasible way to implement this.  You can disable the HTTP connector on port 80 in ...
11922 Nov 2013 @ 10:46 PSTViewpointReplyclear text passwords to Viewpoint SSL ConfigurationMike, You can refer to the "Configuring All Teradata Viewpoint Access to be Over SSL" section of the Viewpoint Config guide, which states:   1  Log o...
11811 Nov 2013 @ 11:16 PSTViewpointReplyViewing QueriesThere's not much that can be done to address this in Viewpoint.  Once the query finishes execution and is in responding mode, the SQL is no longer available from the database.
11725 Oct 2013 @ 06:55 PDTViewpointReplyHow to identify the tpt job name from the teradata view point Hopefully this data is in the query band.  Starting with Viewpoint 14.10, you should see query band data showing up for the control sessions when running load/unload jobs.
11609 Sep 2013 @ 07:45 PDTViewpointReplyBest Viewpoint Portlete for Teradata DBAMike, In Metrics Analysis, the AWT metric shows the average number of AWTs in use per AMP on the system.  This is the solid line in the graph.  The min value in the balloon represents th...
11514 Aug 2013 @ 09:04 PDTViewpointReplyCanary Query DetailsThe Canary Response Times portlet is available as part of the standard Viewpoint Self-Service portlet bundle.  It should be available on your Viewpoint server.  However, it's possible...
11413 Aug 2013 @ 08:38 PDTViewpointReplyBulk Load for Viewpoint usersNo, there haven't been any changes.  You should definitely use LDAP to manage 1500 users.  Even if you don't have a corporate LDAP server you can link to, just stand up an instanc...
11308 Aug 2013 @ 09:02 PDTViewpointReplyCanary Query DetailsViewpoint has never used the logheartbeat in dbcmanager.  This data in not available in Viewpoint.  This functionality was replaced by the existing Canary Response Times portlet.
11206 Aug 2013 @ 04:43 PDTViewpointReplyCanary Query DetailsSobhan, Viewpoint doesn't query a specific Teradata table for the canary response times.  It calculates the response times itself based upon how long it takes to execute the SQL you enter...
11131 Jul 2013 @ 08:04 PDTViewpointReplyCanary Query DetailsViewpoint does not access the dbcmngr.logheartbeat table.  Viewpoint opens its own JDBC connection to the monitored Teradata database and executes the canary query itself.  As you noted t...
11018 Jul 2013 @ 08:53 PDTViewpointReplySpool alert setupSpool Rows is the count of the rows put into spool for a query.  Spool Usage is the amount of space that these rows consume.
10918 Jul 2013 @ 08:50 PDTViewpointReplyHow to undeploy portlet from viewpoint 14.01You can just remove the portlet's folder from /opt/teradata/viewpoint/portal/webapps.
10817 Jul 2013 @ 09:38 PDTViewpointReplySpool alert setupYes, there are exceptions for Spool Rows and Spool Usage (in bytes) in TDWM.
10716 Jul 2013 @ 12:03 PDTViewpointReplyRunning cnsremote on PDN remotely from viewpoint serverThis is not supported today.  You should not be running other programs on the Viewpoint node.  Plus, running the cnsremote utility from the Viewpoint node won't have any impact on the...
10616 Jul 2013 @ 11:59 PDTViewpointReplySpool alert setupThe spool for a session has always been visible in the Query Monitor and other Query portlets, but the alert was added in Viewpoint 14.10 as you indicated.  There's no workaround to get th...
10514 Jun 2013 @ 07:25 PDTViewpointReplyData Labs UsernamesThe Data Labs product will recognize when the password is expired and change the password at that time.
10413 Jun 2013 @ 09:14 PDTViewpointReplyDCSDBYou should upgrade to Viewpoint 14.10.  Viewpoint 13.12 is 3 versions old at this point, and doesn't contain the code to clean up any deleted systems.  There are also likely a couple ...
10313 Jun 2013 @ 06:49 PDTViewpointReplyDCSDBViewpoint's DCS process maintains all of the data in the dcsdb database.  There's a data retention policy for each data collector on each monitored system.  There isn't a sing...
10211 Jun 2013 @ 01:22 PDTViewpointReplyAccess to the Update space utility denied in viewpoint remote console.This is documented in the Viewpoint 14.01 Configuration Guide:   Post Installation Starting with Viewpoint 14.01, the Remote Console portlet allows access to run the updates...
10112 Apr 2013 @ 05:23 PDTViewpointReplyViewpoint CompatabilityViewpoint 14.00 is the minimum version that's compatible with Teradata Database 14.0.  The major/minor version of Viewpoint needs to be at least the same or greater than any version of Ter...
10028 Mar 2013 @ 07:33 PDTViewpointReplyLog out action methodYou have the HttpSession object.  You can get the session ID by calling getId() on this object.

Pages