#DateWhereItemComment
3712 Mar 2013 @ 08:03 PDTUDAStay in sync - Introducing Teradata Unity 13.10 Hi Jeff, Does Unity require dedicated hardware or, is there a software only option that could be installed on any system. Appreciate your response. -Abraham
3609 May 2012 @ 09:08 PDTcarrie's blogChanges to the TASM AMP Worker Task Event in Teradata 13.10Thanks for the detailed information, this would be very helpful.
3509 May 2012 @ 08:59 PDTUDAA reliable rebooting mechanism for Data Mover ServicesGood starting point and would also help if we can add the TMSM components into the sequence.
3410 Apr 2012 @ 07:12 PDTViewpointTeradata Alerts / CAM 14.0 releasedGary,this was not a technical issue,just aa architecture situation since we gave up the windows servers after moving to Viewpoint and hence the disadvantage.
3307 Apr 2012 @ 10:38 PDTcarrie's blogTeradata 13.10 Statistics Collection Recommendations Carrie, thanks for the explanations. Would it be possible to understand the precedence of datatypes used internaly while parsing a multicolumn stats definition longer than 16bytes.
3207 Apr 2012 @ 10:22 PDTViewpointTeradata Alerts / CAM 14.0 releasedAnother useful and helpful enhancement. We used to run scripts to capture sql,abort session and alert user with the aborted sql. we missed that capability since we moved to viewpoint.This new featu...
3126 Feb 2012 @ 10:01 PSTToolsData Mover User Poolwe have over 500 DM scripts and this feature would be a life saver to get away from non expiring passwords. Has any thought been analyzed to look into the potential for accomodation for accountstri...
3026 Feb 2012 @ 09:45 PSTcarrie's blogWhy collect PARTITION statistics on Non-Partitioned tables?Carrie, thanks for this article. I've implemented a stats process based on this rowcount from parttion stats and it has proved to be quite valuable for us. Now if only we could firgure out an easie...
2914 Oct 2011 @ 10:08 PDTAccomplishing tasks when you don't know where to start.Using a named pipe archive to copy a database from one system to anotherGood and discrete simple steps !! To be able to do a restore, the object must exist on the target, if one were to use this method for setting up a new system/environement, you could leverage TSET t...
2823 Sep 2011 @ 09:56 PDTcarrie's blogTips on using Sampled StatsWhat is the best way to extract the output of the 'Help statistics DbName.TblName column Partition;", for the purpose of extracting the value of the column 'Number of Rows'. If you have attempted t...
2729 Jun 2011 @ 10:52 PDTViewpointTeradata Viewpoint 13.11 releasedThe canary SQL is distinct for each account string, its the actual database ID which is constant. This allows us to do 1:many on database id to canaries and we host all the canary SQL as views with...
2629 Jun 2011 @ 12:42 PDTViewpointTeradata Viewpoint 13.11 releasedThanks for the clarification. Another question... Currently VP allows canary queries through a user which can be configured with accountstring, but there is no option to reuse an ID with multiple ...
2527 Jun 2011 @ 07:36 PDTViewpointTeradata Viewpoint 13.11 releasedGary, are there any target database version dependencies for VP 13.11?
2427 Jun 2011 @ 07:34 PDTViewpointTeradata Viewpoint 13.11 releasedFor exixting user one will have to check the option for external authentication, for all new users, the auto provisioning will take care. You'd be glad you did that sooner than later. We have it in...
2313 Jun 2011 @ 08:03 PDTViewpointTeradata Viewpoint 13.11 releasedThanks for the clarification. This is helpful information and is a good thing to get started before the DBS upgrade.
2213 Jun 2011 @ 01:44 PDTViewpointTeradata Viewpoint 13.11 releasedWhat are the differences between the Workload Designer portlet and the current TDWM tool to configure rulesets. Is this is a one way migration and are there any key points to be aware before making...
2113 May 2011 @ 12:20 PDTViewpointTeradata Viewpoint performance considerationsThis certainly is very useful and help me configure the data retention for the different collectors, appropriately. Also helped in identifying the IO issues with the IO subsystem for the Postgresql...
2014 Jan 2011 @ 07:53 PSTcarrie's blogConverting CPU Seconds, Old Node Type to New Node TypeCarrie, Thanks for the clarification. How would we measure the difference in cpu utlization when we move across platforms. Example, when we move an application from an Enterprise class node (5600...
1927 Dec 2010 @ 12:46 PSTViewpointPersonal Workspace TemplateHave gone past the previous error after a re-ftp copy of the War files...Now running into another 'WARNING' message and the portlet is not visible... WARN 27 Dec 2010 20:39:52,883 [http-80-Proces...
1827 Dec 2010 @ 11:12 PSTViewpointPersonal Workspace TemplateI get an error while trying to install the package... ERROR 20 Dec 2010 21:07:35,782 [ContainerBackgroundProcessor[StandardEngine[Catalina]]] [org.apache.catalina.startup.ContextConfig.init(992)] ...
1723 Dec 2010 @ 08:41 PSTToolsSQL Assistant Java Edition 13.10 availableWith a temporary password, the tool fails to prompt with a challenge window to change the password in contrast to the traditional SQLA tool. Is this a setting in the new tool that needs attention ?...
1616 Dec 2010 @ 06:58 PSTViewpointTeradata Manager - Where is that in Viewpoint?In Teradata Manager --> Sessions options, there is a tab for showing the priority of a session. This is for the system which does not have TASM(Full scale, like an Appliance 25xx) and just the old ...
1515 Dec 2010 @ 08:34 PSTViewpointTeradata Manager - Where is that in Viewpoint?What would be the equivalent for the priority tab in TM for an appliance, in a VP portal.
1409 Dec 2010 @ 09:10 PSTcarrie's blogHow to Calculate Your Max Number of Usable AMP Worker TasksCarrie, thanks for this clarification. Is there any documentation to map what type of step within an SQL would need what type of MSGWORK** Your help is greatly appreciated.
1316 Nov 2010 @ 11:21 PSTcarrie's blogConverting CPU Seconds, Old Node Type to New Node TypeCarrie, thanks again for the explanation and this is very helpful. Can you help clarify that even though the CPU time for servicing a request might increase with a newer node with more CPUs, the wa...

Pages