#DateForumTypeThreadPost
4610 Dec 2015 @ 08:59 PSTDatabaseReplyXML Data Type not definedDieter, you are da Man!  Thanks for being so helpful and generous with your knowledge as always! -Mike  
4508 Dec 2015 @ 03:15 PSTDatabaseReplyXML Data Type not definedJust to clarify further, here is a sample table with a column data type of XML that I can successfully create in Production... CREATE TABLE T_XMLDOCS(     ID     VARCHAR...
4408 Dec 2015 @ 03:08 PSTDatabaseTopicXML Data Type not definedWe are attempting to utilize the new in 14.10 DBQLXMLlocktbl.  We have turned on the feature, so the table is getting populated with data.  Now in an attempt to create the stored procedur...
4304 Dec 2015 @ 07:42 PSTPrivate Forum
4204 Dec 2015 @ 01:32 PSTPrivate Forum
4103 Jul 2014 @ 08:11 PDTGeneralReplycould anyone please tell me can we alter a join index tableI believe the ALTER will not work on the JI.  You'll most likely have to drop the JI is you wish to change its structure.  
4003 Jul 2014 @ 07:01 PDTGeneralReplycould anyone please tell me can we alter a join index tableI believe you'll have to drop the Join Index before you can alter the table on which the JI is built.
3910 Feb 2014 @ 03:18 PSTViewpointTopicTASM and States definition in 14.00We have been using Viewpoint and TASM for a few years now, on both VRR12 and V2R13.10.  We are about to stand up our new production box, which is running V2R14.00 and I noticed that the Viewpo...
3810 Feb 2014 @ 02:43 PSTPrivate Forum
3724 Jan 2014 @ 08:00 PSTViewpointReplyTASM Workloads and frequent demotionsThanks for the quick feedback.  We have regular stats collection jobs in place and we validate the stats once a week to make sure they are all current.  I'll check these specific quer...
3623 Jan 2014 @ 02:43 PSTViewpointTopicTASM Workloads and frequent demotionsWe have TASM setup to demote user queries from USERS-SHORT to USERS-MEDIUM and then USERS-LONG, after some CPU seconds consumed threshold.  We are seeing a number of queries get sent to our US...
3508 Jan 2014 @ 11:29 PSTDatabaseTopicSpool Space not being releasedWe had an issue recently where in an attempt to build fairly small Join Indexes on a fairly large table (2TB), the build would blow out the spool limit.  even after increasing the spool limit ...
3422 Nov 2013 @ 01:53 PSTViewpointReplyclear text passwords to Viewpoint SSL ConfigurationThanks Stever.  That is the exact process we followed and the new secured connection does work.  Unfortunately, we just can see how to disable the old non-secured connection, which also w...
3321 Nov 2013 @ 04:14 PSTViewpointTopicclear text passwords to Viewpoint SSL ConfigurationWe have Viewpoint v14 and unfortunately when users logon to the server, their passwords they use to connect to the viewpoint server is being sent in clear text.  Our security folks are not hap...
3209 Sep 2013 @ 07:59 PDTViewpointReplyBest Viewpoint Portlete for Teradata DBAPerfect, very helpful!  Thanks for clarifying that for me.  
3109 Sep 2013 @ 07:26 PDTViewpointReplyBest Viewpoint Portlete for Teradata DBARegarding the Metrics Analysis Graph, can you clarify for me what the Y-axis of the yellow AWT graph line tells us?  The value for instance has bounced between 14 and 0.13 over ...
3027 Aug 2013 @ 02:46 PDTDatabaseReplyNegative maxperm DBCThis can occur when your restore after a sysinit with a backup from a system that has a larger configuration than the system being retored.  For example, you restored a DBC restore from your p...
2927 Aug 2013 @ 07:59 PDTViewpointReplyViewpoint - 14 - Query Monitor issueWe experienced the same issue while running Viewpoint 14.0 against our 13.10 Teradata system.  Both the SQL and EXPLAIN tabs where disabled completely.  After logging on as root to the Li...
2831 Jul 2013 @ 07:55 PDTViewpointReplyNo Data in Query MonitorI verified all the settings were correct in Viewpoint.  I then stopped and started the Viewpoint services on the Linux box.  That didn't fix it immediately but I checked again in...
2729 Jul 2013 @ 12:35 PDTViewpointReplyNo Data in Query MonitorWe have noticed a similar issue in the Teradata Viewpoint Query Monitor portet.  We've been using it for a couple years now and just a few weeks ago I noticed that when we click on the ses...
2618 Jun 2013 @ 01:30 PDTViewpointReplyTASM Ruleset Export/ImportIn Viewpoint, which monitors both our prod and stage systems, I can right-click Export the Ruleset in Prod and save it to my machine.  However, when I attempt to import that saved file is when...
2518 Jun 2013 @ 01:14 PDTViewpointTopicTASM Ruleset Export/Import I'm trying to export our current TASM Ruleset from our production system and import it onto our staging system.  I keep receiving the following error.   Cannot import rules...
2430 May 2013 @ 07:59 PDTDatabaseTopicPartition EliminationFor many years now we have seen the optimizer NOT chose partition elimination for a query when that query qualifies on a date column that is the partitioning column, UNLESS we are qualifying on a h...
2330 May 2013 @ 07:16 PDTViewpointTopicTASM - Priority Distribution and CPU LimitI vaguely recall setting up TASM years ago before Viewpoint and we were encouraged to keep back a small percentage of CPU from the system.  I think we may have set the CPU limit for the system...
2207 May 2013 @ 07:26 PDTDatabaseTopicARCMAIN to backup a database but exclude all table data.I regularly perform the following type of backup to get the database level backup so that I can lay down these databases first, in a full restore.  I can then kick off multiple restore jo...

Pages