#DateForumTypeThreadPost
1430 Jun 2011 @ 08:46 PDTToolsTopicTeradata Manager Log File Location - Can you change itI have an issue with Manager and where it stores log files, the default destination in our set up isn't suitable due to lack of network storage space. Is it possible to change this and if it is ...
1309 Feb 2011 @ 06:30 PSTToolsReplyCompatability Of TTU12 Administrator And Teradata 13.0Mike, Thanks for the reply, not long after posting that I got it to 'work'. As I need to work with both TD12 & TD13 for some time I did more or less what you suggested in that I copied the T...
1207 Feb 2011 @ 09:01 PSTToolsTopicCompatability Of TTU12 Administrator And Teradata 13.0Hi, We're in the process of upgrading to new servers running TD13.0 but as usual the team who prepares the desktop TTU utility packaging are running way behind and don't have a TTU13 version of ...
1107 Jul 2009 @ 06:08 PDTDatabaseTopicVolatile Tables And StatisticsAm I correct in thinking that you can't collect statistics on VTs in TD12 ? I thought I'd read you could but the manuals say you can't.Thanks
1023 Feb 2009 @ 12:11 PSTToolsTopicTDWM and Workload Definition QuestionHi,We have defined a workload as having classifications of < 1 Sec CPU Time and 'Include Single or Few Amp Queries Only' .Does anybody know if there is a definition of 'Few Amps' that is used ? ...
909 Feb 2009 @ 11:03 PSTDatabaseTopicProblem With Create Table Followed By Insert in SQL AssistantHello,Since we upgraded to V12/TTU12 one of our business users has had a problem with some SQL that they say worked happily in the V2R5/TTU7 version of SQL Assistant, although we've no proof of tha...
806 Feb 2009 @ 05:51 PSTDatabaseReplyRevoking All Access Rights For UsersThanks for that, we'd come to the conclusion that the only way to do it was to drop the users and recreate them.
730 Jan 2009 @ 06:02 PSTDatabaseTopicRevoking All Access Rights For UsersHi,We're in the process of moving from our current access setup of granting access rights at user level to using Roles to control access. What we're struggling with is removing the existing rights ...
620 Jan 2009 @ 05:43 PSTDatabaseReplyCompressing a Character Column containing non-alphabetic charactersDieter,Thanks very much for the help, it works perfectly.We hadn't thought of using ", we'd tried ''' and "'".RegardsAlistair
519 Jan 2009 @ 09:36 PSTDatabaseTopicCompressing a Character Column containing non-alphabetic charactersHi,Hopefully someone can help me with a problem compressing text values containing non a-z characters, specifically ' and ( .We have a column containing a number of fixed text entries which we'd li...
422 Dec 2008 @ 10:00 PSTDatabaseTopicCollect Statistics With Sample - Does This Give Good Results in V12Hi,We were told that 'Collect Statistics With Sample' was basically useless in V2R5 and to not use it. We've just moved up to V12 and what I'm trying to determine to settle a difference of opinion ...
308 Oct 2008 @ 06:10 PDTDatabaseTopic3712 Insufficient memory for Plastic StepsWe are in the process of testing our SQL on a new 5500 server running V12 and Linux, we're currently on V2R5 on an MP-RAS server.During our testing we had a failure with a piece of our batch SQL wh...
228 Aug 2008 @ 10:56 PDTDatabaseReplyCan You Limit Number of Sessions Per User ?Jeff,Thanks for the replies, we're in the process of upgrading to V12 and will be introducing Priority Scheduler and DWM at that point.We are trying to get the department that are in charge of the ...
127 Aug 2008 @ 11:18 PDTDatabaseTopicCan You Limit Number of Sessions Per User ?Not sure if this is the correct place in the forum for this question but here goes ... We have a problem with a web based application written by another department which accesses our warehouse via ...